Automate New Website Leads: OpenAI + Gmail + Slack + Sheets

Turn new website leads into instant replies—automated with OpenAI, Gmail, Slack, and Google Sheets

This n8n workflow automatically receives new website leads via a webhook, uses OpenAI to classify urgency and draft a tailored email, sends the reply with Gmail, alerts your team in Slack, logs everything to Google Sheets, and sends exactly one follow-up email two days later if the lead is still marked New.

What this workflow does

• Receives lead submissions via a POST webhook from your website form (name, email, phone, message).
• Uses OpenAI for triage: sends the lead details plus your business settings to OpenAI to label the request type and urgency, then generates a reply subject/body and follow-up text.
• Sends the initial email to the lead using Gmail.
• Notifies your team in Slack with lead details, detected urgency/type, and confirmation that the initial reply was sent.
• Logs to Google Sheets by appending the lead to the “Leads” tab with Status = New.
• Waits two days, checks the lead by email, and only if Status is still New sends one follow-up email.

Use cases

• SaaS lead capture: auto-respond to inbound requests the moment a user submits your contact form.
• Agency or consultancy intake: classify urgency/type and notify your sales team in Slack while keeping a spreadsheet log.
• Automation engineers: a practical template combining Webhook → OpenAI → Gmail → Slack → Sheets with a controlled follow-up.

Technical details

• Core nodes/tools: webhook, if, set, wait, gmail, slack.
• OpenAI is used to generate: request type, urgency, reply subject/body, and follow-up text.
• Google Sheets requirement: create a tab named Leads with columns: Date, Name, Email, Phone, Message, Type, Urgency, Status.
• Follow-up logic: sends one email after two days only when the lead remains Status = New.