• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $149 (🏆Lifetime Access) - View offer

Create rows in goggle sheet from results of Iterator

dodosport

Member
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

Well-known member
Staff member
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

Member
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

Moderator
Staff member
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

Member
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
 
Top