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 fix Salesforce Data Connector connection failures after session expiration

Stop Salesforce connection failures from session timeouts. Learn how to maintain persistent connections with automatic token refresh and retry logic.

RevOps

How to fix Salesforce Data Connector authentication timeout errors in Google Sheets

Stop dealing with Salesforce authentication timeouts in Google Sheets. Learn how to maintain stable connections with automatic session management.

RevOps

How to import Salesforce Opportunities without using Data Loader

Skip Data Loader's Java headaches. Import Salesforce Opportunities directly into spreadsheets with real-time sync and bulk processing up to 10,000 records.

RevOps
Sales

How to implement point-in-time Salesforce data capture when snapshot features are restricted

Implement enterprise-grade point-in-time Salesforce data capture using flexible snapshot functionality that operates independently of native platform limitations.

Finance
RevOps

How to measure total pipeline value changes in Salesforce without close date filters

Measure total pipeline value changes in Salesforce without close date restrictions using comprehensive opportunity capture and automated historical tracking.

RevOps
Sales

How to preserve custom field values from losing account before Salesforce merge

Learn how to preserve custom field values from losing accounts before Salesforce merge operations using automated backup workflows and data preservation strategies.

RevOps

How to remove zero values from HubSpot time series charts

Clean up HubSpot time series charts by removing zero values to create accurate trend lines and better performance visualization.

RevOps

How to send Salesforce reports to external email addresses without user licenses

Learn how to send Salesforce reports to external recipients without purchasing additional user licenses using automated email distribution workarounds.

RevOps
Sales

How to show previous vs current period side by side in Salesforce with independent filters

Create side-by-side period comparisons in Salesforce with independent filter controls using proper data structure and historical management.

RevOps

How to sum closed won and closed lost deals when HubSpot formula builder lacks COUNT function

Learn how to sum closed won and closed lost deals when HubSpot's formula builder lacks COUNT and SUM aggregation functions using spreadsheet integration.

RevOps
Sales

How to track cumulative time in specific Salesforce opportunity stages across multiple transitions

Track cumulative time in Salesforce opportunity stages across multiple transitions with advanced formulas and comprehensive analytics that native reports can't provide.

RevOps
Sales

How to track Salesforce cases that exceeded response time thresholds without losing historical data

Track Salesforce response time violations and maintain historical data with automated capture techniques that preserve SLA breach records permanently.

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

Trusted By Over 50,000 Companies