Create rows in goggle sheet from results of Iterator

[dodosport]

Good morning,

My goal with this new automation is to send every last day of the month to my customers that have my fidelity card a wathsapp message.

The body of the message is how much points their fidelity card has.

So steps I created are these:

1) schedule the date ( last day of the moth)

2) api call to my CRM that answers with the list of fidelity and their points (simple answer)

3) iterator simple answer of step 2

4) insert in a google sheet data’s from step 3: so the step has to create as many rows as the number of fidelity.

At this point I stop because the automation creates only one row and not as many rows I need

Can some one help me? Where am I making a mistake?

Thanks in advance

Tobia

 

[Supreme]

Hey @dodosport

While setting up the workflow using an iterator it will only show you 1st item of the array, but when the workflow actually triggers it will send messages to all the numbers in the array.

 

[dodosport]

Hi Supreme,

thanks for your reply.

So following your reply to send a whatsapp message to each customer I don't need to create rows in a google sheet but I could use directly data from ITERATOR?

Is this correct?

 

[ArshilAhmad]

You could save that data from the Iterator in Google Sheets, or you could use Iterator data to send WhatsApp messages directly; it's completely up to you.

 

[dodosport]

Thanks ArshilAhmad,

I'm facing an issue trying to insert datas in a google sheet from iterator because I've to create 800 rows as many fidelity card I have, in reality workflow creates only one row.

I don't know where I'm making mistake

Thanks if you could help me

Tobia

 

[ArshilAhmad]

Please share the Workflow URL in which you have this concern.