Retrieve all Google Calendar Events in the past week

Question

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!

Troy Tessalone · Accepted Answer

Hi @OliveiraHeroGood 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 · Answer

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.

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded