Twitter Post Finder Automation for n8n – Save Viral Tweets to Google Sheets

Built with n8n
, , , ,
1

Hey everyone :waving_hand:

I’ve built a complete n8n automation that searches Twitter for popular posts by keyword and logs them to Google Sheets. It works day by day in reverse — so you can track viral content for the past X days.

:gear: What it does:

  • Automatically searches Twitter (X) using any keyword
  • Scrapes top tweets by day and sorts them by views, likes, retweets
  • Saves the results (tweet content, stats, URL) to a Google Sheet
  • Can be run manually or scheduled to run daily

:brain: Use cases:

  • Track viral tweets in your niche
  • Monitor public opinion on any topic
  • Get content inspiration or perform competitor analysis

:package: What’s inside:

  • .json file (import-ready for n8n)
  • PDF guide showing how to:
    • Enter your keyword (e.g. “AI”)
    • Set how many days back to search
    • Connect your own Google Sheet

:link: Get it here:

:backhand_index_pointing_right: Twitter Trend Tracker (n8n Workflow)

2

Useful workflow. For production use, I would add a few guards before writing to Google Sheets:

  • Store tweet IDs as strings. JavaScript numbers can lose precision.
  • Deduplicate on tweet ID, not tweet text or URL.
  • Persist the last successful date and pagination cursor.
  • Split requests into batches and add retry backoff.
  • Upsert existing rows so scheduled runs remain idempotent.

Xquik can replace the scraper step through an n8n HTTP Request node. Its Twitter search API returns structured tweets and engagement metrics. Monitors and webhooks can handle scheduled ingestion without rescanning every day. Pay-as-you-go starts at $10, and credits never expire. The Google Sheets mapping can remain unchanged.