Best answer

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


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

icon

Best answer by Troy Tessalone 9 June 2022, 01:48

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.

3 replies

Userlevel 7
Badge +14

Hi @davgill520 

Good 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-behavior

 

However, I’d recommend using Airtable instead of GSheets.

  • Airtable has Views
  • Views have Filters (e.g. Status = X)
  • Views can be used to trigger Zaps

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

Userlevel 7
Badge +9

Hey there, @davgill520! I wanted to check-in and see if you were able to get this sorted? We’d love to know! 🤗