CRM
Salesforce to Snowflake Golden-Record Conflict Report with Email Sign-off
Cross-references Salesforce Accounts against a Snowflake golden-record table, surfaces every field where the CRM and the source of truth disagree.
How it runs
The automated pipeline, trigger to output.
- TriggerScheduled reconciliation run
- ActionRead golden-record rows from SnowflakeSnowflake
- ActionFetch matching Salesforce Accounts and diff each fieldSalesforce
- LogicRank conflicts by business impact and recommend winning source
- ActionEmail prioritized conflict-resolution report to data stewardOutlook
- OutputOn approval, write resolved values back to SalesforceSalesforce
What it does
This workflow compares Salesforce Account fields against the authoritative golden records stored in Snowflake. For each account it identifies which fields conflict, ranks them by business impact, and proposes whether Salesforce or Snowflake should win. It emails a prioritized conflict report to the data steward, and on approval pushes the resolved values back into Salesforce.
When to use it
Use it when Snowflake is your master data warehouse and Salesforce drifts out of sync, and you need a steward to review and approve reconciliations rather than overwriting the CRM automatically.
How it works
- 1A schedule trigger kicks off the reconciliation run.
- 2The workflow reads golden-record rows from Snowflake.
- 3It fetches the matching Salesforce Accounts and diffs each field against Snowflake.
- 4A logic step ranks conflicts by business impact and recommends the winning source.
- 5It emails the prioritized conflict-resolution report to the data steward via Outlook.
- 6On approved reconciliation, it writes resolved field values back to Salesforce.
Set it up
What you configure once, before turning it on.
- 1Connect SalesforceAccounts, opportunities, cases.
- 2Connect SnowflakeWarehouses, queries, shares.
- 3Connect OutlookMail, calendar, contacts.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More CRM workflows
Dormant Account Check-In Call Scheduler
On the anniversary of an account's last touch, books a tentative check-in call on the owner's Google Calendar and emails the contact a scheduling invite.
Weekly Dormant-Anniversary Cohort Digest
Every week, groups dormant Attio accounts by which last-touch anniversary they hit that week, builds a prioritized digest.
AI-Personalized Dormant Account Win-Back
On a dormancy anniversary, an agent researches the account's history and recent public signals, drafts a genuinely personalized win-back email.
Backfill Intercom conversation topics onto stale HubSpot contacts
Finds HubSpot contacts with no recent Intercom topic, pulls their conversation history from Intercom, classifies the dominant topic with OpenAI.
Daily orphaned-opportunity sweep with manager Slack digest
Each morning this scans Salesforce for open opportunities owned by inactive users and posts a per-manager digest in Slack listing the orphaned deals that need a new owner.
Tag closed Intercom conversations onto Salesforce contacts in real time
On each Intercom conversation close, classifies the topic with OpenAI and appends it to the matching Salesforce contact's activity timeline so the topic never goes stale…
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.