Question

The Zap won't trigger on "Status Update" in Google Sheets.

  • 10 April 2024
  • 3 replies
  • 15 views

Hi, I'm having trouble connecting a status update on Google Sheets to send emails.
Here is the problem:

In my sheet, we use this menu to update a lead's status, and I need an email to be sent when the status is updated. However, when I try to automate it with Zapier, it doesn't give me the option to choose the status update

Can someone help me out with this? 


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

3 replies

Userlevel 7
Badge +14

Hi @Toni-Basemaker 

To give us more context, post screenshots with how your GSheet top 5 rows are configured.

Post screenshots from the Zap Trigger example being used that shows the DATA OUT with the Row/ID from GSheets. (check if that Row/ID has data in the desired column)

Help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

Here are the rows
 

What i need exactly is when the Lead status on column “Status Comercial” changes to “Contato 1 não respondido”, zapier begins the email automation

Here are the zapier prints
 

 

Userlevel 7
Badge +14

@Toni-Basemaker 

The first row should be the headers.

Help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help