I am using a google apps script that sends data from one worksheet to another and adds the rows to the new sheet. Zapier isn’t picking that up as a new spreadsheet row… I guess because I’m not manually typing it in? Any thoughts on how to solve this problem? I’ve tried the script, a query on a different sheet and etc. It’s not firing.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 24026 replies
-
12 November 2021
Hi
The Google Sheets trigger is marked "instant" but it still takes a few minutes to trigger
The triggers for Google Sheets are unique among Zapier triggers. When there is a trigger event in the spreadsheet, Zapier gets a notification webhook from Google about this. After that, Zapier sends Google Sheets a request for new data, so it uses both the polling and instant trigger methods. This process takes about 3 minutes overall.
While not being "instant", these triggers are faster than regular polling ones, as they don't depend on the polling interval of the plan your account uses.
I know it’s not instant and I’m not in a rush, but it’s not firing at all no matter how long I wait. It doesn’t show ANY movement when the script sends the new rows to the google sheet. It works when I manually type though.
Userlevel 7
+14
- Certified Zapier Expert
- 24026 replies
-
12 November 2021
Hi
I’d try opening a ticket with Zapier Support for confirmation/guidance: https://zapier.com/app/get-help
Alternative is to use an operational database app such as Airtable: https://zapier.com/apps/airtable/integrations
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.