Best answer

Google Sheets - Email the Changed Cells Only

  • 6 August 2020
  • 1 reply
  • 103 views

I have a Google Sheets doc that has information about products in it. It has 25 columns per row. 
When a row is changed, I am sending myself an email to make the necessary updates based on the changes to the row. 
Often times only one cell is changed in the row. The zap is working fine, but It’s hard to go through each row, line by line and find exactly what was changed when sometimes the value is just changed by one number. (example changing from .003 to .0029)

Is it possible to send only the updated cell value (and/or cell location) via email by zapier?

icon

Best answer by andywingrave 7 August 2020, 00:07

View original

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 +9

The best way I can think to do this on Google sheets is to add a column with a script to tell you which column was last updated - Here’s a support article which will hopefully point you in the right direction:

 

https://support.google.com/docs/thread/14506820?hl=en