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.

Tracking net revenue retention using HubSpot customer and deal data

Track net revenue retention using HubSpot customer and deal data. Calculate NRR rates with cohort analysis and automated retention tracking.

Finance
RevOps

What happens to existing HubSpot data when importing selective fields from Salesforce

Learn how to protect existing HubSpot data during selective Salesforce field imports and prevent unwanted overwrites with proper data validation.

RevOps

What permissions are needed to export Salesforce list view records to Excel

Required Salesforce permissions for exporting list view data to Excel. Understand API access, field-level security, and MFA considerations for data exports.

RevOps

Why can’t I inline edit checkbox fields in Salesforce opportunity product reports

Salesforce blocks inline editing of checkbox fields in opportunity product reports. Learn why this happens and how to edit these fields using Google Sheets.

Sales

Why Salesforce Excel import only shows new contacts in list view

Understand why Salesforce Excel imports exclude existing contacts from list views and how to create comprehensive contact lists that include all records.

RevOps

How to create a Salesforce report for closed won opportunities by rep and month

Learn how to create flexible Salesforce closed won opportunity reports by sales rep and month using spreadsheet pivot tables and automated data refresh.

Sales

How to hide specific fields from Salesforce report type selection

Discover how to control field visibility in Salesforce reports by importing directly from objects instead of using limited report type customization.

RevOps

How to link external report data to Salesforce dashboard components

Combine Salesforce data with external report sources in unified dashboards for comprehensive business intelligence beyond native platform limitations.

Finance
RevOps

How to map Xero customer invoices to specific HubSpot projects for AR visibility

Map Xero customer invoices to HubSpot projects for complete AR visibility using automated data imports, relationship formulas, and dynamic filtering.

Finance
RevOps

How to format transaction date fields for HubSpot import to enable date picker filtering

Learn how to format transaction date fields correctly for HubSpot import to enable proper date picker filtering in reports and workflows.

Finance
RevOps

How to export filtered Salesforce list view records to Excel without creating a report

Export filtered Salesforce list view records directly to Excel without creating reports. Skip the printable view limitations with direct object imports.

RevOps
Sales

How to export more than 2000 rows from Salesforce weekly customer order analysis

Bypass Salesforce 2000-row export limits for weekly customer order analysis. Get complete datasets with automated refreshes and unlimited row access.

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