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.

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.

Step by step instructions:

1. Create a new scenario in Make (formerly Integromat), or use an existing one.
2. Add the Google Calendar > Watch events module to your scenario.
3. Select the calendar you want to watch.
4. Set the Maximum number of events to 1.
5. Add the Google Sheets > Add a row to a spreadsheet module to your scenario.
6. Select the spreadsheet and worksheet you want to add the event to.
7. In the Row section, click the + icon next to the Value field and select Event > Title from the resulting dropdown menu.
8. Repeat this step for the Event > Start and Event > End fields.
9. Add the Google Sheets > Send a spreadsheet module to your scenario.
10. Select the spreadsheet you want to send.
11. Enter the email address you want to send the spreadsheet to.
12. Turn on the Send as attachment option.
13. Set the Sending mode option to Send on each row.
14. Click Continue.

Example of use case:

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.

Try out this ready to use workflow template:

Add new Google Calendar events to a Google Sheets spreadsheet as new rows and email it to a specified email address

Find more templates on our website:

Business workflow templates

Business Automated is an independent automation consultancy. You can visit us at www.business-automated.com if you would like to request custom automation for your business. Visit our YouTube Channel for more automation ideas to accelerate your business. If you like our work buy us a coffee or follow one of our affiliate links and try out Make (formerly Integromat).