How to post Google Sheets data to a Slack channel using Zapier

Hi ​@astockdale 

Make sure to test Zap step 2, and see which row is found in the GSheet to help you troubleshoot.

NOTE: You may be missing a space after the mapped variable and before “Sunday”.

If you need more help, post screenshots of the top 3 rows of your GSheet worksheet being used.

 I tried to put a space in message text where oyu indicated but it’s still just posting like before.

 So now this is showing an error but I don’t understand what it’s wanting

This is all there is on the google sheet.

​@astockdale 

Have you tried removing the “Review” column from the supporting column input?

I’m pretty sure you are asking Google sheets to look for “Sunday Shout Out! in Column A and a “null” value in column A.

I hope this is helpful :) 

Tell us how it goes

Unfortunately removing Review from supporting Column input.  I’m wanting the Zap to take whatever info or wording is in the lowest column row and post that, since it will be changing each week. Latest test shows everything passed but it’s still not pulling the text from the column and row.

​@astockdale 

Are you always trying to find row 2 in the GSheet?

If yes, then add another column.

Header: USE

Row 2 Cell Value: TRUE

Then use this as the lookup column/value.

​@Troy Tessalone Like this?

​@astockdale 

Like this:
ROW 1: USE
ROW: 2: TRUE

​@Troy Tessalone This is what my configuration currently looks like. It says it published but nothing actually published. Previously it was just posting a blank message that said by Zapier.

I want to make sure I am setting up the spread sheet in the manner you were saying and that i’m not misunderstanding and should be setting up something else It’s only posting

​@astockdale 

For us to have current context, post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.