Workflows
Manages and retrieves workflows configured in HubSpot to automate marketing, sales, and service processes.
Table Specific Information
Workflows are automated tasks in HubSpot. You can perform automated tasks with contacts by enrolling contacts in workflows.
SELECT
When selecting workflows, data may be filtered by the WorkflowId. For example:
SELECT * FROM Workflows WHERE WorkflowId = '123456789'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Unique identifier assigned to the workflow. | |
| Name | String | The user-friendly name assigned to the workflow, displayed in HubSpot. | |
| Description | String | Detailed explanation of the workflow's purpose or objective. | |
| IsEnabled | Boolean | Boolean indicating whether the workflow is currently active and can execute. | |
| CreatedAt | Datetime | Timestamp indicating when the workflow was initially created. | |
| UpdatedAt | Datetime | Timestamp indicating the most recent update made to the workflow. | |
| AllowContactToTriggerMultipleTimes | Boolean | Boolean specifying whether the same contact can trigger and be enrolled in this workflow multiple times. | |
| CanEnrollFromSalesforce | Boolean | Boolean indicating whether contacts can be enrolled into this workflow via Salesforce integration. | |
| IsInternal | Boolean | Boolean flag showing whether the workflow is internal and not user-facing. | |
| LegacyCampaignId | Long | Identifier for any legacy campaign associated with the workflow, if applicable. | |
| LegacyMigration | Boolean | Boolean indicating whether this workflow was migrated from HubSpot's legacy lead nurturing tool. | |
| IsListening | Boolean | Boolean specifying whether the workflow is actively monitoring for trigger conditions. | |
| ContactListIdsCompleted | Long | ID referencing the list of contacts who have completed the workflow. | |
| ContactListIdsEnrolled | Long | ID referencing the list of contacts currently enrolled in the workflow. | |
| ContactListIdsSucceeded | Long | ID referencing the list of contacts who successfully completed all steps in the workflow. | |
| ContactListIdsActive | Long | ID referencing the list of contacts currently active within the workflow. | |
| StepsAggregate | String | Aggregate containing the ordered steps and actions defined within the workflow. | |
| SupresssionSettingsAggregate | String | Aggregate defining suppression settings used to prevent specific contacts from entering the workflow. | |
| TriggersAggregate | String | Aggregate listing the trigger conditions that enroll contacts into the workflow. | |
| UnenrollmentSettingType | String | Defines how unenrollment is handled when a contact meets specific conditions. | |
| UnenrollmentSettingExcludedWorkflowsAggregate | String | Aggregate listing workflows from which a contact should be removed upon enrolling in this workflow. | |
| GoalListAggregate | String | Aggregate listing the goal IDs associated with this workflow, used to measure its success. | |
| ExtraUrlParameters | String | Optional input-only property for adding additional query parameters when querying workflow data. Format parameters as name=value pairs separated by commas (for example: 'param1=value1, param2=value2, param3=value3'). |