viniciussricci
Member
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.
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.