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.

Workaround for Salesforce “never logged in” filter when only date-based options available

Discover effective workarounds to identify "never logged in" Salesforce users when standard date-based filters can't capture null login records.

RevOps

Workaround for disabled export button in Salesforce reporting tools

Find effective workarounds when Salesforce export buttons are disabled. Access complete report data while maintaining security compliance.

Finance
RevOps

Why your Salesforce Contact History report shows zero records for status field changes

Fix empty Salesforce Contact History reports for status field changes. Learn why Field Event filters fail and get working solutions with direct data access.

RevOps
Sales

Alternative methods to track Salesforce contact status changes when history reports fail

Track contact status changes when Salesforce Contact History reports return no data. Discover alternative methods using activity history and multi-object analysis.

RevOps

Alternative to dynamic dashboards in Salesforce for user-specific views

Discover the best alternative to expensive Salesforce dynamic dashboards using spreadsheet-based solutions for user-specific data visualization and analysis.

RevOps
Sales

Bypass Salesforce dynamic dashboard licensing restrictions for user views

Completely bypass Salesforce dynamic dashboard licensing restrictions and per-user costs while creating unlimited user-specific dashboard views with enhanced functionality.

Finance
RevOps

Converting unformatted phone numbers to E.164 format in HubSpot workflows

Convert phone numbers to E.164 format for international calling compatibility. Use spreadsheet formulas instead of limited HubSpot workflow functions.

RevOps

Display logged-in user data on static Salesforce dashboard

While you can't modify static Salesforce dashboards to show logged-in user data, learn how to create user-aware external dashboards with personalized data views.

Sales

Export and reimport Salesforce reports to reorganize folders without admin access

Discover how to export and reimport Salesforce reports as a workaround for folder reorganization, plus a superior alternative that eliminates these limitations.

RevOps
Sales

Filter Salesforce dashboard by current user without dynamic functionality

Learn how to create current user filtering for Salesforce dashboards using external solutions since static dashboards cannot detect or filter by the viewing user.

Sales

Formatting international phone numbers with country codes in HubSpot contact properties

Format international phone numbers with country codes in HubSpot using spreadsheet logic. Handle varying country code lengths and formatting standards.

RevOps

Formula for counting records greater than specific value within grouped Salesforce report sections

Learn how to count records meeting specific criteria within grouped Salesforce report sections using advanced COUNTIFS formulas with live data connectivity.

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