Answer new website leads from a webhook with OpenAI, Gmail, Slack and Sheets
Ready for 3.0What this workflow does
This AI workflow has 10 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI, Gmail, Slack and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Settings (Edit Fields (Set)): sets 6 fields: sheetId, businessName, services…
- Understand and draft the reply (OpenAI): uses OpenAI
- Send the reply (Gmail): uses Gmail
- Tell the team in Slack (Slack): uses Slack
- Save the lead (Google Sheets): append
- Wait: waits 2 days
- Look up the lead again (Google Sheets): uses Google Sheets
- Still marked New? (If): checks a condition and branches into true / false
- Send one follow up (Gmail): uses Gmail
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 (8)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - OpenAI
@n8n/n8n-nodes-langchain.openAi - Gmail
n8n-nodes-base.gmail - Slack
n8n-nodes-base.slack - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if
From the author
Quick Overview This workflow receives new website leads via a webhook, uses OpenAI to classify urgency and draft an email reply, sends the reply with Gmail, notifies your team in Slack, logs the lead in Google Sheets, and sends a single follow-up email after…