• 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 $249 (🏆Lifetime Access) - View offer

Data isn't showing in my workflow

Karim Emara

Member
Here is an image of my test sheet
1628513239145.png


but here in iterator it only shows the first row of the sheet and it doesn't recognize the rest of the sheet
1628513323195.png

and here it shows only the first row in the data

1628513354974.png

Be advised Im looking to send automated messages every week or daily ( TBD ) and I wanted to send bulk messages with messages that change daily please advise me if its possible or no.

thanks
 
P

Pabblymember11

Guest
Hey @Karim Emara
here in iterator it only shows the first row of the sheet and it doesn't recognize the rest of the sheet
1628513323195.png

The Iterator will only show the single row of your Google Sheets when setting up the workflow but while executing the workflow, it will take each and every row from the Google Sheets. In the next action step, the Chat API application will automatically fetch details from each row and will send the message to every user.

Thanks!!
 
Last edited by a moderator:

Karim Emara

Member
I'm sorry but I didn't happen, it did not fetch the remaining rows only the first one I can't choose any other rows

1628515896952.png
 

Fagun Shah

Well-known member
You do not need to map all rows while setting up our workflow.
You can and you only need to setup/map first row data.

Other rows data will be filled in automatically when you actually trigger the automation.

Here you can understand how iterator module works in pabbly connect -
 

akudinov

Member
I'm building a plutio invoice out of woocommerce order
The order has multiple items (so an array) and every item contains an array of metadata. So I want to have 2 loops - one over items and for every item a loop of the metadata to add those key-value-pairs to the item, so basically loop inside the loop. With their iterator taking over the rest of the workflow i don't see how that can be possible.
 

Fagun Shah

Well-known member
I would really like to see the array in a screenrecording to help with exact solution.

What output you get when you pass woocommerce line items in iterator?

May be try sending data to another workflow for 2nd loop using pabbly Api module.

If you want, you can PM me on fb messenger with screenrecording and I will take a look.

My messenger url is below.
 

akudinov

Member
Here's another headscratcher and also with arrays - adding an attendee to a google calendar event. Well, first I need to get all current attendees - okay, I did that. And then Pabbly suggests to add another json object to the array (which should not be passed as an array - another weird decision) {"email":"[email protected]"}

So here's the question. Get Event returns either this (if I check Simple Response)

1628997564006.png


or this (a json array):

1628997639178.png

what's the easy way to take ANY of these, add another {"email":"[email protected]"} email to it and send that to Add Guest to Event?
Also I will have arbitrary number of attendees, so I can't "hardcode Attendees 0->email, Attendees 1-> email and so on. I need either a string operator, or array iterator. I am lost - this needs to be simple.
 

Fagun Shah

Well-known member
Here's another headscratcher and also with arrays - adding an attendee to a google calendar event. Well, first I need to get all current attendees - okay, I did that. And then Pabbly suggests to add another json object to the array (which should not be passed as an array - another weird decision) {"email":"[email protected]"}

So here's the question. Get Event returns either this (if I check Simple Response)

View attachment 2902

or this (a json array):

View attachment 2903
what's the easy way to take ANY of these, add another {"email":"[email protected]"} email to it and send that to Add Guest to Event?
Also I will have arbitrary number of attendees, so I can't "hardcode Attendees 0->email, Attendees 1-> email and so on. I need either a string operator, or array iterator. I am lost - this needs to be simple.
After some trial and error I was able to get array of emails of existing email ids in pabbly's desired format for Adding Google Calendar Event Attendees -

1629006170927.png


But to add new email addresses to that array, I need to know in which format are you getting New Email IDs? Can you share the screenshot of that?
 

akudinov

Member
it's just an email - [email protected]
See, my point is it should not be this hard - web automation is not about gluing the whole thing together and praying it sticks together, it's about making things easy - and this is NOT EASY. I would have imagineed that inviting a guest to a google event would be as simple as specifying an event and a guest email, and Pabbly does the rest. Boy was I wrong :)

Well, I got to a similar point where you are - getting a list of emails (for which I need to know regex - how many people who use pabbly know regex???),
1629039465030.png


I can even turn it into an array and all that, but then I am again stuck with a simple operation of assembling an array into a string - THIS SHOULD BE SIMPLE.
 
Last edited:

Fagun Shah

Well-known member
it's just an email - [email protected]
See, my point is it should not be this hard - web automation is not about gluing the whole thing together and praying it sticks together, it's about making things easy - and this is NOT EASY. I would have imagineed that inviting a guest to a google event would be as simple as specifying an event and a guest email, and Pabbly does the rest. Boy was I wrong :)

Well, I got to a similar point where you are - getting a list of emails (for which I need to know regex - how many people who use pabbly know regex???),
View attachment 2906

I can even turn it into an array and all that, but then I am again stuck with a simple operation of assembling an array into a string - THIS SHOULD BE SIMPLE.
So this how you can get all the already present attendees in pabbly desire format and then pass extra attendee with them again to google calendar event -

1629044086757.png

@akudinov and I agree this little bit more complex for normal End User, so tagging @Pabbly to make get their attention to make this easier.

Let me know if you need any more help.
 

akudinov

Member
Alright, great idea, that points me in the right direction. The reason I can't use it verbatim is because google calendar Attendees list might contain many more permutations and attributes inside a single attendee object, so figuring them all out gonna be an impossible task. So basically here's how I am solving it, first regex all emails,

1629045467289.png

and then do 5 (FIVE!!!) text replacements (@Pabbly if you ever are looking to improve your text replacement - make it so we could specify a list of "from/to" pairs in the same action)

basically here's my list of replacements I did in that list (from -> to)

[" -> {
\" -> "
"" -> "
"," -> "},{"
] -> }

which results in what I need

{"email":"[email protected]"},{"email":"[email protected]"}

now I can add comma to that and {"email":"[email protected]"} and then send it to google. So all in all it takes 8 (EIGHT!!! @Pabbly, seriously???) steps to add a recipient to a google calendar event. That's just bad, plain and simple.
 

Fagun Shah

Well-known member
Alright, great idea, that points me in the right direction. The reason I can't use it verbatim is because google calendar Attendees list might contain many more permutations and attributes inside a single attendee object, so figuring them all out gonna be an impossible task. So basically here's how I am solving it, first regex all emails,

View attachment 2909
and then do 5 (FIVE!!!) text replacements (@Pabbly if you ever are looking to improve your text replacement - make it so we could specify a list of "from/to" pairs in the same action)

basically here's my list of replacements I did in that list (from -> to)

[" -> {
\" -> "
"" -> "
"," -> "},{"
] -> }

which results in what I need

{"email":"[email protected]"},{"email":"[email protected]"}

now I can add comma to that and {"email":"[email protected]"} and then send it to google. So all in all it takes 8 (EIGHT!!! @Pabbly, seriously???) steps to add a recipient to a google calendar event. That's just bad, plain and simple.
This is still hard to do if people do not know how to use regex. So pabbly should improve this.

Do you know how to use regex or is there any tool to generate this regex?
 
Top