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.

Notion image

Next click Setup Trigger

Notion image
 

Scroll through the list and locate the option labeled Loop Through Data. Click on it to proceed.

Notion image

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.

Notion image
 

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.

Notion image
 
Note: The starting row for your automation will change based on the number of 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.

Notion image

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.

Notion image
 
For more information how to set up a 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.

 
Notion image

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.

Notion image
 

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.

 
 
 
 
 
Did this answer your question?
😞
😐
🤩