Review this blog post to learn how to link data between Google Sheets by utilizing different approaches, and pick the one that will suit you the best.
To export data from Pipedrive to Google Sheets, use a GSheets add-on, Coupler.io. Check out the flow and real-life use cases in the blog post.
You can import data from Airtable to Google Sheets automatically using an add-on called Coupler.io. Check out this tutorial to discover more available features.