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?
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 
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
