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?
