{"product_id":"n8n-volunteer-shift-signups-google-sheets-gmail-emails","title":"n8n Volunteer Shift Signups: Google Sheets + Gmail Emails","description":"\u003ch3\u003eAutomate volunteer shift signups end-to-end with n8n (Google Sheets + Gmail)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically captures volunteer shift signups from an n8n Form, checks availability in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends the right \u003cstrong\u003econfirmation or waitlist email\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e—while keeping coordinators informed in \u003cstrong\u003eTelegram\u003c\/strong\u003e. It also runs scheduled reminders and weekly digests.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects signup data\u003c\/strong\u003e via an n8n Form and normalizes fields such as name, email, shift ID, experience, and notes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required fields\u003c\/strong\u003e. If anything is missing, it alerts the coordinator in Telegram and sends a review email through Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks shift status in Google Sheets\u003c\/strong\u003e to determine whether the requested shift exists and has remaining capacity.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles unknown shift IDs\u003c\/strong\u003e by notifying the coordinator in Telegram and sending coordinator details via Gmail (including the skipped signup data).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfirmation path (capacity available)\u003c\/strong\u003e: uses OpenAI (DeepSeek) to generate a confirmation email, logs the signup in Google Sheets, emails the volunteer via Gmail, and sends a Telegram alert.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWaitlist path (shift full)\u003c\/strong\u003e: uses OpenAI (DeepSeek) to generate a waitlist email, logs the waitlisted signup in Google Sheets, emails the volunteer via Gmail, and sends a Telegram alert.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSCHEDULED ops\u003c\/strong\u003e: reads confirmed signups from Google Sheets to email reminders for shifts happening today\/tomorrow, posts a Telegram recap, and compiles weekly statistics + an AI-written digest sent via Gmail and Telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eVolunteer-driven events that require fast signup confirmation and accurate capacity tracking.\u003c\/li\u003e\n  \u003cli\u003eTeams that want coordinators to receive real-time Telegram alerts for missing fields or invalid shift IDs.\u003c\/li\u003e\n  \u003cli\u003eOrganizations that need automated daily reminders and weekly reporting without manual spreadsheet work.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Form intake\u003c\/strong\u003e + normalization (name, email, shift ID, experience, notes)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e lookup and logging of confirmed and waitlisted signups\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e for volunteer\/coordinator emails and scheduled reminders\/digests\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e notifications for coordinator alerts, recaps, and weekly updates\u003c\/li\u003e\n  \u003cli\u003eLogic via \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, and \u003cstrong\u003ecode\u003c\/strong\u003e nodes; email templating\/text generation via \u003cstrong\u003eOpenAI (DeepSeek)\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45877626994867,"sku":"N8N-18551","price":72.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/F3tZtv72st4tzc32puY7c_7KQfN001.png?v=1787337409","url":"https:\/\/buyflowscripts.com\/products\/n8n-volunteer-shift-signups-google-sheets-gmail-emails","provider":"N8N Commerce","version":"1.0","type":"link"}