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.

Export Salesforce monthly sales by rep report to Excel format

Eliminate manual Salesforce Excel exports with automated scheduling, professional formatting, and seamless integration for monthly sales reports.

Sales

Fix decimal separator mismatch between Salesforce exported data and Excel regional settings

Resolve decimal separator conflicts between Salesforce exports and Excel regional settings. Get automatic formatting alignment with direct imports.

RevOps

Fix CRM Analytics Pivot Table export losing grouping format in Excel

Solve the problem of CRM Analytics pivot tables losing grouping when exported to Excel with this direct Salesforce connection workaround.

RevOps
Sales

Fix Excel showing dots instead of commas for decimals in Salesforce report exports

Solve decimal separator issues in Salesforce Excel exports. Get comma decimals automatically without changing regional settings or manual fixes.

RevOps
Sales

Fix “Inline editing isn’t supported for this cell” error on Salesforce opportunity product checkbox

Getting the "inline editing isn't supported" error on opportunity product checkboxes? Here's why it happens and how to edit these fields in Google Sheets.

Sales

Fix Salesforce CRM Analytics download Excel format button removing data grouping

Solve the problem of CRM Analytics Excel download button removing data grouping with this direct Salesforce connection alternative.

RevOps

Fix Salesforce report showing all customers but Excel export missing data after row 2013

Solve Salesforce partial data export issues where reports display complete datasets but Excel exports cut off at row 2013. Get all your customer data.

Sales

Force comma decimal separator in Salesforce CSV exports to Excel

Bypass Salesforce CSV export limitations with comma decimal separators. Get properly formatted data in Excel without CSV delimiter conflicts.

RevOps

How to automatically refresh Salesforce data in Excel at scheduled times

Learn how to set up automatic Salesforce data refresh in Excel with scheduled intervals. No more manual downloads or CSV exports needed.

RevOps
Sales

How to automatically sync HubSpot deals with line items to Google Sheets for finance reporting

Learn how to automatically sync HubSpot deals with line items to Google Sheets for accurate finance reporting without manual exports or data staleness.

Finance

How to build custom HubSpot advertising dashboards with contact-level attribution data

Create sophisticated HubSpot advertising dashboards with contact-level attribution analysis that standard HubSpot dashboards can't provide.

RevOps

How to build xlsx files from Salesforce report data without external libraries

Create true xlsx files from Salesforce reports without Apex limitations. Get authentic Excel format with formulas, formatting, and multi-sheet support.

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