โ06-28-2022 04:58 PM
I am trying to pull data from a Google sheet but keep getting an error: "The sheet has duplicated headers". There are multiple sheets in the workbook, and I've tried more than one and keep getting the same error. I couldn't find anything in the documentation. Any ideas?
โ06-28-2022 05:03 PM
Hello Jen,
I don't remember getting that message, but here are a few things to try:
1. Click the Workato "Refresh" button
2. Reload the entire recipe
3. Make sure every column name is unique
4. Make sure there is at least one row of data in the sheet
Good luck!
โ06-28-2022 08:49 PM
Hey Patrick, thanks! And for anyone who comes after me, I just deleted the workflow altogether (it was only the first step after the trigger) and recreated it, and now it's working just fine. I suspect that there was an issue with caching old versions of the spreadsheet because I was making changes to it just before I started building the workflow.
โ06-29-2022 09:55 PM
Thanks for posting your solution, Jen McVicker!