Get All Deals (Pipedrive)
Retrieve all deals from Pipedrive with amounts, stages, statuses, and associated contacts.
PipedriveWhat it needs.
Map each field to a column in your table. Optional fields can stay empty.
limitItems shown per page.nullablenumbersort_bySelect how you want to sort the returned deals.nullableselectowned_by_youIf set to Yes, only deals owned by you will be returned.nullableselect
When to use this.
The "Get All Deals (Pipedrive)" action enables users to retrieve a comprehensive list of deals from Pipedrive, including essential details such as deal amounts, stages, statuses, and associated contacts. Key input parameters include "limit" for pagination, "sort" for organizing the results, and "owned_by_you" to filter deals specifically owned by the user. The output provides a wealth of information, including deal IDs, titles, values, currencies, statuses, and associated organizations and contacts, all categorized under CRM. This action is particularly useful for sales teams looking to analyze their pipeline, track deal progress, and manage customer relationships effectively. By leveraging this API action, businesses can enhance their sales strategies and improve overall CRM efficiency.
What it returns.
Every field this action writes back to the row. Click a line to expand nested objects.
idIdnumbertitleTitletextvalueValuenumbercurrencyCurrencytextformatted_valueFormatted Valuenullabletextweighted_valueWeighted Valuenullablenumberformatted_weighted_valueFormatted Weighted Valuenullabletextstage_idStage Idnumberpipeline_idPipeline IdnumberstatusStatustextprobabilityProbabilitynullablenumberperson_idPerson Idnumberperson_namePerson Namenullabletextorg_idOrg Idnumberorg_nameOrg Namenullabletextuser_id_outUser Id Outnullablenumberowner_nameOwner Namenullabletextcreator_user_idCreator User IdnullablenumberactiveActivenullablebooleandeletedDeletednullablebooleanis_archivedIs Archivednullablebooleanvisible_toVisible Tonullabletextadd_timeAdd Timenullabletextupdate_timeUpdate Timenullabletextstage_change_timeStage Change Timenullabletextclose_timeClose Timenullabletextwon_timeWon Timenullabletextlost_timeLost Timenullabletextexpected_close_dateExpected Close Datetextnext_activity_dateNext Activity Datenullabletextnext_activity_timeNext Activity Timenullabletextnext_activity_idNext Activity Idnullablenumbernext_activity_subjectNext Activity Subjectnullabletextnext_activity_typeNext Activity Typenullabletextlast_activity_idLast Activity Idnullablenumberlast_activity_dateLast Activity Datenullabletextlost_reasonLost Reasonnullabletextproduct_countProduct Countnullablenumberfile_countFile Countnullablenumbernote_countNote Countnullablenumberfollower_countFollower Countnullablenumberemail_message_countEmail Message Countnullablenumberactivity_countActivity Countnullablenumberdone_activity_countDone Activity Countnullablenumberundone_activity_countUndone Activity Countnullablenumberparticipant_countParticipant CountnullablenumberlabelLabelnullabletextoriginOriginnullabletextchannelChannelnullablenumberchannel_idChannel Idnullabletextcc_emailCc EmailnullabletextacvAcvnullablenumberarrArrnullablenumbermrrMrrnullablenumberacv_currencyAcv Currencynullabletextarr_currencyArr Currencynullabletextmrr_currencyMrr Currencynullabletext
How this fits a workflow.
Trigger → Get All Deals (Pipedrive) → enrich → push to your CRM. You set it up once; after that it runs without you.
- Step 1TriggerNew row, form submit, or schedule.
- Step 2Get All Deals (Pipedrive)The Pipedrive action runs.
- Step 3EnrichWaterfall fills missing fields.
- Step 4Push to CRMHubSpot / Pipedrive / Zoho CRM / GoHighLevel.
Two actions you can chain after this one:
Throughput & reliability.
How fast it drains a table, and what happens when the upstream provider has a bad day.
- Per-minute limitNo public cap
- Per-day limitPlan-defined
- RetriesAutomatic w/ backoff
- Failed lookupsZero credits
More Pipedrive actions.
crm
Get Deals by Person (Pipedrive)
Retrieve all deals linked to a specified person from Pipedrive API v2, including amounts, stages, and statuses.
Delete Lead (Pipedrive)
Deletes a specific lead from Pipedrive using its ID.
Search Deals (Pipedrive)
Searches all deals by title, notes, and/or custom fields using Pipedrive API v2. Can be filtered by person ID, organization ID, or status.
Search Organizations (Pipedrive)
Find organizations in Pipedrive by name, address, notes, or custom fields using the v2 Search API.
FAQ.
Run Get All Deals (Pipedrive) in 60 seconds.
Connect the account, drop the action on a column, run it on your rows.