Pipedrive has no native scheduled export and no bulk-write API. This Google Sheets™ add-on fills both gaps: refresh saved Pipedrive searches into the sheet on a schedule, and safely create or update deals, persons, and organizations from a validated template.
Live
Install from Google Workspace MarketplacePipedrive Bulk Importer & Exporter is a Google Sheets™ add-on published by Cody Labs. It connects to your Pipedrive account via a personal API token, with no OAuth app registration required. It does two things: (1) schedule automatic refreshes of any saved Pipedrive filter or search into the sheet (hourly, daily, or weekly), and (2) safely create or update deals, persons, and organizations from a validated spreadsheet template with ID write-back to prevent duplicates. Your data flows directly between your Pipedrive account and your spreadsheet: we operate no servers and never receive your CRM data. See the privacy policy for full details.
Hourly, daily, or weekly refresh of saved Pipedrive filters or searches into a spreadsheet tab, with resumption for large result sets.
Connect with just a personal API token from your own Pipedrive account. No developer registration.
Validate rows against real Pipedrive pipelines, stages, owners, and custom fields before pushing.
ID write-back prevents duplicate creates; sequential updates with validation keep data in sync.
It works in both directions: scheduled exports out of Pipedrive, and validated bulk pushes back in. Set it up once and both halves keep working.
There is no OAuth app to register. Paste a personal API token from your own Pipedrive account into the sidebar and click Test & save. It confirms the token works before storing it.
Point the add-on at a saved filter or search and click Export. Large result sets are resumable, so big exports finish rather than timing out. Schedule it hourly, daily, or weekly to keep a reporting sheet current.
Change values, or add new rows. Before anything is written back, rows are validated against your real pipelines, stages, owners, and custom fields, so a bad stage name is caught in the sheet.
Click Import / update. Record IDs are written back to the sheet, so re-running an import updates the same records instead of creating duplicates.
You'll get your license key by email after checkout. Sign in to your account portal to copy it.
No. Just connect with a personal API token from your own Pipedrive account. No developer app registration required.
Yes, sequentially with validation and ID write-back. Pipedrive has no native batch-write endpoint, so this add-on handles updates safely one by one.
Yes. It refreshes saved Pipedrive filters or searches into your spreadsheet hourly, daily, or weekly.