Trying to find calendar events in Outlook and write them to Google Sheets

Question

Hi all,I am trying to create a Zap that will be scheduled to run each morning at 7.00am.  It should connect to Oulook and find all my calendar events for that day.  And then write the Title, Start Time, End Time, Description, Attendees into a row in Google Sheets.  The trigger is a Schedule by Zapier for each morning. However, I am having difficulty understanding or getting the Find Calendar Event action to work with Outlook.  How do I configure it so that it would bring back everything for that day?  Right now, it require me to enter a search term, that doesn’t seem to bring back anything.  And then for the Create Spreadsheet Row action for Google Sheets, how do I map the Outlook calendar event fields?

Troy Tessalone · Accepted Answer

Hi ​@MJP2025You would have to use the Outlook API to query for and handle multiple events as theOutlook API:https://learn.microsoft.com/en-us/outlook/rest/get-startedOPTIONSCustom Action with the help of AI (if supported for Outlook)https://learn.microsoft.com/en-us/outlook/rest/get-startedZap Action: Outlook - API RequestIf you need to hire help, there is a directory of Certified Zapier Experts:https://zapier.com/experts

MJP2025 · Answer

Hi Troy,That’s really helpful! Thank you. It took me a few hours to get it working, but the Outlook API has worked. Exactly what I need.Much appreciated,Mark

Reply

Useful links

Code of conduct

Using the Community

Community expectations

Reply

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