All our playbooks

How to speed up Power Query Objects connector when expanding related Salesforce fields

Learn why Power Query's expand columns is slow with Salesforce relationships and discover faster alternatives for related field extraction.

Maximum file size limits for Excel attachments in Salesforce Marketing Cloud emails

Understand Marketing Cloud's 1MB Excel attachment limit and learn how to share unlimited spreadsheet data through live links instead.

Query Salesforce Report object metadata using SOQL for Excel export

Execute custom SOQL queries on Salesforce Report object metadata with direct Excel export. Skip API limits and manual formatting with automated solutions.

Refresh Salesforce opportunity data in Excel without re-authenticating each time

Keep Salesforce opportunity data current in Excel without repeated authentication prompts. Get persistent connections that survive restarts and handle MFA.

Setting up time-based triggers for Google Sheets to Slack survey notifications

Configure reliable time-based automation triggers for Google Sheets survey notifications with flexible scheduling and timezone support.

Setting up daily Slack reminders for new Google Sheets survey submissions with respondent emails

Automate daily Slack reminders for Google Sheets survey submissions with automatic respondent email extraction for immediate follow-up.

What happens to Salesforce data refresh when sharing Google Sheets with view-only access

Learn what happens to Salesforce data refresh capabilities when users have view-only access to shared Google Sheets and how to maintain current data.

Workaround for Salesforce Reports API 2000 record limitation when joining multiple objects

Discover effective workarounds for Salesforce Reports API 2000 record limit with multiple object joins using alternative data extraction methods.

Calculating opportunity stage duration using Salesforce field history tracking

Calculate precise opportunity stage duration from Salesforce field history data using advanced date arithmetic and automated tracking formulas.

Can I get automated alerts in a spreadsheet for specific HubSpot deal stage changes, like regressions

Set up automated alerts for specific HubSpot deal stage changes like regressions using Coefficient's alert system combined with spreadsheet formulas.

Can I use AI to pull specific data points from email bodies directly into my spreadsheet without manual entry

Learn how to use AI to automatically extract specific data points from email bodies into spreadsheets with zero manual entry using natural language prompts.

Common causes of Salesforce approval process emails not being delivered

Identify and monitor common Salesforce approval email delivery issues with pattern analysis dashboards and alternative notification systems for reliable workflows.