Comparison graphic for FP&A and financial planning tools that integrate with Salesforce and HubSpot

Best FP&A Tools That Integrate with Salesforce and HubSpot (2026)

Last updated: November 11, 2026 | Reviewed by IntegrateStack Editorial | 6 tools compared

Pigment, Tableau, Qlik and Google Sheets all read Salesforce data with a connector their vendor builds. HubSpot is harder: none of these tools ships a built-in HubSpot data connector, so HubSpot pipeline data reaches them through a partner connector, a HubSpot workflow, or an automation platform.

Most tools read Salesforce; few read HubSpot

Checked November 11, 2026, against each vendor's documentation.

Tool Salesforce HubSpot Limits Source
Pigment Native connector; import, plus export back No native connector (MuleSoft, Workato, Celigo or REST API) Report import capped at 2,000 rows; SOQL has no parent/child queries Pigment
Tableau Built-in connector, any standard or custom object Third-party connector only Extracts only; Tableau Cloud refreshes hourly at most; incremental refresh covers 30 days Tableau
Qlik Cloud Built-in connector Through Qlik Automate's HubSpot connector Salesforce API up to version 56 Qlik
Looker Via a data warehouse Via a data warehouse Connects to SQL databases only Google
Data Studio Partner connectors Partner connectors Data Studio is free; most partner connectors are paid Google
Google Sheets Google's free Data connector for Salesforce add-on HubSpot workflow action (Professional or Enterprise) HubSpot action writes up to 20 cells per row Google, HubSpot

Tableau Cloud Standard (Creator) is $75 per user per month billed annually (pricing). Pigment, Qlik and Looker don't publish prices.

Pick by what finance does with the data

  • Build a revenue plan with sales in the same model: Pigment, the only planning tool here with its own Salesforce connector.
  • Dashboards on Salesforce data, refreshed hourly: Tableau or Qlik Cloud.
  • Governed metrics across CRM, ERP and billing: Looker, after you land the data in a warehouse.
  • A spreadsheet model on a small budget: Google Sheets with Google's Salesforce add-on, or a HubSpot workflow.
Pigment

Pigment imports Salesforce reports or SOQL queries

Pigment's Salesforce connector signs in with OAuth and imports data two ways: by Salesforce report ID, capped at 2,000 rows, or by SOQL query, which can't include parent/child relationship queries. For pipeline larger than 2,000 opportunities, use SOQL. Pigment also documents exporting data back to Salesforce, so plan targets can land on Salesforce records. A Pigment workspace admin sets up the connection.

HubSpot isn't on Pigment's list of native connectors. Pigment points to middleware such as MuleSoft, Workato or Celigo, or its REST API.

Tableau

Tableau reads Salesforce as hourly extracts

Tableau's built-in Salesforce connector reads any standard or custom object, but Tableau Desktop, Server and Cloud can only use extracts with it; there's no live connection. On Tableau Cloud the shortest refresh schedule is hourly (15-minute schedules exist only on Tableau Server). Incremental refresh covers the last 30 days, and text fields over 4,096 characters and Salesforce formula fields aren't extracted.

  • Tableau Pulse, which sends metric digests, is included in Tableau Cloud Standard.
  • Tableau has no built-in HubSpot connector. The HubSpot App Marketplace lists a Tableau connector built by Datawarehouse.io, a third party.

→ Salesforce + Tableau integration details

Qlik

Qlik loads Salesforce natively, HubSpot through Automate

Qlik Cloud includes a Salesforce connector that loads Salesforce data into a Qlik Sense app; on Qlik Cloud it needs no separate install. For HubSpot, Qlik Automate (formerly Application Automation) has a HubSpot connector that reads and writes contacts, companies, deals, products, tickets and line items. Use an automation to land HubSpot deals in a dataset, then load that into the app.

→ Salesforce + Qlik integration details

Looker

Looker needs a warehouse; Data Studio needs partners

Looker, Google's enterprise BI tool, connects only to SQL databases and warehouses. To report on Salesforce or HubSpot in Looker, first load the CRM data into BigQuery, Snowflake or another supported warehouse. Its modeling layer (LookML) then defines metrics such as bookings or ARR in one place for all reports.

Google renamed Looker Studio back to Data Studio in April 2026. Data Studio is free, but Google doesn't build Salesforce or HubSpot connectors for it. Partner connectors fill the gap: Power My Analytics and Adzviser for Salesforce; Datawarehouse.io (from $79 a month), Adzviser and Dataslayer for HubSpot. Each partner sets its own refresh schedule and price.

→ Salesforce + Looker integration details

Mosaic is now Bob Finance inside HiBob

HiBob bought Mosaic in February 2025 and relaunched it as Bob Finance in November 2025, sold to HiBob customers in the US, UK, Canada and Ireland. HiBob's launch announcement says it integrates with CRM systems but doesn't name Salesforce or HubSpot, so confirm the connector with HiBob before choosing it for CRM-driven forecasting.

Google Sheets

Google Sheets has a free Salesforce add-on

Google's Data connector for Salesforce add-on imports Salesforce reports and SOQL results into a sheet and refreshes them manually or on a schedule. It can also push edits back to Salesforce, and its delete option removes the highlighted records from Salesforce, so keep finance models on a read-only copy of the imported tab.

On HubSpot Professional or Enterprise, a workflow can add or update a Google Sheets row when a deal changes. Each action writes up to 20 cells, inserts rows instead of overwriting them, and can create a duplicate row if the request times out. HubSpot recommends one workflow per sheet.

→ Salesforce + Google Sheets integration details

Make covers HubSpot below Professional

HubSpot Starter has no workflow action for Sheets, and a row-per-event workflow doesn't suit a model that needs the whole open pipeline refreshed each morning. A scheduled scenario does both:

  1. Schedule: daily at 6 a.m.
  2. HubSpot: search deals in open stages, with amount, stage, close date and owner.
  3. Google Sheets: clear the data tab, then add the rows in bulk.

Make ↗ charges about one credit per module run, and its free plan includes 1,000 credits a month. n8n ↗ counts one execution per run regardless of steps, and the self-hosted Community Edition is free.

Affiliate disclosure

Frequently asked questions

What FP&A tools connect natively to Salesforce? ▼

Pigment, for planning, with import and export. Tableau and Qlik Cloud, for analytics. Google Sheets, through Google's free add-on. Looker needs the data in a warehouse first.

Can I export HubSpot pipeline data to Tableau? ▼

Not with a built-in connector. Use Datawarehouse.io's third-party connector, or land HubSpot deals in a database or sheet with a HubSpot workflow or Make ↗ , then point Tableau at it.

Is Looker Studio free for HubSpot and Salesforce dashboards? ▼

Looker Studio is now called Data Studio. The tool is free, but the Salesforce and HubSpot connectors come from partners, and most charge for them.

How do I sync Salesforce data to Google Sheets automatically? ▼

Install Google's free Data connector for Salesforce add-on, import a report or SOQL query, and set a refresh schedule.

Does Qlik integrate with HubSpot? ▼

Through Qlik Automate. Its HubSpot connector handles contacts, companies, deals, products, tickets and line items, and an automation can land that data where a Qlik Sense app loads it.

Related guides and integration pages