Skip to main content
Question

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


I am trying to create a zap that each Sunday am it goes to google sheets copies and pastes the newest row in column A and posts to a specific slack channel. I run the tests and they all say successful but when it actually posts it only shows the message text I have typed in and not the copied information from the google row

I have spent about 4 hours trying to get this to work and am about to give up.

Did this topic help you find an answer to your question?

10 replies

Troy Tessalone
Forum|alt.badge.img+14

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.

 

 


  • Author
  • Beginner
  • 5 replies
  • January 9, 2025

 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.


Forum|alt.badge.img+1

@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


  • Author
  • Beginner
  • 5 replies
  • January 10, 2025

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.

 


Troy Tessalone
Forum|alt.badge.img+14

@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.


  • Author
  • Beginner
  • 5 replies
  • January 10, 2025

@Troy Tessalone Like this?

 


Troy Tessalone
Forum|alt.badge.img+14

@astockdale 

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


  • Author
  • Beginner
  • 5 replies
  • January 13, 2025

@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

 


  • Author
  • Beginner
  • 5 replies
  • January 13, 2025

 


Troy Tessalone
Forum|alt.badge.img+14

@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.