Generate and email daily AI-powered HR changes digest from SAP SuccessFactors EC with GPT-4o-mini and Gmail
Ready for 3.0What this workflow does
This workflow has 19 nodes and runs on a schedule (cron 30 6 * * *) (plus 1 other trigger). Along the way it connects Gmail. It also calls api.openai.com over HTTP.
How it runs
Trigger: On a schedule (cron 30 6 * * *) (plus 1 other trigger).
- Set Config Variables (Edit Fields (Set)): sets 3 fields: SF_BASE_URL, EMAIL_TO, DIGEST_LANGUAGE
- Calculate Date Range (Code): runs custom JavaScript code
- Fetch New Hires (HTTP Request): calls an HTTP API
- Fetch Terminated Employees (HTTP Request): calls an HTTP API
- Fetch Internal Transfers (HTTP Request): calls an HTTP API
- Fetch Address Changes (HTTP Request): calls an HTTP API
- Combine Data from Sources (Code): runs custom JavaScript code
- Check for Critical Errors (If): checks a condition and branches into true / false
- Create Error Email Content (Code): runs custom JavaScript code
- Check for HR Changes (If): checks a condition and branches into true / false
…plus 7 more steps. See the full node list below.
Services it uses
HTTP calls to: api.openai.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail
From the author
How it works 1. Triggers daily or manually for execution. 2. Configures base URL and email settings for SAP SF. 3. Fetches HR change data from SuccessFactors. 4. Aggregates data and checks for errors or changes. 5. Processes results with AI and sends digest…