Hello Pipedrive Community,
Last year, I created an add-on called API Connector for Sheets that pulls data from Pipedrive and other platforms to Google Sheets. There are now nearly 100K users, many of whom use it for Pipedrive, so I created a beginner-friendly, step-by-step tutorial for how to use API Connector with the Pipedrive API: https://mixedanalytics.com/knowledge-base/import-pipedrive-data-to-google-sheets/
The tutorial walks through how to get your personal API token, create an API request URL, and pull data into Google Sheets.
Creator, API Connector