Tally to Salesforce Follow-Up Automation (n8n + OpenAI)

Turn every new Tally form submission into an approved SMS follow-up in Salesforce—automatically

This Tally to Salesforce Follow-Up Automation (n8n + OpenAI) workflow listens for new Tally responses, records the inquiry in Salesforce, finds (or creates) the right Lead/Contact, generates an internal sales brief with OpenAI, and—when consent and a valid phone number are present—sends an approved first follow-up via Sent.

What this workflow does

• Triggers on new Tally submissions and validates the submission using the expected form ID and mapped question IDs.
• Normalizes and validates fields (email, phone, consent) and builds an inquiry snapshot.
• Creates a Salesforce custom object record (Tally_Inquiry__c) to atomically claim the submission, and stops on replays or already-completed records.
• Resolves the CRM match by searching Salesforce for an existing Lead and/or Contact by email, linking the inquiry appropriately or creating a new Lead when needed.
• Generates an internal brief with OpenAI and saves it to the Salesforce inquiry record when submitter consent is present and the phone number is valid.
• Sends an approved first-follow-up template via Sent, using an idempotency key to prevent duplicate sends.
• Writes send outcomes back to Salesforce, or raises a manual-review error when results are ambiguous.

Use cases

• A SaaS team collects demo requests through Tally and wants instant CRM capture + first SMS follow-up.
• Sales operators need consistent Lead/Contact matching by email and traceable inquiry status in Salesforce.
• Automation engineers want a replay-safe workflow that prevents duplicate follow-ups while using OpenAI for internal context.

Technical details

• n8n nodes/blocks: if, set, code, salesforce, sticky note, and sentdmn8n-nodes-sentsent.
• Salesforce setup: create Tally_Inquiry__c and required fields (Submission_Key__c, Status__c, Inquiry__c, Result__c, Lead__c, Contact__c), and ensure the n8n user can create/update them.
• Integrations: Tally (submission trigger), Salesforce (recording + Lead/Contact linking), OpenAI (internal sales brief), Sent (SMS template sending).