Description of My Issue:
I have a scenario in Make.com that works well with the Google Sheets "Watch Rows" trigger. This setup monitors new rows in the Google Sheet, which are populated via responses from a Google Form. When a new row is added, it triggers the workflow, generating a summary via OpenAI and sending the results to other services (e.g., email or Google Docs).
However, I would prefer the workflow to be instantly triggered as soon as the Google Form is submitted, rather than using the "Watch Rows" trigger, which checks for changes at intervals. The current setup delays the process, and I need something more immediate.
Problem:
- I am unsure whether to use the Google Sheets Instant Trigger, because from my understanding, it monitors changes in the sheet (such as cell edits) but not necessarily new rows created by form submissions.
- I need advice on what module or method to use to ensure the scenario is triggered instantly as soon as a Google Form is submitted.
Brief Description of the Scenario:
The scenario is designed to automate the process of capturing responses from a Google Form and generating a business coaching summary. When a client submits the form, their responses are logged into a Google Sheet, and the trigger activates the following workflow:
- Captures the client’s responses from the Google Sheet.
- Passes the responses to OpenAI to generate a personalized coaching summary.
- Sends the generated summary via email or saves it as a Google Doc for further review.
I would like this process to begin as soon as the form is submitted, rather than waiting for the Google Sheets module to detect new rows at intervals.
