All our playbooks

Configure Excel to pull fresh Salesforce data at set intervals

Set up interval-based Salesforce data pulls in Excel without creating new files. Configure hourly, daily, or weekly refresh schedules for live reporting.

Configure Salesforce report export to use European number format with comma decimals

Get European number formatting in Salesforce reports with comma decimals. Bypass export limitations with automatic regional formatting.

Connect live Salesforce reports to Excel pivot tables with automatic updates

Create self-updating Excel pivot tables from Salesforce data without VBA macros. Set up daily refresh schedules for live reporting dashboards.

Create self-updating Excel pivot tables from Salesforce data

Build Excel pivot tables that automatically update with fresh Salesforce data. Eliminate daily macro copying and file management with persistent connections.

Creating automated workflow to push Google Sheets data to Salesforce leads

Create automated workflows to push Google Sheets data to Salesforce leads with scheduling, conditional logic, lead assignment, and duplicate prevention.

Creating automated MRR cohort analysis reports with HubSpot revenue data

Create automated MRR cohort analysis reports using HubSpot revenue data. Track customer retention and revenue expansion by acquisition cohorts.

Creating custom reports with junction object and related object fields without formula fields in Salesforce

Build custom junction object reports with related object fields in Salesforce without writing complex formula fields using this no-code approach.

Creating unified advertising reports combining HubSpot ad metrics and contact-level interactions

Build comprehensive advertising reports that combine HubSpot campaign metrics with individual contact interactions for complete attribution analysis.

Custom object vs contact object performance impact in HubSpot when storing millions of user events

Compare performance impacts of storing millions of user events in HubSpot custom objects vs contact objects and learn optimization strategies.

Display fixed weekly target line across entire report chart for sequence enrollment metrics

Create truly fixed weekly target lines for HubSpot sequence enrollment reports using spreadsheet charts that don't fluctuate with calendar variations.

Export Salesforce campaign contacts with segmentation data to Excel for analysis

Export Salesforce campaign data with complete segmentation fields for analysis. Get industry, lead source, and behavioral data in one comprehensive export.

Export Salesforce CRM Analytics dashboard with preserved hierarchy and grouping structure

Learn how to recreate CRM Analytics dashboards with preserved hierarchy and grouping structure using direct Salesforce data connections.