Pipedrive leads to Sheets

Hi!

I'm preparing a dashboard using data studio, and for that I need to feed a spreadsheet in google sheets periodically, my idea is to hit the pipedrive 'get all leads' endpoint and update all the rows in the spreadsheet with the data again, but I'm only able to insert one line through the sheets api.

My question would be, how can I hit the 'get all leads' endpoint of the pipedrive and thus write the fields that interest me all at once in a given spreadsheet of the sheets, in my head I would need a looping in pabbly to do that, but I couldn't find anything about it.
 

Supreme

Well-known member
Staff member
My question would be, how can I hit the 'get all leads' endpoint of the pipedrive and thus write the fields that interest me all at once in a given spreadsheet of the sheets, in my head I would need a looping in pabbly to do that, but I couldn't find anything about it.
You can try the following action step once and then try. Further with the help of the Filter action step, you can process the data accordingly.

1673075662750.png
 
Top