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.
Hi
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.
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.
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.
Like this:
ROW 1: USE
ROW: 2: TRUE
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.