How to Make a Workflow Trigger in Sequence for Each New Entry in a Google Sheet?

This topic was automatically generated from Slack. You can find the original thread here.

Hello and Good morning.
I have a workflow that triggers based off of new rows in a google sheet. I’d like each new entry in the sheet done before the next row is picked up. The challenge I’m running into is if multiple rows are added, the workflow doesn’t trigger in sequence - some rows later on get done first. Please help :pray:

Hi , I’ll try to reproduce this and get back to you

Here’s a quick video:

Hi , I’ve tried to update manually the sheet an I see the event emitted in the correct order as the image below.

I suspect that the operation where you update the Google sheet is not updating the cells in correct order, or it update the cell simultaneously that Google Sheet couldn’t determine the order that changed

What I would recommend is to check the source where you update the Google sheet to see if they update by order, try to slow it down and have it to update by order

Hi Leo, if you review the video I attached above, you’ll see they come in sequence, but you’ll see the ones coming in later sometimes finishing the Pipedream workflow faster than the earlier ones.

:point_up:

I see . Could you try to set the Limit concurrency to 1 on your Workflow settings? It would ensure that the event is processed by sequence and not in parallel.

More detail in this doc: Concurrency and Throttling

Sigh… looks like even though I have a paid account, I don’t have access to Execution control :disappointed: