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.

Creating monthly historical snapshots of opportunity pipeline stages in Salesforce

Build automated monthly pipeline snapshots from Salesforce field history data to track opportunity stage distributions over time.

RevOps
Sales

DataLoader update operation that skips populated fields in Salesforce

Make DataLoader skip populated Salesforce fields during updates. Learn field-skipping techniques that preserve existing data integrity.

RevOps

Extracting point-in-time opportunity stage values from Salesforce field history

Extract precise point-in-time opportunity stage values from Salesforce field history using custom SOQL queries and advanced formula logic.

RevOps
Sales

Fix Salesforce approval process email notifications not triggering despite correct setup

Resolve Salesforce approval email notification failures with real-time monitoring dashboards and multi-channel alert systems for reliable workflow management.

RevOps

How to access live subscription and billing data directly within a Google Sheets customer dashboard

Access live subscription and billing data directly in Google Sheets dashboards with real-time updates, payment alerts, and automated revenue forecasting.

Finance
RevOps

How to add Google Analytics style date picker to Salesforce dashboard filters

Add Google Analytics-style date picker functionality to Salesforce dashboards with interactive calendar controls and dynamic filtering capabilities.

RevOps

How to aggregate Salesforce opportunity field history data into monthly stage summaries

Aggregate Salesforce opportunity field history into monthly stage summaries using advanced grouping functions and automated calculations.

RevOps
Sales

How to automatically update Salesforce reports directly in Google Sheets or Excel

Automatically refresh Salesforce reports in spreadsheets with scheduled updates. Eliminate manual exports and keep data current with live CRM connections.

RevOps
Sales

How to combine sales activity and intent data into single Salesforce account score

Learn how to combine Salesforce sales activity data with external intent data from Bombora, 6sense, and TechTarget into unified account health scores.

RevOps
Sales

How to check Salesforce approval process email logs and delivery status

Check Salesforce approval email delivery status with comprehensive logging systems, delivery inference analytics, and automated monitoring dashboards.

RevOps

How to count opportunities by stage at month-end using Salesforce field history

Count opportunities by stage at specific historical dates using Salesforce field history data and advanced spreadsheet formulas.

RevOps
Sales

How to create dynamic date range filter with calendar picker in Salesforce dashboard

Learn how to add Google Analytics-style calendar picker functionality to Salesforce dashboards using dynamic date filters for better reporting.

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