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 create more than 10 dynamic dashboards in Salesforce

Bypass Salesforce's 10 dynamic dashboard limit with unlimited dashboards in Google Sheets and Excel that connect directly to your Salesforce data.

RevOps
Sales

How to create real-time sales dashboards in HubSpot using daily imported data from external sources

Learn how to create real-time sales dashboards in HubSpot by automating daily imports from external sources with data standardization and validation.

RevOps
Sales

How to create static copies of time-sensitive Salesforce report data without snapshot access

Create static copies of time-sensitive Salesforce data using automated snapshot capabilities that work independently of native Salesforce snapshot features.

RevOps

How to create weighted pipeline scenarios in Salesforce based on different deal closure assumptions

Learn how to create weighted pipeline scenarios in Salesforce using different deal closure assumptions with real-time data and sophisticated probability modeling.

RevOps
Sales

How to display report groupings with row-level data in Salesforce dashboard

Salesforce dashboards only show aggregated group totals, never individual row details. Learn how to display both group structure and row-level data.

Finance
Sales

How to exclude dates with no value from HubSpot report visualizations

Remove empty dates and zero values from HubSpot reports to create cleaner visualizations and more accurate trend analysis.

RevOps

How to export HubSpot payment links with product names prices and URLs to Excel

Export HubSpot payment links with product names, prices, and URLs to Excel using automated data integration for comprehensive payment link management.

Sales

How to extract Salesforce Maps visit logs with associated territory assignments for analysis

Learn the most efficient method for extracting Salesforce Maps visit logs with territory assignments for comprehensive rep activity analysis.

Sales

How to filter Salesforce asset renewal reminders to show only first asset per renewal date

Filter Salesforce asset renewal reminders to display only the first asset per renewal date, eliminating duplicate notifications and reducing alert fatigue.

RevOps
Sales

How to fix broken Salesforce reports after adding lookup fields to custom report types

Fix broken Salesforce reports caused by lookup field additions with direct object access that bypasses report type limitations entirely.

RevOps
Sales

How to fix “field does not exist” error when filtering Salesforce dashboard with Forecasting Quota and Opportunity reports

Fix Salesforce dashboard "field does not exist" errors when filtering Forecasting Quota and Opportunity reports with cross-object solutions.

RevOps
Sales

How to fix broken trend lines caused by empty dates in HubSpot reports

Fix broken trend lines in HubSpot reports by removing empty dates and creating continuous visualizations that show true performance patterns.

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