Trigger sms when google sheet row/column x is changed from "empty" to "Interested" drop down selection

Question

Hi Zapier Community,

I have a simple google sheet that has a drop down list of items to pick from in a column. It starts out blank but when a user changes the specific row/column they are working on to “Interested” I want to send an SMS notification. When setting up the zapier trigger I see the variable “Status” as a list of options but how do I get it to be triggered when column H which is “Status” is changed to Interested?

I’m using a drop down list rather than have someone type the word “Interested” to avoid typo’s. If this is possible thank you for any help! If keywords (TEXT) are the only way then I guess I can at minimum type it out manually.

Thank you all,

David

Troy Tessalone · Accepted Answer

Hi @davgill520Good question.Check out this related help article: https://zapier.com/help/doc/common-problems-with-google-sheets-on-zapier#new-or-updated-spreadsheet-row-trigger-behaviorHowever, I’d recommend using Airtable instead of GSheets.Airtable has ViewsViews have Filters (e.g. Status = X)Views can be used to trigger Zaps

davgill520 · Answer

Thank you very much for the quick reply. I will give this a shot. Im not familiar with AirTable but it would be something to consider.

Since everyone on the team who is using this is familiar with Gsheets it makes having this work in GSheets ideal. Thank you again!

David

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded