All our playbooks

How to send mass emails using Excel-based targeting criteria not available in Salesforce CRM fields

Execute mass email campaigns using Excel-based targeting criteria by automatically syncing external data with Salesforce custom fields for native execution.

How to structure Salesforce data with merged fields for accurate component counting

Learn to structure Salesforce data with merged fields using a dual-architecture approach that enables both display readability and accurate component counting.

How to standardize contact data from different sources before Salesforce import

Standardize contact data from multiple sources using spreadsheet formulas and validation before importing to Salesforce for consistent data quality.

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.

How to track Excel import progress in Salesforce LWC with status updates

Track Excel import progress in Salesforce without building custom LWC polling logic. Get real-time status updates and background processing capabilities.

How to sync external spreadsheet criteria with Salesforce CRM contacts for automated email campaigns

Automate email campaigns by syncing external spreadsheet criteria with Salesforce CRM contacts using scheduled data pipelines and export automation.

How to validate Excel data before uploading to Salesforce accounts in LWC

Validate Excel data for Salesforce Account uploads without building custom LWC validation logic. Get automatic field type and picklist validation.

How to troubleshoot “unauthorized” error when teammate uses Salesforce connector in shared Google Sheet

Learn how to troubleshoot and prevent "unauthorized" errors when teammates use Salesforce connectors in shared Google Sheets through proper permission setup.

How to troubleshoot Google Sheets permission errors in Salesforce automated workflows

Troubleshoot Google Sheets permission errors in Salesforce workflows. Get clear error messages and guided resolution for authentication and access issues.

JavaScript libraries for generating XLS files directly from Lightning component data in Salesforce

Avoid JavaScript library complexity in Salesforce Lightning components. Get reliable XLS exports with SheetJS alternatives using Coefficient's direct integration.

Import multi-sheet Excel workbooks into different Salesforce objects

Learn how to import multi-sheet Excel workbooks into different Salesforce objects with automated mapping, relationship handling, and error management.

Import Excel files with lookup relationships into Salesforce

Import Excel files with lookup relationships into Salesforce using automatic reference resolution, missing lookup handling, and relationship integrity checking.