Flow Variable into Google Analytics Connection Node

[wisemanleo]

Always been curious about flow variables and finally have a use case that I think would warrant it:

The Google Analytics Connection node has one editable field called Profile ID. A preceding node, Google Authentication, can prefill this field if properly authenticated. It is still editable.

I’d like to reference a table in Table Creator with a list of Profile ID’s, and I’d like to “flow variable” it into that field in Google Analytics Connection node. I got as far as doing something like this:

But, I think I’m doing something wrong. Any pointers in the right direction would be appreciated.

Thanks!

[MichaelRespondek]

Hi @wisemanleo,

Could you please try to change the type of your created flow variable to the type String as the “s” within the “Flow Variables” tab of the configuration option “profile_id” indicates? Your current one is of type integer (indicated by the “i”).

Best,
Michael

[wisemanleo]

Hi @MichaelRespondek - thank you. I have just done this:

But still seems to query only one of the two values I have populated in the Table Creator node:

When I look at the “Variables Output” of the Table Row to Variable node, I observe only one of the two values captured:

[MichaelRespondek]

Hi @wisemanleo,

If you want to use the values of different rows you have to use a loop structure to iterate over these.
I would recommend the “Table Row to Variable Loop” for your use case, you can find an example here.

Best,
Michael

[wisemanleo]

That worked - I had to troubleshoot a bit, but that helped me understand the “flow” of flow variables better. Thank you! Here is the final workflow that allows for Profile ID’s to be stored in a table.