Add new Google Calendar events to a Google Sheets spreadsheet as new rows and email it to a specified email address
Every time a new event is created in a Google calendar, Make (formerly Integromat) will automatically add that event to your Google Sheets spreadsheet as a new row. The spreadsheet will be then sent to a specified email address. The template uses this example spreadsheet.
Greg Vonf
Software used in this automated workflow example
Google Sheets
Integromat
Make
Summary
Every time a new event is created in a Google calendar, Make (formerly Integromat) will automatically add that event to your Google Sheets spreadsheet as a new row. The spreadsheet will be then sent to a specified email address.
Detailed explanations
Step by step instructions
-
Create a new scenario in Make (formerly Integromat), or use an existing one.
-
Add the Google Calendar > Watch events module to your scenario.
-
Select the calendar you want to watch.
-
Set the Maximum number of events to 1.
-
Add the Google Sheets > Add a row to a spreadsheet module to your scenario.
-
Select the spreadsheet and worksheet you want to add the event to.
-
In the Row section, click the + icon next to the Value field and select Event > Title from the resulting dropdown menu.
-
Repeat this step for the Event > Start and Event > End fields.
-
Add the Google Sheets > Send a spreadsheet module to your scenario.
-
Select the spreadsheet you want to send.
-
Enter the email address you want to send the spreadsheet to.
-
Turn on the Send as attachment option.
-
Set the Sending mode option to Send on each row.
-
Click Continue.
Business use case example
You can use this scenario template to automatically add new events to a Google Sheets spreadsheet and email it to a specified email address. This can be useful for tracking events or keeping a record of them.