{"product_id":"n8n-workflow-find-missing-client-assets-with-google-sheets-gmail","title":"n8n Workflow: Find Missing Client Assets with Google Sheets \u0026 Gmail","description":"\u003ch3\u003eAutomatically find missing client assets and draft internal Gmail reminders—powered by n8n, Google Sheets, and Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow compares a Google Sheets client checklist against a staff-only Google Drive folder to identify missing files, pending human approvals, and readiness blockers—then drafts internal Gmail reminders and produces an internal readiness digest. It includes a credential-free demo and requires no AI API.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRun with fictional demo data\u003c\/b\u003e: Execute the workflow using default demo settings to generate a report without connecting any accounts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLive mode checklist validation\u003c\/b\u003e: After configuration, the workflow reads the \u003cb\u003eRequirements\u003c\/b\u003e and \u003cb\u003eHistory\u003c\/b\u003e tabs and checks the intake folder for direct files.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eMatch assets by naming pattern\u003c\/b\u003e: Each asset is matched using the filename pattern \u003ccode\u003eproject_id__requirement_id__description.ext\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eStop on invalid or incomplete listings\u003c\/b\u003e: Invalid checklist rows block client drafts; incomplete listings stop the run until staff attention resolves the issue.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCapture human approval status\u003c\/b\u003e: A human records approval against the file ID and version. If a file changes, it must be reviewed again.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCreate eligible Gmail reminders\u003c\/b\u003e: When actions are enabled, the workflow groups reminders by \u003cb\u003eclient email\u003c\/b\u003e, creates eligible drafts, and sends an internal digest.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReduce duplicates\u003c\/b\u003e: Existing generated drafts, a draft-creation cooldown, and daily digest receipts help prevent repeated reminders.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRecord outcomes\u003c\/b\u003e: After each Gmail acknowledgement, the workflow appends a \u003cb\u003eHistory receipt\u003c\/b\u003e. Client emails remain as unsent drafts for staff to review and send.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAgencies tracking onboarding or deliverables who need a reliable “missing assets” report.\u003c\/li\u003e\n  \u003cli\u003eOperations teams who want reminders only for items that are truly missing, ambiguous, or pending review.\u003c\/li\u003e\n  \u003cli\u003eTeams that maintain client readiness reporting across projects with staff-only approvals.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations\/nodes\u003c\/b\u003e: \u003ccode\u003egmail\u003c\/code\u003e (draft IDs and acknowledgements), plus Google Sheets\/Drive via the workflow logic.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eControl flow\u003c\/b\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, and supporting notes (\u003ccode\u003esticky note\u003c\/code\u003e), including \u003ccode\u003ehttp request\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOutputs\u003c\/b\u003e: Missing assets, requested corrections, pending reviews, and project readiness status + internal digest receipts.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46058949247155,"sku":"N8N-19687","price":25.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/t_iKgwVbA6s2YZyXfcl6Y_UJBuCkg6.png?v=1789722588","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-find-missing-client-assets-with-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}