Loop on items the Google Sheet Row

Discussions
1

Need help regarding my flow in Active Pieces.
-Starting from step 1: I used cronjob for my trigger (15th and 30th of the month)
-step 2: get the current date and time
-step 3: Getting the rows in google sheets and my start row is 3
-step 4: Loop on items and i selected the Get next row(s) item
-step 5: inside the loop is the Send text message using telegram

this flow already send me one message each row from the gsheets and example of a message is like:

Full name: Esmi
Phone number: 09123456789

The thing is every time I Test Flow it only sends one message for one run. What I want is to run only the flow once then it will send each row a telegram message until there is no rows in the google sheet. Is that possible in active pieces?

image
image654×890 51.1 KB

2

Hello @Esmi , Welcome to the community :wave:,

For the loop piece, when you individually test the Telegram step, it will only send one row as sample data. You can continue mapping those values in the next steps. After you complete all the steps, click the Test Flow (Ctrl + D) button, it will send a message for each row from Step 3.

3

what if I have 50-100 rows in that sheet? should i map it one by one? or if not, do you any have suggestions?

4

You don’t have to map each and every row. Mapping just one row is sufficient, and it will apply the same mapping to all rows in the sheet.