PipedriveSheets support
Everything I know about
running this add-on.
Videos, the full menu mapped out, fixes for the things that actually go wrong, and my inbox when none of that does it.
50 answers, guides and menu items on this page
Start here
Three tutorials, about a minute each. Watch in this order.
Fix something
What you're seeing, why it happens, and the exact click that fixes it.
Only 50 rows came through, and some of my columns are missing
WhyThe Free plan pulls up to 50 rows and 12 columns per sync. Everything past that is left behind rather than partially written.
FixNarrow the Pipedrive filter you selected so the records you care about fit inside 50, or move to Pro for unlimited rows and columns.
PipedriveSheets ▸ 💎 Upgrade Plan
I edited cells but Push to Pipedrive does nothing
WhyTwo-way sync is off for that sheet. Without it there is no Sync Status column, so nothing is ever marked Modified, and a push has no rows to send.
FixTurn on two-way sync for the sheet. A Sync Status column appears. Edit a cell, watch that row flip to Modified, then push.
PipedriveSheets ▸ ⚙️ Settings ▸ 🔁 Two-Way Sync Settings
This is the single most common reason a Pro subscription goes unused. If the column is not in your sheet, the setting is not on.
I changed the Stage, Pipeline or Owner column and Pipedrive ignored it
WhyThose columns hold the human-readable label. Pipedrive only accepts the underlying id on write, so an edit to the label column is never sent.
FixAdd the id column — stage_id, pipeline_id, owner_id — to your column selection and edit that instead. The label column keeps updating on every pull, so you can read one and write the other.
PipedriveSheets ▸ ⚙️ Settings ▸ 🔄 Sync Setup
A row I typed by hand did not create anything in Pipedrive
WhyNew records are recognised by an empty Pipedrive ID. If that cell has anything in it, the push treats the row as an update to a record that does not exist.
FixLeave the Pipedrive ID cell completely blank on new rows, then push. Rows without an ID survive a pull, so nothing you type gets wiped before it is sent.
Leads are the exception: a new lead needs either a Person ID or an Organization ID filled in, or Pipedrive rejects it.
Scheduled sync stopped running on its own
WhyGoogle occasionally drops the timer behind a scheduled sync — most often after a long stretch of the spreadsheet going untouched, or a change to the account that owns it.
FixOpen the schedule, delete the existing entry, and create it again. The new timer registers immediately and the schedule resumes.
PipedriveSheets ▸ 🛠️ Tools ▸ ⏱️ Schedule Sync
If a run was interrupted mid-way, the next run picks up where it left off — you do not need to repair the sheet by hand.
“Sheet is not configured for Pipedrive sync”
WhyThe tab you are on has no saved mapping. Settings live per sheet, so a new tab, a copied spreadsheet or a renamed sheet starts blank.
FixFor an empty sheet, run Sync Setup. For a sheet you already built by hand, run Configure Existing Sheet so your columns are mapped instead of overwritten.
PipedriveSheets ▸ ⚙️ Settings ▸ 🔄 Sync Setup
“No column mapping found” or “No fields are mapped”
WhyThe sheet was mapped once, but the headers have since been renamed, reordered or deleted, so the saved mapping no longer points at real columns.
FixRe-run Configure Existing Sheet. Auto-Suggest will match most headers for you, and you only correct the ones it gets wrong.
PipedriveSheets ▸ ⚙️ Settings ▸ 📋 Configure Existing Sheet
“Cannot delete: No Pipedrive ID found”
WhyDelete only works on records that exist in Pipedrive, and the ID column is how the add-on knows which record you mean.
FixDelete the spreadsheet row instead — a row that was never pushed exists nowhere else. For a record that does exist, pull once so the ID column is populated, then delete.
Pipedrive keeps asking me to reconnect
WhyThe connection is an OAuth grant. Revoking access in Pipedrive, changing companies, or an admin removing the app all end it.
FixReconnect from the Get Started item. Your sheets, mappings and schedules are kept — reconnecting restores access, it does not reset your setup.
PipedriveSheets ▸ 🚀 Get Started with PipedriveSheets
A brief network or Pipedrive outage no longer disconnects you, and your plan is not downgraded to free-tier limits during one.
The PipedriveSheets menu is missing from Extensions
WhyGoogle builds add-on menus when a spreadsheet opens. A spreadsheet left open across an update, or opened before the add-on finished installing, can miss it.
FixReload the browser tab. If the menu is still absent, confirm you are signed into the Google account that installed the add-on — menus do not follow you between accounts.
Answers
Billing, updates, data handling and the questions that come up most.
How quickly do you reply to support email?
Usually within 24 hours, and often the same day. Pro and Team messages are answered first. It is me answering, not a queue — so the more detail you send, the faster it resolves.
Do I have to reinstall to get new versions?
No. PipedriveSheets updates itself through the Google Workspace Marketplace. You are always on the current published version the next time you open a spreadsheet. The version you are running is shown under Support Center, alongside the release notes.
Will syncing overwrite my formulas, notes and formatting?
Only mapped columns are ever written to. Columns you added yourself — notes, formulas, conditional formatting, anything the mapping does not reference — are left exactly as they are on every pull.
Can I sync more than one sheet in the same spreadsheet?
Yes. Settings are stored per sheet, so one tab can hold deals, another persons, another a filtered slice of the same pipeline. Manage Synced Sheets lists everything currently wired up in that spreadsheet.
Where do I change or cancel my subscription?
Manage Subscription opens the Stripe billing portal, where you can update your card, switch between monthly and yearly, or cancel. Cancelling leaves your data in the sheet untouched; the sheet simply stops syncing at the end of the paid period.
What happens to my sheets if I go back to the Free plan?
Nothing is deleted. Your data stays in the sheet, your mappings stay saved, and manual pulls keep working within the Free limits of 50 rows and 12 columns. Two-way sync, scheduled sync and bulk operations stop until you upgrade again.
Do you store my Pipedrive data on your servers?
No. Your CRM data moves between Pipedrive and your spreadsheet over encrypted connections and is not kept on any server of mine. Authentication is OAuth 2.0, so your Pipedrive password is never seen or stored by the add-on.
Can my whole team use one subscription?
The Team plan covers up to 5 members and shares filters, column preferences and access across everyone on it. Pro is a single-user plan — a second person needs their own, or the team moves to Team.
Does it work on a shared drive or a spreadsheet someone else owns?
Yes, as long as you have edit access to the spreadsheet and the add-on installed on your own Google account. Each person connects their own Pipedrive account, so records are created and updated under the right user.
Read more
Longer pieces, and honest comparisons with the other ways to do this.
Guides on the blog
Compared with
Still stuck
Write to me. It's me reading it, usually the same day.
Put these in the message and you'll get a real answer instead of a follow-up question
- Which sheet and which data type — deals, persons, activities.
- What you clicked, and what happened instead of what you expected.
- The exact error text, or a screenshot of it.
- Whether you're on Free, Pro or Team.