{"product_id":"n8n-travel-sale-alert-automation-rss-to-x-with-openai-google-sheets","title":"n8n Travel Sale Alert Automation: RSS to X with OpenAI \u0026 Google Sheets","description":"\u003ch3\u003eTurn Tabiris travel sales into fresh daily X posts—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans the \u003cstrong\u003eTabiris RSS\u003c\/strong\u003e every morning at \u003cstrong\u003e7:30 (JST)\u003c\/strong\u003e, filters relevant travel sale items, avoids duplicates via \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to write original Japanese X copy, and publishes up to \u003cstrong\u003etwo\u003c\/strong\u003e posts to \u003cstrong\u003eX (Twitter)\u003c\/strong\u003e—with logging for traceability.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled run\u003c\/strong\u003e: Executes daily at 7:30 (JST).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads posted history\u003c\/strong\u003e: Loads the existing “posted” log from Google Sheets (guid, title, postedAt).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches Tabiris RSS\u003c\/strong\u003e: Retrieves the latest entries from the Tabiris feed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSmart filtering\u003c\/strong\u003e: Keeps items in the \u003cstrong\u003e「セール情報」\u003c\/strong\u003e category, or items in \u003cstrong\u003e「新規就航」\u003c\/strong\u003e\/\u003cstrong\u003e「格安旅行」\u003c\/strong\u003e whose title contains a price pattern like \u003cstrong\u003e「xxx円」\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDuplicate prevention\u003c\/strong\u003e: Removes already-posted items by comparing RSS \u003cstrong\u003eguid\/link\u003c\/strong\u003e and \u003cstrong\u003enormalized titles\u003c\/strong\u003e against the Google Sheets log.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLink enrichment\u003c\/strong\u003e: Detects the airline\/OTA mentioned and attaches a matching official website URL (or falls back to the article link).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates up to two posts\u003c\/strong\u003e: Limits output to the first two remaining items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI-generated X copy\u003c\/strong\u003e: Uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to generate a short, non-copy-pasted Japanese X comment from the article title and summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes \u0026amp; logs\u003c\/strong\u003e: Posts to \u003cstrong\u003eX\u003c\/strong\u003e and appends guid\/title\/timestamp to Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate daily \u003cstrong\u003etravel deal promotion\u003c\/strong\u003e without manual browsing\u003c\/li\u003e\n  \u003cli\u003eRun a lightweight \u003cstrong\u003eflight\/OTA sale alert\u003c\/strong\u003e account with deduped posting\u003c\/li\u003e\n  \u003cli\u003eGive SaaS operators a working example of \u003cstrong\u003eRSS → OpenAI → X\u003c\/strong\u003e publishing with audit logging\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e (daily at 7:30 JST)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRSS Feed Read\u003c\/strong\u003e (Tabiris)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e (filtering, normalization, duplicate checks, link selection, tweet assembly)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2; spreadsheet ID + sheet gid; posted log)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e (API credential; model: \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTwitter \/ X\u003c\/strong\u003e (OAuth2; publish tweets)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSticky Note\u003c\/strong\u003e (workflow documentation)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46154061775027,"sku":"N8N-20065","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/nKPiJpaZOqr4SKNbeWPO1_3JSXZia6.png?v=1790933216","url":"https:\/\/buyflowscripts.com\/products\/n8n-travel-sale-alert-automation-rss-to-x-with-openai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}