Looping through data
Looping through automation steps
In this article, we will showcase how to Loop through data
. Looping can be useful when you want to automate a process to run multiple times, but also want it to skip over certain steps, such as logging into a website.
Setting up a Loop
To set a Loop
on an automation, first select the automation you wish to modify.
Next click Setup Trigger
Scroll through the list and locate the option labeled Loop Through Data
. Click on it to proceed.
You will be prompted to add in Google Sheet Data
to use data from your spreadsheet into your automation. Or you may choose to skip adding in a Google Sheet
.
Setup Google Sheet loop
Choosing to set up a Google Sheet
loop will allow you to choose which row of your Google Sheet
the automation will start from. As well as how many rows each run will complete.
rows at a time
you entered. For example, if your automation starts at row 2 and loops
10 rows at a time, it will add 10 to the starting row each time the automation runs (1st-2, 2nd-12, etc.). Skip Google Sheets
This option allows you to skip extracting data from a Google Sheet
and loop from the automation itself.
In this example, the automation will go through the loop you set up five times each time you run it.
Once you have chosen which loop
you want you can then choose the time and frequency your automation will run.
Scheduled Time
click here:
Setup trigger: What it does and how to use it. Loop Steps
After selecting your loop
settings, it's time to edit your loop steps. You should see a loop between
bar at the top of your animation.
You may click the Green circle
on either side and adjust your loop parameters. In this example our loop
will start at step 5 and end at step 8. Your animation will go through these steps until it finishes how many you specified in the previous steps.
Looping can be a powerful tool, whether it is used to skip a login step or to break down lists into smaller portions of work.