Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Data Sync & ETL

Data Sync & ETL

Flag at-risk supplier deliveries with Google Sheets and Slack alerts

On a schedule, it moves and syncs data using Google Sheets, Slack.

Import it free Sign in to open it

What it does

## Supplier Failure Early-Warning System ### How it works This workflow runs on a daily schedule to check purchase orders against supplier history, customer commitments, and carrier tracking data. It joins the source data, scores supplier delivery risk, and branches based on whether any risks are found. When risks exist, it writes them to a risk register and sends a Slack alert; every run is logged and normalized for downstream reporting. ### Setup steps - Configure the schedule on the Daily Early-Warning Check trigger for the desired run time and timezone. - Edit the CONFIG - Edit Before Running node with the correct Google spreadsheet ID, Slack channel, timezone, and lateGraceDays threshold. - Connect Google Sheets credentials with access to the purchase orders, supplier history, customer commitments, carrier tracking, risk register, and run log sheets. - Connect Slack credentials and confirm the bot can post to the configured channel. - Review the code nodes to ensure column names and risk-scoring assumptions match the spreadsheet structure. ### Customization Adjust the risk-scoring logic, grace period, Slack message format, and sheet/tab names to match your supplier monitoring process. @youtube

The steps

  1. When Every 6 Hours
  2. Set Configuration Options
  3. Read Purchase Orders from Sheets
  4. Read Supplier History from Sheets
  5. Read Customer Commitments Sheets
  6. Read Carrier Tracking from Sheets
  7. Analyze Risk Data
  8. Check for Risk Presence
  9. Append to Risk Register
  10. Create Slack Alert Message
  11. Post Alert to Slack
  12. Log Execution Results
  13. No Risk Action
  14. Draft Escalation Queue

15 steps in total.

Similar automations

Monitoring, Ops & IncidentsScore Supplier Risk Daily and Email Alerts14 stepsFinance, Invoices & AccountingFlag possible duplicate supplier invoices in Google Sheets before payment with Slack9 stepsEmail AutomationScore customer health and flag churn risk with Stripe, Zendesk, OpenAI, Slack and HubSpot24 stepsAI Agents & AssistantsRetry webhook deliveries with exponential backoff and a dead-letter queue webhook9 steps