{"product_id":"recover-unclaimed-gmail-credits-with-n8n-openai-google-sheets","title":"Recover Unclaimed Gmail Credits with n8n + OpenAI + Google Sheets","description":"\u003ch3\u003eRecover potential Gmail “credits” faster with n8n + OpenAI + Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans your selected \u003cstrong\u003eGmail\u003c\/strong\u003e messages for potential gift cards, refunds, vouchers, cashback, rebates, travel credits, and reward points—then uses \u003cstrong\u003eOpenAI-compatible chat completions (OpenRouter)\u003c\/strong\u003e to extract structured value signals and records them in a Google Sheets “Value Register.” Low-confidence items can be flagged for review and emailed to you.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily discovery\u003c\/strong\u003e: Runs on a schedule (or manually) to search Gmail using a configurable query for messages likely to contain value-related offers.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRedacts sensitive strings\u003c\/strong\u003e: Pulls each matching email and removes code\/token-like content before sending it to the AI.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI classification \u0026amp; extraction\u003c\/strong\u003e: Sends the redacted text to \u003cstrong\u003eOpenRouter (OpenAI-compatible chat completions)\u003c\/strong\u003e to determine whether the email contains potential value and to extract merchant, value type, possible amount\/points, expiry, confidence, and an evidence summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAvoids reprocessing\u003c\/strong\u003e: Applies a configured Gmail label and filters results to records that indicate potential value.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts to Google Sheets\u003c\/strong\u003e: Writes a minimal, source-linked row into the “Value Register” tab keyed by message\/thread, preserving any human-set status, desired action, and redeemed fields if the record already exists.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReview loop\u003c\/strong\u003e: Emails a review notice via Gmail when confidence is low or extraction is incomplete and the item is marked \u003cem\u003e“Needs review.”\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly digest\u003c\/strong\u003e: Runs weekly to read the Sheets register and prioritize items that are expiring soon (and still outstanding).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFind missed \u003cstrong\u003estore vouchers\u003c\/strong\u003e, \u003cstrong\u003erefunds\u003c\/strong\u003e, or \u003cstrong\u003etravel credits\u003c\/strong\u003e buried in Gmail.\u003c\/li\u003e\n  \u003cli\u003eFor SaaS ops\/automation engineers: maintain a lightweight “credits registry” with evidence and confidence scoring.\u003c\/li\u003e\n  \u003cli\u003eReduce manual inbox review by turning relevant emails into structured rows in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used\u003c\/strong\u003e: if, set, code, gmail, sticky note, http request\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI integration\u003c\/strong\u003e: OpenRouter (OpenAI-compatible chat completions)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage\u003c\/strong\u003e: Google Sheets “Value Register” with message\/thread-keyed upserts\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45726238834867,"sku":"N8N-17471","price":48.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/YQRg5tWzUXg0gcYZbT3iF_aeIsEQ87.png?v=1785056869","url":"https:\/\/buyflowscripts.com\/products\/recover-unclaimed-gmail-credits-with-n8n-openai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}