How to write data into multiple sub-tables within the same Google Sheets using n8n?

[JoseAI-Automatizacio]

Hi everyone

I’m trying to build an automation where n8n sends data into a Google Sheets file.
The challenge is that this Google Sheets doesn’t contain just one table — it has multiple sub-tables within the same sheet, separated into different sections.

My question is: Is there a way for n8n to automatically write data into all these sub-tables or into specific rows within each one?
So far, I’ve only seen how to write to a standard table, but not how to target several separated table areas inside the same sheet.

Has anyone dealt with something similar or knows the best approach for this?

Thanks in advance!

[mohamed3nan]

Hello @JoseAI-Automatizacio, welcome!

Please take a look at my answer here:

Question about n8n workflow for proposal document (Google Sheets)

Hello @towyssl Using this approach as you mentioned, you’ll need multiple “Update Row in Sheet” nodes, and to update data only for a specific range, you’ll need to specify the location in the “Data Location on Sheet” option. For example: [image] Calling the Google Sheets API using an HTTP Request lets you do it in a single call node, and the JSON body is easy to create, especially since the cell range syntax (like "B7:H7") is the same as what you see in Google Sheets: [image] Here’s a …

This is probably what you’re trying to achieve..

[JoseAI-Automatizacio]

Thank you so much Mohamed!!!