All our playbooks

Learn about tips and tricks for spreadsheets, how to get the most out of your business systems, new product features, and innovative customer use cases.

How to use HubSpot company domain for deduplication when importing companies with name variations

Learn how to use company domains to prevent duplicate HubSpot companies when importing data with name variations like "ABC Corp" vs "ABC Corporation".

RevOps

How to use Salesforce report IDs as filter criteria in multiple reports simultaneously

Learn how to apply ID-based filtering across multiple Salesforce reports simultaneously using centralized ID management and cross-report automation.

RevOps

Leveraging report folders and user permissions instead of Salesforce dynamic dashboards

Enhance Salesforce report folders with user permissions using advanced visualization and automated distribution that eliminates dynamic dashboard limits.

RevOps

List all visible fields for each record type in Salesforce without running data report

Discover how to list all visible fields by Salesforce record type without exposing data using metadata queries and field visibility mapping.

RevOps

Monitoring failed records during automated SQL to Salesforce data imports

Get comprehensive monitoring and error tracking for SQL to Salesforce imports with built-in status columns and automated alerting systems.

RevOps

Pipeline coverage reporting limitations in HubSpot custom reports

Overcome HubSpot's pipeline coverage reporting limitations with dynamic calculations, cross-data integration, and flexible visualization options.

RevOps
Sales

Pull Salesforce field names and data types by record type using Schema Builder

Complement Salesforce Schema Builder with exportable field metadata extraction for comprehensive documentation and analysis capabilities.

RevOps

Retrieve calculated metrics from CRM dashboard via API authentication

CRM APIs don't expose dashboard calculations directly. Import underlying data and recreate metrics using spreadsheet formulas without API complexity.

RevOps
Sales

Salesforce Data Import Wizard vs Data Loader limitations comparison

Compare Data Import Wizard and Data Loader limitations. Discover modern alternatives that handle all Salesforce objects with better UX and enterprise features.

RevOps

Salesforce field history tracking limitations for opportunity stage duration reporting

Salesforce field history tracking has major limitations for opportunity stage duration reporting. Here's how to bypass 18-month retention limits and calculation constraints.

RevOps
Sales

Send Salesforce report as attachment to external email using custom sender address

Learn how to send Salesforce reports as email attachments to external recipients while using custom sender addresses for professional branding.

RevOps

Setting up fuzzy matching rules in HubSpot to prevent duplicate companies during Excel imports

HubSpot lacks fuzzy matching for company imports. Learn how to build sophisticated matching rules to prevent duplicates like "LLC" vs "L.L.C." variations.

RevOps
700,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies