Question

How update a Google Sheet when there is row added at the top of another Google sheet

  • 28 February 2022
  • 1 reply
  • 55 views

Hello everyone,

I'm looking to create a zap including Google Sheets and Send Email. 

The first one is a table in which the production status of the different jobs we are working on are regularly added. 

For example :

 

 

When we have a new job, we add a line from the top. The most recent job is insert at the top.

 

I would like to do the following zap: 

When a cell "In progress" in column B is changed to "Done" send an email to the team.

 

The problem I have:

When someone adds a new job by inserting a row from the top, all my rows shift down. Zapier considers that all the lines with the mention "Done" that have shifted down are updated and so it sends me as many emails as lines present in the document. 

 

Do you have any idea how I can tell it "Trigger" only when In progress is changed to Done and not when we add a new line and the lines shift down.

 

Thanks for your help.

Sophie

 


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 @Sophie_VT 

Make sure to review the available help articles for how to configure GSheets to use in Zaps: https://zapier.com/apps/google-sheets/help

 

As an alternative, consider using Airtable instead of GSheets: https://zapier.com/apps/airtable/integrations#triggers-and-actions

Airtable has Views.

Views have Filters.

Views can be used to trigger Zaps. (e.g. Status = Done)