Kütüphane / Veri Senkronizasyonu ve ETL
Veri Senkronizasyonu ve ETL
Flag at-risk supplier deliveries with Google Sheets and Slack alerts
On a schedule, it moves and syncs data using Google Sheets, Slack.
Ne yapar
## 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
Adımlar
- When Every 6 Hours
- Set Configuration Options
- Read Purchase Orders from Sheets
- Read Supplier History from Sheets
- Read Customer Commitments Sheets
- Read Carrier Tracking from Sheets
- Analyze Risk Data
- Check for Risk Presence
- Append to Risk Register
- Create Slack Alert Message
- Post Alert to Slack
- Log Execution Results
- No Risk Action
- Draft Escalation Queue
Toplam 15 adım.
Benzer otomasyonlar
İzleme, Operasyon ve OlaylarTedarikçi Riskini Günlük Puanla ve Uyarıları E-postayla Gönder14 adımFinans, Faturalar ve MuhasebeFlag possible duplicate supplier invoices in Google Sheets before payment with Slack9 adımE-posta OtomasyonuScore customer health and flag churn risk with Stripe, Zendesk, OpenAI, Slack and HubSpot24 adımYapay Zekâ Ajanları ve AsistanlarRetry webhook deliveries with exponential backoff and a dead-letter queue webhook9 adım