The short answer
A successful Pipedrive spreadsheet import does not establish that an automation should run. First identify the record type, what changed and the exact event or date trigger. Then check conditions, user visibility, timing and any activity or message already created. An empty history is inconclusive: it does not prove a failed execution or tell you to reimport.
This guide diagnoses one expected action after an import. It is documentation-informed advice with an original blank ledger and fictional cases, not an import test. Do not delete records, move deals back and forth or resend a batch to force activity. Those changes can create follow-up work that no longer matches the customer's current request.
Write down the expected business action
Start with one record rather than the whole batch. Was the intended result an internal reminder, a new activity or a customer acknowledgment? Name the action and its owner. Find the record ID, import reference and time, then describe what the import actually changed. Creating a deal already in a stage is a different operation from moving an existing deal into that stage.
Pipedrive's troubleshooting guide says most imports do not trigger automations. Its exceptions include imported lead updates for event triggers and date-field additions or updates in activities, deals, organizations and people for date triggers. API-created items have separate requirements, including activation before creation, matching conditions and valid values. That activation-before-creation rule should not be generalized to date-trigger scenarios. Treat these as routes to investigate, not promises that an action will occur.
The automation overview distinguishes event and date triggers and describes availability from Growth upward, with account differences in the automation version. It also mentions lead deletion alongside updates, while troubleshooting lists updates. This guide uses lead updates as the practical example and does not claim an exhaustive exception list. Deletion is not a workaround.
Classify the event before looking for a failure
| Control to record | Your entry |
|---|---|
| New imported deals or people | Check whether the expected trigger applies to this import at all. Record creation success is not an automation event guarantee. |
| Imported update to an existing lead | Inspect the exact update, enabled automation, conditions and authorized user visibility. The documented exception is not a guaranteed outcome. |
| Imported date field | Identify the supported record type, field, relative schedule, hour and time zone. Look for the scheduled check rather than assuming immediate execution. |
| API-created item | Use the API-specific requirements. Do not transfer spreadsheet-import assumptions to a different creation route. |
| Deliberate subsequent edit | Establish the real business change and approved scope first. A later edit may be a separate event; never stage-bounce to provoke one. |
Pipedrive's conditions guide separates passive state from active change. A deal being in Estimate sent is not the same as a stage-change event. Movement in either direction can trigger relevant automations. Reversing and restoring stages therefore adds events; it is not a harmless diagnostic refresh.
Use the Import-to-Action Ledger
Keep one copy per record you investigate. This is our editorial worksheet, not a native Pipedrive feature. A small controlled spreadsheet or paper sheet is enough. Use private references to evidence, not full customer messages or publicly shared screenshots. Leave the actual result blank until you have observed it through an authorized check.
| Control to record | Your entry |
|---|---|
| Batch reference, import time and time zone | ____________ |
| Record type and record ID | ____________ |
| What the import created or changed | ____________ |
| Intended business action and responsible person | ____________ |
| Automation ID, owner and account version | ____________ |
| Event trigger or date trigger | ____________ |
| Required active change and static conditions | ____________ |
| Date field, relative execution time, hour and time zone | ____________ |
| Authorized user, ownership and visibility | ____________ |
| Existing activity, message or destination reference | ____________ |
| Evidence reference and unresolved question | ____________ |
| Classification: no qualifying event / scheduled check / stopped-failed / unresolved | ____________ |
| Approved next action, person and review time | ____________ |
| Actual observed result | ____________ |
Use no qualifying event only when the documented trigger and the actual operation support that conclusion. Scheduled check means you still need to verify the applicable timing. Stopped-failed requires evidence of an execution or relevant limit. Unresolved is a useful state when visibility or records do not settle the question. Do not convert uncertainty into a resend instruction.
Check time, visibility and history separately
Date-trigger documentation covers activity, deal, organization and person date fields, with before, exact or after relationships, an execution hour and time zone. Enabled-user ownership and visibility affect evaluated items. Record those choices before calling a missing immediate action a fault. A date trigger can evaluate existing eligible records at its configured time, including records imported earlier. Importing a date is not a promise of immediate execution or retroactive catch-up.
Automation history documentation describes viewer ownership, unmet-condition visibility and a normal 15-day history extended by delays. Its legacy Advanced label should not decide current plan eligibility. Across the documentation, history visibility also depends on execution progress. The robust conclusion is limited: no history entry is inconclusive.
Pipedrive's limits guide adds that bulk edits can stop executions, while loops or fan-out can produce ignored executions absent from history. Global administrators can skip automations during bulk changes. Email provider and account constraints are another check. Do not diagnose a trigger problem solely from a missing email, or prescribe a broad retry before identifying where the action stopped.
Three fictional records, with outcomes left blank
These cases are proposed reasoning exercises. No account operation was performed and none is a recorded pass or failure.
| Synthetic record | Proposed decision | Observed outcome |
|---|---|---|
| DEMO-DEAL-01: new spreadsheet deal already in Estimate sent | The expected internal follow-up is absent in the fictional scenario. Classify import versus trigger first; do not declare a failed execution from the stage label. Inspect existing activities before any approved check. | ____________ |
| DEMO-LEAD-02: existing lead owner updated | Consider the documented lead-update exception, then inspect exact conditions, automation version and user visibility. Owner change alone is not a guaranteed action. | ____________ |
| DEMO-ORG-03: future renewal date imported | Inspect the date field, relative schedule, hour and time zone. No immediate action is not necessarily a fault. Record the next review rather than inventing a catch-up result. | ____________ |
Make the next check small and accountable
Before an authorized test, look for existing activities, destination records and messages. Reconcile current customer replies, cancellations and the intended action. A duplicate reminder or obsolete acknowledgment is not a useful diagnostic. If a real subsequent change is appropriate, record its purpose, affected record and owner before making it; this article does not authorize account changes.
For support, collect the private batch reference, record and automation IDs, import time and time zone, trigger type, conditions, relevant settings and redacted history evidence. State the expected action and what you could actually inspect. Keep unknowns explicit. Never publish customer data, private record URLs or credentials in a public troubleshooting example.
Use the Pipedrive review for product fit and the Pipedrive workflow evaluation for a broader controlled assessment. If the issue is what the next message should say or when it remains appropriate, use the estimate follow-up guide. Finish this diagnosis with a justified next action, not an artificially busy history.
Editorial record
Who reviewed this page and what happens next.
Commercial relationships cannot change the evidence state, fit statement, caveats, or conclusion.
- Research and review
- Andre Ribeiro
- Published
- Last material review
- Next scheduled review
- Evidence scope
- Official Pipedrive documentation reviewed through the verified research handoff on 3 October 2026. Original Import-to-Action Ledger, classification aid and fictional cases.
- Evidence state
- Documentation-informed proposed checks only. No import, account change, message send or automation test was performed. Actual worksheet and case results remain blank.
Testing methodologyEditorial standardsCorrections and update log