{"product_id":"gmail-chat-currency-rates-gemini-frankfurter-api-n8n","title":"Gmail \u0026 Chat Currency Rates: Gemini + Frankfurter API n8n","description":"\u003ch3\u003eInstant currency-rate replies from Gmail or chat—powered by Gemini + Frankfurter API (with smart caching)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow listens for exchange-rate questions in \u003cstrong\u003eGmail\u003c\/strong\u003e or an \u003cstrong\u003en8n chat trigger\u003c\/strong\u003e, extracts the currency pair, and replies with the latest reference rate using a \u003cstrong\u003eGoogle Gemini AI agent\u003c\/strong\u003e calling the \u003cstrong\u003eFrankfurter exchange-rate API\u003c\/strong\u003e. To reduce repeated model\/API calls, it caches successful answers in \u003cstrong\u003en8n Data Tables\u003c\/strong\u003e with a configurable TTL.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on new messages\u003c\/strong\u003e: starts when a new Gmail email matches the exchange-rate search filter, or when an n8n chat message is received.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes input\u003c\/strong\u003e: converts incoming email\/chat content into a common format (session ID, user text, source channel, sender email) and processes requests one at a time.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a per-day cache key\u003c\/strong\u003e: extracts two ISO 4217 currency codes from the message and checks an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e for a cached response for that pair\/day.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses cache when fresh\u003c\/strong\u003e: if a valid cached entry exists within the configured TTL, the workflow returns it directly—no new AI call.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches fresh rates with Gemini when needed\u003c\/strong\u003e: if there’s no fresh cache hit, the workflow runs a \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e-powered agent that calls the \u003cstrong\u003eFrankfurter API\u003c\/strong\u003e and generates a short plain-text (one to two sentences) reply.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCaches results + logs metrics\u003c\/strong\u003e: stores valid rate answers back into the cache, then logs query details (source, currency pair, cache hit, latency) to a second Data Table.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAnswering “What’s the EUR to USD rate today?” directly in your support inbox via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eProviding quick currency-rate responses in an \u003cstrong\u003en8n chat\u003c\/strong\u003e interface for operators or customers.\u003c\/li\u003e\n  \u003cli\u003eReducing AI and API usage costs with \u003cstrong\u003eper-day caching\u003c\/strong\u003e of successful responses.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes\u003c\/strong\u003e: Gmail (trigger + replies), Google Gemini (PaLM) API credentials, and \u003cstrong\u003en8n Data Tables\u003c\/strong\u003e for caching + logging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore node types\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eno op\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003edata table\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCredentials required\u003c\/strong\u003e: Gmail OAuth2 and Google Gemini (PaLM) API credentials.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46153960685747,"sku":"N8N-20312","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7rauvH63dFVERltyKzOdz_iShSdFou.png?v=1790932071","url":"https:\/\/buyflowscripts.com\/products\/gmail-chat-currency-rates-gemini-frankfurter-api-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}