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 you schedule automatic imports of daily sales data from Excel files to HubSpot CRM

Yes, learn how to schedule automatic daily imports of sales data from Excel files to HubSpot CRM using automated scheduling and field mapping retention.

RevOps
Sales

Creating automated win percentage reports using deal value in HubSpot CRM

Build automated HubSpot win percentage reports using deal values with scheduled imports, custom formulas, and real-time alerts for revenue-based analysis.

RevOps
Sales

Creating monthly pipeline snapshots in Salesforce to measure growth or decline over time

Create automated monthly pipeline snapshots in Salesforce to track growth and decline patterns over time with preserved historical data and trend analysis.

RevOps
Sales

Creating Python script for SQL Server to Salesforce data sync with error handling

Skip custom Python scripting for SQL Server to Salesforce sync. Get built-in error handling and reliability without code maintenance overhead.

RevOps

CRM Analytics permission sets needed for dashboard PDF download functionality in Salesforce

Simplify CRM Analytics dashboard PDF downloads by avoiding complex permission sets. Learn a streamlined approach with standard Salesforce permissions.

RevOps
Sales

Export all active HubSpot payment link URLs to CSV with associated product information

Export active HubSpot payment link URLs with product data to CSV using advanced filtering and association handling for comprehensive reporting.

RevOps
Sales

Export multi-page CRMA tabular widget to PDF without Slack integration in Salesforce

Export multi-page CRMA tabular widgets to PDF without requiring Slack integration. Get complete dataset access and reliable PDF generation.

RevOps

Extract all fields associated with specific record type in Salesforce Case object

Discover how to extract complete field lists for specific Salesforce Case record types using Custom SOQL queries and metadata objects.

RevOps
Sales

Extract Salesforce field labels and API names by record type using SOQL

Learn how to extract Salesforce field labels and API names by record type using accessible Custom SOQL queries without developer console access.

RevOps

Get around Salesforce 100,000 row limit for automated email report delivery

Bypass Salesforce's 100,000 row limit for automated email reports using alternative delivery methods that handle unlimited data volumes.

RevOps
Sales

How to automatically backup loser account data before Salesforce merge operation

Create automated backup workflows for Salesforce loser account data before merge operations using scheduled imports, snapshots, and intelligent monitoring systems.

RevOps

How to automatically detect duplicate HubSpot records by contract number without manual export

Automatically detect duplicate HubSpot records by contract number using live data sync. Skip manual exports with real-time monitoring and alerts.

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