Search Deals (HubSpot)
Search for deals using a text query or specific filters
What it needs.
Map each field to a column in your table. Optional fields can stay empty.
propertynameThe name of the property to filter by (e.g., 'dealname', 'amount').nullableselectoperatorThe operator for the filter (e.g., EQ, CONTAINS_TOKEN). Required if Filter Property Name is used.nullableselectvalueThe value to filter for. Required if Filter Property Name is used.nullabletextquery_stringQuery string for text search across multiple fields.nullabletextsort_byThe property to sort the results by.nullableselectsort_directionThe direction to sort (ASCENDING or DESCENDING).nullableselectlimitThe maximum number of results to return per page (max 100).nullablenumberafterThe paging cursor token for retrieving the next page of results.nullabletext
When to use this.
The "Search Deals (HubSpot)" action enables users to efficiently search for deals within the HubSpot CRM by utilizing a text query or specific filters. Key input parameters include 'propertyname' for filtering by attributes like 'dealname' or 'amount', 'operator' to define the filter logic, and 'value' to specify the filter criteria. Users can also employ 'querystring' for broader text searches, while 'sortpropertyname' and 'sortdirection' allow for organized results. The action returns a comprehensive set of output fields, including deal ID, creation and update dates, deal stage, amount, close date, and more, providing valuable insights into each deal's status and details. This action is ideal for sales teams looking to streamline deal management, analyze performance, and prioritize follow-ups, making it a vital tool in CRM operations.
What it returns.
Every field this action writes back to the row. Click a line to expand nested objects.
idIdtextcreated_atCreated Atnullabletextupdated_atUpdated AtnullabletextarchivedArchivednullablebooleandeal_nameDeal NametextpipelinePipelinetextdeal_stageDeal StagetextamountAmountnumberclose_dateClose Datetextdeal_typeDeal TypenullabletextdescriptionDescriptionnullabletextpriorityPrioritynullabletextanalytics_sourceAnalytics Sourcenullabletextclosed_lost_reasonClosed Lost Reasonnullabletextclosed_won_reasonClosed Won Reasonnullabletextnext_stepNext Stepnullabletextdeal_stage_probabilityDeal Stage Probabilitynullablenumberdeal_collaborator_owner_idDeal Collaborator Owner Idnullabletextcreator_dateCreator Datenullabletextlast_modified_dateLast Modified Datenullabletexthubspot_owner_idHubspot Owner IdnullabletexttotalTotalnullablenumbernext_afterNext Afternullabletext
How this fits a workflow.
Trigger → Search Deals (HubSpot) → enrich → push to your CRM. You set it up once; after that it runs without you.
- Step 1TriggerNew row, form submit, or schedule.
- Step 2Search Deals (HubSpot)The HubSpot 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 limit100 / min
- Per-day limit24,000 / day
- RetriesAutomatic w/ backoff
- Failed lookupsZero credits
More HubSpot actions.
crm
List Contacts (HubSpot)
Retrieves all HubSpot contacts with email, name, phone, company, and custom properties.
crm
Get Contact (HubSpot)
Retrieves a specific HubSpot contact by ID with all standard, demographic, and custom properties.
crm
Create Company (HubSpot)
Creates a new company record in HubSpot with firmographic properties and optional associations.
crm
Search Contacts (HubSpot)
Search for HubSpot CRM contacts by email address or other filters and retrieve their properties.
FAQ.
Run Search Deals (HubSpot) in 60 seconds.
Connect the account, drop the action on a column, run it on your rows.