Skip to main content
Best answer

Retrieve all Google Calendar Events in the past week


OliveiraHero
Forum|alt.badge.img+1

Hi there,

How to retrieve all Google Calendar events in the past 7 days and store them into a Google sheet? I saw there is the option to “add”, “update” or “search” calendar events but not sure if they can achieve the goal.

 

The only way I can think of is every time a calendar event has been added, send it to Google Sheet. Is there a way to do bulk export instead?

 

Thank you all!

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @OliveiraHero 

Good question.

Most Zap app triggers/actions work on a per record basis, meaning only 1 record.

If you go with your approach of logging the GCal events into a GSheet, the you’ll need to potentially use a formula to derive the WEEK for a given event.

That way you have a standardized value that can be used in the GSheet Lookup Row Zap action to get the matching rows of GCal events.

 

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31426 replies
  • Answer
  • March 12, 2023

Hi @OliveiraHero 

Good question.

Most Zap app triggers/actions work on a per record basis, meaning only 1 record.

If you go with your approach of logging the GCal events into a GSheet, the you’ll need to potentially use a formula to derive the WEEK for a given event.

That way you have a standardized value that can be used in the GSheet Lookup Row Zap action to get the matching rows of GCal events.

 

 


OliveiraHero
Forum|alt.badge.img+1
  • Author
  • Beginner
  • 12 replies
  • March 14, 2023

Thank you! @Troy Tessalone  I guess based on what you said, we have to log every new event and can’t retrieve previous events just using Zapier.