How to share Salesforce dashboards to Google Sheets

1. Manual ways to share a Salesforce dashboard

Before you automate anything, you need to master the native patterns. In Salesforce, dashboards are shared through folders and permissions, not directly on the dashboard itself.

‍

Method 1: Share via dashboard folder (recommended)

1. Log into Salesforce and go to the App Launcher.
2. Click 'Dashboards'. You can also open the specific app (e.g., Sales) and choose the Dashboards tab.
3. In the left pane, select 'All Folders'.
4. Find the folder that contains your dashboard. If you want granular control, click 'New Folder' and move your dashboard into it.
5. Next to the folder name, click the down arrow and choose 'Share'.
6. In the share dialog, add users, roles, or public groups.
7. Choose the access level: 'View', 'Edit', or 'Manage'.
8. Click 'Done'. Everyone you added now sees all dashboards in that folder.

Salesforce help: https://help.salesforce.com/s/articleView?id=sf.dashboards_share_folder.htm&type=5

‍

Method 2: Use roles and public groups for scalable access

1. Work with your admin to create public groups that match how your business operates (e.g., 'EMEA Sales Managers', 'Marketing Leadership').
2. Add users to those groups based on role hierarchy.
3. When sharing the dashboard folder, share to the group instead of individual users.
4. Going forward, you simply manage group membership; the dashboard access follows automatically.

Docs on groups & sharing: https://help.salesforce.com/s/articleView?id=sf.security_about_groups.htm&type=5

‍

Method 3: Control dashboard running user and visibility

1. Open the dashboard you want to share.
2. Click the down arrow and choose 'Edit'.
3. Set 'View dashboard as' to a running user (single user) or 'The dashboard viewer' if you use dynamic dashboards.
4. Save your changes.

This ensures users see data appropriate to their access. More: https://help.salesforce.com/s/articleView?id=sf.dashboards_dynamic.htm&type=5

‍

Method 4: Export components to a file for ad-hoc sharing

1. Open the dashboard.
2. Click the menu on a component and choose 'View Report'.
3. From the report, click 'Export'.
4. Export as .xlsx or .csv and send manually.

It works, but you will quickly drown in versions if you repeat this weekly.

‍

Method 5: Create a dedicated 'Executive' or 'Client' folder

1. Create a new folder called e.g. 'Executive Dashboards' or 'Agency Client – ACME'.
2. Clone the dashboards you want to expose and save them into this folder.
3. Share the folder only with the relevant decision makers or external-facing users.

This pattern isolates sensitive dashboards while still letting you tailor what each group sees.

‍

2. No-code methods with automation tools

Manual work is fine for one or two dashboards. But for agencies, revenue teams, or multi-region orgs, you often need the same Salesforce data shared into Google Sheets where non-Salesforce users live.

‍

Method 6: Use a Salesforce–Sheets connector (no-code)

1. Install an official connector or add-on that syncs Salesforce reports to Google Sheets.
2. In Salesforce, open the report behind your dashboard component.
3. Configure the connector to pull that report data into a specific Google Sheet tab on a schedule (e.g., hourly or daily).
4. In Google Sheets, click 'Share' and invite stakeholders by email or create a view-only link.
5. Use filters, pivot tables, and charts in Sheets to create lightweight reporting views.

Google Sheets sharing help: https://support.google.com/docs/answer/2494822

‍

Method 7: Scheduled report exports via email + Sheets

1. Open the report powering your dashboard.
2. Click 'Subscribe' or 'Schedule Future Runs' (depends on your Salesforce edition/UI).
3. Schedule a recurring email with the report export to a shared mailbox (e.g., reports@yourcompany.com).
4. Use an automation tool (no-code platform, or even a simple script) connected to Gmail to:
   • Watch for new report emails.
   • Download the attachment.
   • Overwrite or append data into a target Google Sheet.
5. Stakeholders work only in Sheets, while the pipeline from Salesforce is automated in the background.

‍

Method 8: No-code integration platform (e.g., iPaaS)

1. In your integration platform, select Salesforce as the trigger app.
2. Use a trigger such as: 'On dashboard report refreshed' or 'On schedule, query report X'.
3. Map the report fields to matching columns in Google Sheets.
4. Choose whether to overwrite the Sheet or append rows.
5. Add conditional logic, e.g., refresh more frequently for key accounts.
6. Finally, share the Google Sheet link with teams or clients once; the integration keeps it up-to-date.

This removes repetitive exports but still relies on API connectors, not true cross-app computer use.

‍

3. Automating at scale with an AI agent

Traditional automation breaks whenever UX changes, fields are renamed, or new dashboards are added. An AI computer agent can behave like a power user: logging into Salesforce, navigating folders, clicking 'Share', and even jumping into Google Sheets.

‍

Method 9: AI agent to maintain Salesforce folder sharing How it works

• You demonstrate the process once: opening Dashboards, locating specific folders (e.g., by naming pattern like 'Client – *'), clicking the folder menu, selecting 'Share', and adding groups with the right access.
• The AI agent records this workflow and can replay it for every new client or territory.

Pros

• Works across the full desktop: browser, Salesforce UI, and admin consoles.
• Can handle exceptions (e.g., missing groups) by reading on-screen errors.
• Every action is transparent and modifiable, so ops leaders can review what the agent is doing.

Cons

• Requires a clear naming convention and guardrails.
• Initial onboarding time to teach the workflow.

‍

Method 10: AI agent to sync dashboards to Google Sheets for non-licensed users Scenario: You run an agency that manages 30 clients. Each client needs a weekly performance dashboard, but you do not want to buy 30 Salesforce viewer licenses.

AI workflow

1. On schedule (e.g., every Monday), the agent:
   • Logs into Salesforce.
   • Opens each client dashboard or its underlying report.
   • Exports the report to .csv.
2. The agent opens Google Sheets in the browser.
3. For each client:
   • Opens the correct Sheet (based on client name).
   • Clears last week's data tab.
   • Imports the latest .csv.
4. Optionally, the agent adds timestamp notes or updates a 'Last refreshed' cell.

Pros

• No custom APIs needed; it works through the UI like a human.
• Ideal when IT is busy or you lack admin rights to install connectors.
• Great for sales and marketing teams who live in Sheets.

Cons

• Requires stable logins and 2FA strategy.
• Best for recurring, predictable workflows.

‍

Method 11: AI agent to provision and revoke dashboard access at scale Use case: New sales reps join; others move territories. Instead of manual clean-up in Salesforce, you delegate access management.

AI workflow

1. Agent opens a master Google Sheet where HR or sales ops lists new hires, role changes, and separations.
2. For each row, the agent:
   • Logs into Salesforce.
   • Adds or removes the user from relevant public groups.
   • Validates that associated dashboard folders show the correct access.
3. It logs every change in the same Sheet for audit.

Pros

• Reduces risky over-permissioning.
• Creates a clear, auditable trail of dashboard access changes.

Cons

• Still needs clear governance and review, especially in regulated industries.

By combining Salesforce's native folder sharing, no-code integrations to Google Sheets, and an AI agent that literally drives the browser for you, you create a reporting layer where every stakeholder sees the right dashboard in the tool they already use, without you babysitting every share button.