Skip to main content

Hello,

I want to create an automation. The task is to create a box in Streak for every row in a Google Sheet where the column C equals "H". Then, a task should be created inside each of these boxes.

Here are my steps:

  1. Lookup Spreadsheet Rows (output as Line Items) in Google Sheets.
  2. Create a New Box in Streak.
  3. Create a Task in Streak.

Unfortunately, when creating the box, only one box is created. How can I create a task for each of the matching rows individually?

Thank you.

Hi @zjacint 

Good question.

You would need to add a Looping step before the Streak steps to iterate over each found row from GSheets: https://zapier.com/apps/looping/help


Hi,

 

Thank you, I tried this. I'm attaching the images of the settings. Unfortunately, only one box is created, not 268. What am I doing wrong?

Thank you!


@zjacint 

In the help article for looping: https://help.zapier.com/hc/en-us/articles/8496106701453-Loop-your-Zap-actions