• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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.
 
P

Pabblymember11

Guest
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