I want to make a Google form that people fill out to add events to a Google Calendar. When I try to build the zap, it is asking me for the “spreadsheet” and “worksheet” and even though I’m starting with a Google form. I didn’t think Forms had “worksheets”.
What am I doing wrong here?
Anyone done this zap successfully?
Best answer
Google Form To Google Calendar
Best answer by PaulKortman
However, behind every Google Form is a Google Sheet with a worksheet, and so you can get to that by clicking on the Google Sheet Icon in the “Responses” area of your Google Form… this will either prompt you to create a sheet, OR will take you to the sheet that this form is connected to… here’s a GIF showing that:
https://cdn.zappy.app/9a512475277d94c0a03e16848c3dd53c.gif
You simply need to point the Zap trigger to the sheet that this form is connected to and boom it will work :)
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+10- Zapier Solution Partner
- Answer
However, behind every Google Form is a Google Sheet with a worksheet, and so you can get to that by clicking on the Google Sheet Icon in the “Responses” area of your Google Form… this will either prompt you to create a sheet, OR will take you to the sheet that this form is connected to… here’s a GIF showing that:
https://cdn.zappy.app/9a512475277d94c0a03e16848c3dd53c.gif
You simply need to point the Zap trigger to the sheet that this form is connected to and boom it will work :)
+10- Zapier Solution Partner
So happy to help 
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.