Jobs newsletter automation system (N8N, Bolt.new, RapidAPI, Mails.so & ChatGPT)

by Joseph ✓ · 2,242 views · created 2025-05-28 · Social Media, Multimodal AI

What this workflow does

This AI workflow has 36 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Sheets, OpenAI and Gmail. It also calls jobs-search-api.p.rapidapi.com over HTTP.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).

1. Get All Subscribers (Google Sheets): uses Google Sheets
2. get rows in all subscribers sheet (Google Sheets): uses Google Sheets
3. Get Subscribers (Google Sheets): uses Google Sheets
4. If: checks a condition and branches into true / false
5. change status to unsubscribed (Google Sheets): update
6. If: checks a condition and branches into true / false
7. Send Email: sends an email over SMTP
8. Confirm Email Validity (HTTP Request): calls an HTTP API
9. add to unsubscribed sheet (Google Sheets): append
10. Get Jobs (HTTP Request): calls jobs-search-api.p.rapidapi.com (POST)

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

Services it uses

Google SheetsOpenAIGmail

HTTP calls to: jobs-search-api.p.rapidapi.com

Before you upgrade to n8n 3.0

Nodes used (14)

• Webhookn8n-nodes-base.webhook
• HTTP Requestn8n-nodes-base.httpRequest
• Send Emailn8n-nodes-base.emailSend
• Ifn8n-nodes-base.if
• Mergen8n-nodes-base.merge
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Split Outn8n-nodes-base.splitOut
• Aggregaten8n-nodes-base.aggregate
• Google Sheetsn8n-nodes-base.googleSheets
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Coden8n-nodes-base.code
• Respond to Webhookn8n-nodes-base.respondToWebhook
• Gmailn8n-nodes-base.gmail
• Stop and Errorn8n-nodes-base.stopAndError

From the author

Watch on Youtube▶️ Welcome to this complete step-by-step guide on how to build your own newsletter automation system using n8n, Bolt.new, and RapidAPI. Whether you're a solo founder, indie hacker, or community builder, this setup will allow you to collect…

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