Schedule Supplier Follow-ups from Airtable POs to Google Calendar with AI, Slack & Gmail — n8n 工作流

高 复杂度⏰ 定时16 个节点🏷️ Project Management作者：Rahul Joshi

概览

📊 Description Ensure suppliers never miss a follow-up by automating overdue purchase order tracking and scheduling. 📦⏰ This workflow checks Airtable every weekday morning for open POs older than seven days without scheduled follow-ups, generates Google Calendar events, updates Airtable with the follow-up link, and sends notifications to your team via Slack and Gmail. It centralizes supplier management and eliminates manual reminders, helping operations teams stay on top of aging purchase orders

使用的节点

AirtableSlackGoogle CalendarGmailAI AgentOpenAI Chat ModelSimple MemoryStructured Output Parser

工作流预览

🔄 Automated Supplier Follow-up System
How it works
This workflow monitors overdue purchase orders in Airta
⏰ Trigger & Data Fetch
Runs every weekday at 10 AM to pull overdue purchase or
🤖 AI Processing & Validation
Filters POs with valid supplier emails, then uses GPT-4
📅 Calendar & Notifications
Creates Google Calendar events with AI-generated agenda
🔐 Credentials & Security
Use OAuth2 for Google Calendar, Slack, and Gmail. Airta
🚨 Error Monitoring
Catches errors from key nodes (AI, Notion, Sheets) and
Helps ensure the automation runs reliably.
memorymodelparser
⚡
S
Schedule Trigger
Fetch Overdue POs from A…
P
Process Each PO Individu…
Save Calendar Link to Ai…
Send Slack Notification
Create Calendar Event
Send Email Confirmation
Initial Slack Alert
I
If
Parse AI Output (Structu…
AI Model: GPT-4 Screenin…
AI Memory: Candidate Con…
AI Agent: Agent Writer
Send a message
⚡
E
Error Trigger
Slack - Error Alert
16 nodes15 edges

工作原理

  1. 1

    触发器

    工作流由 定时 触发器启动，按预定计划运行。

  2. 2

    处理

    数据流经 16 个节点, connecting agent, airtable, errortrigger。

  3. 3

    输出

    工作流完成自动化并将结果发送到配置的目标。

节点详情 (16)

AI

Airtable

airtable

#1
SL

Slack

slack

#2
GO

Google Calendar

googleCalendar

#3
GM

Gmail

gmail

#4
AI

AI Agent

n8n-nodes-langchain.agent

#5
OP

OpenAI Chat Model

n8n-nodes-langchain.lmChatOpenAi

#6
SI

Simple Memory

n8n-nodes-langchain.memoryBufferWindow

#7
ST

Structured Output Parser

n8n-nodes-langchain.outputParserStructured

#8

如何导入此工作流

  1. 1点击右侧 下载 JSON 按钮保存工作流文件。
  2. 2打开你的 n8n 实例，依次点击 工作流 → 新建 → 从文件导入。
  3. 3选择下载的 schedule-supplier-follow-ups-from-airtable-pos-to-google-calendar-with-ai-slack-gmail 文件并点击导入。
  4. 4为每个服务节点配置 凭证（API 密钥、OAuth 等）。
  5. 5点击 测试工作流 验证一切正常，然后激活它。

或直接在 n8n → 从 JSON 导入 中粘贴：

{ "name": "Schedule Supplier Follow-ups from Airtable POs to Google Calendar with AI, Slack & Gmail", "nodes": [...], ...}

集成

agentairtableerrortriggergmailgooglecalendariflmchatopenaimemorybufferwindowoutputparserstructuredscheduletriggerslacksplitinbatches

获取此工作流

一键下载并导入

下载 JSON在 n8n.io 上查看
节点16
复杂度high
触发器scheduled
分类Project Management

创建者

Rahul Joshi

Rahul Joshi

@rahul08

标签

agentairtableerrortriggergmailgooglecalendariflmchatopenaimemorybufferwindowoutputparserstructuredscheduletrigger
⚡

n8n 新手？

n8n 是一款免费开源的工作流自动化工具，支持自托管或使用云版本。

免费获取 n8n →