AutomationMart
Home/Browse/Generate weekly supply chain OTIF reports and AI analysis with Notion and GPT-4o
n8n

Generate weekly supply chain OTIF reports and AI analysis with Notion and GPT-4o

n8nn8n11 modulesv1.0
NotionGoogle SheetsOpenAILinkedIn

Tags: Logistics, Supply Chain, OTIF, KPI Tracking, Performance Management, AI Analysis, Notion Context Hi! I'm Samir, Supply Chain Engineer, Data Scientist based in Paris, and founder of LogiGreen. > Let's use AI with n8n to automate supply chain performance tracking! Tracking On-Time In-Full (OTIF) delivery performance is critical for retail logistics, but manually compiling data, computing KPIs, and writing analysis reports is time-consuming and error-prone. []( This workflow automates the

At a glance

Generate weekly supply chain OTIF reports and AI analysis with Notion and GPT-4o is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Notion, Google Sheets, OpenAI, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Notion, Google Sheets, OpenAI, LinkedIn
Modules
11
Price
Free
Version
v1.0
Generate weekly supply chain OTIF reports and AI analysis with Notion and GPT-4o workflow diagram

About this workflow

Tags: Logistics, Supply Chain, OTIF, KPI Tracking, Performance Management, AI Analysis, Notion Context Hi! I'm Samir, Supply Chain Engineer, Data Scientist based in Paris, and founder of LogiGreen. > Let's use AI with n8n to automate supply chain performance tracking! Tracking On-Time In-Full (OTIF) delivery performance is critical for retail logistics, but manually compiling data, computing KPIs, and writing analysis reports is time-consuming and error-prone. []( This workflow automates the entire process: collecting shipment data, aggregating weekly KPIs, generating AI powered performance analyses, and pushing everything into a Notion dashboard. []( For business inquiries, you can find me on LinkedIn Demo of the workflow The workflow collects shipment records from your TMS and WMS, then aggregates them by week. []( An AI Agent analyses each week's performance and generates summary cards in Notion. []( Weekly OTIF data is automatically pushed to a Notion database for tracking and visualisation. []( Who is this template for? This template is ideal for logistics and supply chain teams looking to automate KPI reporting: - Supply chain managers tracking delivery performance across carriers and warehouses - Logistics analysts who need automated weekly OTIF scorecards - Operations teams looking to leverage AI for performance insights Tutorial A complete tutorial (with explanations of every node) is available on YouTube: []( What does this workflow do? This automation uses Notion databases and OpenAI AI Agents to build a complete OTIF scorecard: 1. The workflow is triggered manually (or on a schedule). 2. Shipment data is collected from your TMS and WMS systems. 3. Records are aggregated by week, computing On-Time rate, In-Full rate, and OTIF rate. 4. An AI Agent analyses each week's performance and identifies trends, issues, and recommendations. 5. Weekly KPI rows are pushed to the Daily OTIF Summary database in Notion. 6. Per-week AI analysis cards are created in the AI Generated Analysis database. 7. A second AI Agent generates a global performance summary across all weeks. 8. The global summary card is updated in Notion with the overall analysis. Next Steps Before running the workflow, follow the sticky notes and configure: - Connect your Notion API credentials and update the database IDs in all Notion nodes - Add your OpenAI API Key to the AI Agent nodes - Update the "Collect Shipments from TMS & WMS" node with your actual data source (API, Google Sheets, or database) - Adjust the AI prompts to match your specific KPI thresholds and business context - Set up the Notion template with the two required databases: "Daily OTIF Summary" and "AI Generated Analysis" - Duplicate the Notion template to your workspace before connecting the workflow - (Optional) Change the trigger from manual to a scheduled cron for automated weekly reporting Submitted: 8 March 2026 Template designed with n8n version 2.10.12

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Add Intercom users from new Google Sheets rows

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a new user in Intercom. The template uses this [examplle spreadsheet](https://bit.ly/2JsO3Sm).

Free

Import products from Google Sheets to Shopify with multi-variant support

Short Description (for listing) Import products from Google Sheets to Shopify with automatic handling of single products and multi-variant products (sizes, colors, etc.). Includes SKU management, inventory tracking, and image uploads via GraphQL API. Category - E-commerce - Productivity - Data Import/Export Full Description Overview This workflow automates the process of importing products from a Google Sheet into your Shopify store. It intelligently detects and handles both simp

Free

Detect misinformation and manipulation risks with GPT-4o agents and Google Sheets

How It Works This workflow automates misinformation and information manipulation detection using a coordinated multi-agent AI architecture. It is designed for trust and safety teams, media analysts, researchers, and platform moderators who need scalable, structured threat assessment. The pipeline begins when a trigger initiates content analysis. A central Misinformation Detection supervisor agent coordinates three specialised sub-agents: a Narrative Pattern Detector that identifies recurring dis

Free

Create a Reply.io contact and push it to a sequence from a new Dux-Soup visit event

Every time Dux-Soup visits a LinkedIn profile that contains an email address, Make will automatically create a Reply.io contact and push it to a campaign (sequence).

Free

Add subscribers to Campaign Monitor from a Google Sheets spreadsheet

Every time a new row is added to a selected Google Sheets spreadsheet, Make will automatically add a new subscriber to your Campaign Monitor list. The template uses this [example spreadsheet](https://goo.gl/BUAwJs).

Free

Access control for AI agents (RBAC) using Airtable and Telegram

Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control. Demo & Explanation []( How it works - User permissions are managed in Airtable where every restricted AI tool is listed by name and connected via roles to users - Requests to the Main Agent can be sent through a Telegram message (can be replaced by Whatsapp, IMAP or similar) - On every request the Telegram username is used to query a list o

Free

Multi-AI agent router: compare OpenAI, Anthropic & Groq responses with webhooks

Introduction This workflow connects to OpenAI, Anthropic, and Groq, processing requests in parallel with automatic performance metrics. Ideal for testing speed, cost, and quality across models. How It Works Webhooks trigger parameter extraction and routing. Three AI agents run simultaneously with memory and parsing. Responses merge with detailed metrics. Workflow Template Webhook → Extract Parameters → Router ├→ OpenAI Agent ├→ Anthropic Agent ├→ Groq Agent → Merge → Metrics → Respond

Free

Report and clean up stale GitHub branches with Slack notifications

Quick Overview This workflow runs weekly (or manually) to scan GitHub repositories for merged-but-not-deleted and stale branches, then posts a cleanup report to Slack and can optionally auto-delete a capped number of branches. How it works 1. Runs on a weekly schedule or when you manually execute the workflow. 2. Loads configuration for the GitHub repo owner, repository list, stale age threshold, protected branch patterns, Slack channel, and deletion limits. 3. For each configured repository, fe

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free