TL;DRIf you need a one-time contacts export from Pipedrive:
Contacts tab → Filter (top right, next to your name) → Create a new filter → Export filter result (top right)
If you need a regular export to Google Sheets:
Sign up to
CSV Loader → New Export → Pipedrive and People/Organizations → Start Export → Select Google Sheets → Set schedule