Simple but complicated google sheet bulk update row

How To
1

I’m having trouble with my keyword classification workflow. Here’s what it does:

  1. Reads 500 keywords from Google Sheets
  2. Uses Gemini AI to classify them as “Product” or “Blog” keywords
  3. Parses the results into structured data
  4. Tries to mark processed rows as “TRUE” in column D so future runs don’t repeat the same keywords

My Problem

Everything in the workflow work right except my, Bulk Update Rows to save operations (1 operation vs 500), but it’s not working right. When I process rows 501-1000, it still updates rows 1-500 instead of the actual rows I processed.

I’ve tried:

  • Setting Range to D2:D sum(14.__IMTAGGLENGTH__ ; 1)
  • Setting Array Aggregator’s “Target structure type” to “Google Sheets - Bulk update rows - rows field”
  • Making sure my array includes the correct row numbers and “TRUE” for column D
  • Different range formulas
  • tried with the google sheet api instead

always the same result, i’ve been stuck for days.

Unlike the YouTube tutorials where people update one big range, I need it to update specific batches (0-500, then 501-1000, 1001-1500 etc.) just like the regular Update Row module would, but in bulk.

Any ideas why it’s ignoring my row numbers and always updating the first 500 rows? BAsically i want it tto work like the classic update rows but wi

image
image2410×1342 332 KB

image
image704×1331 68.5 KB

image
image698×485 23.5 KB

2

Hey there,

for the second update you don’t start from D2 but from D502, no? Then D1002? You need to change the starting number as well, not just the end one.

3

thank i see, how do i dinamically change the starting number, to fit the right lines?