n8n Monthly Volunteer Hour Statements via Google Sheets + Gmail

Automatically generate and email monthly volunteer hour statements from Google Sheets using n8n

This n8n workflow reads your verified volunteer-hours ledger in Google Sheets, 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 Gmail—all while logging each period to prevent duplicate sends.

What this workflow does

• Runs on a monthly schedule and automatically computes the previous calendar month’s start/end dates and a unique period key.
• Checks an n8n Data Table named “Volunteer Statements Issued Log” for the current period; if statements were already issued, the workflow stops.
• Loads valuation and policy settings from the “Volunteer Statement Config” n8n Data Table (e.g., hourly in-kind rate, milestone thresholds, and a zero-hour policy).
• Reads volunteer entries from your Google Sheets ledger, groups them by volunteer, and computes:
  • Monthly hours and year-to-date hours
  • Milestone progress
  • In-kind value summary
  • An HTML statement per volunteer
• Sends volunteer emails one at a time using Gmail; it continues even if an individual send fails.
• Sends a coordinator program summary (totals, in-kind value, milestones, and send status) and then appends the period record to the issued-log Data Table.

Use cases

• Volunteer-based nonprofits needing consistent, auditable monthly statements without manual spreadsheet work.
• SaaS operators using n8n to automate in-kind valuation reporting and distribute documents at scale.
• Coordinators who want milestone tracking and a single emailed overview alongside individual volunteer communications.

Technical details

• Integrations: Google Sheets (OAuth2) and Gmail (OAuth2)
• n8n components/nodes: if, set, code, gmail, data table, sticky note
• Data storage: n8n Data Tables “Volunteer Statement Config” and “Volunteer Statements Issued Log” to manage settings and prevent duplicate sends

Setup (high level)

• Provide Google Sheets OAuth2 credentials and configure the ledger spreadsheet ID and tab name.
• Provide Gmail OAuth2 credentials for the sending account.
• Create and populate the n8n Data Tables “Volunteer Statement Config” (and “Volunteer Statements Issued Log”).