Send monthly missing document reminders with Google Drive, Sheets, and Chatwork
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 14 nodes and runs on a schedule (every month at 12:00). Along the way it connects Google Sheets, Google Drive and Chatwork (community). It also calls googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every month at 12:00).
- Compute Last Month (Code): runs custom JavaScript code
- Read Client List from Sheets (Google Sheets): uses Google Sheets
- Identify New Clients to Remind (If): checks a condition and branches into true / false
- Batch Process Clients (Loop Over Items (Split in Batches)): loops over the items in batches
- Locate Monthly Client Folder (Google Drive): work with file folder
- Retrieve Client Subfolders (Google Drive): work with file folder
- Select Client Folders (Code): runs custom JavaScript code
- Verify Files on Google Drive (HTTP Request): calls googleapis.com
- Assess Folder Submission (Code): runs custom JavaScript code
- Compile Missing Documents (Code): runs custom JavaScript code
…plus 3 more steps. See the full node list below.
Services it uses
HTTP calls to: googleapis.com
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-chatwork is verified or supports 3.0 (used in Dispatch Chatwork Reminder).
Nodes used (8)
- Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Google Drive
n8n-nodes-base.googleDrive - HTTP Request
n8n-nodes-base.httpRequest - Chatwork
n8n-nodes-chatwork.chatwork
From the author
Quick overview This workflow runs monthly to check each client’s previous-month folder in Google Drive for missing required documents, sends a Chatwork reminder listing missing categories, and updates a Google Sheets tracker to avoid duplicate reminders. How…