We would like to setup a Key client Google Sheet Dashboard for Sales Team, that pulls information from:
-Pipedrive (Last Activity, won deals in last 12 months, total deals in last 12months, etc)
-Mailchimp (Subscribed?, Last Opened campaign)
Any hints on what is the easiest way to set this up/ how to go about this?
My company (momentumtools.io) has built an easy & secure backup solution for Podio.com that syncs their data to a readable format to Google Sheets.
It also syncs meta data such as comments & files to a secured Google Drive folder. This transparent approach has received lots of praise from the Podio community and we’re keen to do the same for Pipedrive.