HubSpot
Append HubSpot deals to Google Sheets
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 code
- Hubspot.listRecentDeals.TotalCount
- Type
- String
- Example
- 10
Most recent deal name
- Slug
- most_recent_deal_name
- Filter code
- Hubspot.listRecentDeals.MostRecentDealName
- Type
- String
- Example
- Acme Q2 Renewal
Most recent amount
- Slug
- most_recent_amount
- Filter code
- Hubspot.listRecentDeals.MostRecentAmount
- Type
- String
- Example
- 12500.00
Most recent stage name
- Slug
- most_recent_stage_name
- Filter code
- Hubspot.listRecentDeals.MostRecentStageName
- Type
- String
- Example
- Closed Won
Most recent created at
- Slug
- most_recent_created_at
- Filter code
- 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 code
- Hubspot.listRecentDeals.MostRecentDealUrl
- Type
- Web URL
- Example
- https://app.hubspot.com/contacts/12345/deal/98765
Total amount
- Slug
- total_amount
- Filter code
- Hubspot.listRecentDeals.TotalAmount
- Type
- String
- Example
- 98500.00
