Skip to main content

I’m building an automated workflow for contract analysis. The idea is:

  1. Customer submits a contract (PDF) via  google forms I extract the text with PDF.co.

  2. I send the text into ChatGPT (OpenAI) with a prompt that analyzes legal risks, clauses, and gives a summary.

  3. I take the output and create a Google Doc, then export it to PDF.

  4. Finally, I want to send the PDF analysis back to the customer’s email automatically with Gmail/Outlook.

The problem:

  • My current trigger is Google Drive → New File in Folder.

  • This works to grab the file, but it doesn’t provide me with the customer’s email address (only my own, as the owner of the Drive folder).

  • Because of that, in the final email step I don’t know which email address to send the analysis to.

What I need:

  • A way to capture both the uploaded PDF AND the customer’s email address in the trigger, so that I can map the email field to the Gmail “To” field.

I tried switching to Google Forms, but I can’t find the right trigger event (I only see Actions like “Create Spreadsheet Row” etc. when using Google Sheets).

Question:
👉 What is the best way in Zapier to capture a customer’s email together with their uploaded PDF, so I can email the analysis results back automatically?
Should I switch to Google Forms + Google Sheets as the trigger, or is there a simpler solution?

Thanks in advance!

The Simple workflow u can get new records from sheet via google forms
and extract file id and search folder in drive so will get both folder and email at same time.


Hi ​@viktor 2222 

If a user is submitting a GForm with their email address and file, then you will have both data points to use.

 

Zap trigger: GForms - New Form Response

 


I’m having a problem with my Zap. i need help
I’ve set up an automation to analyze contracts for lawyers. The workflow seems to work correctly at first: when I upload a new contract, it gets analyzed and a new Google Doc is created with the correct content from that specific contract.

The issue comes when the summary is emailed. Instead of sending the summary of the new contract, I always receive the same summary from the very first test contract I used.

So the document creation works properly i think, but the email step is stuck sending the old summary instead of the latest one. Below are screenshots with my zap please check them out. Thanks

This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing personal or potentially sensitive details.


You need to dynamically add doc file on 
File field of drive so each time u will get correct summary

This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing personal or potentially sensitive details.


@viktor 2222 

Your latest comment is the same as your other topic: 

 


After seen your 5th image u need to add File field map dynamically so u will get different pdf each time
u need to output file of doc map through its id