Hi there, I’m trying to use Zapier to go through all my google calendar appointments and export them to a Google Sheet. Obviously I can do this as new appointments are made or as appointments are changed but I cannot find a way to simply ask Zapier to go through all existing appointments and export to Google sheets.
In addition, as I manage 6 calendars do I need to create a zap for each calendar or can I have more than one calendar on a Zap?
Question
How to copy existing Google Calendar into Google Sheets for existing appointments?
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 Expert
- 31398 replies
Hi
Might make more sense to do a manual export from GCal, then import to GSheets: https://support.google.com/calendar/answer/37111?hl=en
Otherwise it would involve using the GCal API: https://developers.google.com/calendar/api/guides/overview
Zap action options:
- API Request
- Custom Action (with the help of AI)
NOTE: Using the GCal API likely involves deal with pagination to handle the max results returned per page. (e.g. 100)
+6- Zapier Staff
- 6531 replies
Hi
I’m jumping in to see if I can help!
At the moment, Zaps are only built to look at new and incoming information, and won't process existing data. You can read a bit more about this here:
This means that data created before the Zap is turned on won't be pulled in automatically.
That said, if you're able to export that data as a spreadsheet or CSV file, you may be able to "import" them using a separate Zap. This guide has some great visual references for getting that workaround set up: https://help.zapier.com/hc/en-us/articles/8496274335885-Transfer-existing-data-using-a-Zap
Hopefully, this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.