Best answer

How do I create multiple boxes and tasks in Streak from a Google Sheet using Zapier?

  • 23 October 2023
  • 3 replies
  • 34 views

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.

icon

Best answer by Troy Tessalone 23 October 2023, 19:55

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +14

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!

Userlevel 7
Badge +14

@zjacint 

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