> ## Documentation Index
> Fetch the complete documentation index at: https://docs.runway.com/llms.txt
> Use this file to discover all available pages before exploring further.
# HubSpot
> The HubSpot integration allows you to automatically sync your deals and revenue data into Runway.
Runway offers two ways to integrate with **HubSpot**:
* **SQL-powered integration via Fivetran (Recommended)** – Ideal if you need advanced data customization and want to pull in a wide range of HubSpot objects (like Deals, Owners, Accounts, Users, and more).
* **Quick-start connection via Workato** – A simpler setup, but limited in scope. For example, it supports only a subset of HubSpot objects, such as Deals, and doesn't allow you to pull in related context like Owner, Account, or User data.
## SQL-powered integration via Fivetran (Recommended)
1. Click **Setup** on the **HubSpot (Fivetran)** integration in the Integrations directory and follow the on-screen authentication process.
2. When prompted in **Fivetran**, select **Sync all historical data** for the sync time frame.
3. After being redirected back to **Runway**, we recommend using our **HubSpot Deal Quickstart** integration template.
* In the left sidebar, navigate to **Templates**.
* Search for **HubSpot Deal Quickstart**.
* Click **+ Add to Runway** to apply the template.
4. This template automatically creates a database for you to begin building your model.
5. Alternatively, you can follow our [SQL guide](https://docs.runway.com/integrations/writing-sql) to customize the existing quick-start template or pull additional objects and properties. Note that when referencing HubSpot properties in your query, you must use their internal names, which differ from the display names shown in the HubSpot interface.
* To find available properties, go to HubSpot settings (⚙️) → Data Management → Properties → Select the relevant object (e.g., deal)
* From this list, search for the specific property you want to add to Runway, such as deal name.
* Click the property to find its internal name. When writing your SQL, search for a property with a matching name.
## Quick-start connection via Workato
1. Open your [Runway instance](https://app.runway.com/).
2. In the left sidebar, hover over **Integrations** and click the **+** button to open the Integrations Directory.
3. Under the **Other** section, search for **HubSpot** and click **+ Set up** on the option listed in **Others** section.
4. You'll be redirected to HubSpot to authorize the connection and complete authentication.
5. Once authorized, you'll return to Runway. Click **+** next to the integration name in the sidebar to create a new query.
6. You can then change the default query name, **New query**, to something more descriptive. To do this, click the **three-dots button** next to the query name in the sidebar and select **Rename query**.
7. In the query form, you can select the **HubSpot object** you want to work with (**Deals** is the most commonly used), and in the **properties** you want to pull for that object.
8. Note that for **properties**, you must use their internal names, which differ from the display names shown in the HubSpot interface.
* To find the list of available properties, in **HubSpot**, navigate to **Settings (⚙️) → Data Management → Properties** and select the matching object (e.g., Deals).
* In this list, search for the property you wish to add to runway, for example, deal name.
* Click into the property and find the internal name.
9. Type that internal name into the Runway properties field and press Enter.
10. Repeat for all desired fields for that object.
11. Once completed, click Run query and validate the data looks correct.
12. You’re done integrating! [Go ahead and configure a new database.](https://docs.runway.com/concepts/databases/databases-basics)
## HubSpot FAQs
See this [help doc](https://docs.runway.com/integrations/writing-sql).
Our Fivetran integration has access to all standard HubSpot objects and
fields. HubSpot data can be complex, and writing queries can sometimes be
challenging. If you need help pulling specific data, reach out to our
team—we’re happy to assist.
It’s fully customizable—you can map each deal based on dates such as creation
date, close date, or contract start date. You can also use Runway’s built-in
functionality to pull values forward into future periods. This is a common use
case, so feel free to contact our team for guidance.