Runwork
DaySchedule Google Sheets BigMailer

AI-generated LinkedIn posts with OpenAI, Google Sheets & email approval workflow

Transform your content strategy by automatically generating tailored LinkedIn posts from Google Sheets data using OpenAI's powerful language models. This workflow integrates a seamless email approval gate, ensuring every post is reviewed and refined by a human before publication. It’s a perfect balance of AI efficiency and brand-safe editorial control.

Start Building

What This Recipe Does

Maintaining a consistent presence on LinkedIn is essential for professional growth and brand authority, yet creating high-quality content daily is a significant time commitment. This automation streamlines your entire social media strategy by combining AI-driven content creation with a secure human approval process. The system automatically pulls topics or prompts from a Google Sheet, uses AI to draft professional posts, and sends a preview directly to your inbox. You maintain full control over your brand voice without ever having to log into a scheduling tool or draft posts from scratch. By integrating your approval via Gmail, the automation ensures that nothing goes live without your final sign-off. Once approved, the post is automatically published to LinkedIn at your preferred time. This workflow eliminates writer's block and the manual overhead of social media management, allowing you to focus on high-level strategy while your professional network stays engaged with fresh, relevant content.

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, BigMailer 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

Do I have control over what actually gets posted to my LinkedIn profile?

Yes. The automation includes a mandatory approval step via Gmail. You will receive an email with the drafted content and can choose to approve, reject, or request changes before anything is published.

Where does the AI get the topics or ideas for the posts?

The system pulls data from a designated Google Sheet. You can populate this sheet with simple keywords, industry news links, or specific themes you want the AI to expand upon.

Can I customize the tone and style of the generated content?

The underlying AI prompt can be adjusted to match your specific brand voice, whether you prefer a professional, technical, or conversational tone.

How often does this automation run?

The schedule is fully customizable. You can set it to generate and post daily, weekly, or on specific business days based on your marketing strategy.

Importing from n8n?

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

HttpRequest ScheduleTrigger Langchain.lmChatOpenAi GoogleSheets Langchain.chainLlm Set Gmail Switch If LinkedIn StickyNote

Based on n8n community workflow. View original

Related Recipes

DaySchedule Google Sheets BigMailer

AI-generated LinkedIn posts with OpenAI, Google Sheets & email approval workflow

Maintaining a professional presence on LinkedIn often requires hours of manual drafting and scheduling. This automation streamlines the entire content lifecycle by generating high-quality posts based on your specific data sources or content pillars. Instead of starting from a blank page, the system automatically prepares drafts and stores them in a Google Sheet for easy management. To ensure brand consistency and quality control, the workflow includes a built-in approval process. You receive a notification for every new draft, allowing you to review and approve the content before it goes live. Once approved, the system handles the publishing to LinkedIn on your behalf at the scheduled time. This approach eliminates the friction of manual posting while maintaining full control over your professional voice. By automating the repetitive parts of social media management, business leaders and marketing teams can focus on high-level strategy and engagement rather than the mechanics of content creation and distribution.

Build this
Google Sheets Google Drive

Extend and merge UGC viral videos using Kling 2.1, then publish on social media

Short-form video content is the primary driver of engagement in modern digital marketing, yet producing high-quality viral clips consistently is resource-intensive. This automation leverages the power of Kling 2.1 AI to transform brief User-Generated Content (UGC) into extended, professional-grade marketing assets. By automating the process of extending clips and merging them into cohesive narratives, your team can scale video production without increasing headcount. The system manages the entire lifecycle of video creation—from initial trigger and AI processing to cloud storage and data logging. This ensures that every piece of content is captured, processed, and organized automatically. Businesses can now maintain a constant presence on platforms like TikTok, Instagram, and YouTube Shorts by turning a handful of raw clips into a library of extended, high-impact video content. This workflow eliminates the manual bottleneck of video editing and technical rendering, allowing your creative team to focus on strategy and messaging rather than file management and processing wait times.

Build this
Google Sheets Google Drive

Extend and merge UGC viral videos using Kling 2.1, then publish on social media

Scaling high-quality video content is a major bottleneck for marketing teams and content creators. This automation solves that problem by leveraging the Kling 2.1 AI engine to automatically extend and merge user-generated content (UGC) into professional, viral-ready videos. Instead of spending hours in manual video editing suites, businesses can now automate the expansion of short clips into longer, more engaging narratives. The system monitors your data sources, processes raw video files through advanced AI models, and organizes the final assets directly into your cloud storage. By automating the technical heavy lifting of video production, your team can focus on creative strategy while maintaining a consistent publishing schedule across social platforms. This workflow ensures that every piece of raw footage is maximized for its full potential, transforming simple clips into high-production-value assets that drive engagement and brand awareness.

Build this
Google Drive

Translate PDF documents from Google Drive folder with DeepL

Managing a consistent content pipeline is often the biggest bottleneck for growing marketing teams. This automation bridges the gap between raw ideas and published assets by integrating your Google Drive ecosystem with powerful AI processing. By automating the heavy lifting of drafting, researching, and formatting, your team can focus on high-level strategy rather than repetitive typing. The workflow handles the entire lifecycle of a content piece, from retrieving source documents to calling advanced AI models via secure web requests. It includes built-in logic to filter results, ensure quality standards are met, and manage the timing of outputs. This ensures that every piece of content generated aligns with your brand guidelines and is ready for immediate review. Whether you are scaling a blog, generating product descriptions, or creating social media updates, this tool eliminates manual data entry and significantly reduces the time from concept to completion. It provides a scalable solution for businesses that need to maintain a high volume of quality communication without increasing headcount.

Build this

Ready to build this?

Start with this recipe and customize it to your needs.

Start Building Now