getting all the contacts emails (existing contacts & newly created) from freshsales suite into google sheets.

[Hai]

Hi, i'm kinda lost with trying to get this to loop over the entire contacts.
in programming these should be something like a for loop that runs x times per the contacts array.
I've tried the itterator but after 4 hours in the forum and tutorials i find the logic to be far from understanding.


Steps:
0.Trigger new contact in freshsales
1.calculate number of contacts.
2.fetch freshsales contact email & name.
3.create or update row in google sheets accordingly
4.repeat until the all contacts are made.

the required result: updated customers email & name list in google sheets.
Pabbly feels like it can be an amazing tool for me - but either my knowledge is lacking or im missing something. would love to get support to solve this, and more important some good guidance so i can use this tool properly.
Thanks.

 

[Supreme]

Hey @Hai

Steps:
0.Trigger new contact in freshsales
1.calculate number of contacts.

Regarding the 1 & 2nd points, you can only get 1 contact detail at a time, so you can only process one contact in your Google Sheets at a time.

3.create or update row in google sheets accordingly
4.repeat until the all contacts are made.

Further, if you want to add a new row and update the row of your Google Sheets for the same contact then you should use the "Router" action step.

So, in that way you can create 2 routes first for creating a new row and the second one for updating the same row for a contact.

You can refer to the following video tutorial on how you can use the router action step.

Let us know if you get stuck at any step.