AI Agents & Chatbotsfree

Automated Hospital Outreach System: Send Personalized Emails Via Google Sheets & Gmail

by Hans Wilhelm RadamUpdated Aug 2026

Requires

Google Sheets

Gmail

1/5

STEPS · 10

Starts from a chat message

From a chat trigger, reads contacts in Google Sheets and sends personalized, batched Gmail emails to each recipient.

AI Form Response Emailer

On form submission, enriches data via HTTP, generates a reply with an OpenAI agent, and emails it through Gmail.

On a webhook request, runs an OpenAI agent that writes results to Google Sheets and returns a response.

On a form submission, runs an OpenRouter and OpenAI agent that researches YouTube strategy, saves to Google Sheets and notifies Slack.