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 to set up email notifications in Zapier to alert you when a date is added to a specific column in Google Sheets?

Hello, I am trying to work on a google sheet where there is a list of items (column A) with a reffered date of start for that item (column 😎. I want to automate that every time column B is modified (a date of start is added) I receive an email.

I am using the “New or Updated Spreadsheet Row in Google Sheets” Zap, but I can’t manage to set the zap so that it sends email only when column B is modified, I am receiveing emails also every time other columns are modified (there are multiple columns in addition to A and B so I am receiving too many emails).

I have noticed that there is a trigger column field in the “New or Updated Spreadsheet Row in Google Sheets” Zap but I can’t figure out how to set it just to Column B.

 

Many thanks.

Hi and welcome to the Community, @Alg! 😁

To set the Zap to only trigger when column B is edited in the Trigger Column field you’d need to select the name of that Date of Start column from the list of available columns. Assuming row 1 of the spreadsheet contains the column header names (see: Work with Google Sheets in Zaps) then the name of column B should appear in the dropdown list, for example:
8ef8837117b3cc876f052f869f0478cc.png

That said, selecting the column there would not stop the Zap triggering for brand new rows that are added to the spreadsheet. To get around that you’d need to add a filter to the Zap to only continue if the Date of Start field Exists - meaning that a value exists for that field. If you’ve not worked with filters before you can learn more about them here: Add conditions to Zaps with filters
 

Hope that helps to get you pointed in the right direction. If you run into any issues on that or have any further questions just let us know!

Terms & Conditions