Key Client Dashboard in Google Sheet with Pipedrive/Mailchimp/etc data


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?

Many Thanks