Track a viral X post with a scheduled agent that logs to Google Sheets
Melvin Vivas · X post · 2026-10-10 · Open on X
Topics: AI Agents, Tool Use & MCP, Prompt & Context Engineering, AI Dev Tools & Productivity · Level: beginner
Summary
A step-by-step prompt recipe for having an agent track how an X post performs over time. You send the bot the post link and ask it to check every 30 minutes, measure how many views it gains per interval, judge whether growth is speeding up or slowing down, log everything to a Google Sheet, and write a final report with graphs.
Key points
- Send the bot the post link and tell it to 'check this every 30 mins'.
- Ask for the number of views gained in each 30-minute period, and whether growth is speeding up or slowing down.
- Say 'log everything to a Google Sheet' to keep a record of each check.
- Say 'when it ends, write me a report with graphs' to get a final summary.
- The agent sets up the schedule, collects the numbers and sends you updates.
- Change the tracking length and check interval to suit you.
Resources mentioned
- Grok Bot · tool · x.ai · paid
An AI personal assistant the creator describes as having memory, day planning, task scheduling and the ability to do background work without any coding.
Also in: Turn repeated agent tasks into reusable Skills (Melvin Vivas on X · notes), Using a Grok Bot to find free AI credit giveaways (Melvin Vivas on X · notes), Grok Bot can now use phone calendar, contacts and reminders (Melvin Vivas on X · notes), Grok Bot Adds 1Password Integration for Agent Logins (Melvin Vivas on X · notes) and 129 more - Google Sheets · tool · google.com · free · recommended by both Bashiri Smith & Melvin Vivas
Google's online spreadsheet app, used here as the place where the agent stores its results.
Also in: Tracking a Viral X Post's Growth with a Grok Bot Agent (Melvin Vivas on X · notes), A 5-Step Framework for Designing a Grok Bot Automation (Melvin Vivas on X · notes), Organizing Grok Bot Lead Collection in One Google Sheet (Melvin Vivas on X · notes), Morning digest from a chief-of-staff agent (Melvin Vivas on X · notes) and 2 more
Try this
- Send your agent a post link and ask it to check the post every 30 minutes.
- Ask it to log the metrics to a Google Sheet and write a final report with graphs.
- Build an agent that monitors a social post's views on a schedule, measures whether growth is speeding up or slowing down, logs the data to a spreadsheet and produces a charted report.