Want to Automate Daily Email from Multiple Google Calendars

Hi @akfullerton 

Good question.

Check out Digest by Zapier: https://zapier.com/apps/digest/help

You’ll probably want to make sure of this Zap trigger: GCal Event Start

Some challenges you’ll encounter.

1. Number of Zaps that need to be configured for all the Calendars
2. Organizing data from the Digest
3. Formatting of data for the email

@akfullerton 

As an alternative, consider this approach…

Configure Zaps to send data to an Airtable Base for new/updated/cancelled events.

• Airtable has Views.
• Views have Filters. (e.g. Date = Today OR Tomorrow)
• Views can be shared as ready only via links or embedded on sites.

Then use a Zap with the Schedule trigger to send a daily email with the link to the Airtable View that is filtered for Today/Tmrw.

I’ve never used Airtable before - how would I go about setting that up? Do you have any resources you could share to help there? 

@akfullerton

Airtable has tons of resource: https://support.airtable.com/hc/en-us

Your Airtable Base would have to be configured first before you can use it in Zaps.

You’d need 2 Zaps at a min

Zap 1

1. Trigger: GCal - New/Updated Event
2. Action: Airtable - Find/Create Record
3. Action: Filter (continue if existing record found)
4. Action: Airtable - Update Record

Zap 2

1. Trigger: GCal - Event Cancelled
2. Action: Airtable - Find Record
3. Action: Airtable - Update Record