I want to create a zap that updates google sheets whenever an event is updated in google calendar but it’s giving me an error message. It only runs when I try to update just one row.
Best answer
Google Sheets error: Unable to get a value when looking for "responses". Is it empty or missing?
Best answer by DamiakBest answer by Damiak
Thank you
I have been able to accomplish it with custom actions.
+14- Zapier Expert
- 30948 replies
Hi
For us to have more info about the error, post screenshots with how your Zap step is configured for the ‘Action’ tab section.
Hi
I have been able to create the zap with the actions I wanted it to run. I did that by creating custom actions and giving it a prompt to identify specific ID for each calendar event and to update the event in Google sheet when an update is made in Google calendar or to create a new row if that particular ID is not found in the Google sheet.
+6- Zapier Staff
- 6380 replies
Hi
I’m jumping in to see if I can help!
If you’re trying to update rows in Google Sheets you will need to add a Lookup Spreadsheet Row action for you to be able do that. You can learn more about updating rows in Google Sheets here: https://help.zapier.com/hc/en-us/articles/8495978803213-Find-and-update-spreadsheet-rows-in-Google-Sheets-on-Zapier
Hopefully, this helps!
+6- Zapier Staff
- 6380 replies
That’s great news
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.