{"product_id":"audit-forgotten-gmail-accounts-with-ai-google-sheets","title":"Audit Forgotten Gmail Accounts with AI \u0026 Google Sheets","description":"\u003ch3\u003eAudit forgotten Gmail account emails with AI—then keep a deduplicated register in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your Gmail for account-related messages, uses an AI model via \u003cstrong\u003eOpenRouter\u003c\/strong\u003e to extract service details and risk signals, and maintains a clean, deduplicated \u003cstrong\u003eAccount Register\u003c\/strong\u003e in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e. It can also label messages to prevent reprocessing and send you a weekly digest for review.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRun modes:\u003c\/strong\u003e execute manually, daily, or weekly—switching between \u003cem\u003ediscovery\u003c\/em\u003e (finding signals) and \u003cem\u003edigest\u003c\/em\u003e (reviewing results).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDiscovery:\u003c\/strong\u003e searches Gmail using a configurable query for account-related signals, then fetches the full content of each matching message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI extraction:\u003c\/strong\u003e cleans and filters candidates, then sends each email to an AI model through \u003cstrong\u003eOpenRouter\u003c\/strong\u003e to extract structured fields such as service, domain, category, evidence, billing and sensitivity signals, and confidence.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalization \u0026amp; scoring:\u003c\/strong\u003e normalizes the AI output, computes an account key and a risk score, and labels the assessed Gmail message to avoid processing it again.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets upsert:\u003c\/strong\u003e if the message contains an account signal, it upserts a single source-linked row per account into the “\u003cstrong\u003eAccount Register\u003c\/strong\u003e”, preserving any human-set fields like \u003cstrong\u003eStatus\u003c\/strong\u003e and \u003cstrong\u003eDesired Action\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReview alerts:\u003c\/strong\u003e sends a Gmail review notice when marked “\u003cstrong\u003eNeeds review\u003c\/strong\u003e” due to low confidence, missing service identification, or parsing issues.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDigest mode:\u003c\/strong\u003e reads the Google Sheets register, prioritizes records needing decisions, and emails a weekly digest with evidence links and optional copy-ready data rights drafts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIdentify old sign-up, billing, and account-change emails you may have forgotten.\u003c\/li\u003e\n  \u003cli\u003eBuild a centralized account inventory for SaaS operators to manage risk and actions.\u003c\/li\u003e\n  \u003cli\u003eDetect low-confidence or ambiguous cases and route them to a human review loop.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail integration:\u003c\/strong\u003e Gmail OAuth for reading messages, labeling assessed emails, and sending review notices\/digests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI via OpenRouter:\u003c\/strong\u003e \u003cem\u003ehttp request\u003c\/em\u003e calls to extract structured account details and risk signals.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData handling:\u003c\/strong\u003e nodes include \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStorage:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e “Account Register” with deduplication via computed account keys.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45741413793971,"sku":"N8N-17608","price":52.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/b9iubJwRGQqwg8TtLlCRr_Yp4Bo5fI.png?v=1785315992","url":"https:\/\/buyflowscripts.com\/products\/audit-forgotten-gmail-accounts-with-ai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}