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.

  • Home
  • Get Help
  • How Do I
  • How do I trigger an Outlook email with Zapier when 'Y' is inserted into a month column in Google Sheets?

I have a google sheet set up, i has the following columns (which have data in them)
 

  • Company Name
  • Location
  • Contact First Name
  • Contact Surname
  • Contact Email
  • Contact Phone

Additionally it has colums for (dont have data initially

Jan, Feb, Mch, Apr, May June, July, Aug, Sept, Oct, Nov and Dec

I want zapier to trigger an email via outlook when “Y” is inserted into one of the month boxes, can anyone help with this please?

Hi ​@HowardForster 

Will “Y” be entered into 1 of the 12 month columns or possibly 1+ of the 12 month columns?

 

Zap trigger: GSheets - New or Updated Row

Try adding a Filter step or Paths:

 

ALTERNATIVE

Use Airtable instead of GSheets.

Airtable has native automations that have a native integration with Outlook.

Initially the month box will be empty, when i get to that month i will decide if the email is to go, at thay point i will out a y in the month box, i want the email to trigger then.

 

​@HowardForster 

You may need to create a separate Zap for each of the 12 months.

Try this Zap steps...

  1. Trigger: GSheets - New or Updated Row
    1. Select the trigger column
      1. e.g. January
  2. Action: Filter
    1. Condition to check the value for January Column = Y
  3. Action: Outlook - Send Email

 

Hi ​@HowardForster,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

No it didnt help, was very easy to setup in make.com however

Sorry to hear that ​@HowardForster. Glad you were able to get it sorted though, even if it wasn’t with Zapier!

If things change and you’d like to revisit this with Zapier, I’d be happy to help—just let me know. And if there’s anything else I can assist with in the meantime, feel free to reach out! 🙂

Reply


Terms & Conditions