Hi, I’m testing Jotform’s internal integration with Google Sheets and then using that “new row” as a trigger to POST a webhook. The data is appearing in the new row but the trigger is not working. I understand there is a delay but it is simply not triggering. Is there perhaps something I have missed here?
I use “new row” as a trigger for a similar workflow with the data coming from a 3rd party source other than Jotform. It works great.
+14
Hi
Good question.
If the issue persists, why not use a Zap for the entire workflow and cut out the GSheet?
Another alternative would be to use Airtable instead of GSheets, which has a native Jotform integration too.
If your Google Sheets trigger stops working suddenly, first check if you’ve accidentally inserted a blank row anywhere in the spreadsheet. Zapier interprets a blank row as the end of the spreadsheet and may have trouble finding any new rows below it.
In addition to this, making the following changes to your spreadsheet while the Zap is turned on can cause errors:
If you need to make any of those changes to your Google Sheet, turn your Zap off while you work on the spreadsheet, and then turn it back on again.
Thanks for your advice. Unfortunately I use Google Sheets extensions for other key parts of my workflow so I’m stuck with the nuances of Google Sheets triggering. I have just set up a webhook within Jotform rather than use their native Google Sheets integration this seems to be the issue.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
