All our playbooks

How to set up automatic scheduled refreshes for CRM and ERP data in Google Sheets and Power BI

Set up automated scheduled data refreshes from CRM, ERP, and other business systems directly into spreadsheets. No more manual exports or outdated data.

How to replace static Notion marketing KPI reports with automatically refreshing charts from Google Sheets

Replace static Notion marketing reports with auto-refreshing Google Sheets charts. Automate KPI tracking from multiple platforms for real-time insights.

Triggering real-time sales performance alerts in Slack when CRM data updates in Google Sheets

Set up instant Slack notifications when your CRM data changes in Google Sheets using Coefficient's real-time triggers and automation features.

Auto-update Google Sheets when Salesforce report data changes

Auto-update Google Sheets when Salesforce report data changes with scheduled refresh and alerts. Get near real-time data synchronization without manual intervention.

Build live Excel dashboards that pull Salesforce case data automatically each morning

Create Excel dashboards with automatic morning updates from Salesforce case data. Track case metrics, team performance, and resolution times with live data connections.

Build Salesforce report with rep names as rows and months as columns

Create professional Salesforce reports with sales rep names as rows and months as columns using dynamic layouts and automated calculations.

Building finance-ready deal reports from HubSpot with line item breakdowns in Google Sheets

Create finance-ready deal reports from HubSpot with complete line item breakdowns that meet financial reporting standards and update automatically.

Building point-based scoring dashboards in HubSpot for activity tracking

Build point-based scoring dashboards in HubSpot for activity tracking with weighted calculations and automated real-time updates.

Calculating expansion MRR and contraction MRR from HubSpot deal properties

Calculate expansion MRR and contraction MRR from HubSpot deal properties. Track customer-level MRR changes and net expansion rates automatically.

Calculate quarterly quota attainment when system only shows monthly data

Transform monthly CRM quota data into accurate quarterly calculations with weighted formulas and automated aggregation that your system can't provide natively.

Can spreadsheet formulas be used when creating Salesforce objects

Learn how to use spreadsheet formulas when creating Salesforce objects. Formula Auto Fill Down enables dynamic data transformation and calculations.

Can you export more than 2000 records from Salesforce list view to Excel directly

Export large Salesforce datasets beyond 2000 records directly to Excel. Bypass list view pagination limits with API-based data retrieval methods.