Home/Insights/Data Engineering
Watch the video with chapters & transcript →
AUTOMATION
In short: An n8n workflow plus Google News RSS surfaces the most-viewed X posts for any keyword, with no X API access and no paid tools.
Finding what is trending on X normally means paid API access or third-party subscriptions. Ani Björkström demonstrated a workflow that skips both: n8n orchestrates a Google News RSS feed restricted to X, scores each post, and delivers a ranked list in a Google Sheet, built entirely on free components.
With an n8n form trigger. The form's URL is auto-populated, authentication is set to none, and you define three fields: a text field for the search keyword, a "days back" field (7 for the last week, 14 for two weeks), and a "top N results" field that caps the output, for example the top 15 posts by views. Executing the trigger opens the form, where you might enter "AI" as the keyword to pull AI posts from X.
They build and process the feed, and you do not have to write the code yourself: an LLM such as ChatGPT, Claude, or Gemini can generate it, or you can get the complete workflow free by commenting "N8N" on the video. The first code node stores the form inputs as variables, restricts the site to X/Twitter, and assembles the Google News RSS URL, with English as a default parameter. The nodes then run in sequence:
| Node | Purpose |
|---|---|
| Form trigger | Collects keyword, days back, and top-N results |
| Code | Saves inputs as variables and builds the RSS URL limited to X |
| RSS | Calls the Google News feed, no adjustments needed |
| Code (JavaScript) | Assigns each post a trend score; highest score means most views |
| Limit | Keeps only the top N defined in the form |
| Code | Assigns rank 1, 2, 3 by descending score |
| Google Sheets | Appends or updates rows with the ranked results |
Through the append-or-update-row node, after connecting n8n to your Google account with credentials. You create a Google Sheet whose columns match the output fields, rank, title, X URL, publish date, and source domain, then select the document and correct sheet tab, and drag and drop each field to map it. The X URL serves as the identifying column: if a post already exists in the sheet it is not entered again, otherwise a new row is created. In the demo, the sheet held ten ranked rows, and the top post had 31.5K views versus 18,000 for a lower-scored one.
Two things: market intelligence and growth. Set the keyword to your industry, finance, marketing, AI, or any niche, and you instantly see the most hyped topics in it. To grow your own X account, comment on or share the top posts, or create a similar post of your own, because you already know that the topic performed.
No. The workflow uses a Google News RSS feed filtered to X, orchestrated by n8n, and every component involved is free.
No. You can ask ChatGPT, Claude, Gemini, or another LLM to write it, or comment "N8N" on the video to receive the full workflow, code included, for free.
The Google Sheets node matches on the X URL column. Since each X post has a unique URL, existing posts are skipped and only new ones create rows.
Read the full video transcript, with chapters, on the video page →
Want this working inside your finance team?