Daily X follower and engagement tracker to Google Sheets

PromptCreate

Build a deterministic code workflow (no LLM step) that logs daily X (Twitter) KPIs for my handle and a configurable list of competitors into a Google Sheet so I can chart growth over time.

Trigger: cron, every weekday (Mon-Fri) at 9:00am in the workspace timezone.

Inputs (configurable at the top of the workflow): a list of X handles (mine plus 5 to 10 competitors), the target Google Sheet spreadsheetId, and the target sheet/tab name.

For each handle in the list, do the following in order:

1. Call TwitterAPI.io "Get User Info" with the handle to read followers, following, statusesCount, and isBlueVerified from the UserInfo response.

2. Call TwitterAPI.io "Get User Last Tweets" for the same handle to fetch the most recent 10 tweets. Sum likeCount, retweetCount, replyCount, and viewCount across that batch of (up to) 10 tweets. If fewer than 10 tweets are returned, sum across whatever was returned and proceed.

3. Append one row to the Google Sheet via the Google Sheets "Append Values" operation with these columns, in this order: date (YYYY-MM-DD in the workspace timezone), handle, followers, following, tweets_total (statusesCount), likes_sum_last10, retweets_sum_last10, replies_sum_last10, views_sum_last10.

Process handles sequentially (small list, no need to parallelize). Use valueInputOption USER_ENTERED so the date column is interpreted as a real date by Sheets. If a handle fails (404, unavailable account, rate limit), log the failure and continue with the next handle rather than aborting the whole run.

Output expectations: one new row per handle per run, appended to the existing log. The sheet should accumulate a daily time series that the user can chart with Sheets charts or a pivot table. Keep credit usage in mind (roughly 30 to 35 TwitterAPI.io credits per handle per day across the two read calls). No AI/LLM step is needed anywhere in this workflow.

What does this prompt do?

Pulls follower count, following count, and total post count for your handle and a list of competitors every weekday morning.
Adds up likes, reposts, replies, and views across each account's latest 10 posts.
Appends one fresh row per handle per day to your Google Sheet, ready to chart or pivot.
Runs hands-off so the log keeps building day after day with no manual exports.

What do I need to use this?

A TwitterAPI.io account with credits topped up (about 30 to 35 credits per handle per day).
A Google account with edit access to the spreadsheet you want rows appended to.
A short list of X handles you want to track (yours plus 5 to 10 competitors).

How can I customize it?

Change the schedule, the days of the week, or the timezone the tracker runs in.
Add or remove handles from the watch list as your competitive set evolves.
Point it at a different Google Sheet, rename the columns, or extend the row with extra fields like profile bio or verified status.

FAQs

Can I track more than 10 handles?

Yes. The handle list is just a configurable input, so you can grow it to 20 or 30. Just keep an eye on your TwitterAPI.io credits, since each handle costs roughly 30 to 35 credits per run.

Does it have to run on weekdays at 9am?

No. The schedule is fully configurable. Pick any time and any combination of days. Most teams keep it on weekday mornings so they have a consistent baseline for charts.

Where do the charts come from?

This workflow only logs the raw numbers. Once a few weeks of rows are in your sheet, use Google Sheets' built-in charts or a pivot table to plot follower growth and engagement trends over time.

Will it work for private X accounts?

No. Handles need to be public for follower counts and recent posts to be readable. For your own brand and competitors this is almost always the case.

What if an account didn't post recently?

The latest-10-posts totals will just reflect older posts and may be flat. That's a real signal too. If a handle has fewer than 10 posts ever, the sums are taken across whatever exists.

Related templates

Call overdue Xero customers with an AI collections agent

Every weekday at 10am, an AI voice agent phones your most overdue Xero accounts, logs what each customer promised, and reports back to finance in Slack.