Daily Travel News to X: n8n, OpenAI & Google Sheets Workflow

Daily Travel News → X (Twitter) with n8n, OpenAI & Google Sheets

Turn Google News travel headlines into fresh, Japan-ready X posts—automatically. This n8n workflow runs every day at 17:30 JST, selects the best recent travel stories, uses OpenAI (gpt-4o-mini) to write a short Japanese comment, posts the top items to X (Twitter), and logs everything to Google Sheets so you never repost the same links.

What this workflow does

• Scheduled automation: Triggers daily at 17:30 (Asia/Tokyo) via an n8n schedule trigger.
• Reads posted history: Pulls the existing “already posted” list from Google Sheets (columns: guid, title, postedAt).
• Fetches travel headlines: Uses a Google News RSS search feed to retrieve travel-related items.
• Filters to the last 12 hours: Keeps only articles published within the last 12 hours, excludes overly business/IR-style headlines, and scores items for travel relevance using keywords such as deals, disruptions, and crowding.
• Prevents duplicates: Compares each article’s GUID/link and a normalized title against Google Sheets history, then selects the top two scored articles.
• Generates X-ready copy: Calls OpenAI (gpt-4o-mini) to create a 1–2 sentence Japanese comment (kept within 150 characters) from the title and snippet.
• Posts and logs: Builds the final post text (including the article link, a blog link, and auto-generated hashtags), posts to X, and appends guid/title/timestamp back to Google Sheets.

Use cases

• Run a travel-focused X account that consistently shares timely updates without manual curation.
• Automate daily “what’s new for travelers” content for SaaS operators, agencies, or community pages.
• Maintain auditability and anti-duplicate posting using a Google Sheets log.

Technical details

• n8n nodes/integrations: Schedule Trigger, RSS Feed Read, Google Sheets, OpenAI (gpt-4o-mini), Twitter/X (OAuth2) via Twitter node, Code, plus a Sticky Note for workflow guidance.
• Requires setup: Configure Google Sheets OAuth2 + spreadsheet/tab (gid) with guid/title/postedAt; add OpenAI API credentials; connect X (Twitter) OAuth2 for posting.