n8n Salesforce Risk Analysis: Gmail & Calendar Alerts

Automatically assess Salesforce stakeholder engagement risk using Gmail & Google Calendar — and alert your team in Slack

This n8n workflow watches for updated Salesforce Opportunities, analyzes stakeholder engagement from Gmail and Google Calendar, then uses OpenAI (gpt-4o-mini) to score risk and write results back into Salesforce. If the risk score is high (61+), it posts an alert to Slack.

What this workflow does

• Triggers on Opportunity updates in Salesforce.
• Pulls Opportunity details and related Opportunity Contact Roles from Salesforce.
• Calculates which stakeholder roles are expected based on the opportunity amount and stage, then compiles the relevant contact emails/domains to search.
• Searches the connected Gmail mailbox for emails involving those stakeholders and pulls interaction events from a specified Google Calendar.
• Normalizes emails and meetings into a single interaction list and combines it with opportunity context + contact details.
• Sends the data to OpenAI (gpt-4o-mini) to generate a structured JSON analysis (stakeholder gap + risk). It then parses and validates the response.
• Updates the Salesforce Opportunity with:
  • Stakeholder risk status and score
  • Engagement insight
  • Last analysis timestamp
  • Missing stakeholder roles
• Posts a Slack alert when the Stakeholder_Risk_Score__c is 61 or higher.

Use cases

• Flagging deals where required stakeholders haven’t engaged via email or meetings.
• Ensuring accountability by writing engagement gaps directly into Salesforce custom fields.
• Surfacing high-risk opportunities to sales/ops teams with real-time Slack alerts.

Technical details

• n8n workflow: if, code, no op, gmail, merge, slack
• Integrations: Salesforce, Gmail, Google Calendar, OpenAI (gpt-4o-mini), Slack

Setup note: Connect Salesforce credentials and ensure the Opportunity has the custom fields used for output (e.g., Stakeholder_Engagement_Status__c, Last_Stakeholder_Analysis__c, Stakeholder_Risk_Score__c, Stakeholder_Engagement_Insight__c, and missing roles field).