Workflow overview
Why this workflow matters
Relevant for managed services and support workflows.
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
Best fit
Categories
Services
Use cases
Need another direction?