Explore Plans
HubSpot

List recent deals

This query returns the most recent deals in your HubSpot CRM, optionally filtered by pipeline and stage.

Developer info

API endpoint slug
hubspot.list_recent_deals
Runtime method
performQuery("hubspot.list_recent_deals"}

Query fields

Pipeline stage Nested dropdown list

Label
Pipeline and stage
Helper text
Optional. Pick a pipeline and stage to filter the deals returned. Leave blank to list across all pipelines.
Slug
pipeline_stage_id
Required
false
Can have default value
false

Ingredients

Total count

Slug
total_count
Filter
Hubspot.listRecentDeals.TotalCount
Type
String
Example
10

Most recent deal name

Slug
most_recent_deal_name
Filter
Hubspot.listRecentDeals.MostRecentDealName
Type
String
Example
Acme Q2 Renewal

Most recent amount

Slug
most_recent_amount
Filter
Hubspot.listRecentDeals.MostRecentAmount
Type
String
Example
12500.00

Most recent stage name

Slug
most_recent_stage_name
Filter
Hubspot.listRecentDeals.MostRecentStageName
Type
String
Example
Closed Won

Most recent created at

Slug
most_recent_created_at
Filter
Hubspot.listRecentDeals.MostRecentCreatedAt
Type
Date with time (ISO8601)
Example
2020-07-08T04:17:06+05:00

Most recent deal url

Slug
most_recent_deal_url
Filter
Hubspot.listRecentDeals.MostRecentDealUrl
Type
Web URL
Example
https://app.hubspot.com/contacts/12345/deal/98765

Total amount

Slug
total_amount
Filter
Hubspot.listRecentDeals.TotalAmount
Type
String
Example
98500.00