To move data from Pipedrive to Google Sheets automatically, use a ready-made scenario — no manual exports.
You can launch this Pipedrive + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.