Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

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:

 

 

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/

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. 

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

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

@AboveTheClouds 

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

@AboveTheClouds

Here’s a possible workaround.

Use Airtable instead of GSheets.

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

 

Reply


Terms & Conditions