Quick Overview
Quick Overview This workflow collects volunteer shift signups via an n8n form, checks shift availability in Google Sheets, and uses OpenAI (DeepSeek) to write confirmation or waitlist emails sent through Gmail, while notifying coordinators in Telegram and sending scheduled reminder and digest messages. How it works Receives a volunteer signup through an n8n Form and normalizes the submitted details (name, email, shift ID, experience, and notes). Validates that required fields are present, and if not, alerts the coordinator in Telegram and sends a review email via Gmail. Looks up the requested shift and current signup count in Google Sheets to determine whether the shift exists and has remaining capacity. If the shift is unknown, sends Telegram and Gmail notifications to the coordinator with the skipped signup details. If capacity is available, uses OpenAI (DeepSeek) to generate a confirmation email, appends the signup to the Google Sheets log, emails the volunteer via Gmail, and sends a Telegram alert. If the shift is full, uses OpenAI (DeepSeek) to generate a waitlist email, appends the waitlisted signup to Google Sheets, emails the volunteer via Gmail, and sends a Telegram alert. On a schedule, reads confirmed signups from Google Sheets to email reminders for shifts happening today or tomorrow and posts a Telegram recap, and also compiles weekly stats, generates an AI-written digest, and sends it via Gmail and Telegram. Setup Create or choose a Google Sheets spreadsheet with a Shifts tab (including shift_id, role, date, start_time, end_time, location, description, capacity) and a Signups tab matching the fields the workflow appends. Add a Google Sheets OAuth2 credential and update the spreadsheet ID and sheet names if you are not using the provided document. Add a Gmail OAuth2 credential and replace the coordinator email address used for invalid/unknown shift notices and weekly digests. Add a Telegram bot credential and replace the chat ID used for coordinator alerts and recaps. Add an OpenAI API credential (used with the deepseek-v4-flash chat model) and adjust the prompts or model name if needed. Publish the n8n Form and share its URL with volunteers, and update the schedule triggers (cron expressions) to the times you want reminders and digests to run. An n8n automation workflow template by Khairul Muhtadin.
Khairul Muhtadin
web
free
Others in the same category, ranked by how often they are opened.
