n8n Travel Sale Alert Automation: RSS to X with OpenAI & Google Sheets

Turn Tabiris travel sales into fresh daily X posts—automatically

This n8n workflow scans the Tabiris RSS every morning at 7:30 (JST), filters relevant travel sale items, avoids duplicates via Google Sheets, uses OpenAI (gpt-4o-mini) to write original Japanese X copy, and publishes up to two posts to X (Twitter)—with logging for traceability.

What this workflow does

• Scheduled run: Executes daily at 7:30 (JST).
• Reads posted history: Loads the existing “posted” log from Google Sheets (guid, title, postedAt).
• Fetches Tabiris RSS: Retrieves the latest entries from the Tabiris feed.
• Smart filtering: Keeps items in the 「セール情報」 category, or items in 「新規就航」/「格安旅行」 whose title contains a price pattern like 「xxx円」.
• Duplicate prevention: Removes already-posted items by comparing RSS guid/link and normalized titles against the Google Sheets log.
• Link enrichment: Detects the airline/OTA mentioned and attaches a matching official website URL (or falls back to the article link).
• Creates up to two posts: Limits output to the first two remaining items.
• AI-generated X copy: Uses OpenAI (gpt-4o-mini) to generate a short, non-copy-pasted Japanese X comment from the article title and summary.
• Publishes & logs: Posts to X and appends guid/title/timestamp to Google Sheets.

Use cases

• Automate daily travel deal promotion without manual browsing
• Run a lightweight flight/OTA sale alert account with deduped posting
• Give SaaS operators a working example of RSS → OpenAI → X publishing with audit logging

Technical details

• Schedule Trigger (daily at 7:30 JST)
• RSS Feed Read (Tabiris)
• Code (filtering, normalization, duplicate checks, link selection, tweet assembly)
• Google Sheets (OAuth2; spreadsheet ID + sheet gid; posted log)
• OpenAI (API credential; model: gpt-4o-mini)
• Twitter / X (OAuth2; publish tweets)
• Sticky Note (workflow documentation)