Schedule supplier follow-ups from Airtable POs to Google Calendar with AI, Slack & Gmail
Ready for 3.0What this workflow does
This AI workflow has 16 nodes and runs on a schedule (cron 0 10 * * 1-5) (plus 1 other trigger). Along the way it connects Airtable, Slack, Google Calendar and Gmail and 1 more.
How it runs
Trigger: On a schedule (cron 0 10 * * 1-5) (plus 1 other trigger).
- Fetch Overdue POs from Airtable (Airtable): search
- Slack: uses Slack
- Process Each PO Individually (Loop Over Items (Split in Batches)): loops over the items in batches
- Initial Slack Alert (Slack): uses Slack
- If: checks a condition and branches into true / false
- AI Agent: runs an AI agent, with model: AI Model: GPT-4 Screening Engine; memory: AI Memory: Candidate Context; output parser: Parse AI Output (Structured JSON)
- Send a message (Slack): uses Slack
- Create Calendar Event (Google Calendar): uses Google Calendar
- Save Calendar Link to Airtable (Airtable): update
- Send Slack Notification (Slack): uses Slack
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Airtable
n8n-nodes-base.airtable - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Slack
n8n-nodes-base.slack - Google Calendar
n8n-nodes-base.googleCalendar - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - AI Agent
@n8n/n8n-nodes-langchain.agent - Error Trigger
n8n-nodes-base.errorTrigger
From the author
📊 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…