Send an email from Gmail when a value is updated in Google Sheets

  • 29 June 2023
  • 1 reply

Hello, I am trying to sent up a zap to send out emails when ETA’s are updated on a google sheet. The preplanned Zap is not working for this. I need an email to be sent when some one changes the date of an ETA and it says when Row was update. Any help would be appreciated. 

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

1 reply

Userlevel 7
Badge +14

Hi @K.Spragg 

Good question.

I’d recommend using Airtable instead of GSheets.

Airtable has a Last Modified field which can be configured to watch for updates to specific other fields.

The Last Modified field can be chosen in the Zap trigger to indicate when the Zap should fire.

As part of the Zap trigger config, a View (filtered data) can be set to limit which records would cause the Zap to fire.