Automatically repost videos with AI captions and track them in Sheets

Finds a creator's new videos on X, writes an AI caption, reposts them, and logs everything in Google Sheets.

How the work actually flows

A straight line. Runs once per each new video.

Pattern: Sequence (1) ยท Multiple Instances with a priori Run-Time Knowledge (14)

flowchart TD trig(["scheduled account check"]):::trigtime s0[("log video to sheet")]:::store s1[["AI writes video caption"]]:::mi s2["repost video to X"]:::svc s3[("mark sheet record complete")]:::store trig --> s0 s0 -->|"one per each new video"| s1 s1 --> s2 s2 --> s3 out[/"reposted videos with captions logged"/]:::out pay{{"hands off reposting without duplicates"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itAn outside serviceRuns once per itemA record or sheetResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
AI Agents & Autonomous SystemsSpreadsheet & Database Ops
Connects
TwitterGoogle SheetsOpenRouter

The problem it solves

Manually finding a creator's new videos, writing captions, and reposting them takes ongoing attention, and it's easy to accidentally repost the same video twice. Keeping a clean record of what's already gone out adds even more manual work.

Who it fits

Marketers, creators, or social media managers who want hands-off reposting of a specific account's videos with on-brand captions.

How it works

  1. On a schedule, the system checks a target account's recent posts for new videos
  2. New videos are logged in Google Sheets to avoid duplicates
  3. AI writes a short, on-brand caption for each video
  4. The video is reposted to X with the new caption
  5. The Sheets record is updated to mark it complete
What you get

Reposts that keep your account active

Keep your account active with fresh reposts and on-brand captions without lifting a finger.

What you get

Reposted videos with fresh captions, plus a deduplicated log in Google Sheets.

What you need

An X account, a Google account for Sheets, and an OpenRouter API key.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Automate social post research, writing, and publishing

AI researches trending topics, writes LinkedIn and Twitter posts, publishes them, and logs the results for you.

Advanced

Turn daily Twitter mentions into ready-to-post content ideas

Every morning, AI scans your brand's Twitter mentions, spots problems people are having, and drafts posts your team can approve.

Standard

Track how your brand shows up in AI search results

The system asks AI search engines about your brand each day and sends your team a graded visibility report.

Advanced

AI assistant that browses the web and completes tasks for you

Lets you chat with an AI assistant that browses websites and takes real actions on them for you.

Advanced
Back to the AI Playbook