Marketing
Auto-Publish Latest News on X with AI Content Generation using Keywords and Bright Data
This n8n workflow triggers via form submission, fetches news from Google News using Bright Data, then uses an OpenAI (GPT-4o) agent to generate an X (Twitter) post. It publishes to X, records the tweet in Google Sheets, and sends a confirmation email via Gmail.
Built · ~10 hours saved per week
Auto-Publish Latest News on X with AI Content Generation
Workflow Overview This workflow automates the entire process of finding the latest news on a specific topic, generating a unique and localized social media post using AI, publishing it to X (formerly Twitter), and then logging the activity for reporting and notification.
The process begins when a user submits a form specifying a news topic (keyword) and a target country. The workflow then uses a web scraping service (Bright Data) to find a relevant, current news article on Google News. Once the article is found, it feeds the headline, URL, and country to an AI Agent powered by OpenAI's GPT-4o. The AI crafts a compelling tweet tailored to the local audience. This tweet is automatically published on X, its URL is logged in a Google Sheet, and a final confirmation email is sent to a stakeholder.
Automation & Value This workflow provides immense value by transforming a time-consuming, multi-step content marketing task into a simple, form-based trigger. It eliminates the manual effort of:
1. News Research: Automatically finds the latest, relevant articles instead of requiring manual searches on Google News. 2. Content Creation: Uses AI to write creative, context-aware social media copy, saving hours of brainstorming and writing. 3. Publishing & Scheduling: Directly posts to X without needing a user to log in and manually paste content. 4. Reporting & Logging: Keeps a perfect, automated log of all published content in Google Sheets for easy tracking and analysis. 5. Notification: Closes the loop by automatically notifying stakeholders that the task is complete.
Technologies Used - n8n: The core automation platform coordinating the entire process. - Bright Data: A web data platform used here to programmatically scrape the latest news from Google News based on keywords. - LangChain & OpenAI: The AI stack used for intelligent content generation. - X (Twitter): The social media platform where the generated content is published. - Google Sheets: Used as a simple database to log all published tweets. - Gmail: Used for sending email notifications upon successful publication.
Tags: Marketing, Forms, Admin, Content Management, Content Creation, AI Automation
Integrations: AI Agent, OpenAI, HTTP, X / Twitter, Code, Google Sheets, Email