← All integrations
HubSpot

HubSpot → Google Sheets™

HubSpot CRM contacts, companies, deals, tickets, and pipeline data.

API Import for Google Sheets™ lets you connect HubSpot with the most popular apps, so you can automate your work and have more time for what matters most — no code required.

HubSpot OAuth

HubSpot is a CRM platform used by sales and marketing teams to track contacts, companies, deals, and support tickets across the customer lifecycle. HubSpot's native reports live inside HubSpot — to blend CRM data with other sources, build custom pipeline dashboards, or share data with stakeholders who don't have seats, you need to get the numbers out. API Import pulls HubSpot contacts, deals, and pipeline data directly into Google Sheets™ on a schedule, so your reports stay current without anyone manually exporting a CSV.

Example prompts
“List my HubSpot CRM contacts with name, email, and company”
“List all deals in my HubSpot pipeline with name, stage, and amount”
“List my HubSpot companies with name, domain, and industry”
“Get all HubSpot deal pipelines and their stages”
How to get credentials
Recommended: Most users should connect with the API Import MCP app from the sidebar. You only need the custom MCP Auth App setup below if you manage your own API Import Apps Script™ deployment.
Recommended — Connect in API Import
  1. Open API Import for Sheets from the Google Sheets™ Extensions menu.
  2. Select HubSpot from the API selector.
  3. Under Authentication, click Connect.
  4. HubSpot opens Connecting API Import for Google Sheets™ to HubSpot.
  5. Choose the minimum permissions needed for the data you want. Prefer View-only permissions; do not select write permissions unless your workflow explicitly needs them.
  6. Click Connect app.
  7. Because the API Import MCP app is currently unverified, HubSpot asks you to confirm the risk. Type I accept the risk, then click Connect.
  8. Return to the sidebar. Wait for the HubSpot credential to appear, or click Refresh Connection.
  9. Select the connected HubSpot credential from the dropdown and run your prompt.
HubSpot shows an unverified-app warning until the API Import MCP app has completed HubSpot review. Only continue if you trust API Import and the permissions you selected.
Advanced — Use your own MCP Auth App

Use this path only if you manage a separate API Import Apps Script™ deployment and want to connect HubSpot through your own HubSpot MCP Auth App instead of the API Import MCP app.

Step 1 — Open MCP Auth Apps
  1. Log in to your HubSpot dashboard.
  2. Click the gear icon (Settings) in the top navigation bar.
  3. In the left sidebar, go to Integrations, then click MCP Auth Apps.
  4. Click Create MCP auth app.
Step 2 — Create the custom app
  1. Enter a clear Name, such as API Import for Sheets.
  2. Enter a short Description, such as Google Sheets™ API import connector.
  3. Set Redirect URL to the API Import Apps Script™ callback URL:
https://script.google.com/macros/d/1MM5flAOQ3nGmBsxbaH1ceWyt8aVlsu9U4avHWFNaXbXUaI2xXYiAIluE/usercallback
  1. Use this production URL for the live API Import add-on. For staging or a private Apps Script™ copy, replace the script ID with that deployment's script ID.
  2. Add an icon if you plan to certify or list the app in HubSpot Marketplace.
  3. Click Create.
Step 3 — Copy your client credentials
  1. After HubSpot shows MCP Auth App Created, find the Client credentials section.
  2. Copy the Client ID. This is used to initiate OAuth.
  3. Click Show for Client secret, then copy it.
  4. The Installation URL Builder test URL is for manual OAuth testing only — API Import handles OAuth automatically.
Step 4 — Connect in API Import
  1. Add these two Script Properties to your API Import Apps Script™ deployment:
    AI_API_CONNECTOR_HUBSPOT_CLIENT_ID → your Client ID
    AI_API_CONNECTOR_HUBSPOT_CLIENT_SECRET → your Client secret
  2. Open API Import for Sheets from the Google Sheets™ Extensions menu.
  3. Select HubSpot from the API selector.
  4. Under Authentication, click Connect and authorize the connection.
  5. Select the connected HubSpot credential from the dropdown and run your prompt.
✓ Keep the Client secret private. If it is exposed, rotate it from the HubSpot MCP Auth App page.
→ View in docs

Ready to connect HubSpot to Google Sheets™?

Install the free add-on and start pulling data in minutes.

Install Free on Google Sheets™