Recover Unclaimed Gmail Credits with n8n + OpenAI + Google Sheets

Recover potential Gmail “credits” faster with n8n + OpenAI + Google Sheets

This n8n workflow scans your selected Gmail messages for potential gift cards, refunds, vouchers, cashback, rebates, travel credits, and reward points—then uses OpenAI-compatible chat completions (OpenRouter) 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.

What this workflow does

• Daily discovery: Runs on a schedule (or manually) to search Gmail using a configurable query for messages likely to contain value-related offers.
• Redacts sensitive strings: Pulls each matching email and removes code/token-like content before sending it to the AI.
• AI classification & extraction: Sends the redacted text to OpenRouter (OpenAI-compatible chat completions) to determine whether the email contains potential value and to extract merchant, value type, possible amount/points, expiry, confidence, and an evidence summary.
• Avoids reprocessing: Applies a configured Gmail label and filters results to records that indicate potential value.
• Upserts to Google Sheets: 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.
• Review loop: Emails a review notice via Gmail when confidence is low or extraction is incomplete and the item is marked “Needs review.”
• Weekly digest: Runs weekly to read the Sheets register and prioritize items that are expiring soon (and still outstanding).

Use cases

• Find missed store vouchers, refunds, or travel credits buried in Gmail.
• For SaaS ops/automation engineers: maintain a lightweight “credits registry” with evidence and confidence scoring.
• Reduce manual inbox review by turning relevant emails into structured rows in Google Sheets.

Technical details

• n8n nodes used: if, set, code, gmail, sticky note, http request
• AI integration: OpenRouter (OpenAI-compatible chat completions)
• Data storage: Google Sheets “Value Register” with message/thread-keyed upserts