Skip to main content
Question

How do I automate the weekly transfer of future Google Calendar events to Google Sheets using Zapier?

  • January 24, 2024
  • 1 reply
  • 36 views

Foundstone

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.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 24, 2024

Hi @Foundstone 

Zap Trigger: Schedule

 

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