Automated hospital outreach system: Send personalized emails via Google Sheets & Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 8 nodes and runs when a chat message arrives. Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When a chat message arrives.
- Hospital Parser (Code): runs custom JavaScript code
- Batch Sender (Loop Over Items (Split in Batches)): loops over the items in batches
- Region Switcher (Switch): routes items into 3 branches
- LUZON FILES (Google Sheets): uses Google Sheets
- VISAYAS FILES (Google Sheets): uses Google Sheets
- MINDANAO (Google Sheets): uses Google Sheets
- Send Gmail Message (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 (6)
- Google Sheets
n8n-nodes-base.googleSheets - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Switch
n8n-nodes-base.switch - Gmail
n8n-nodes-base.gmail
From the author
Description: This workflow automates personalized email outreach to a list of hospitals. It uses a chat-based interface to accept a region and a list of hospital names, looks up their specific contact details from a structured Google Sheet, and sends a…