Help required for creating a Google Sheet entry from the Agent

[ayush_lakhotia]

Hi All,

I intend to create the following workflow on n8n:

1. Pick the first URL from a Google Sheet which has 24 URLs available
2. Visit that particular URL in Chrome and scrape all the names of clients available in that HTML file
3. Paste the extracted data in a Google Sheet for better readability
4. Repeat the entire process

I am getting stuck at the last step where I intend to “create” a new Google Sheet and then “Append” a row name. My n8n Agent is able to create a new Document / Spreadsheet but unable to enter the extracted data because it cannot figure out the Column Name in this new Sheet. Has anyone faced this issue?

[mohamed3nan]

maybe try to auto map