My goal is to post a Slack message from a cell to a Slack but fails. The error that thows is:
Bargle. We had trouble getting a matching spreadsheet row. :-(Error details:
Nothing could be found for the search.
I have a gut feeling is a permission error, I've tried changing the names of the columns, the filename, selecting another sheet. But no luck.
Best answer by AndrewJDavison_Luhhu
View original
+10
Hi
The good news here is that it’s not a permissions issue.
You’ve got a step that searches for a row on your spreadsheet, and this error means it’s not finding any rows matching your search criteria - that’s what we need to fix.
Could you show us a screenshot of how that search step is setup?
Hi Andrew, thanks so much for reaching out. I just left two screenshots. The one above shows the flow and the one below shows how the spreadsheet is being setup. Again, thanks so much for your help.
+10
So
I see what you want to do - your want to find the 7th row.
Sadly you can’t tell Zapier to retrieve a specific row. Luckily there is a workaround.
Create a new column and populate every row with the formula:
=ROW()
That column will then auto fill with its row number. Then you just need to adjust your Zapier search step to search that row instead.
Let me know if you need any help with that.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
