cancel
Showing results for 
Search instead for 
Did you mean: 

"Duplicated headers" error with Google Sheets

jmcvicker
Deputy Chef II
Deputy Chef II

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?

Jen McVicker
CSP-SM, CSP-PO, SAFe 5 SPC, ICA-AC, ICA-ATF, Automation Pro II
3 REPLIES 3

patrick-steil
Deputy Chef III
Deputy Chef III

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
Deputy Chef II
Deputy Chef II

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.

Jen McVicker
CSP-SM, CSP-PO, SAFe 5 SPC, ICA-AC, ICA-ATF, Automation Pro II

meghan-legaspi
Community Manager
Community Manager

Thanks for posting your solution, Jen McVicker!