How to insert multiple rows to data tables from google sheets

[hyeok2]

Please share your workflow

Information on your n8n setup

• n8n version: 1.117.0
• Database (default: SQLite): Google sheets, n8n - data tables
• n8n EXECUTIONS_PROCESS setting (default: own, main): main
• Running n8n via (Docker, npm, n8n cloud, desktop app): cloud
• Operating system: mac os

i think this work flow. Any suggestions to improve this workflow?

thanks

And also i wnat to know how to add workflow embeded like under

[mohamed3nan]

Hi @hyeok2

Is there a specific issue you have?
Your workflow is working

[jabbson]

I think they were just asking for improvement suggestions.

I could give one - rename your Edit Fields node be more indicative of its function. This makes it easier for others (and future you by the way) to understand the goal and the need for this node without having to open and read the config.

[hyeok2]

yess its work. but i wonder if there’s another way to insert multiple rows at once instead of using a loop node.

thanks

[hyeok2]

Thanks! I was just wondering if I really needed to use a loop.(cause i learned avoid loop..)
I’ll make sure to apply the suggestion you mentioned as well.

[mohamed3nan]

You can just remove the Loop Over Items node entirely, n8n by design will automatically iterate because the Set node outputs 3 items, as a result the Insert Row node will be executed 3 times, and so on..

[hyeok2]

…..thanks