{"product_id":"monthly-missing-docs-reminder-google-drive-chatwork-n8n","title":"Monthly Missing Docs Reminder (Google Drive + Chatwork) | n8n","description":"\u003ch3\u003eNever miss a required document again—automatically\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eMonthly Missing Docs Reminder (Google Drive + Chatwork) | n8n\u003c\/strong\u003e workflow checks each client’s previous-month Google Drive folder for missing required subfolders, then sends a \u003cstrong\u003eChatwork\u003c\/strong\u003e reminder listing what’s empty—while updating a \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tracker to prevent duplicate alerts.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation runs on a schedule at \u003cstrong\u003e12:00 on the 10th day of every month\u003c\/strong\u003e. It:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003eCalculates the \u003cstrong\u003eprevious month’s folder prefix\u003c\/strong\u003e in \u003cstrong\u003eReiwa format\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eLoads the client list from the Google Sheets sheet named \u003cstrong\u003e“clients”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSkips clients when their \u003cstrong\u003elast_reminder\u003c\/strong\u003e value equals today’s date (YYYY-MM-DD), avoiding duplicate reminders.\u003c\/li\u003e\n  \u003cli\u003eFor each remaining client, searches Google Drive for the \u003cstrong\u003eprevious-month folder\u003c\/strong\u003e under the client’s parent folder and retrieves its subfolders.\u003c\/li\u003e\n  \u003cli\u003eFilters subfolders against the client’s comma-separated \u003cstrong\u003erequired_folders\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses the \u003cstrong\u003eGoogle Drive API\u003c\/strong\u003e to verify each required subfolder contains at least one \u003cstrong\u003enon-folder file\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSends a \u003cstrong\u003eChatwork reminder\u003c\/strong\u003e with the missing categories and updates \u003cstrong\u003elast_reminder\u003c\/strong\u003e in Google Sheets to today.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operations teams need monthly document collection reminders for each client.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers want a reliable workflow that audits Google Drive content and notifies via Chatwork.\u003c\/li\u003e\n  \u003cli\u003eSmall teams centralize required files in Google Drive and want zero-manual follow-up.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (n8n)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSchedule trigger: runs monthly (10th day at 12:00).\u003c\/li\u003e\n  \u003cli\u003eNodes\/blocks: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eOAuth2 for \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e access.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eIdeal for:\u003c\/strong\u003e n8n users, automation engineers, and SaaS operators who need a dependable \u003cstrong\u003eGoogle Drive document audit\u003c\/strong\u003e with \u003cstrong\u003eChatwork notifications\u003c\/strong\u003e.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46153944432819,"sku":"N8N-20320","price":61.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/uPNqdmkneqgHPHcujcBic_cjrUMXpm.png?v=1790931869","url":"https:\/\/buyflowscripts.com\/products\/monthly-missing-docs-reminder-google-drive-chatwork-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}