Home/Insights/Data Engineering

How I Find Viral X Posts Without APIs!

By Ani BjörkströmPublished 17 December 2025Reviewed 17 November 20269 min video + articleData Engineering

How I Find Viral X Posts Without APIs!
▶ Watch the full 9-minute video · with chapters & transcript

AUTOMATION

How Do You Find Viral X Posts Without Paying for APIs?

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.

Key takeaways

  • 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.
  • A simple form takes three inputs, keyword, days back, and top-N results, and the workflow scores, ranks, and writes the posts to a Google Sheet.
  • Using the X post URL as the matching column prevents duplicate rows, since every X post has a unique URL.

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.

How does the workflow start?

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.

What do the code and RSS nodes actually do?

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:

NodePurpose
Form triggerCollects keyword, days back, and top-N results
CodeSaves inputs as variables and builds the RSS URL limited to X
RSSCalls the Google News feed, no adjustments needed
Code (JavaScript)Assigns each post a trend score; highest score means most views
LimitKeeps only the top N defined in the form
CodeAssigns rank 1, 2, 3 by descending score
Google SheetsAppends or updates rows with the ranked results

How do results land in Google Sheets?

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.

What can you use the ranked list for?

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.

FAQ

Do I need X API access or any subscriptions?

No. The workflow uses a Google News RSS feed filtered to X, orchestrated by n8n, and every component involved is free.

Do I have to write the JavaScript myself?

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.

How are duplicates avoided in the sheet?

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.

Want this working inside your finance team?

Ani Björkström

Ani Björkström — founder of QvantX Sweden AB, a Stockholm consultancy building AI solutions for banks, asset managers and finance teams. Anthropic partner. Every article starts from a real client build, minus the confidential parts. LinkedIn →