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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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

Test Works But Email Not Sending - Google Sheet Row to Email In Outlook

  • 17 January 2024
  • 6 replies
  • 55 views
A

I had my whole Zap setup working when I was using my personal email address. I didn’t want to use my work email until I had everything working. Once I had it working, I switched my personal Outlook account to be my work email (also Outlook based). I run the test and the email shows up. However, it is no longer sending the email when the row in Google Sheets is created (it previously had been working).

Any ideas why the email test would work but the email would no longer send when the Google Sheet row is created? I looked at the Zapier Google Sheets troubleshooting page and none of those things seem to apply. Zap setup below and I do have a body written in that is not pictured in the screenshot:

 

 

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @AboveTheClouds 

Make sure the set an Outlook Body value as it’s required.

 

Help article about GSheet triggers:
https://help.zapier.com/hc/en-us/articles/21612033911437-Google-Sheets-triggers-aren-t-instant

 

Make sure your GSheet is configured correctly: https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps

 

Check your Zap Runs history for activity/issues: https://zapier.com/app/history/

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

Thanks, as I mentioned in my post, I do have an email body set - it is just not pictured in the screenshot as it contains personal information. As a result, that would not be the issue for the failure to send.

I will look at the links you sent. But I am still confused as to how it would have been working yesterday and now suddenly stopped working but still works when I run the test. 

Troy Tessalone
Userlevel 7
Badge +14

@AboveTheClouds 

Check to see if Zap 1 is running to first send data to the GSheet.

Help articles for using Outlook in Zaps: https://zapier.com/apps/microsoft-outlook/help

It may be relate to different settings in your Outlook biz email account.

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

Thanks. The data is definitely getting into Google Sheets just fine. The breakdown occurs after that. 

Troy Tessalone
Userlevel 7
Badge +14

@AboveTheClouds 

Can you post screenshots with how the top 3 rows of your GSheet are configured?

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

@AboveTheClouds

Here’s a possible workaround.

Use Airtable instead of GSheets.

Airtable Automations have a native integration with Outlook to send emails.

 

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

Reply


Terms & Conditions