{"product_id":"n8n-salesforce-risk-analysis-gmail-calendar-alerts","title":"n8n Salesforce Risk Analysis: Gmail \u0026 Calendar Alerts","description":"\u003ch3\u003eAutomatically assess Salesforce stakeholder engagement risk using Gmail \u0026amp; Google Calendar — and alert your team in Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches for updated Salesforce Opportunities, analyzes stakeholder engagement from \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e, then uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to score risk and write results back into Salesforce. If the risk score is high (61+), it posts an alert to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on Opportunity updates\u003c\/strong\u003e in Salesforce.\u003c\/li\u003e\n  \u003cli\u003ePulls \u003cstrong\u003eOpportunity details\u003c\/strong\u003e and related \u003cstrong\u003eOpportunity Contact Roles\u003c\/strong\u003e from Salesforce.\u003c\/li\u003e\n  \u003cli\u003eCalculates which stakeholder roles are expected based on the \u003cstrong\u003eopportunity amount\u003c\/strong\u003e and \u003cstrong\u003estage\u003c\/strong\u003e, then compiles the relevant contact emails\/domains to search.\u003c\/li\u003e\n  \u003cli\u003eSearches the connected \u003cstrong\u003eGmail mailbox\u003c\/strong\u003e for emails involving those stakeholders and pulls interaction \u003cstrong\u003eevents\u003c\/strong\u003e from a specified \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eNormalizes emails and meetings into a single interaction list and combines it with opportunity context + contact details.\u003c\/li\u003e\n  \u003cli\u003eSends the data to \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to generate a structured JSON analysis (stakeholder gap + risk). It then \u003cstrong\u003eparses and validates\u003c\/strong\u003e the response.\u003c\/li\u003e\n  \u003cli\u003eUpdates the Salesforce Opportunity with:\n    \u003cul\u003e\n      \u003cli\u003eStakeholder risk status and score\u003c\/li\u003e\n      \u003cli\u003eEngagement insight\u003c\/li\u003e\n      \u003cli\u003eLast analysis timestamp\u003c\/li\u003e\n      \u003cli\u003eMissing stakeholder roles\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003ePosts a \u003cstrong\u003eSlack\u003c\/strong\u003e alert when the \u003cstrong\u003eStakeholder_Risk_Score__c\u003c\/strong\u003e is \u003cstrong\u003e61 or higher\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFlagging deals where required stakeholders haven’t engaged via email or meetings.\u003c\/li\u003e\n  \u003cli\u003eEnsuring accountability by writing engagement gaps directly into Salesforce custom fields.\u003c\/li\u003e\n  \u003cli\u003eSurfacing high-risk opportunities to sales\/ops teams with real-time Slack alerts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n workflow: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eSalesforce\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e, \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e 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).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217910616243,"sku":"N8N-20845","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/glbog0XrH_hEDmLnvG6l3_Ke07xzoT.png?v=1791882640","url":"https:\/\/buyflowscripts.com\/products\/n8n-salesforce-risk-analysis-gmail-calendar-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}