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.

Can dashboard viewers automatically filter opportunities by AE Opportunity Owner field without manual selection in Salesforce

Discover how to automatically filter Salesforce opportunities by custom AE Opportunity Owner fields based on viewing user context without manual selection.

Sales

Connecting HubSpot CRM data to Excel for automatic refresh every hour

Connect HubSpot CRM data to Excel with automatic hourly refreshes. Set up real-time data access without manual CSV exports or API development.

RevOps
Sales

How to identify missing email data in Salesforce email message reports

Learn how to identify gaps and inconsistencies in Salesforce email data by comparing multiple objects and creating comprehensive audit reports.

RevOps

How to create multiple HubSpot lists from single Excel import

Create multiple targeted HubSpot static lists from a single Excel import using advanced filtering and automated segmentation based on data values.

RevOps

Creating custom API usage monitoring dashboard when standard Salesforce report is unavailable

Build a custom Salesforce API usage monitoring dashboard with real-time updates, multi-metric integration, and predictive alerts when standard reports are missing.

RevOps

Creating user-context dashboard filters for multiple opportunity owner fields simultaneously in Salesforce

Learn how to create user-context dashboard filters that work across multiple opportunity owner fields simultaneously using dynamic filtering and OR logic.

RevOps

Dashboard filter logic for OR conditions between Opportunity Owner and custom owner fields in Salesforce

Learn how to implement OR conditions between Opportunity Owner and custom owner fields in Salesforce dashboards using advanced filtering techniques.

RevOps

Dynamic report filtering to show only logged-in user data in Salesforce

Create dynamic Salesforce reports that automatically filter by logged-in user. Skip complex dashboard parameters with personalized data imports.

Sales

Excel template for importing contacts with notes and activity history

Import contact notes and activity history effectively. Handle timestamps, activity types, and relationship preservation during CRM data migration.

RevOps

How to extract email engagement metrics from Salesforce when native reporting fails

Extract comprehensive email engagement metrics from Salesforce using advanced data extraction when native reporting limitations prevent proper analysis.

RevOps
Sales

Excel template headers for importing contacts with multiple email addresses

Handle multiple email addresses in contact imports without template guesswork. Get automatic field mapping for primary, secondary, and custom email fields.

RevOps

How to find API usage report in Salesforce when it’s missing from Administrative Reports

Learn how to access Salesforce API usage data when the Administrative Report is missing. Get real-time API monitoring with better tracking than native reports.

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