Generate and email a daily GPT-4o HR changes digest from SAP SuccessFactors EC

SFEC Daily People-Changes Digest

Automatically monitors SAP SuccessFactors Employee Central for people changes in the last 24 hours and delivers an AI-generated digest email every morning.

The workflow tracks four event types: new hires, terminations, internal moves (role/department/location changes), and home address updates. The raw data is sent to OpenAI, which composes a concise, professional-language summary and delivers it to your inbox.

If no changes occurred, the email is skipped and only a log entry is written. If all SF connections fail simultaneously, an error alert is sent instead of the digest.

How it works

1. Configuration — set your SF tenant URL, recipient email, and digest language
2. Set Date Range — computes a 24-hour window and builds four SF OData query URLs
3. Fetch Hires / Terminations / Moves / Addresses — queries SF Employee Central via Basic Auth
4. Aggregate Data — merges and normalises the four result sets; detects errors
5. Critical Error? — if all 4 calls fail, routes to the error email branch
6. Has Changes? — if no data, skips the digest
7. Build AI Prompt → Call OpenAI — generates a structured prose digest in the configured language
8. Send Digest Email — delivers the digest via Gmail

Set up

1. Set the three values in Configuration
2. Assign credentials to the four Fetch nodes, Call OpenAI, and both Gmail nodes
3. Run manually once to verify, then activate the schedule

Side notes

The flow currently works with Basic Auth and GMAIL for easier testing and can be easily enhanced to use SMTP. Or even more security with OAuth 2, which is described here SAP SuccessFactors via SAML 2.0 Bearer Assertion based on OAuth 2 configuration