{"product_id":"n8n-rss-reader-japanese-business-tech-summaries-with-gemini-google-sheets","title":"n8n RSS Reader: Japanese Business \u0026 Tech Summaries with Gemini + Google Sheets","description":"\u003ch3\u003eGet Japanese business \u0026amp; tech summaries from RSS—automatically—every 15 minutes\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically reads seven RSS sources, deduplicates and tracks articles in Google Sheets, and uses the Google Gemini API to generate structured Japanese titles and summaries—so your team stays on top of new updates without manual copy\/paste.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns every 15 minutes\u003c\/b\u003e to load workflow settings and pull existing article history from Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFetches from seven configured RSS feeds\u003c\/b\u003e, and if a direct feed fails, it falls back to a \u003cb\u003eGoogle News RSS query\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCleans, normalizes, and deduplicates\u003c\/b\u003e incoming items against the stored records in the \u003cb\u003eArticles\u003c\/b\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWrites results back to Google Sheets\u003c\/b\u003e:\n    \u003cul\u003e\n      \u003cli\u003eNew\/updated article rows in the \u003cb\u003eArticles\u003c\/b\u003e tab\u003c\/li\u003e\n      \u003cli\u003ePer-source feed health status entries in the \u003cb\u003eFeedStatus\u003c\/b\u003e tab\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eBatches pending items\u003c\/b\u003e (up to a configured limit) and sends their RSS titles\/excerpts to \u003cb\u003eGoogle Gemini\u003c\/b\u003e to generate \u003cb\u003eJapanese\u003c\/b\u003e titles and summaries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eValidates Gemini’s JSON response\u003c\/b\u003e, marks failures for retry, and updates each Google Sheets row with the Japanese title, summary, status, and timestamp.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eSaaS operators\u003c\/b\u003e who want an always-current feed of business and tech updates in Japanese.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAutomation engineers\u003c\/b\u003e using n8n to build a reliable “RSS → Sheets → LLM summaries” pipeline.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eTeams monitoring markets\/technology\u003c\/b\u003e who need deduplication, feed health tracking, and structured summaries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eScheduling:\u003c\/b\u003e runs every 15 minutes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e \u003cb\u003eGoogle Sheets\u003c\/b\u003e (OAuth) and \u003cb\u003eGoogle Gemini (PaLM)\u003c\/b\u003e via \u003ci\u003egenerateContent\u003c\/i\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWorkflow nodes\/logic:\u003c\/b\u003e \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003esplit out\u003c\/b\u003e, plus \u003cb\u003ehttp request\u003c\/b\u003e for RSS retrieval and Gemini requests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOutputs:\u003c\/b\u003e updates the \u003cb\u003eArticles\u003c\/b\u003e and \u003cb\u003eFeedStatus\u003c\/b\u003e tabs using configured spreadsheet ID and tab names.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146278981811,"sku":"N8N-20260","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/FlzYO5S0eIRsbiZVEAzNs_x7CDtukd.png?v=1790845702","url":"https:\/\/buyflowscripts.com\/products\/n8n-rss-reader-japanese-business-tech-summaries-with-gemini-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}