I am trying to automate a daily email to my organization that compiles all events happening today & tomorrow across multiple 30+ Google Calendars, with headings for each calendar. Is there a way to do this with Zapier? It looks as if Zapier can’t “find” events just by day, as it asks for a search term. I just want everything from the whole day compiled into an email.
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
- Trigger: GCal - New/Updated Event
- Action: Airtable - Find/Create Record
- Action: Filter (continue if existing record found)
- Action: Airtable - Update Record
Zap 2
- Trigger: GCal - Event Cancelled
- Action: Airtable - Find Record
- Action: Airtable - Update Record
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?
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.
Hi
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.
- Number of Zaps that need to be configured for all the Calendars
- Organizing data from the Digest
- Formatting of data for the email
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.