Join my free AI automation community + free templates ⤵️
https://www.skool.com/automation-hub-...
Need custom software? Work with me ⤵️
https://www.cyanstack.com/
Summary ⤵️
Learn how I built a fully automated AI outreach system using n8n + GPT + Google Sheets + Gmail — no coding required. In this hands-on tutorial, I’ll show you how to build a workflow that reads a list of businesses from a Google Sheet, generates a personalized email for each one using Open AI GPT-5, and sends those emails automatically through Gmail.
This is perfect for:
• Cold outreach
• Launch announcements
• Following up with leads
• Partnership requests
The best part? It’s all free to replicate — I’ll walk you through every step, and you can download the template below.
🛠️ Tools Used ⤵️
• n8n (workflow builder)
• Google Sheets (store leads)
• OpenAI GPT (generate custom emails)
• Gmail (send messages)
Download the full workflow inside the community ⤵️
https://www.skool.com/automation-hub-...
🕛 Timestamps:
00:00 Intro – What we’re building
00:26 Workflow overview (Sheets → GPT → Gmail)
01:35 Tools + setup
02:11 Create the n8n workflow
02:55 Connect Google Sheets
03:50 Enable Sheets API & create credentials
05:41 Authenticate Google Sheets in n8n
06:19 Set up the AI email agent (GPT-5)
07:30 Open AI credentials
08:58 Add user message and system message
12:20 Email generation demo
13:30 Connect to Gmail + send message
15:30 Fix agent sign-off and remove attribution
16:20 Generate subject with AI + Structure Output
18:40 Test full flow with 3 example leads
20:06 Final result — perfect emails, fully automated
20:22 How to download the free template
Thanks for watching! I hope this helped