Question about n8n workflow for proposal document (Google Sheets)

Questions
1

Hello everyone,

I’m a student from Korea and I’m just taking my first steps with n8n. I’m posting here because I’m stuck and have nowhere else to ask for help.

I am trying to build an automation workflow that fills out a “Gianso” (an official proposal document in Korea). My current workflow is in the attached image.

The part where I am stuck is writing the AI-generated values into our Google Sheets proposal form. I want to input the data into very specific, non-contiguous locations on the sheet, not just append new rows.

For example, I need to write data to these specific (and sometimes merged) ranges:

  • B7:H7 = Title

  • B9:H9 = Content

  • A11:H11 = Purchased Items

  • A13:H13 = Total Amount

  • A15:H15 = Supplier

My question is, what is the best way to achieve this?

Should I use the Google Sheet node (maybe using multiple nodes, one for each range)? Or is it better to use the HTTP Request node to call the Google API directly? Or is there another, more efficient method I am missing?

Would there be anyone who could offer some advice on this?

Thank you so much in advance!
–
Information on your n8n setup

  • **n8n version:**n8n Version 1.108.2
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
1 Like
2

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
image429×257 9.32 KB

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
image464×403 25.6 KB

Here’s a sample of this approach:

Personally, I prefer this one.
Try both approaches and see which one works best for you, only you can decide based on your specific situation.