DaySchedule Google Sheets

Auto-post X videos with OpenRouter AI captions & Google Sheets deduplication

Streamline your content curation by automatically fetching videos from specific X accounts and generating unique, on-brand captions using OpenRouter AI. This robust workflow utilizes Google Sheets to prevent duplicate posts and maintain a detailed log of your social media activity. It offers a hands-off solution for marketers looking to maintain a consistent and engaging video presence on X with minimal manual effort.

Run this with your team's AI

What This Recipe Does

Maintaining a consistent social media presence requires a constant stream of high-quality content, but manually monitoring sources and reformatting posts is time-consuming. This automation streamlines your content pipeline by automatically identifying, filtering, and republishing video content from specified sources to X (formerly Twitter). The workflow monitors targeted accounts, cross-references a database to ensure no duplicate content is posted, and uses AI to generate fresh, engaging captions tailored for your audience. By removing the manual burden of content curation and caption writing, this system ensures your social feeds remain active and relevant around the clock. It transforms a manual four-step process—discovery, verification, creative writing, and posting—into a single, hands-off operation. This allows marketing teams to scale their reach and maintain high engagement levels without increasing their daily workload or headcount.

What your team gets

Something anyone can use

Forms and dashboards, so it is not a script only one person understands

It keeps running

Runs on your schedule in the cloud, so it does not stop when a laptop closes

Your other tools can call it

Endpoints, so the rest of your stack can trigger the same work

Accounts connected once

DaySchedule, Google Sheets connected for the team, not per person

How It Works

  1. 1

    Open the recipe and connect your accounts

    Connect DaySchedule and Google Sheets once, in your team cloud, and nobody has to do it again on their own machine

  2. 2

    Tell your own agent what is different about your process

    Claude, ChatGPT, Cursor, whichever your team already uses. It adapts the recipe to how you actually work

  3. 3

    Run it, then leave it running

    It lives in your team cloud, so it keeps going after you close the laptop and every teammate's AI can use it

Who Uses This

Frequently Asked Questions

How does the system prevent posting the same video twice?

The automation integrates with Google Sheets to maintain a permanent log of previously processed videos, checking every new find against this database before proceeding.

Can I control the tone and style of the AI-generated captions?

Yes, the AI logic can be customized within the workflow to match your specific brand voice, whether you prefer professional, humorous, or analytical captions.

Do I need to manually trigger the automation every day?

No, the workflow includes a schedule trigger that allows you to set specific intervals for the automation to run, ensuring your feed is updated consistently without manual intervention.

Is it possible to track which videos were posted and when?

The connected Google Sheet acts as a comprehensive audit log, recording every video processed and the status of the post for easy reporting and performance tracking.

Coming from n8n?

This recipe uses nodes like ScheduleTrigger, HttpRequest, Code, GoogleSheets and 6 more. On Runwork, you don't need to learn n8n's workflow syntax. Describe what you want to your own AI agent in plain English.

ScheduleTrigger HttpRequest Code GoogleSheets Set If Langchain.agent Twitter Langchain.lmChatOpenRouter StickyNote

Based on n8n community workflow. View original

Related Recipes

Google-gemini Http

Automated YouTube video scheduling & AI metadata generation 🎬

The YouTube Content Intelligence automation transforms how marketing teams monitor and leverage video content. By automating the extraction and processing of YouTube data, this workflow eliminates the manual effort required to track competitors, monitor brand mentions, or gather industry insights. It systematically fetches video details, handles high volumes of data through intelligent batching, and removes duplicates to ensure your dataset remains clean and actionable. Instead of spending hours browsing channels and manually logging information, your team receives a structured feed of intelligence ready for analysis. This automation allows you to stay ahead of market trends, identify high-performing content patterns, and react to new video releases in real-time. By bridging the gap between raw video data and business strategy, you can optimize your content production and competitive positioning with data-driven precision.

See the recipe
Http

Retweet cleanup with scheduling for X/Twitter

Maintaining a professional and focused brand presence on X requires a curated feed that highlights your original insights rather than a cluttered history of old retweets. The Automated Retweet Cleanup for X Accounts allows businesses and personal brands to automatically purge shared content after it has served its purpose. By scheduling regular cleanups, you ensure that your profile remains streamlined and relevant to new followers who are auditing your expertise. This automation systematically scans your account, identifies retweets based on your specific criteria, and removes them without requiring manual oversight. Beyond just tidying your timeline, the workflow includes error handling and Slack notifications to keep you informed of the process. This tool is essential for marketing teams who want to maintain a high-signal-to-noise ratio on social media while protecting their brand's long-term digital footprint.

See the recipe
Http

Extract and merge Twitter (X) threads using TwitterAPI.io

The Twitter Thread Fetcher is a specialized automation designed to solve the problem of fragmented social media content. Instead of manually copying and pasting individual tweets from a long thread, this automation systematically extracts every post in a sequence and merges them into a single, cohesive document. This is particularly valuable for content marketers and researchers who need to archive high-performing social content or repurpose Twitter insights for other platforms like blogs, newsletters, or internal knowledge bases. By automating the retrieval process, businesses can save significant time and ensure that no part of a valuable discussion or announcement is lost. The automation handles the technical complexity of connecting to the Twitter API and restructuring the data, providing a clean, ready-to-use text output that preserves the original narrative flow of the thread.

See the recipe
Http

Auto-post breaking news content using Perplexity AI to X (Twitter)

Maintaining a consistent and authoritative presence on social media is essential for brand growth, yet manually scouring the web for relevant news is a significant time sink. This automation bridges the gap between information gathering and content distribution by leveraging Perplexity AI to research current events and automatically drafting and posting updates to X (Twitter). Instead of spending hours each morning looking for industry trends, this workflow proactively identifies timely topics based on your specific criteria and shares them with your audience. By automating the research-to-publication pipeline, businesses can ensure they remain at the forefront of industry conversations without diverting resources from high-level strategy. This system transforms your social media profile into a real-time information hub, increasing engagement and establishing your brand as a thought leader in your niche. The result is a streamlined marketing operation that delivers consistent value to followers while operating entirely in the background.

See the recipe

Run this with the AI your team already uses

Your agent adapts it, your team cloud keeps it running, and everyone's AI can find it.

Open this recipe in Runwork