Need Help: Google Sheets Multiple Row Triggers Not Working in Make.com

How To
,
1

Hi Make.com community,

I’m struggling with setting up a trigger system between Google Sheets and Make.com. Here’s my situation:

What I’m Trying to Do:
I regularly paste lists of texts (10-20 items or more) into a Google Sheet column. I need each row to trigger my Make.com scenario separately, with its text being passed to the next steps in the scenario.

What I’ve Tried:

  1. Watch Changes module:
  • Works perfectly for single row pastes
  • But completely ignores when I paste multiple rows at once
  1. Watch New Rows module:
  • Can detect when multiple rows are added
  • But I can only specify a fixed column to pass forward
  • Can’t seem to pass the actual triggering text to the next steps

My Ideal Flow:
When I paste this list in column A:
“Text1”
“Text2”
“Text3”

I want:

  • Each row to create its own trigger
  • Each trigger to pass its specific text forward
  • So “Text1” triggers and passes “Text1”, then “Text2” triggers and passes “Text2”, etc.

Current Problem:
Either all rows trigger at once (overwhelming the system) or the module misses most of the rows completely.

Is there a way to make this work? I need a solution that can:

  1. Detect each row when multiple rows are pasted at once
  2. Create separate triggers for each row
  3. Pass the specific text from each triggering row to the next steps

Any help or alternative approaches would be greatly appreciated!

Thanks in advance!