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 show only accounts with more than X opportunities in Salesforce standard reports

Learn how to show Salesforce accounts with more than X opportunities using Coefficient's dynamic filtering and automated aggregation capabilities.

Sales

How to split large HubSpot contact lists into smaller segments for email campaigns

Split large imported HubSpot contact lists into smaller, manageable segments for sequential email campaigns using automated batch creation tools.

RevOps

How to track first occurrence of accounts in Salesforce reports while grouping by week

Learn how to track first occurrence of accounts in Salesforce weekly reports using advanced formulas and real-time data integration with spreadsheets.

RevOps
Sales

How to trigger HubSpot workflows on every property value change not just unknown to known

Learn how to capture every HubSpot property change, not just initial assignments. Bypass workflow limitations with automated monitoring solutions.

RevOps

How to troubleshoot Google Sheets API connection timeout errors in reporting

Eliminate Google Sheets API timeout errors with optimized data retrieval and automatic pagination. Handle large datasets without execution limits or memory issues.

RevOps

Salesforce static dashboard show current user data workaround

Bypass Salesforce static dashboard limitations that prevent showing current user data with external dashboard solutions and user-specific data filtering.

Sales

Salesforce workaround for grouping activities by lead owner and contact owner in same report

Discover how to group Salesforce activities by both lead and contact owners in unified reports with automated owner attribution and real-time data sync.

RevOps

Sync partner metrics from Google Sheets to HubSpot without manual imports

Automatically sync partner metrics from Google Sheets to HubSpot CRM properties. Eliminate manual imports with scheduled exports and bulk updates.

RevOps

Troubleshooting HubSpot workflow execution success but no data appearing in Google Sheets

Fix HubSpot workflows that show successful execution but don't populate Google Sheets. Get reliable data transfer with transparent error reporting.

RevOps

Troubleshoot Salesforce Contact History Field Event filters returning empty results

Fix Field Event filters in Salesforce Contact History reports that return no data. Solve syntax issues and access ContactHistory object data directly.

RevOps

What specific activity metrics should I track in a Salesforce sales activity report

Track the right activity metrics in Salesforce with volume, response rates, velocity metrics, and quality scores. Learn how to calculate advanced metrics beyond native reporting.

RevOps
Sales

What time-based filters work best for Salesforce daily sales activity reports

Best time-based filters for Salesforce daily activity reports including rolling dates, business day filters, and dynamic filtering for flexible date range analysis.

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