Google Sheets reader cannot extract the column names, i.e., header row

[deependuprasad]

I want to extract the column names in a google sheet and run it in loop throught the ask AI to run generate information from it by referring a pdf (text extracted). But I could not get the google sheets reader to read the column names and put it in a list.

The documentation says the reader does not read the header row. Is there any workaround to get the column names?

[Wasay-Gumloop]

Hey @deependuprasad – Yes, this should be possible! You can create a customized node for Google Sheet that pulls the header values as well using the MCP feature:

Tutorial for that here: Introducing MCP Nodes & Workflows in Gumloop

Let me know if this makes sense and works for you