Qualify leads and send personalized outreach with OpenAI, Outlook and Sheets

by FLOW AI Automation ✓ · 65 views · created 2026-09-28 · Lead Generation, AI Summarization

What this workflow does

This workflow has 48 nodes and runs on a schedule (every day at 09:00). Along the way it connects Google Sheets. It also calls graph.microsoft.com and api.openai.com over HTTP.

How it runs

Trigger: On a schedule (every day at 09:00).

1. FLOW AI konfigurieren (Code): runs custom JavaScript code
2. Outlook-Konto prüfen (HTTP Request): calls graph.microsoft.com (GET)
3. Outlook-Absender übernehmen (Code): runs custom JavaScript code
4. Leads aus Google Sheets laden (Google Sheets): read (sheet)
5. Leads bereinigen und Dubletten schützen (Code): runs custom JavaScript code
6. Neuer Lead prüfen (If): checks a condition and branches into true / false
7. Firmenwebsite abrufen (HTTP Request): calls an HTTP API
8. Fälliges Follow-up prüfen (If): checks a condition and branches into true / false
9. Website-Recherche aufbereiten (Code): runs custom JavaScript code
10. Outlook-Unterhaltung laden (HTTP Request): calls graph.microsoft.com (GET)

…plus 37 more steps. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: graph.microsoft.com, api.openai.com

Before you upgrade to n8n 3.0

Nodes used (5)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview This workflow runs daily to read leads from Google Sheets, research company websites, score and qualify them with OpenAI, and draft or send personalized initial and follow-up emails via Gmail while writing statuses, scores, drafts, and send…

View the original on n8n.io → Check your own copy