Activity
Mon
Wed
Fri
Sun
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
What is this?
Less
More

Memberships

7 contributions to AI Automation Society
Google sheet - row by row execution VOL 2
vHi, since my previous attempt to solve the Google Sheets problem was unsuccessful, I've created a simple scenario that illustrates my challenge. There is a Google sheet with sheets: DATA, X1, X2, ... Xn - In the sheet, DATA are variables - There is a SCRIPT node that calculates via JS simple multiplication - row by row - Result of multiplication of variables from each row has to be appended by the last node into a different sheet accordingly to X1, X2, to Xn Simple? When the scenario was executed, all the results were appended into sheet X1. Could you help me solve my puzzle ?
Google sheet - row by row execution VOL 2
1 like • 1d
@Albert Gray I'm afraid the problem is that Google Sheets operates in batch mode; it doesn't go row by row. With the append operation, it works in batches. I solved the problem with the loop node, but I do not like it.
Interesting to learn
Which niche sounds less exciting but more sustainable? Which one from this and different from this you already learned/learning?
Poll
23 members have voted
3 likes • 1d
@Muskan Ahlawat, as @Aslam Khatri said, we are still learning :)
Google sheet - row by row execution
Dear N8N enthusiasts !!! I use Google Sheets as a database; in each record on the main sheet, there is a new "item" entity. In this scenario, I want to select the first item from the first row and then execute all nodes of the scenario. Then the scenario should extract the second row and manage all remaining nodes as a fresh one. I have to misconfigure something because, on the first run, the very first node gets all the records, and the remaining nodes try to use them in one pass, which makes JS not work correctly. How do I force my scenario to go through a table, one row at a time, until the last node, then start over for the next item?
1 like • 2d
@Rafan Natasya, It was my first idea, but since it didn't work for me, I focused on the node loop. I still have some issues, so I'm in debug mode.
1 like • 1d
Follow up on my challenge presented on a simple 4-node scenario - could you share your help ? https://www.skool.com/ai-automation-society/google-sheet-row-by-row-execution-vol-2
Google sheet new row formatting issue
I work on a scenario where the last node adds a row to a Google Sheet via Upsert. In scenario I have to add two values in columns A and B; all other columns have formulas and should propagate automatically. I add only raw data in columns A and B, and formatting is not copied from the previous record, nor are formulas propagated. Could you advise me on what I should do differently to force formula propagation and formatting propagation?
1 like • 6d
@Adesoji Johnson, I've decided to use the Script node to rewrite all formulas there in JS, then upload the final numbers to the Google Sheet. I've tried the proposed method by you, then I thought of two areas that calculate the final result in the system and about future problems with maintenance, so I have migrated all of it into N8N.
2 likes • 6d
@Chris Jadama Thank you for the tip - I considered that, but formulas were working on a specific range of cells, and it was an additional complication. I've decided to use the Script node to rewrite all formulas there, then upload the final numbers to the Google Sheet.
🎉 Halloween Giveaway Winners! - Free n8n for a year
Huge congrats to our two winners of the free n8n Cloud Starter Plans ($240 value): 🥇 @Dudley Wise — for the meme about how people use AI with emails (1st image) 🥈 @Simão Rodrigues — for being brutally honest about how people are probably approaching a challenge like this (2nd image) Keep an eye on your DMs, I’ll be reaching out to get you set up with your codes. Have a great weekend, everyone! Cheers, Nate
🎉 Halloween Giveaway Winners! - Free n8n for a year
5 likes • Nov 1
Excellent - congrats to the winners !!!
1-7 of 7
Grzegorz S
3
31points to level up
@grzegorz-scislo-8975
30 years in IT! From BASIC in the 80s to AI and automation today. Love sharing tech war stories and exploring AI automation with fellow enthusiasts.

Active 5h ago
Joined May 15, 2025
Powered by