• 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

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