All our playbooks

How to change decimal separator from dot to comma in Salesforce Excel exports

Fix decimal separator issues in Salesforce Excel exports. Learn how to automatically format dots to commas without changing system settings.

How to combine multiple Salesforce reports into one dashboard component

Learn how to combine multiple Salesforce reports into a single dashboard component using spreadsheet integration for unified data analysis.

How to check Salesforce API limits causing undefined length error during Google Sheets refresh

Prevent Salesforce API limits causing undefined length errors during Google Sheets refresh with intelligent API management and monitoring solutions.

How to connect Google Sheets as External Object in Salesforce Lightning Experience

Learn why Google Sheets can't connect as External Objects in Salesforce and discover a better alternative for importing spreadsheet data into dashboards.

How to prevent users from editing original Salesforce reports while allowing copies

Protect original Salesforce reports from modifications while enabling users to create and customize their own copies with live data connections.

How to protect source Salesforce reports from modifications while enabling duplication

Protect source Salesforce reports from modifications while enabling user duplication through Google Sheets templates with live data connections.

How to remove formula fields from Salesforce reports without deleting them

Learn how to exclude formula fields from Salesforce reports while preserving them in your org using selective field import methods.

How to remove duplicate formula fields from Salesforce report types

Learn how to eliminate duplicate formula fields from Salesforce reports using direct object imports instead of modifying rigid report types.

How to restrict edit access but allow save as functionality on shared Salesforce reports

Learn how to restrict edit access while preserving save as functionality on shared Salesforce reports using Google Sheets with live data connections.

How to replicate Salesforce formatted report export functionality in CRM Analytics

Learn how to recreate Salesforce's formatted report export capabilities for CRM Analytics data using direct connections and native spreadsheet formatting.

How to set up master Salesforce reports with clone-only permissions

Create master Salesforce reports with true clone-only permissions using Google Sheets templates that maintain live data connections for copied reports.

How to set up scheduled Salesforce data refreshes in Excel without force.com connector

Set up automated Salesforce data refreshes in Excel with cloud-based scheduling, timezone support, and enterprise-grade automation without force.com connector.