👥 Automate AI-powered employee onboarding emails and Slack updates with Groq, Gmail, and Google Sheets
⚡ 46 views · 👥 HR & Recruitment
Description
How it works
- Triggered every 4 hours (or manually) to check all active products in Google Sheets
- Each product is evaluated for stock level and urgency against its reorder threshold
- Products with sufficient stock are skipped; duplicate daily orders are prevented
- OpenAI generates a professional Purchase Order message for products needing reorder
- PO is posted to a Slack channel; inventory sheet is updated and reorder log appended
- A summary report is posted to Slack after each full run
- An error handler sends a Slack alert if anything fails
Set up steps
- Estimated time: ~15 minutes
- Add your OpenAI API key; connect Slack and Google Sheets via OAuth2
- Create a Google Sheet with a Products tab and a Reorder Log tab (column names in setup sticky note)
- Select your spreadsheet in all Google Sheets nodes
- Select your Slack channels in the three Slack nodes
- Activate the workflow
🔗 Nodes Used
Google Sheets, Slack, Google Drive, Gmail, AI Agent, Structured Output Parser
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File