Automate AI-powered employee onboarding emails and Slack updates with Groq, Gmail, and Google Sheets

Go to Workflow
0 views
Built by Redowan Ahmed Farhan Redowan Ahmed Farhan
Created on June 10, 2026

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 (8)

AI Agent
@n8n/n8n-nodes-langchain.agent
Code
n8n-nodes-base.code
Gmail
n8n-nodes-base.gmail
Google Drive
n8n-nodes-base.googleDrive
Google Sheets
n8n-nodes-base.googleSheets
Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq
Slack
n8n-nodes-base.slack
Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured