About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Want to Automate Daily Email from Multiple Google Calendars

  • 16 March 2022
  • 4 replies
  • 23 views
A

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. 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Userlevel 7
Badge +14

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
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Troy Tessalone
Userlevel 7
Badge +14

@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.

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A

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? 

Troy Tessalone
Userlevel 7
Badge +14

@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
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions