Question

Can I update Google Spreadsheet row with a custom value conditional on a Slack message?

  • 6 April 2023
  • 2 replies
  • 24 views

I have set up a Zap to Update a Google Spreadsheet row based on a Slack message in a private channel. Basically I want to update different columns for Monday-Friday to track when people will be in our office in person. So I would like to update each column, based on whether the message includes “Monday” or “Tuesday” or “Wednesday” etc… but I can only seem to set the cell value to “Raw Text” of the Slack message.

 

Is it possible to set the value using an IF statement or some other dynamic value conditional on the message?


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

2 replies

Userlevel 4
Badge +6

Hi @econnelly 

Welcome to the Community! Thanks for your interest in Zapier.

Yes, you can use our Filter by Zapier app.

4ba998a0b094f3d6fe10541f38fc90b1.png

Cool I think this will work! Thanks @Brem !