zap not trigger when added new row in google sheet. it is working fine when click on “run test “ button. we have successfully published in free tier. It shows instant trigger only.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/integrations#help
Make sure your GSheet is configured correctly to be used in Zaps:
- Row 1 with headers and a value in A1
- No gap rows/columns
- No grouped rows/columns
Check your Zap Run history for activity and errors: https://zapier.com/app/history/
- Beginner
I have configured properly and able to see success in app history. Please check above screenshot. It is connected Google Sheets -> private zapier app. While testing it works as expected. But our endpoint did not get data which defined in actions of zapier app.
+14- Zapier Orchestrator & Solution Partner
Post screenshots showing how your Zap steps are outlined and configured in the CONFIGURE tab while in EDIT mode for us to have more info.
- Beginner
Please check above screenshots for your reference and guide us
This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing personal or potentially sensitive details like Zap links.
+14- Zapier Orchestrator & Solution Partner
Screenshot does not show how Zap step 2 is configured.
- Beginner
please check step 2 screenshot
This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing personal or potentially sensitive details like Zap links.
Hey
+14- Zapier Orchestrator & Solution Partner
From your screenshot below, the bottom Zap Run happened automatically.
Click on a Zap Run to see how the Zap steps processed.
Click on a Zap Run Step to see the DATA IN/OUT for each step to help you trace the data flow and troubleshoot.
The Zap action step DATA OUT should return and ID that you can use to find the record in the app to verify the data.
Otherwise, there may be an issue with the private Zap app integration used in Zap step 2.
- Beginner
How can switch the trigger to “New Spreadsheet Row” (polling) instead of instant trigger ?
+11- Community Manager
Hi there
The only polling version I could see for the “New Spreadsheet Row” Google Sheets trigger, would be the Team Drive version. The non-team drive version is an instant trigger:
As the Zap was triggering previously but suddenly stopped working, this could be caused by a structural change being made to the spreadsheet. For example, if rows were deleted or columns were added/deleted then that might have caused a disconnect between the Zap and Google Sheets. You can learn more about the other types of spreadsheet changes that can prevent a Zap from triggering here: Google Sheets error: Zap not triggering
In which case, I’d suggest turning the Zap off and back on again to re-establish its connection to the spreadsheet. Then, add a new row to see if that triggers the Zap.
Let us know how it goes!
- Zapier Solution Partner
Hey
Book a free 20min troubleshooting call from my calendar here: —LINK REMOVED—
Let me see if we can solve the issue on that call
Fahad S
Founder @ AutomateMyBiz.ai. | Zapier Platinum Partner
This post has been edited by a moderator to remove self-promotional calendar booking link as per our Community Code of Conduct.
+11- Community Manager
Hey
Want to make sure you’re all set! 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.