"Duplicated headers" error with Google Sheets

[jmcvicker]

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?

[patrick-steil]

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!

[jmcvicker]

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.

[meghan-legaspi]

Thanks for posting your solution, Jen McVicker!