Hi, I've gotten a connection between Sheets & my Discord server working and the setting is set to instantly send data from a new row created in the Sheet to the server. When I test the connection I immediately get the test message sent to the server, but when I actually input the data in the new row in the sheet it takes 2-3 minutes before the data gets sent to Discord.
Is this something that I can't change or is there a way to make the transmission immediate just like the tests are?
Best answer by DanversBest answer by Danvers
Hi
The short answer is that there isn't a way to speed up the Zap, I'm sorry about that! The longer answer is that this is because the Google Sheets New and Update Row triggers work differently to most other triggers in Zapier.
Generally, there are two types of trigger for Zaps - polling triggers and webhooks. Broadly speaking, polling triggers check back with the trigger app at fixed intervals to see if there's new information, whereas webhooks send new information over as soon as it's available. It you're not already familiar with those, you can learn more about them in this guide to different types of triggers.
The Google Sheets instant triggers are a new kind of trigger - sort of a hybrid of the two. We get a webhook saying that the sheet has changed but that hook doesn't contain any information about the changes, so we then poll Google Sheets to get the information from the sheet.
This poll is set a couple of minutes in the future because if we get the information too quickly, a user might not have finished making changes to the row.
I hope that all makes sense, let me know if you have any questions!
+10Hi
So, while Google Sheets is listed as an 'Instant' trigger app, it actually runs a bit differently due to limitations with the Google Sheets API.
Maybe
As far as I know, there's no way around it.
+12Hi
The short answer is that there isn't a way to speed up the Zap, I'm sorry about that! The longer answer is that this is because the Google Sheets New and Update Row triggers work differently to most other triggers in Zapier.
Generally, there are two types of trigger for Zaps - polling triggers and webhooks. Broadly speaking, polling triggers check back with the trigger app at fixed intervals to see if there's new information, whereas webhooks send new information over as soon as it's available. It you're not already familiar with those, you can learn more about them in this guide to different types of triggers.
The Google Sheets instant triggers are a new kind of trigger - sort of a hybrid of the two. We get a webhook saying that the sheet has changed but that hook doesn't contain any information about the changes, so we then poll Google Sheets to get the information from the sheet.
This poll is set a couple of minutes in the future because if we get the information too quickly, a user might not have finished making changes to the row.
I hope that all makes sense, let me know if you have any questions!
+10Hi
Thanks for clarifying! Might I suggest this gets added to the Google Sheets help page:
Google Sheets - Integration Help & Support | Zapier
I had wondered why the Google Sheet triggers were a weird hybrid of instant and there was no way to manual run them... this explains it :-)
+12Good shout
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
