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.
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
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.
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.