{"product_id":"daily-travel-news-to-x-n8n-openai-google-sheets-workflow","title":"Daily Travel News to X: n8n, OpenAI \u0026 Google Sheets Workflow","description":"\u003ch3\u003eDaily Travel News → X (Twitter) with n8n, OpenAI \u0026amp; Google Sheets\u003c\/h3\u003e\n\u003cp\u003eTurn Google News travel headlines into fresh, Japan-ready X posts—automatically. This n8n workflow runs every day at \u003cstrong\u003e17:30 JST\u003c\/strong\u003e, selects the best recent travel stories, uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to write a short Japanese comment, posts the top items to \u003cstrong\u003eX (Twitter)\u003c\/strong\u003e, and logs everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e so you never repost the same links.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled automation:\u003c\/strong\u003e Triggers daily at \u003cstrong\u003e17:30 (Asia\/Tokyo)\u003c\/strong\u003e via an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads posted history:\u003c\/strong\u003e Pulls the existing “already posted” list from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (columns: \u003cem\u003eguid\u003c\/em\u003e, \u003cem\u003etitle\u003c\/em\u003e, \u003cem\u003epostedAt\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches travel headlines:\u003c\/strong\u003e Uses a \u003cstrong\u003eGoogle News RSS\u003c\/strong\u003e search feed to retrieve travel-related items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters to the last 12 hours:\u003c\/strong\u003e Keeps only articles published within the last \u003cstrong\u003e12 hours\u003c\/strong\u003e, excludes overly business\/IR-style headlines, and scores items for travel relevance using keywords such as \u003cstrong\u003edeals\u003c\/strong\u003e, \u003cstrong\u003edisruptions\u003c\/strong\u003e, and \u003cstrong\u003ecrowding\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates:\u003c\/strong\u003e Compares each article’s \u003cem\u003eGUID\/link\u003c\/em\u003e and a \u003cem\u003enormalized title\u003c\/em\u003e against Google Sheets history, then selects the \u003cstrong\u003etop two\u003c\/strong\u003e scored articles.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates X-ready copy:\u003c\/strong\u003e Calls \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to create a \u003cstrong\u003e1–2 sentence Japanese\u003c\/strong\u003e comment (kept \u003cstrong\u003ewithin 150 characters\u003c\/strong\u003e) from the title and snippet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts and logs:\u003c\/strong\u003e Builds the final post text (including the article link, a blog link, and auto-generated hashtags), posts to \u003cstrong\u003eX\u003c\/strong\u003e, and appends \u003cem\u003eguid\/title\/timestamp\u003c\/em\u003e back to Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRun a travel-focused X account that consistently shares timely updates without manual curation.\u003c\/li\u003e\n  \u003cli\u003eAutomate daily “what’s new for travelers” content for SaaS operators, agencies, or community pages.\u003c\/li\u003e\n  \u003cli\u003eMaintain auditability and anti-duplicate posting using a Google Sheets log.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/integrations:\u003c\/strong\u003e 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.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequires setup:\u003c\/strong\u003e Configure Google Sheets OAuth2 + spreadsheet\/tab (gid) with \u003cem\u003eguid\/title\/postedAt\u003c\/em\u003e; add OpenAI API credentials; connect X (Twitter) OAuth2 for posting.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46157949272243,"sku":"N8N-19985","price":69.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ODDjUFQK_XUmff5WJxysJ_97lgj5Ms.png?v=1791019450","url":"https:\/\/buyflowscripts.com\/products\/daily-travel-news-to-x-n8n-openai-google-sheets-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}