Skip to main content
Question

Looping can't seem to trigger action per iteration


Alexb11

I am having a problem and none of the support material seems to address the issue in a manner I can understand.

 

I would like to:

  1. Read from Google Analytics 4 the Active User metric for each month of the year.
  2. Write the value to a table in Zoho Analytics

 

I have done this on a single month basis repeated for every month of the year. Eg read May-23 value, write May-23 value, read June-23 value, etc. Very frustrating because first it is dumb, but second I cannot write a zap for a month that does not yet exist. So I have to update the Zap at the start of the each month for the new month.

 

What I can do is read monthly data for all months in the year. This gives me the data month by month. Then I use a Zap loop and it converts the data to look like:

01,02,03…12

1000,1500,2000…1400

Where the first line is the month number (e.g. 1 is January) and the second line is the data (e.g. 1000 active users in January).

 

All good so far. But now I want to write to the database. I add Zoho Analytics to the loop (there is a shadow box around the widget).

 

My expectation is we will loop through the data like this:

First iteration

01

1000

Second iteration

02

1500

Etc

 

Instead the widget is presented with:

01,02,03…12

1000,1500,2000…1400

 

There is no looping. It treats the loop step as though it is completed before it calls the next processing step.

 

Not sure what I am missing.

 

Kind regards,

 

Alex

Did this topic help you find an answer to your question?
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

Troy Tessalone
Forum|alt.badge.img+14

Hi @Alexb11 

In order for us to have more context, post screenshots with how your Zap steps are outlined and configured in EDIT mode.


Alexb11
  • Author
  • Beginner
  • 1 reply
  • June 6, 2024

Hi Troy. Thank you for taking an interest. Does this help?


Troy Tessalone
Forum|alt.badge.img+14

@Alexb11 

Try using this Zap action: Looping - Create Loop From Line Items

That handles data structured as an array of items.