Reconcile Salesforce Pipeline Data with Tableau Revenue Dashboards

Finance and revenue operations teams frequently find that Salesforce pipeline data and Tableau revenue dashboards are out of sync, leading to conflicting reports in leadership meetings. This workflow queries Salesforce for current pipeline data and triggers a Tableau data source refresh so dashboards reflect the latest CRM state.

How the workflow runs

The scenario uses specific integration tools at each step, while Metorial keeps access scoped and visible.

  1. 1

    Query current Salesforce pipeline

    Run a SOQL query against Salesforce opportunities to retrieve the latest pipeline data by stage, owner, and close date.

    • salesforce:query_records
  2. 2

    Run the pipeline summary report

    Execute the designated Salesforce pipeline report to validate totals and identify any data anomalies before triggering a refresh.

    • salesforce:run_report
  3. 3

    Identify the Tableau data source to refresh

    List Tableau data sources and locate the one connected to Salesforce pipeline data.

    • tableau:list_datasources
  4. 4

    Trigger the data source refresh

    Initiate an extract refresh on the Tableau data source to pull the latest Salesforce data into Tableau.

    • tableau:manage_datasource
  5. 5

    Monitor refresh job completion

    Check the status of the background refresh job and confirm it completed without errors.

    • tableau:manage_jobs
  6. 6

    Confirm affected dashboards are updated

    List workbooks that use the refreshed data source to verify all revenue dashboards will reflect the current pipeline state.

    • tableau:list_workbooks

Integrations used in this scenario

salesforce

Query Records

Query Salesforce for current open opportunity data including stage, amount, and close date.

View details

salesforce

Run Report

Run a Salesforce pipeline report to get a formatted summary of current revenue data.

View details

tableau

List Data Sources

List Tableau data sources to identify the pipeline or revenue data source to refresh.

View details

tableau

Manage Data Source

Trigger an extract refresh on the Salesforce-connected Tableau data source.

View details

tableau

List Workbooks

List workbooks that depend on the refreshed data source to confirm which dashboards will be updated.

View details

tableau

Manage Jobs

Monitor the refresh job status to confirm it completed successfully before notifying stakeholders.

View details

Connected systems

Integration

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Subscribe to real-time change events via Change Data Capture and Platform Events. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

View Salesforce

Integration

Tableau

Manage Tableau Cloud and Tableau Server resources through the Tableau REST API. Query and manage workbooks, data sources, views, custom views, flows, users, groups, projects, permissions, favorites, collections, jobs, and data-driven alerts. Export views as CSV, PNG, or PDF.

View Tableau

Expected outcomes

Outcome 1

Revenue dashboards in Tableau reflect current Salesforce pipeline data without manual refresh triggers

Metorial keeps the workflow connected, governed, and traceable across the systems involved.

Explore scenarios

Outcome 2

Finance and sales teams avoid conflicting pipeline numbers in leadership reporting

Metorial keeps the workflow connected, governed, and traceable across the systems involved.

Explore scenarios

Outcome 3

Data refresh completion is confirmed before stakeholders are notified, preventing stale dashboard views

Metorial keeps the workflow connected, governed, and traceable across the systems involved.

Explore scenarios

How Metorial powers this scenario

Metorial is the governed connection layer between your AI agents and the tools your company runs on. It turns workflows like reconcile salesforce pipeline data with tableau revenue dashboards into something you can deploy quickly, safely, and at scale.

Fast

Ready for your entire team

Connect 1000+ verified integrations through one Magic MCP URL instead of building and maintaining bespoke connectors for each system in this workflow.

Browse integrations

Secure

Guardrails on every action

Protoguard inspects every message and tool call for prompt injection and policy violations before an agent touches your systems.

See how Protoguard works

Enterprise

SSO, policies, and audit trails

Agents act on real identity under company SSO, with per-user and per-group access policies and a complete, searchable record of everything that happens.

Explore enterprise

Team ready

Reusable across your org

Package this workflow as a skill, attach the tools it needs, and let teammates run it through Portals — governed by admins, owned by the people who do the work.

See Skills & Portals

Products behind this workflow

The Metorial products that connect, govern, and observe this scenario.

Connectivity

Integrations

Start from 1000+ verified integrations or bring your own, and give every one a governed path to your agents under existing SSO and access policies.

Explore Integrations

Connectivity

Magic MCP

A single URL your AI client connects to. Sign in with the login you already use and your agent reaches every integration and tool you allow — no per-app setup.

Explore Magic MCP

Identity

Access Control

Sign in with company SSO, set policies per user and group, and let agents act on real identity across every connected system in this workflow.

Explore Access Control

Governance

Protoguard

Metorial’s security layer reviews every message and tool request before an agent acts — catching prompt injection and blocking anything outside your policies.

Explore Protoguard

Observability

Tracing

A complete, searchable record of everything your agents, team, and machines do across these integrations, so you can trust the workflow in production.

Explore Tracing

Governance

Portals

Let teammates connect agents to the integrations and skills your company already uses, with admins deciding who gets access to what.

Explore Portals

Built for your whole team

However you adopt AI, Metorial has a path for connecting it safely.

Solution

For Agents

Give the agents behind this scenario governed access to every tool and integration they need, with one connection layer instead of bespoke glue code.

Agents solution

Solution

For Enterprise

SSO, granular access control, security review, and full audit trails so this workflow meets enterprise governance and compliance requirements.

Enterprise solution

Solution

For your Workforce

Let the people who do this work connect their own AI agents to approved integrations and reusable skills — safely, without waiting on engineering.

Workforce solution

Build this workflow with your own tools

Metorial gives teams one governed layer for connecting integrations to real production work.