Runwork
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.

Start Building

What This Recipe Does

Maintaining a consistent presence on X (formerly Twitter) is essential for brand visibility, but manually sourcing content and writing engaging captions is a significant time commitment. This automation streamlines your social media strategy by monitoring specific video sources and automatically reposting them to your profile with AI-generated captions. The system includes a sophisticated deduplication layer using Google Sheets to ensure you never post the same content twice, maintaining a fresh and professional feed. By leveraging AI to analyze video context and generate relevant text, you eliminate the creative bottleneck of content creation. This workflow allows marketing teams to scale their social media reach, increase engagement through high-quality video content, and focus their energy on high-level strategy rather than the repetitive task of manual posting. It transforms your profile into a curated hub of industry-relevant video content that runs autonomously around the clock.

What You'll Get

Complete App

Forms, dashboards, and UI components ready to use

Automated Workflows

Background automations that run on your schedule

API Endpoints

REST APIs for external integrations

Connected Integrations

DaySchedule, Google Sheets configured and ready

How It Works

  1. 1

    Click "Start Building" and connect your accounts

    Runwork will guide you through connecting DaySchedule and Google Sheets

  2. 2

    Describe any customizations you need

    The AI will adapt the recipe to your specific requirements

  3. 3

    Preview, test, and deploy

    Your app is ready to use in minutes, not weeks

Who Uses This

Frequently Asked Questions

How does the system prevent duplicate posts?

The automation uses a Google Sheet as a database to track every video processed. Before any content is posted to X, the system checks this log to ensure the video has not been used previously.

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

Yes, you can customize the instructions within the AI component to match your specific brand voice, whether you prefer professional, humorous, or informative captions.

Which platforms can I pull videos from?

The workflow is designed to fetch video content via HTTP requests, meaning it can be configured to pull from various web sources, APIs, or specific user feeds.

Do I need to manually trigger the posting process?

No, the workflow includes a schedule trigger that allows you to set specific intervals—such as hourly or daily—for the automation to check for new content and post automatically.

Importing from n8n?

This recipe uses nodes like ScheduleTrigger, HttpRequest, Code, GoogleSheets and 6 more. With Runwork, you don't need to learn n8n's workflow syntax—just describe what you want in plain English.

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

Based on n8n community workflow. View original

Related Recipes

Ready to build this?

Start with this recipe and customize it to your needs.

Start Building Now