Issue with Google Sheets: Workato Assumes Headers Are in Row 1

[hiteshwagh9383]

Hi everyone,
I'm working with a Google Sheet that's styled for human readability — for example, the sheet has a title or notes in the first two rows, and actual column headers start in row 3.
However, I've noticed that Workato assumes row 1 contains the column headers, which causes issues when mapping data for automation.
Is there a way to configure Workato to recognize headers starting from a different row (e.g., row 3), or do we need to reformat the sheet to always have headers in row 1?
Appreciate any suggestions or workarounds!
Thanks!

[Bhagya_pola]

Hi @hiteshwagh9383 ,
One workaround is to use a Custom Action with the Google Sheets API.

Use this endpoint in custom action:

GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}

Just pass your spreadSheetId and set the range to start from your actual headers in sheet (eg: Sheet1!A3:Z), skipping the top rows.

In the API response:

• The first array is treated as headers.
• The remaining arrays are your data rows.

You’ll need to handle this structure as per your needs.
For more details, refer to the API doc here:
 https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get

Attaching a screenshot below showing the custom action setup and sample output.

[varun]

Hi @hiteshwagh9383 

Yes, based on your use case, here's one way to handle the response schema:

1. Create a list with the required schema structure.
2. Use a batch operation on the custom action output to loop through and add only the data rows (skipping the header).
3. Since the header array is not needed in the list, make sure to remove it for a cleaner result.

You can try the logic below and see if it works for your scenario.

Attaching reference screenshots for better clarity.

[dineshtirumani]

Hello @hiteshwagh9383 

Try Adding Range as A4:D2000 In Get Actions Rows. Please find the Screen Shot for your Reference.

• A4:D2000= Start at cell A4, and go down to D2000.

• You are reading columns A to D.

• You are reading from row 4 (inclusive) to row 2000 (inclusive).

• Total max: 1997 rows of data (if they exist).

  ---