Not able to create a google sheet and populate data

[jero_at_n8n]

Describe the problem/error/question

Not able to create a google sheet and popualte data into it.
I can only create an empty sheet, after that I am unable to figure out how to insert data since it asks for columns to map but such columns can’t be createad in the sheet creation step… What am I doin wrong?

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

• n8n version: 1.86
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[mohamed3nan]

Hi @jero_at_n8n

Without a sample workflow or the errors you’re encountering—it’s a bit difficult to provide specific help.

Could you share a sample of your current workflow and maybe a small snippet of the data you’re working with? That would help a lot!

[jero_at_n8n]

hi @mohamed3nan , I included the workflow, please let me know if you need something else. thanks.

[mohamed3nan]

Thank you,

The issue you’re facing is because, in the last step

where you want to insert the data, there are several problems:

• First, you’re manually selecting a sheet, and it’s a completely different sheet from the one that was created initially.
• Second, even after selecting the correct sheet, you’ve chosen the mapping mode as “manually,” and you’re specifying columns that don’t even exist yet, since the sheet is still new.

So the solution here is either to delete all of them and choose automatic mapping, or make sure the sheet already has those columns (create them manually).

[jero_at_n8n]

The issue of the different sheets is just a copy paste error for creating the workflow sample, that was not actually the issue.

The issues I had actually were 2:

1. I didn’t know that the automatic mapping mode would just create the “header/column names” for me and I thought I would need to specifiy them somewhow in the create sheet node step.

2. I was not able to select the document and sheet source in the insert sheet node since the document is created in real time by the workflow ,therefore the “From list” dropdown was obiously not containing the name of the document I was expecting, now I realized I had just to use “By id” and map it with the id returned in the creation of the sheet.

Now it is working fine. Thank you for the support!