Best answer

Google sheet -> gmail - Last Row plus specific cels

  • 28 August 2020
  • 1 reply
  • 90 views

Userlevel 1

I have a zap that sends me a Gmail when a row is added to my google sheet. 

At the top of the sheet, I have several calculations to the right side of the existing data.  Is there a way to make the email include data from the last row added and also from the calculation cells at the top of the sheet?  

In this example all data from the bottom row and the 4 pieces of data with arrows on the right.  

 

Thank you in advance. 

 

 

icon

Best answer by Troy Tessalone 28 August 2020, 18:53

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

You’ll have to add another step to the Zap to lookup the row that has “New” in that column.

NOTE: The column with Today/Yesterday/New should have a column header.