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.

Salesforce dashboard date filter allowing users to select custom date ranges on the fly

Enable on-the-fly custom date range selection in Salesforce dashboards with instant filtering and dynamic analysis capabilities for flexible reporting.

RevOps
Sales

Salesforce dashboard limitation workaround for displaying amount on stacked bar hover

Work around Salesforce stacked bar chart hover limitations with external dashboards that display opportunity amounts and custom metrics in tooltips.

RevOps
Sales

Salesforce dashboard relative date filter for month-over-month comparisons without multiple filters

Create dynamic month-over-month comparisons in Salesforce dashboards without managing multiple relative date filters using automated comparison logic.

RevOps
Sales

Salesforce dashboard filter to compare any two months across different years dynamically

Create dynamic filters in Salesforce dashboards to compare any two months across different years without pre-configuring specific filter combinations.

Finance
Sales

Time-based decay formulas for Salesforce account scoring in long sales cycles

Build sophisticated time-based decay formulas for Salesforce account scoring that prevent outdated activities from inflating health scores in long sales cycles.

RevOps
Sales

TCRM API automated email exports for filtered Salesforce table data

Discover why TCRM API has limitations for automated email exports and learn a more effective alternative for Salesforce filtered table data.

RevOps

Update null fields only in Salesforce bulk data load operation

Target only null fields in Salesforce bulk data operations. Learn precise null field update techniques that preserve existing data integrity.

RevOps

What are the benefits of using AI to streamline data hygiene for live CRM data in Google Sheets

Discover how AI-powered data hygiene transforms CRM data management with 98% time reduction, improved accuracy, and automated workflows for live data.

RevOps
Sales

NetSuite API integration with Excel for automatic report generation without coding

Automate NetSuite report generation in Excel without coding. Connect via API for scheduled refreshes of financial reports and custom dashboards.

Finance

NetSuite REST API vs SuiteAnalytics Connect for BI tool integrations

Compare NetSuite REST API vs SuiteAnalytics Connect for BI integrations. Discover a third option that combines flexibility with ease-of-use at lower cost.

Finance
RevOps

NetSuite REST API vs saved searches for pulling large amounts of transaction data

Compare NetSuite REST API vs saved searches for large transaction datasets. Get API performance through user-friendly interfaces without development.

Finance

NetSuite saved search configuration for revenue recognition schedule automation

Automate NetSuite revenue recognition schedules using saved search configurations with Excel integration and automated refresh capabilities.

Finance
700,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies