Last updated: September 19, 2025
Available with any of the following subscriptions, except where noted:
-
Data Hub
Professional, Enterprise
In Data Studio, you can create comprehensive datasets by integrating external data sync apps like Google Sheets and Snowflake in your HubSpot CRM. Continuously sync third-party app data into a dataset and merge it with other sources to refine and expand your datasets.
Please note:
- HubSpot does not support custom objects for LimeCRM currently.
- Some nested fields may not be supported.
- The maximum columns per external data source is 200 for sync apps and 100 for CSVs.
Sync external data sources
To sync external data sources:
- In your HubSpot account, navigate to Data Management > Data Studio.
- On the top right, click Add external data source.
- In the right sidebar menu, select the application to connect. Use the search bar for quick access to available apps. Connected apps will be labeled Installed. If the app is not installed, click the app, and follow the prompts to connect your account.
- If there is more than one account connected, select the account you want to bring data from.
- On the Data sources screen, select your data sources. The data sources available will vary from app to app. There may be a 2-3 minute delay before the data appears in the preview.
- Click Next.
- On the Columns screen, click the checkbox next to the columns you want to sync. The maximum number of columns per external data source is 200.
- Click Next.
- On the Sync details screen, refine the remaining details of your data source, then click Add data source at the top right.
- On the External data sources tab, your external data sources will appear in the table.
Sync data from Google Sheets and Office 365 Excel
The Google Sheets and Microsoft Excel integrations allow you to build datasets, which can be used in reports, workflows, or to send data to the CRM. Updates occur every 5 minutes to ensure you have the most current data available.
- In your HubSpot account, navigate to Data Management > Data Studio.
- On the top right, click Add external data source.
- In the right sidebar menu, select Google Sheets Data Ingestion or Office 365 Excel to connect. Connected apps will be labeled Installed. If the app is not installed, click the app, and follow the prompts to connect your account.
- On the Data sources screen, click the file you want to connect, then click Select.
- Click Next.
- On the Columns screen, click the row you want to use as a column header. It is crucial to have a clear column structure with headers for the extraction of column names and data. If you want to re-select a row for the column header, click the back arrow at the top right of the table.
Please note: defining data types for your columns is essential for certain actions within the datasets builder. Only numeric fields can be used in dataset calculations. If a column contains multiple data types, you will be prompted to select the appropriate type manually. For example, a column labeled Total amount should consistently contain numeric values to ensure accuracy. Learn more about data types.
- Click Add data source.
- On the External data sources tab, your external data sources will appear in the table.
Data types in Google Sheets and Office 365 Excel
A data type specifies the kind of information in a cell—such as a number, text, or date—helping spreadsheets like Google Sheets and Excel process data correctly. Choosing the right type ensures accurate calculations, sorting, and formatting.
Examples are below.
| Data Type | Definition | Example |
| Boolean | A cell that only contains one of two possible values: TRUE or FALSE | TRUE, FALSE |
| Text | A cell that contains letters, words, sentences, or any combination of characters that are not used in mathematical calculations. | Hello, HubSpot, Sales Report |
| Date | A cell that stores calendar dates, allowing Google Sheets to recognize and format them properly. | 4/27/2024, April 27, 2024 |
| Datetime | A cell containing both a date and a time. | 4/27/2024 14:30, April 27, 2024 2:30 PM |
| Decimal | A type of number that includes digits after the decimal point, representing fractions or parts of a whole number. | 3.14, 0.75, -2.5 |
| Number | A cell that contains only digits and can be used in calculations. | 42, 3, 7 |
Sync data from Snowflake and BigQuery Data Ingestion
The Snowflake and BigQuery Data Ingestion integrations allow you to bring in data into datasets from external data warehouses.
- In your HubSpot account, navigate to Data Management > Data Studio.
- On the top right, click Add external data source.
- In the right sidebar menu, select Snowflake Data Ingestion or BigQuery Data Ingestion to connect. Connected apps will be labeled Installed. If the app is not installed, click the app, and follow the prompts to connect your account.
- If there is more than one account connected, select the account you want to bring data from.
- On the Data sources screen, select your data sources. The data sources available will vary from app to app. There may be a 2-3 minute delay before the data appears in the preview.
- Click Next.
- On the Columns screen, click the checkbox next to the columns you want to sync. The maximum number of columns per external data source is 200.
- Click Next.
- On the Sync details screen, refine the remaining details of your data source, then click Add data source at the top right
- On the External data sources tab, your external data sources will appear in the table.
