How it works
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. An n8n automation workflow template by Redowan Ahmed Farhan.
Redowan Ahmed Farhan
web
free
Others in the same category, ranked by how often they are opened.
