Skip to main content
  • Home
  • Get Help
  • How Do I
  • How do I automate the weekly transfer of future Google Calendar events to Google Sheets using Zapier?

Dear all experts,

1. I need to copy future events from google calender to google sheet every week manually. I am wonder is it possilbe to build a zap to automate my work?


For example:

From: Google Calender
24/3/2023 - Meeting with Ada
26/3/2023 - Meeting with Bob
28/3/2023 - Meeting with Ada
24/4/2023 - Meeting with Chris
24/5/2023 - Meeting with Ada

To: Google Sheet
Google Sheet (Ada)
24/3/2023 - Meeting with Ada
28/3/2023 - Meeting with Ada
24/5/2023 - Meeting with Ada

Google Sheet (Bob)
26/3/2023 - Meeting with Bob

Google Sheet (Chris)
24/4/2023 - Meeting with Chris

  1. Is it possible to run the zap scheduely but not new event add to google calender? (let say once per week or month??)

    Thank you.

Hi @Foundstone 

Zap Trigger: Schedule

 

You would have to use the GCal API: https://developers.google.com/calendar/api/v3/reference/events/get

 

Terms & Conditions