topic Re: "Duplicated headers" error with Google Sheets in Workato Pros Discussion Board

"Duplicated headers" error with Google Sheets

jmcvicker — Tue, 28 Jun 2022 23:58:46 GMT

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?

Re: "Duplicated headers" error with Google Sheets

patrick-steil — Wed, 29 Jun 2022 00:03:32 GMT

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!

Re: "Duplicated headers" error with Google Sheets

jmcvicker — Wed, 29 Jun 2022 03:49:37 GMT

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.

Re: "Duplicated headers" error with Google Sheets

meghan-legaspi — Thu, 30 Jun 2022 04:55:44 GMT

Thanks for posting your solution, Jen McVicker!