{"product_id":"n8n-monthly-volunteer-hour-statements-via-google-sheets-gmail","title":"n8n Monthly Volunteer Hour Statements via Google Sheets + Gmail","description":"\u003ch3\u003eAutomatically generate and email monthly volunteer hour statements from Google Sheets using n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your verified volunteer-hours ledger in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, calculates per-volunteer monthly and year-to-date totals (including in-kind valuation), and emails an individualized HTML statement to each volunteer plus a coordinator summary via \u003cstrong\u003eGmail\u003c\/strong\u003e—all while logging each period to prevent duplicate sends.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a monthly schedule\u003c\/strong\u003e and automatically computes the previous calendar month’s start\/end dates and a unique \u003cstrong\u003eperiod key\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks an n8n Data Table\u003c\/strong\u003e named \u003cstrong\u003e“Volunteer Statements Issued Log”\u003c\/strong\u003e for the current period; if statements were already issued, the workflow stops.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads valuation and policy settings\u003c\/strong\u003e from the \u003cstrong\u003e“Volunteer Statement Config”\u003c\/strong\u003e n8n Data Table (e.g., hourly in-kind rate, milestone thresholds, and a zero-hour policy).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads volunteer entries\u003c\/strong\u003e from your Google Sheets ledger, groups them by volunteer, and computes:\n    \u003cul\u003e\n      \u003cli\u003eMonthly hours and \u003cstrong\u003eyear-to-date hours\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eMilestone progress\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eIn-kind value\u003c\/strong\u003e summary\u003c\/li\u003e\n      \u003cli\u003eAn \u003cstrong\u003eHTML statement\u003c\/strong\u003e per volunteer\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends volunteer emails one at a time\u003c\/strong\u003e using Gmail; it continues even if an individual send fails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a coordinator program summary\u003c\/strong\u003e (totals, in-kind value, milestones, and send status) and then \u003cstrong\u003eappends the period record\u003c\/strong\u003e to the issued-log Data Table.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eVolunteer-based nonprofits needing consistent, auditable \u003cstrong\u003emonthly statements\u003c\/strong\u003e without manual spreadsheet work.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators using n8n to automate \u003cstrong\u003ein-kind valuation\u003c\/strong\u003e reporting and distribute documents at scale.\u003c\/li\u003e\n  \u003cli\u003eCoordinators who want milestone tracking and a single emailed overview alongside individual volunteer communications.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (OAuth2) and Gmail (OAuth2)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n components\/nodes:\u003c\/strong\u003e if, set, code, gmail, data table, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage:\u003c\/strong\u003e n8n Data Tables “Volunteer Statement Config” and “Volunteer Statements Issued Log” to manage settings and prevent duplicate sends\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup (high level)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProvide Google Sheets OAuth2 credentials and configure the \u003cstrong\u003eledger spreadsheet ID\u003c\/strong\u003e and \u003cstrong\u003etab name\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eProvide Gmail OAuth2 credentials for the sending account.\u003c\/li\u003e\n  \u003cli\u003eCreate and populate the n8n Data Tables \u003cstrong\u003e“Volunteer Statement Config”\u003c\/strong\u003e (and “Volunteer Statements Issued Log”).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45814429614259,"sku":"N8N-17986","price":53.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/8OtQzWYbwvwNWKeJkKrwi_9SpJZnLX.png?v=1786439868","url":"https:\/\/buyflowscripts.com\/products\/n8n-monthly-volunteer-hour-statements-via-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}