Question

How to link only one cell from google sheet to slack?

  • 4 June 2020
  • 1 reply
  • 163 views

Userlevel 1

Hi,

I am trying to link google sheets to slack in a way that when someone updates the amount of one particular cell on Google sheet, an automatic message is sent on slack channel with the updated amount of that cell only. However, the issue is that anytime an amount is changed above that specific cell, Zapier sends 2 messages on slack, one shows the amount of the cell that was edited and the other of the cell I want (this is Total amount).


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

Hi @zns1! Would you like the Zap to trigger any time a value in a cell in a row  is update (eg whenever the value in column F is updated for any row)? 

 

If so, you can do that with the Google Sheets New or Updated Spreadsheet Row trigger. To make sure that it only triggers from the cell that you want, add the column that you want to trigger the Zap in the trigger column field:

Does that look like it’ll do what you need?