Google Sheets and LinkedIn integration

AI Social Media Content Automation – n8n Workflow This workflow is built for creators, solopreneurs, SaaS founders, and agencies looking to automate their social media content process from idea to publication. It combines the power of OpenAI, Google Sheets, and official APIs for Instagram, Facebook, X (Twitter), and LinkedIn to deliver fully automated, brand-consistent social media posts — including text, images, hashtags, CTAs, and scheduling. No more switching tools, rewriting content, or forgetting to post. Just set it up once and let your brand grow automatically. 🔧 What the Workflow Does Generates platform-specific post ideas based on your brand tone. Selects the best idea (or lets you manually input one). Writes tailored posts for Instagram, Facebook, X, and LinkedIn. Auto-generates platform-specific visuals using OpenAI (DALL·E) and uploads to Cloudinary. Publishes content directly using official platform APIs. Logs all actions to Google Sheets and optionally sends a summary email via Gmail. ⚙️ How It Works Trigger the workflow manually, on a schedule, or from a chatbot. AI generates multiple post ideas and filters the best one. Based on the selected idea, it generates full posts for each platform. Custom visuals are created using OpenAI and uploaded to Cloudinary. Final post content is merged and sent to Instagram, Facebook, X, and LinkedIn. Logs and optional reports are created in Google Sheets and Gmail. 🛠️ Setup Steps Set up your accounts and credentials: OpenAI, Cloudinary, Gmail, Meta, LinkedIn, X, and Google Sheets. Import the workflow and subworkflow (Get Brand Brief) into n8n. Replace all placeholders (sheet IDs, access tokens, profile/page IDs, brand brief URLs). Optionally personalize prompts and output templates to match your brand voice. Setup time: ~30–45 minutes (including credentials and testing). Detailed configuration notes are included in sticky nodes throughout the workflow. 📦 Included in Your Package JSON workflow file (main flow + brand brief subflow) Google Sheets templates for history logging Setup documentation (Markdown & PDF) Placeholder reference sheet

Social Media Spark (SMS) — Automated Viral Content Engine Automate your entire content workflow: discover viral ideas, generate posts in your tone, repurpose for X, and auto-publish — reducing 90% of manual effort. 🚀 What it Does Scrapes competitors or niche profiles on LinkedIn to find high-performing posts. Classifies and saves evergreen content ideas for later use. Generates fresh posts in your own voice with matching images. Repurposes content for X (Twitter) in a platform-optimized style. Automatically publishes content to LinkedIn and X on your schedule. Allows on-demand commands via Telegram for research or instant content generation. 🧩 Why Use It Save time:** no more manual scraping, idea collection, or formatting. Stay consistent:** maintain a daily content pipeline. Multi-platform leverage:** create once, adapt for LinkedIn and X. Creative control:** mix automation with optional human review. Scalable:** extend to more platforms, analytics, and workflows as you grow. 🔧 Prerequisites & Setup Before importing or activating the workflow, prepare these: AI Provider (OpenAI / Gemini / OpenRouter)** For classifying posts, generating new content, repurposing for X. Google Sheets** Central database for competitors, ideas, generated posts, and posting status. Google Drive** Stores generated images. Apify & Browseract** Scrapes LinkedIn profiles, posts, and performs research tasks. LinkedIn API** Needed for automated LinkedIn publishing. X (Twitter) API** Requires OAuth 1.0a for image uploads and OAuth 2.0 for text posting. Telegram Bot** Enables on-demand commands and notifications. Set your Telegram User ID in the trigger node. > 🔎 In each sub-workflow, look for nodes marked “Configure Me!” to replace example prompts, search keywords, sheet IDs, etc. ⚙️ How It Works (Simplified Flow) Scrape & Classify: Collect high-engagement posts → keep evergreen ones. Generate Content: Rewrite ideas into new posts in your voice → create images. Repurpose for X: Adapt LinkedIn posts for short-form, high-impact tweets. Auto-Publish: Post daily on LinkedIn and X. Control via Telegram: Manually trigger scraping, research, or post generation. 💡 Best Practices & Tips Keep all API keys private — never share them in public repos or screenshots. Adjust cron schedules (e.g., scraping on weekends, posting on weekdays) to fit your content rhythm. Add Human-in-the-Loop review steps for brand-sensitive content. Extend to other platforms (Instagram, TikTok, YouTube Shorts) as needed. Experiment with prompt variations for different tones or creative styles. Add analytics logging (likes, comments, clicks) to measure content performance. 🙋‍♂️ Who is This For Solo creators & founders** who want to post consistently but don’t have time for daily ideation. Small marketing teams** that need to keep up with trends without spending hours on research. Consultants & thought leaders** who want to amplify their personal brand on LinkedIn and X. Startups & bootstrapped businesses** that need a lean but reliable content engine. Content strategists** who want a data-driven, repeatable pipeline for finding and using what works. Or anyone who wants to boost social presence by 300% 💡 Why SMS Stands Out Authentic voice:** Uses your own tone and style (defined in prompts and examples), so posts feel personal — not generic AI fluff. Data-driven:** Pulls from real, viral posts in your niche to inspire fresh content. Quality over quantity:** Focuses only on proven viral ideas instead of churning random posts. Consistent growth:** Keeps your posting regular, so you stay visible and relevant. Efficient workflow:** Minimizes manual work while letting you step in when needed (e.g., for approvals or special campaigns). > ⚡ SMS combines real market data with your unique voice — so you post smarter, not just more often.

Extract Trends and Auto-Generate Social Media Content with OpenAI, Reddit, and Google Trends: Approve and Post to Instagram, TikTok, and More Description What Problem Does This Solve? 🛠️ This workflow automates trend extraction and social media content creation for businesses and marketers. It eliminates manual trend research and content generation by fetching trends, scoring them with AI, and posting tailored content to multiple platforms. Target audience: Social media managers, digital marketers, and businesses aiming to streamline content strategies. What Does It Do? 🌟 Fetches trending topics from Reddit, X and Google Trends Scores trends for relevance using OpenAI. Generates content for Twitter/X, LinkedIn, Instagram and Facebook Posts to supported platforms Stores results in Google Sheets for tracking Key Features 📋 Real-time trend fetching from Reddit and Google Trends. AI-driven trend scoring and content generation (OpenAI). Automated posting to Twitter/X, LinkedIn, Instagram, and Facebook. Persistent storage in Google Sheets. Setup Instructions Prerequisites ⚙️ n8n Instance**: Self-hosted or cloud n8n instance. API Credentials**: Reddit API: Client ID and secret from Reddit. SerpApi (Google Trends): API key from SerpApi, stored in n8n credentials OpenAI API: API key with GPT model access. Twitter/X API: OAuth 1.0a credentials with write permissions. LinkedIn API: OAuth 2.0 credentials with w_organization_social scope. Instagram/Facebook API: Meta Developer app with posting permissions. Google Sheets API: Credentials from Google Cloud Console. Installation Steps 📦 Import the Workflow: Copy the workflow JSON from the "Template Code" section below. Import it into n8n via "Import from File" or "Import from URL". Configure Credentials: Add API credentials in n8n’s Credentials section for Reddit, SerpApi, OpenAI, Twitter/X, LinkedIn, Instagram/Facebook, and Google Sheets. Assign credentials to respective nodes. For example: In the Fetch Google Trends node (HTTP Request), use n8n credentials for SerpApi instead of hardcoding the API key. Example: Set the API key in n8n credentials as SerpApiKey and reference it in the node’s query parameter: api_key={{ $credentials.SerpApiKey }}. Set Up Google Sheets with the following columns (exact column names are case-sensitive) -Timestamp | Trend | Score | BrandVoice | AudienceMood | Customize Nodes: OpenAI Nodes** (Trend Relevance Scoring, Generate Social Media Content): Update the model (e.g., gpt-4o) and prompt as needed. HTTP Request Nodes** (Post to Twitter/X, Post to LinkedIn, etc.): Verify URLs, authentication, and payloads. Brand Voice/Audience Mood**: Adjust Prepare Trend Scoring Input for your desired brand_voice (e.g., "casual") and audience_mood (e.g., "curious"). Test the Workflow: Fetch Reddit Trends to Store Selected Trends- to score and store trends. Retrieve Latest Trends to end) to generate and post content Check Google Sheets for posting statuses How It Works High-Level Steps 🔍 Fetch Trends**: Pulls trends from Reddit,X and Google Trends. Score Trends**: Uses OpenAI to score trends for relevance. Generate Content**: Creates platform-specific social media content. Post Content**: Posts to LinkedIn, Facebook or X Detailed descriptions are available in the sticky notes within the workflow screenshot above. Node Names and Actions Trend Extraction and Scoring Daily Trigger Idea: Triggers the workflow daily. Set Default Inputs: Sets default brand_voice and inputs. Fetch Reddit Trends: Fetches Reddit posts. Extract Reddit Trends: Extracts trends from Reddit. Fetch Google Trends: Fetches Google Trends via SerpApi. Extract Google Trends2: Processes Google Trends data. Fetch Twitter Mentions: Fetches Twitter mentions. Translate Tweets to English: Translates tweets. Fix Tweet Translation Output: Fixes translation format. Detect Audience Mood: Detects audience mood. Fix Audience Mood Output: Fixes mood output format. Analyze News Sentiment: Analyzes news sentiment. Combine Data (Merge): Merges all data sources. Merge Items into Single Item: Combines data into one item. Combine Trends and UGC: Combines trends with UGC. Prepare Trend Scoring Input: Prepares data for scoring. Trend Relevance Scoring: Scores trends with OpenAI. Parse Trend Scores: Parses scoring output. Store Selected Trends: Stores trends in Google Sheets. Content Generation and Posting Retrieve Latest Trends: Retrieves trends from Google Sheets. Parse Retrieved Trends: Parses retrieved trends. Select Top Trends: Selects the top trend. Generate Social Media Content: Generates platform-specific content. Parse Social Media Content: Parses generated content. Generate Images: Generates images for posts (if applicable). -Handle Approvals/Rejection before Posting Post to Instagram: Posts to Instagram. Post to Facebook: Posts to Facebook. Post to LinkedIn: Posts to LinkedIn. Customization Tips Add Trend Sources** 📡: Include more sources (e.g., Instagram trends) by adding nodes to Combine Data (Merge). Change Content Tone** ✍️: Update the Generate Social Media Content prompt for a different tone (e.g., "humorous"). Adjust Schedule** ⏰: Modify Daily Trigger Idea to run hourly or weekly. Automate TikTok/YouTube** 🎥: Add video generation (e.g., FFMPEG) to post TikTok and YouTube Shorts

💼 LinkedIn Content Machine – AI-Powered Post Generator & Scheduler for X and LinkedIn How it works: This end-to-end workflow automates your personal or brand content strategy by: 🧠 Using Google Gemini or OpenAI to generate engaging LinkedIn/X content from a title or trending posts. 🗓️ Posting directly to LinkedIn and X (formerly Twitter). 📊 Pulling high-performing LinkedIn posts to inspire new ideas. ✍️ Saving AI-generated drafts to Google Sheets for review. 🔔 Notifying your team on Slack when drafts are ready. Steps to set up: Add your API keys for Google Gemini or OpenAI. Set up your LinkedIn, X (Twitter), Google Sheets, and Slack credentials. Customize prompt logic or post filters if needed. Schedule the idea generation module or trigger it manually. Start generating and posting consistent, high-quality content with zero manual effort!

How it works This workflow automates your entire LinkedIn content strategy, from ideation to publishing. Daily Idea Generation:** Every day, the workflow uses an advanced AI agent (Anthropic's Claude model) to generate a new, viral-optimized LinkedIn post idea, complete with a title, full text, and a detailed image description. It analyzes your past posts from a Google Sheet to ensure content is fresh and aligns with one of your four content pillars: timeless principles, case studies, growth hacks, or controversial ads. AI Image Creation:** It then uses OpenAI's DALL-E to create a custom, high-quality image based on the generated description and a style reference image you provide, ensuring brand consistency. Review & Approval Workflow:** The generated post and its accompanying image are automatically saved as a new row in a Google Sheet, marked with a "review" status. This gives you full editorial control. Automated Publishing:** Once you approve a post by changing its status to "ready" in the Google Sheet, a separate part of the workflow picks it up and automatically publishes it to your LinkedIn profile at a scheduled time. Status Tracking:** After publishing, the workflow updates the status in your Google Sheet to "posted," so you always have a clear overview of your content pipeline. Set up steps This workflow integrates several services. Follow these steps to get it running: Copy the Google Sheet: Make a copy of the AI Posts Content Machine Google Sheet template and select your copy in the Get Past Ideas, Save Post, Get Ready Posts, and Update Status nodes. Set Up Credentials: You will need to create and add API credentials for the following services within the corresponding n8n nodes: Google Sheets & Google Drive: Create a Google credential. Anthropic: Add your API key in the Anthropic Chat Model node. OpenAI: Add your API key as a Header Auth credential in the OpenAI Image node. Perplexity AI: Add your API key as a Header Auth credential inside the Perplexity Research sub-workflow. LinkedIn: Create a LinkedIn credential. Customize Your Content: In the Idea Generator node, adjust the system prompt to reflect your specific audience, topics, and content style. Create a folder in Google Drive for your post images. Add a reference image to this folder that defines your desired visual style. Paste the shareable link to your style reference image into the Image Style node. Activate the Workflow: Enable the workflow to start the automated content creation and publishing process.

Workflow Description for n8n: Social Media Post from Ideas Copy This workflow automates the process of creating and publishing social media posts across multiple platforms (Twitter/X, Facebook, LinkedIn, and Instagram) based on content from a WordPress post. It uses AI models to generate platform-specific captions and images, and integrates with Google Sheets, WordPress, and various social media APIs. Is a powerful tool for automating social media post creation and publishing, saving time and ensuring consistent, platform-optimized content across multiple channels. Below is a breakdown of the workflow: How It Works The workflow is designed to streamline the creation and publishing of social media posts. Here's how it works: Trigger: The workflow starts with a Manual Trigger node, which initiates the process when the user clicks "Test workflow." Fetch Data: The Google Sheets node retrieves the WordPress Post ID from a predefined Google Sheet. The Get Post node fetches the corresponding WordPress post content using the retrieved Post ID. Generate Social Media Content: The Social Media Manager node uses an AI model (OpenRouter) to analyze the WordPress post and generate platform-specific captions for Twitter/X, Facebook, LinkedIn, and Instagram. The AI ensures that each caption is tailored to the platform's audience, tone, and style, including hashtags and calls to action. Generate Images: The Image Instagram and Image Facebook e Linkedin nodes use OpenAI to generate platform-specific images for Instagram, Facebook, and LinkedIn posts. Publish on Social Media: The workflow publishes the generated content and images on the respective platforms: Publish on X: Posts the caption on Twitter/X. Publish on LinkedIn: Posts the caption and image on LinkedIn. Publish on Facebook: Posts the caption and image on Facebook. Publish on Instagram: Posts the caption and image on Instagram. Update Google Sheets: The workflow updates the Google Sheet to mark the posts as published (e.g., "X OK," "Facebook OK," "LinkedIn OK," "Instagram OK"). Set Up Steps To set up and use this workflow in n8n, follow these steps: Google Sheets Setup: Create (or clone) a Google Sheet with columns for POST ID, TEXT, TWITTER, FACEBOOK, INSTAGRAM, and LINKEDIN. Link the Google Sheet to the Google Sheets node by providing the Document ID and Sheet Name. WordPress Integration: Set up WordPress credentials in n8n for the Get Post node. Ensure the WordPress site is accessible via its REST API. AI Model Configuration: Configure the OpenRouter credentials in n8n for the Social Media Manager node. Ensure the AI model is set up to generate platform-specific captions. Image Generation: Set up OpenAI credentials for the Image Instagram and Image Facebook e Linkedin nodes to generate images. Social Media API Integration: Set up credentials for each social media platform: Twitter/X: Configure the Publish on X node with Twitter OAuth2 credentials. LinkedIn: Configure the Publish on LinkedIn node with LinkedIn OAuth2 credentials. Facebook: Configure the Publish on Facebook and Publish on Instagram nodes with Facebook Graph API credentials. Test the Workflow: Click the "Test workflow" button in n8n to trigger the workflow. The workflow will: Fetch the WordPress post content. Generate platform-specific captions and images. Publish the posts on Twitter/X, Facebook, LinkedIn, and Instagram. Update the Google Sheet to mark the posts as published. Optional Customization: Modify the workflow to include additional platforms or customize the AI-generated content further. Need help customizing? Contact me for consulting and support or add me on Linkedin.

How it works This workflow sources news from news websites. The information is then passed to an LLM, which processes the article's content. An editor approves or rejects the article. If accepted, the article is first published on the WordPress site and then on the LinkedIn page. Setup Instructions Credentials You'll need to add credentials for the following services in your n8n instance: News API**: A credential for your chosen news provider. LLM**: Your API key for the LLM you want to use. Google OAuth**: For both Gmail and Google Sheets. WordPress OAuth2**: To publish articles via the API. See the WordPress Developer Docs. LinkedIn OAuth2**: To share the post on a company page. Node Configuration Don't forget to: Fetch News (HTTP Request)**: Set the query parameters (keywords, language, etc.) for your news source. Basic LLM Chain: Review and **customize the prompt to match your desired tone, language, and style. Approval request (Gmail)**: Set your email address in the Send To field. HTTP Request WP - Push article**: Replace <site_Id> in the URL with your WordPress Site ID. getImageId (Code Node)**: Update the array with your image IDs from the WordPress Media Library. Create a post (LinkedIn)**: Enter your LinkedIn Organization ID. Append row in sheet (Google Sheets)**: Select your Google Sheet file and the target sheet. All Email Nodes**: Make sure the Send To field is your email.

📰 LinkedIn News Auto-Publisher Overview 📋 This project is an automated news publisher for LinkedIn. It uses RSS feeds to fetch news, processes the content with the Gemini API to generate precise summaries, and automatically publishes to LinkedIn via its API. How It Works Architecture and Workflow ⚙️ n8n**: Efficient orchestration of workflow with automation. RSS**: News sources such as TechCrunch and MIT Technology Review. Gemini API**: Dynamic generation of content and precise summaries. LinkedIn API**: Automatic publication on profiles and corporate pages. Content Processing 🧠 Fetching news through RSS feeds. Processing and generating summaries with the Gemini API. Automatic publication on LinkedIn. Key Benefits ✅ Complete automation of the news publishing process. Dynamic generation of precise and relevant content. Integration with reliable news sources and publication on a professional platform. Use Cases 💼 Automation of news publishing for businesses and professionals. Keeping corporate profiles and pages updated with relevant content. Saving time in managing content on social networks. Requirements 👨‍💻 n8n instance (self-hosted or cloud). Gemini API credentials. LinkedIn bot setup and API credentials. Configured RSS feeds to fetch news. Authors 👥 Joel Choez Alan Bajaña Jaren Pazmiño David Sandoval Members of CIAP

🧠 Who is this for? Marketing teams, content creators, solopreneurs, and agencies who want to generate emotionally-resonant, SEO-optimized content tailored to audience psychology and buyer journey stages — and get picked up by AI discovery engines like ChatGPT, Gemini, and Perplexity. How it works: ✅ Decodes why people buy (using buyer psychology) ✅ Creates SEO + emotionally resonant content for 4 formats: → Blog Posts, Newsletters, Landing Pages, Social Media ✅ Structures the content to be picked up by ChatGPT, Gemini, Perplexity & Google ✅ Automatically routes it to Google Sheets, Gmail, or even WordPress This isn’t just about writing better content — it’s about getting seen by the tools that shape the internet. How long does it take to set-up: 30 Mins

This n8n workflow automatically captures LinkedIn leads from multiple sources (new connections, post engagements), enriches the data with AI-powered scoring, eliminates duplicates, syncs to Google Sheets and your CRM (HubSpot or Salesforce), and sends instant notifications to your sales team for high-quality leads. No more manual copy-pasting or lost opportunities—every LinkedIn interaction becomes a tracked, qualified lead ready for follow-up. Benefits Zero Manual Data Entry:** Eliminates tedious copy-paste work—saves 10+ hours per week for active LinkedIn users Smart Lead Scoring:** AI calculates quality scores (0-100) and assigns temperature labels (Hot/Warm/Cold) based on engagement patterns Multi-Source Capture:** Monitors new connections, post comments, likes, and shares to catch leads from all touchpoints Duplicate Prevention:** Tracks leads for 90 days to avoid database clutter and redundant outreach Instant Sales Alerts:** Notifies team via Slack/Email within seconds for Hot & Warm leads, enabling rapid follow-up CRM Integration:** Syncs directly to HubSpot or Salesforce with custom fields for lead temperature and quality metrics Built-in Analytics:** Tracks cumulative statistics (total leads, temperature distribution) for performance monitoring Always-On Automation:** Runs every 15 minutes 24/7, capturing leads even when you're sleeping or in meetings Useful for Which Industry B2B SaaS & Tech:** Sales teams prospecting decision-makers and capturing demo requests from LinkedIn content Consulting & Professional Services:** Agencies tracking client inquiries and partnership opportunities from thought leadership posts Recruiting & HR:** Talent acquisition teams building candidate pipelines from LinkedIn engagement Real Estate & Financial Services:** Agents capturing high-intent leads from market updates and educational content Marketing Agencies:** Business development teams converting social engagement into qualified opportunities E-Learning & Coaching:** Course creators and consultants tracking interested prospects from free content Manufacturing & B2B Sales:** Enterprise sales teams monitoring buying committee members engaging with product content How it works Monitor LinkedIn - Checks every 15 minutes for new connections and post engagements Extract data - Pulls profile information, company, position from multiple sources Score leads - Calculates quality score (0-100) and assigns temperature (Hot/Warm/Cold) Prevent duplicates - Tracks leads for 90 days to avoid duplicate entries Sync to platforms - Saves to Google Sheets and your CRM (HubSpot or Salesforce) Smart notifications - Alerts sales team via Slack/Email for Hot and Warm leads only Setup steps Connect LinkedIn - Add OAuth2 credentials to both LinkedIn nodes Setup Google Sheets - Create spreadsheet with these columns: leadId, fullName, firstName, lastName, email, phone, company, position, headline, location, profileUrl, leadSource, leadTemperature, qualityScore, engagementType, commentText, dateAdded, status, assignedTo, notes, lastUpdated Choose CRM - Enable either HubSpot OR Salesforce nodes (disable the other) Configure alerts - Add Slack webhook URL and/or email settings Test workflow - Run manually first to verify all connections Activate - Turn on for automatic lead capture Key features Smart scoring**: Quality score based on engagement level and profile completeness Temperature labels**: Hot (70+), Warm (50-69), Cold (<50) for prioritization No duplicates**: 90-day tracking prevents duplicate entries Multi-CRM support**: Works with HubSpot or Salesforce Analytics built-in**: Tracks total leads and temperature distribution

💅 AI Agents Generate Content & Automate Posting for Beauty Salon Social Media 📲 Who Is This For? This workflow is for beauty salons who want consistent, high‑quality social media content without writing every post manually. It also suits agencies and automation builders who manage multiple beauty brands and want a reusable, AI‑driven posting system they can adapt per client. What Problem Is This Workflow Solving? Many beauty businesses struggle to post regularly because research, copywriting, and design all take time and marketing skills. This workflow automates research, writing, image creation, and posting, so your channels stay active and relevant while you focus on clients and services. What This Workflow Does Generates short, engaging posts tailored to a beauty‑salon audience (hair, nails, skincare, make‑up, self‑care) using an AI agent. Uses Tavily Internet Search to pull up‑to‑date information and trends based on a reference link or topic. Turns each post into a detailed, photorealistic image prompt and creates a matching visual with an AI image model (for example, gpt‑image‑1 or other connected providers). Automatically sends the final text and image to Telegram, and can be extended to other social platforms from the Split Out node. How It Works Trigger the workflow Scheduled automatic generation:** Run the parent workflow on a schedule (for example, once per day at 9 AM) to publish new content regularly. Google Sheets trigger:** Generate content when a new row with a reference link or topic is added to your sheet. Use it when you manage ideas or briefs in Google Sheets and want the workflow to react as soon as a new idea appears. RSS Feed trigger:** Start the workflow when new items appear in a selected RSS feed. Ideal for turning fresh blog posts, news, or industry updates into social media content or automated summaries. Meta (Facebook/Instagram) webhook:** Use the Meta Reference trigger to fire the workflow on incoming webhooks from Meta (for example, new comments, messages, or events). Helpful when you want to auto‑respond, log activity, or generate follow‑up content from Meta activity. Airtable trigger:** Start the workflow when records in a selected Airtable base/table change (for example, a new idea, brief, or status update), so your posts react instantly to updates in your Airtable content board. Postgres trigger:** Fire the workflow when new rows are inserted or existing rows are updated in a connected PostgreSQL table, letting you drive content generation from events in your app database or Supabase‑style back end. Manual start:* Hit Execute workflow* whenever you want to spin up a batch of posts on demand, test new prompt settings, or debug the flow step by step. Research and generate copy The GENERATE TEXT agent calls Tavily to gather fresh information on the topic. It writes a post under 1024 characters with a hook, practical tips, relevant hashtags, and a closing line with your salon address and contact. Create the visual The GENERATE PROMPT agent converts the post into a single, clear description of the scene (client, service, salon interior, lighting, mood) with a strict “no text on image” rule. An image model such as gpt‑image‑1 or one of the HTTP image APIs renders a matching beauty visual. Distribute the content The Split Out node fans out the result so Telegram receives a photo post with the generated caption. Additional social or content nodes (for example Facebook, LinkedIn, X, template tools) can be wired after this step for multi‑channel posting. How to Customize This Workflow to Your Needs Brand voice** Edit the system message in the GENERATE TEXT node to adjust tone (luxury, friendly, clinical, playful), language, services, and city. Update the final address and phone line to match your salon details. Topics and triggers** Point the Google Sheets Trigger to your own document ID, sheet, and columns for ideas, links, or campaign themes. Use the Schedule Trigger for fully automatic posting or rely on the Manual Trigger for controlled, batch generation sessions. Models and providers** Swap GPT‑5 llm and the default image model for alternatives such as Mistral, Gemini, Anthropic, DeepSeek, or custom HTTP image APIs by enabling the corresponding nodes and adding credentials. Channels and outputs** Connect or remove social nodes after Split Out depending on which platforms you actively use. Add extra processing steps (for example resizing images or adding UTM parameters) before each channel if needed. Visual style** Tweak the GENERATE PROMPT instructions to control composition (close‑up vs. full‑body), color palette, lighting, and overall salon aesthetic, while keeping the constraint of no text or logos in the image.

How it works Automates daily LinkedIn post creation from trending AI tweets. Fetches latest tweets, processes content, checks for duplicates, converts to LinkedIn-ready format, schedules, and posts automatically. Set up steps Setup required: Google Sheets, LinkedIn, Telegram, RapidAPI, and OpenAI/OpenRouter API credentials. Approximate setup time: 30-45 mins for all integrations and triggers. Detailed credential/config instructions are in sticky notes inside the workflow.

Automated Blog Post Review and Multi-Platform Publishing Workflow with RSS Feeds Description This workflow automates the process of generating, reviewing, and publishing blog posts across multiple platforms, now enhanced with support for RSS Feeds as a content source. It streamlines the management of blog posts by fetching content from RSS Feeds, formatting, storing, reviewing, templating, and publishing to platforms like LinkedIn and WordPress. The workflow is split into three key flows: Initial Flow**: Fetches content from RSS Feeds, prepares and stores blog post data, sends a review email with approval/rejection links. Approval Flow**: Handles review actions via a webhook to update the status in Google Sheets. Status Update Flow**: Monitors status changes and publishes approved posts. Target Audience Content creators, bloggers, and digital marketers. Teams managing multi-platform content publishing. Users familiar with n8n, Google Sheets, LinkedIn, and RSS Feeds. Problem Solved Manually managing blog posts, especially when sourcing content from RSS Feeds, can be time-consuming and error-prone This workflow addresses: Content Sourcing**: Fetches blog posts from RSS Feeds for automated processing Content Formatting**: Automatically formats and stores blog posts. Review Process**: Simplifies approval with email notifications and webhook triggers. Multi-Platform Publishing**: Publishes to LinkedIn, WordPress and optionally Medium) with delays to avoid rate limits Status Tracking**: Tracks approval and publishing status in Google Sheets. Setup Instructions Prerequisites n8n Instance**: Ensure you have an active n8n instance RSS Feed URL**: Identify an RSS Feed URL (e.g., a blog’s feed like https://example.com/feed) Google Sheets**: Create a spreadsheet with columns: Title, Blogpost, Publication Date, Keywords, Status, Published, Featured Image, articleUrl, Rendered Blog. Sheet Name: Posts Initial Add a dropdown for Status: Pending, Approved, Rejected. Gmail Account**: For sending review and notification emails. LinkedIn Account**: For publishing posts (OAuth credentials needed). Optional**: WordPress.com or Medium account for additional publishing. Customization Guidance Below is a detailed breakdown of each flow and node, including setup instructions. 🔹 Initial Flow: Fetch from RSS Feeds, Prepare, and Send for Review. Purpose: Fetches blog posts from an RSS Feed, formats them, extracts images, stores data, and sends a review email. Fetch from RSS Feed Type: RSS Feed Purpose: Retrieves blog posts from an RSS Feed Configuration: URL: https://example.com/feed (replace with your RSS Feed URL) Limit: 1 (or adjust based on your needs) Setup: Ensure the RSS Feed URL is valid and accessible; test the node to verify it fetches posts Set Fields Type: Set Purpose: Maps RSS Feed data to blog post fields Setup: Adjust field mappings based on your RSS Feed’s structure Format Blog Post for Storage Type: Code Purpose: Cleans up the blog post content. Extract Featured Image Type: Code Purpose: Extracts or generates a featured image URL. Setup: Ensure originalHtml contains image data; otherwise, it uses a placeholder. Store Blog Posts Initial Type: Google Sheets Purpose: Stores initial blog post data Setup: Ensure Google Sheets credentials are set up and the spreadsheet has the required columns. Set Fields for Email Type: Set Purpose: Prepares fields for the review email. Setup: Replace https://your-n8n-instance with your n8n instance URL. Prepare Email HTML Type: Code Purpose: Generates HTML email content with conditional image display Setup: No additional configuration needed Notify for Review (Gmail) Type: Gmail Purpose: Sends a review email with approval/rejection links 🔹 Approval Flow: Handle Review Actions Purpose: Updates the blog post status based on approval/rejection Webhook Trigger Type: Webhook Purpose: Triggers on approval/rejection link clicks Configuration: HTTP Method: GET Path: approve-post Response Code: 200 Response Data: {"message": "Status updated"} Setup: Ensure the webhook URL matches the one in Set Fields for Email Find Row to Update Type: Google Sheets Purpose: Retrieves all rows to find the matching blog post Filter Row by Title Type: Code Purpose: Filters the row matching the blog post title Setup: No additional configuration needed Update Status on Approval Type: Google Sheets Purpose: Updates the status to Approved or Rejected 🔹 Status Update Flow: Publish Approved Posts Purpose: Monitors status changes and publishes approved posts Google Sheets Trigger (Fetch Row) Type: Google Sheets Trigger Purpose: Triggers when a row’s status is updated Configuration: Event: Update Sheet Name: Posts Initial Output Fields: title, status, published, featuredImage, articleUrl Setup: Ensure Google Sheets credentials are set up Router (Check Status) Type: Router Purpose: Routes based on status and published state Configuration: Route 1: Approved and Not Published Condition: status equals Approved AND published equals NO Route 2: Rejected Condition: status equals Rejected Route 3: Pending Condition: status equals Pending Setup: No additional configuration needed Apply Blog Template Store Blog Posts Final Type: Google Sheets Purpose: Stores the final HTML content Configuration: Operation: Update Row Setup: Ensure the Rendered Blog column exists Loop Over Blog Posts Type: Split in Batches Purpose: Processes each blog post individually Configuration: Default settings Setup: No additional configuration needed Delay Between Posts Type: Wait Purpose: Adds a delay to avoid rate limits Configuration: Wait Type: Delay Amount: 1 second Setup: Adjust delay as needed for LinkedIn rate limits Publish to LinkedIn Type: LinkedIn Purpose: Publishes the blog post to LinkedIn Configuration: Operation: Share Post Author: urn:li:person:YOUR_PERSONAL_URN Setup: Set up LinkedIn OAuth credentials and replace YOUR_PERSONAL_URN with your LinkedIn URN Update Published State Type: Google Sheets Purpose: Updates the published status Configuration: Operation: Update Row Setup: Ensure the Published column exists Notify Team Type: Gmail Purpose: Notifies the team of successful publishing Configuration: The blog post "{{ $json.title }}" has been successfully published Setup: Set up Gmail credentials; replace [Link] with the LinkedIn URL if captured Notify Rejection (Gmail) (Route 2) Type: Gmail Purpose: Notifies on rejection The blog post "{{ $json.title }}" has been rejected Suggestions: Rewrite with more engaging content, adjust keywords, or verify facts Please update the status in Google Sheets if you wish to revise and resubmit Setup: Set up Gmail credentials Wait for Status Update (Route 3) Type: Wait Purpose: Delays for status recheck Configuration: Wait Type: Delay Duration: 24h Setup: Adjust delay as needed Conclusion This workflow streamlines blog post management with RSS Feeds, making it ideal for busy content creators and teams. Customize it by adding more platforms adjusting delays, or enhancing notifications. Share your feedback in the n8n community to help others benefit from this automation.

Who Is This For? This workflow is designed for marketers, content creators, agencies, and solo founders who want to publish long‑form posts with visuals on autopilot using n8n and AI agents. ​ Whether you run a blog, SaaS, personal brand, newsletter, or client accounts, this tool helps you keep a consistent content pipeline without manually writing every article, creating images, and posting to each platform one by one. ​ ​ 💪🏼 While the template is wired around classic blog + social media distribution, the underlying logic is universal. You can easily adapt it to any niche by editing prompts, swapping models, and re‑wiring nodes. You can plug in any LLM you like, from ChatGPT to Claude, Gemini, Mistral, DeepSeek, OpenRouter, or even local models through Ollama. ​ What Problem Is This Workflow Solving? 🤯 Most teams waste hours on the same repetitive loop: research a topic, gather links, write a blog post, craft social captions, generate visuals, upload everything to multiple platforms, and archive assets. ​ ​ 💎 This workflow solves that by automating the full content chain—from research and blog‑post generation to image creation, publishing across channels, and logging everything in your content database—so your feeds stay active while you focus on strategy, not busywork. ​ What This Workflow Does ✨ Generates in‑depth blog posts tailored to your topic and target audience, enriched with fresh references from the web via Tavily/SerpAPI search tools. ​ ✨ Creates an image prompt and title from the article, generates the visual with OpenAI Images (gpt-image-1), and converts it into a ready‑to‑use image file. ​ ✨ Automatically publishes content to your connected platforms (WordPress for blog posts, Telegram, X/Twitter, Facebook, LinkedIn) while saving images to Google Drive and logging each publication in Google Sheets for tracking. ​ How It Works? Surprisingly simple ☺️ The workflow is triggered by another n8n workflow or by one of several triggers (Facebook, RSS, Google Sheets, Airtable, Postgres) that pass in the blogTopic, targetAudience, and Telegram chatID. ​ ​ The Blog Post Agent (LLM with access to Tavily/SerpAPI) researches the topic, writes a structured article for the specified audience, and sends its output to the Image Prompt Agent, which turns the content into a visual prompt and title. ​ 🎯 The end result: you provide a topic, run the workflow, and receive a complete blog post, matching image, and ready‑made social posts shipped directly to your channels and archives—no manual copy‑paste. ​ How to Customize This Workflow to Your Needs 🎨 Switch AI models and fine‑tune prompts so the agent can handle your exact formats: tutorials, case studies, listicles, product updates, thought‑leadership pieces, or campaign landing posts. 🔍 Refine research sources inside Tavily/SerpAPI to prioritize the domains, blogs, and docs your audience trusts, keeping posts accurate and up to date. ⏰ Adjust posting cadence and schedules to align with peak engagement for your audience, mixing automated slots with manual “launch” runs for special announcements. 📱 Expand or trim channels as needed: keep just WordPress + LinkedIn, add Telegram as a content feed, or plug the workflow into additional automations like email campaigns or RSS feeds. 📊 Use Google Sheets as your content hub to store ideas, angles, CTAs, references, and performance notes so you can double‑down on topics and formats that perform best. 🎬 Swap images for video by replacing the image generation node with video tools (for example, Runway‑style APIs) if your strategy is video‑first while keeping the same prompt pipeline. 💾 Build a reusable prompt library in Sheets, Notion, or Airtable so you can rotate proven prompt patterns each month and keep quality high without reinventing the wheel. 🤖 The system will continuously generate blog posts, visuals, and social updates and publish them across your selected platforms while archiving everything in Drive and Sheets—keeping your brand visible, consistent, and professional with minimal ongoing effort.

Who's it for This workflow is ideal for: Content creators who want to replicate successful LinkedIn strategies Social media managers monitoring competitor content performance Marketing teams analyzing trending topics in their industry Personal brands looking to create data-driven content Agencies managing multiple LinkedIn accounts What it does This comprehensive workflow automates the entire LinkedIn content lifecycle: it scrapes viral posts from target accounts, analyzes engagement patterns, identifies trending topics, generates original AI-powered content based on those trends, creates accompanying images, and automatically publishes to your LinkedIn profile or company page. How it works Phase 1: Data Collection (Runs every 12 hours) Scheduler triggers the workflow twice daily Fetches LinkedIn profile URLs from Google Sheets Processes profiles in batches of 3 to respect API limits Uses Apify API to scrape recent posts from each profile Adds 3-second delays between requests to avoid rate limiting Filters for high-engagement posts (20+ likes, comments, or reposts) Saves viral posts to Google Sheets with full metadata Phase 2: Content Generation (Triggered by new data) Monitors Google Sheets for new viral posts every minute Filters posts published within the last 3 days that haven't been analyzed Aggregates trending content into a single dataset Analyzes patterns using Google Gemini AI to identify: Common themes and topics Engagement triggers and hooks Successful content structures Trending hashtags and formats Generates original LinkedIn post with proper formatting Creates AI image prompt optimized for minimal text Generates professional image using Google Imagen Publishes complete post to your LinkedIn account Marks analyzed posts as complete to prevent duplication Setup steps Configure Google Sheets Create a new Google Sheet with two tabs: Tab 1: "usernames & links" - Add LinkedIn profile URLs you want to monitor Tab 2: "scrape data" - Leave empty (auto-populated by workflow) Connect your Google Sheets credentials in both nodes Replace all instances of YOUR_GOOGLE_SHEET_ID with your actual sheet ID Replace SHEET_GID values with your actual sheet GIDs Set up Apify API Sign up for Apify account and get API token Replace YOUR_APIFY_API_TOKEN in "Scrape LinkedIn Posts API" node Note: Apify has free tier with limited requests Configure Google Gemini credentials Obtain Google PaLM API credentials Add credentials to both "Google Gemini Chat Model" and "Generate an image" nodes Set up LinkedIn publishing Connect your LinkedIn credentials in "Publish to LinkedIn" node If posting as organization, replace YOUR_LINKEDIN_ORGANIZATION_ID with your company page ID If posting as individual, change "postAs" parameter to "person" Configure scheduling Default schedule: every 12 hours Adjust "LinkedIn Content Automation Scheduler" trigger if needed Consider your API rate limits when changing frequency Test the workflow Manually trigger Phase 1 to scrape posts Verify data appears in Google Sheets "scrape data" tab Wait for Phase 2 trigger or manually activate it Check that content is generated and published correctly Verify posts are marked as analyzed in Google Sheets Requirements Google Sheets API access (free) Google Sheets Trigger OAuth2 (free) Apify API token (free tier available, $49/month for more) Google PaLM/Gemini API key (pay-per-use pricing) LinkedIn OAuth credentials (free) How to customize Adjust scraping targets: Add more LinkedIn profile URLs to your Google Sheets Change batch size in "Process Profiles in Batches" (default: 3) Modify post limit per profile in Apify API call (default: 1 post) Modify engagement filters: Edit "Filter High-Engagement Posts" node thresholds Default: 20+ likes OR 20+ comments OR 20+ reposts Adjust based on your niche's typical engagement rates Add additional criteria like views or impressions Customize content analysis window: Change "Filter Recent Posts (3 Days)" to analyze different timeframes Options: 24 hours for fast-moving trends, 7 days for broader patterns Balance between recency and data volume Refine AI content generation: Edit system prompt in "LinkedIn Content Strategy AI" node Adjust content length, tone, or style preferences Add industry-specific guidelines Include brand voice requirements Modify hashtag strategy Customize image generation: Edit image prompt structure in AI prompt Change visual style, colors, or composition Adjust for brand guidelines Modify dimensions or aspect ratios Change posting schedule: Adjust "LinkedIn Content Automation Scheduler" frequency Consider optimal posting times for your audience Balance between content quality and posting frequency Coordinate with other marketing activities Enhance data collection: Increase posts per profile in Apify settings Add more profile URLs to monitor Implement competitor tracking Track additional metrics like impressions or click-through rates Add notifications: Connect Slack/Email nodes after successful posts Set up alerts for high-performing content Create reports of analyzed trends Monitor API usage and errors

How This LinkedIn Automation Workflow Helps You: Save time - Eliminate manual LinkedIn posting and content scheduling tasks Stay consistent - Automated daily posting keeps your LinkedIn profile active and engaging Keep control - Preview every post before it goes live via Telegram approval system Track everything - Complete posting history and status tracking in Google Sheets dashboard Never double-post - Smart status tracking prevents duplicate content and posting errors Scale content - Manage multiple posts in advance through organized spreadsheets Professional workflow - Streamlined process perfect for social media agencies and content creators Reduce errors - Automated file handling eliminates manual upload mistakes How This LinkedIn Auto-Posting System Works: Setup your content in Google Sheets with captions and Google Drive image URLs Schedule runs daily at your chosen time (default 4 PM) automatically via n8n Finds next eligible post with empty posting status column using smart filtering Downloads image directly from your Google Drive storage securely Sends Telegram preview with image and caption for manual approval Posts to LinkedIn immediately if approved, or marks as declined in database Updates sheet status automatically to "Posted" or "Declined" with timestamps Sends confirmation message to Telegram with posting results and analytics Requirements: Google Sheets with organized post content and image URLs Images stored in Google Drive for reliable access Telegram bot configured for approval notifications LinkedIn business account connected to n8n platform Here is how your google sheet look like

Altcoin News to LinkedIn Posts with DeepSeek AI & Google Sheets Automate your daily crypto content creation and publishing using this n8n workflow. This automation fetches the latest altcoin news from an RSS feed, rewrites it into LinkedIn-style posts using DeepSeek AI, stores it in Google Sheets, and schedules it for publishing—completely hands-free. 🔧 Prerequisites n8n instance (cloud or self-hosted) DeepSeek AI or OpenAI API key Google account with Sheets API enabled RSS feed URL of your preferred altcoin news source (Optional) LinkedIn API or scheduling tool ⚙️ Workflow Breakdown Fetch RSS Feed – Retrieve altcoin news articles. Filter Articles – Only select posts from today and containing keywords like "altcoin", "crypto", "defi", etc. Rewrite with DeepSeek – Convert article into a LinkedIn-style post using a prompt template (includes Hook, Body, CTA). Store in Google Sheets – Save the generated content into your sheet. Post to LinkedIn (optional) – Schedule or publish via LinkedIn API or integration. Setup Connect RSS Feed: Set up the CoinDesk RSS feed to be fetched automatically. API Keys: Add your DeepSeek AI API key to enable content generation. Google Sheets: Link your Google Sheet to store both raw RSS data and AI-generated LinkedIn posts. Scheduling: Set the time intervals for when the posts will be scheduled (e.g., every 6 hours). Customization Instructions **Change RSS Feed URL: ** Open the Fetch RSS Feed node. Replace the current URL with your new RSS feed URL in the "URL" field. **Change GPT Model: ** Open the DeepSeek Chat Model node. Find the "Model" field and select your preferred model (e.g., gpt-4). **Change Prompt: ** Open the DeepSeek Chat Model node. Edit the prompt text in the "Prompt" field to customize the tone, content, or keywords. **Change Wait Time: ** Open the Schedule Tweet node. Adjust the "Wait Time" (in seconds) to your desired interval: For 6 hours: 21600 For 1 hour: 3600 For 30 minutes: 1800 For 15 minutes: 900

How it works This workflow fetches the latest blog post from a WordPress API and checks against a Google Sheets tracker to prevent duplicate processing. If a new post is found, the workflow updates the tracker and cleans the blog data. The cleaned content is then sent to a Gemini-powered AI agent to generate a newsletter and LinkedIn teaser. Finally, the workflow distributes the content via LinkedIn and Gmail to subscribers. Step-by-step Detect new blog content** Schedule Trigger – Runs the workflow automatically at intervals. HTTP Request – Fetches the latest blog post from WordPress. Last ID – Retrieves the last processed blog ID from Google Sheets. If – Compares IDs to check if the blog is new. Update Last ID – Updates the sheet with the latest blog ID. Clean and generate AI content** data cleanse – Cleans HTML, extracts title, content, and image. AI Agent2 – Generates newsletter and teaser content. Google Gemini Chat Model – Provides AI model for content generation. Distribute content across channels** Format Response – Parses and structures AI output. Create a post – Publishes content on LinkedIn. Email List – Fetches subscriber emails from Google Sheets. Loop Over Items – Iterates through each recipient. Send Email – Sends HTML newsletter via Gmail. Why use this? Automates end-to-end blog promotion workflow Prevents duplicate publishing using ID tracking Uses AI to generate engaging content instantly Saves time on manual posting and emailing Easily scalable for growing audiences

Who is this for? This workflow is designed for content creators, social media managers, digital marketers, and business owners who want to automate their LinkedIn content creation and publishing process. It's especially valuable for those who struggle with consistently creating engaging content or want to maintain a regular posting schedule without manual effort. What this Workflow Does / Key Features Automatically runs every 6 hours to generate and post LinkedIn content Retrieves content topics from a Google Sheet that haven't been processed yet Uses AI to research trending topics and create detailed content frameworks Generates engaging LinkedIn post content based on those topics Creates professional images to accompany posts using AI Develops optimized hashtags to improve post visibility Posts the complete content package to both LinkedIn profiles and company pages Updates the Google Sheet to track which topics have been processed Requirements Google Sheets OAuth2 API credentials for accessing your content spreadsheet LinkedIn OAuth2 API credentials for posting to profiles and pages OpenAI API credentials for content generation and image creation Google Gemini (PaLM) API credentials for AI processing Mistral Cloud API credentials for trend analysis A Google Sheet with specific columns: SL, Topic, Status, row_number Workflow Components Explained Schedule Trigger**: Automatically starts the workflow every 6 hours Get row(s) in sheet**: Retrieves topics from your Google Sheet that haven't been processed Loop Over Items**: Processes topics one at a time to avoid overwhelming the system Content topic generator**: Creates detailed content topics with titles, rationale, and hooks AI Agent Tool**: Gathers trending topics from external sources Content creator**: Writes the actual LinkedIn post content based on the topic OpenAI**: Creates images to accompany the LinkedIn posts SEO**: Generates relevant hashtags for the LinkedIn posts Merge**: Combines the post content, image, and hashtags into a single package LinkedIn page & LinkedIn profile**: Posts the content to both a LinkedIn company page and personal profile Update row in sheet**: Marks the processed topic as "checked" in the Google Sheet Support & Help For n8n workflow questions: n8n Community For LinkedIn API issues: LinkedIn Developer Portal For Google Sheets integration: Google Sheets API Documentation Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

This n8n template shows how to fully automate your social media workflow from Google Sheets to X, Threads, LinkedIn, Facebook, and Instagram — with AI-generated visuals. Instead of manually writing, designing, and posting content, this workflow turns a single Google Sheet row into multi-platform posts plus a custom AI image that matches your message. You write once. n8n posts everywhere. How it works A scheduled trigger checks your Google Sheet for content marked “Ready To Post.” The post text is pulled from Sheets and sent to all text-only platforms (X and Threads). At the same time, an AI agent analyzes your post and generates a high-quality image prompt. GPT-Image creates a custom visual based on that prompt. The image is uploaded to ImgBB to create a shareable URL. That image + your caption are automatically posted to LinkedIn, Facebook, and Instagram. Finally, your Google Sheet is updated so you never repost the same content twice. How to use Add your posts to Google Sheets in the Content column. Set Status = Ready To Post when you want it published. Make sure all platform credentials are connected in n8n. Turn the workflow on and let it run automatically. What you get Hands-free posting to 5 platforms AI-generated visuals for every post Zero manual design work Built-in error handling No duplicate posts Requirements Google Sheets access X (Twitter) account Threads account LinkedIn account Facebook & Instagram Page access ImgBB account OpenAI credentials for image generation Need help? Ask in the n8n Forum or shoot me a DM on LinkedIn Happy automating 🚀

Description Automate LinkedIn organization page posting with precise time scheduling and Google Drive media management. Runs hourly during business hours, processes approved posts scheduled for today, waits until exact time, publishes to LinkedIn, and updates tracking sheet—perfect for maintaining consistent LinkedIn presence. What this workflow does This workflow automates LinkedIn organization page posting with precise timing control and a centralized Google Sheets content calendar. It runs four times daily (9:45 AM, 10:45 AM, 11:45 AM, 12:45 PM) and reads your Google Sheet to find posts marked with Approval Status = "Good" and Platform = "LinkedIn" that are scheduled for today. Unlike batch processing workflows, this processes ONE post per run to prevent duplicate scheduling. Once it finds a post, it marks it as "Scheduled" in your sheet, then uses a Wait node to pause the workflow execution until the exact scheduled time (with automatic timezone conversion from Eastern to India time). At the scheduled moment, it either downloads an image from Google Drive and publishes a Creative Post, or publishes an Article link—depending on the Post Type. After successfully publishing to your LinkedIn organization page, it updates your Google Sheet with the live post URL and changes the Approval Status to "Published", creating a complete audit trail with precise timing control. Perfect for social media managers maintaining consistent LinkedIn presence, marketing agencies scheduling client LinkedIn content with approval checkpoints, content creators batch-planning professional posts, and teams needing collaborative LinkedIn calendars with exact time control. Key features Precise time scheduling with Wait node: Unlike immediate publishing, this workflow uses n8n's Wait node to pause execution until the exact scheduled time—ensuring posts publish at 10:00 AM sharp, not 9:45 AM when the workflow runs. Timezone conversion included: Automatically converts "Scheduled On" times from Eastern Time (content creator's timezone) to India Time (server timezone) using DateTime.fromFormat—no manual calculation needed. One post per run: Processes only the first pending post each time the workflow runs, preventing duplicate scheduling if multiple posts share the same time slot—ensures clean execution and tracking. Dual post type support: Handles both Creative Posts (image posts downloaded from Google Drive) and Articles (link posts with article URL)—automatically routes based on Post Type column. LinkedIn organization posting: Posts directly to your LinkedIn organization/company page (not personal profile) using LinkedIn Community Management API with proper OAuth authentication. Status progression tracking: Three-stage workflow: Good (approved) → Scheduled (waiting for time) → Published (live on LinkedIn)—always know what's queued vs. what's live. Google Sheets content calendar: Manage LinkedIn posts in a familiar spreadsheet with columns for Scheduled On, Platform, Post Type, Caption, Media URL, and Approval Status—no complex tools needed. Google Drive media integration: Stores images in Google Drive (centralized storage), then automatically downloads them when publishing Creative Posts—supports shared drives and private files. Post URL tracking: After publishing, updates Google Sheet with the live LinkedIn post URL (https://www.linkedin.com/feed/update/{urn})—enables easy performance tracking and reporting. Runs during business hours only: Schedule trigger fires at :45 minutes (9-12 AM) to catch morning posts—won't run at night or on weekends unless you modify the cron. How it works Hourly trigger during business hours A cron trigger runs at 9:45 AM, 10:45 AM, 11:45 AM, and 12:45 PM every day. The :45 timing gives a 15-minute buffer before the hour to schedule posts for :00, :15, :30, or :45 times. Load LinkedIn credentials The workflow reads a separate ".env" sheet in your Google Sheets document containing: LinkedIn Organization ID:** Your company page's unique ID (e.g., 56420402) Other LinkedIn-specific configuration This centralizes credentials so multiple workflows can share the same settings. Fetch approved LinkedIn posts The workflow reads your main "Post URL" sheet and applies two filters: Approval Status = "Good":** Only processes approved posts Platform = "LinkedIn":** Filters out Facebook, Instagram, etc. This returns all approved LinkedIn posts regardless of date. Filter posts scheduled for today A Code node compares the "Scheduled On" column value against today's date (ignores time, just checks the date part). Only posts scheduled for today pass through. Supported date format: "2025-10-30 10:00" (YYYY-MM-DD HH:MM) Time uses 24-hour format Process first post only Critical difference from Facebook workflow: A Code node extracts only the FIRST item from the filtered posts. Why only one post? Prevents duplicate scheduling if workflow runs multiple times Wait node works on single execution paths Ensures precise timing per post Next run will pick up the next pending post Route by post type A Switch node checks the Post Type column: Output 0 (Creative Post):** Posts with images (routes to Branch A) Output 1 (Article):** Posts with article links (routes to Branch B) Branch A: Creative Post with Image 7a. Mark as scheduled in sheet Before waiting, the workflow updates the Google Sheet: Approval Status:** "Scheduled" This prevents the same post from being picked up again in the next hourly run. 8a. Wait until scheduled time Most critical node: The Wait node pauses workflow execution until the exact scheduled time. Timezone conversion logic: DateTime.fromFormat( $('Route by Post Type').item.json['Scheduled On'], 'yyyy-MM-dd HH-mm', { zone: 'America/New_York' } // Input timezone (Eastern) ) .setZone('Asia/Kolkata') // Server timezone (India) .toFormat("yyyy-MM-dd'T'HH:mm:ss") Example: Sheet value: "2025-10-30 14:00" (Eastern Time) Converted to: "2025-10-30T23:30:00" (India Time) Workflow resumes at exactly 11:30 PM India time = 2:00 PM Eastern 9a. Prepare post data Aggregate node (keeps data structure intact for next nodes). 10a. Download image from Google Drive Uses the Media URL (Google Drive sharing link) to download the image file. Supports: Direct Google Drive file URLs Shared Drive files Public or private files (as long as OAuth account has access) The image is downloaded as binary data. 11a. Publish creative post to LinkedIn Uses n8n's LinkedIn node with these settings: Authentication:** communityManagement (LinkedIn Community Management API) Post as:** organization Organization:** 56420402 (your company page ID) Text:** Caption from Google Sheet Share media category:** IMAGE Binary data:** Downloaded image The LinkedIn API returns a URN (unique post identifier). 12a. Save post URL & mark published Constructs the LinkedIn post URL: https://www.linkedin.com/feed/update/{urn} Then updates the Google Sheet row: Approval Status:** "Published" Post URL:** Constructed LinkedIn URL Branch B: Article Post with Link 7b. Mark article as scheduled Updates Google Sheet: Approval Status = "Scheduled" 8b. Wait until article scheduled time Same Wait node logic as Creative Posts—pauses until exact scheduled time with timezone conversion. 9b. Prepare article data Aggregate node. 10b. Publish article link to LinkedIn Uses LinkedIn node with these settings: Authentication:** communityManagement Post as:** organization Organization:** 56420402 Text:** Caption from Google Sheet Share media category:** ARTICLE Original URL:** Media URL (the article link) LinkedIn scrapes the article URL and creates a rich preview card. 11b. Save article URL & mark published Same as Creative Posts—constructs post URL and updates sheet with "Published" status. Setup requirements Tools you'll need: Active n8n instance (self-hosted or n8n Cloud) Google Sheets with OAuth access Google Drive with OAuth access LinkedIn organization/company page (not personal profile) LinkedIn Community Management API credentials Estimated setup time: 35–40 minutes Configuration steps Set up LinkedIn Community Management API Go to LinkedIn Developer Console Create an app (or use existing) Add "Community Management API" product Request access for your organization page Under Auth → OAuth 2.0 settings: Add redirect URL: https://your-n8n-instance.com/rest/oauth2-credential/callback Note your Client ID and Client Secret In n8n: Credentials → Add credential → LinkedIn Community Management OAuth2 API Complete OAuth flow and select your organization page Find your LinkedIn Organization ID Method 1 (URL): Go to your LinkedIn company page URL will be: https://www.linkedin.com/company/{company-name}/ View page source and search for "organizationId" Copy the numeric ID (e.g., 56420402) Method 2 (API): Use LinkedIn API endpoint: /v2/organizationalEntityAcls?q=roleAssignee Find your organization in the response Set up Google Sheets Create two sheets in one Google Sheets document: Sheet 1: ".env" (credentials) | LinkedIn Organization ID | |---| | 56420402 | Sheet 2: "Post URL" (content calendar) | Scheduled On | Platform | Post Type | Caption | Media URL | Approval Status | Post URL | row_number | |---|---|---|---|---|---|---|---| | 2025-10-30 10:00 | LinkedIn | Creative Post | Excited to announce our new product! | https://drive.google.com/file/d/xxx | Good | | 1 | | 2025-10-30 14:00 | LinkedIn | Article | Check out our latest blog post | https://blog.example.com/post | Good | | 2 | Important column details: Scheduled On:** Format YYYY-MM-DD HH-MM (24-hour, Eastern Time) Platform:** Must be "LinkedIn" (case-sensitive) Post Type:** "Creative Post" (with image) or "Article" (with link) Caption:** Post text (LinkedIn supports up to 3,000 characters) Media URL:** Google Drive URL for Creative Post, article URL for Article Approval Status:** "Good" (publish), "Pending" (hold), "Rejected" (skip) Post URL:** Leave empty (auto-filled after publishing) row_number:** Auto-generated by Google Sheets Connect Google Sheets OAuth In n8n: Credentials → Add credential → Google Sheets OAuth2 API Complete OAuth authentication Update these nodes with your sheet URL: "Load LinkedIn Organization Credentials" → .env sheet "Fetch Approved LinkedIn Posts" → Post URL sheet "Mark as Scheduled in Sheet" → Post URL sheet "Save Post URL & Mark Published" → Post URL sheet "Mark Article as Scheduled" → Post URL sheet "Save Article URL & Mark Published" → Post URL sheet Connect Google Drive OAuth In n8n: Credentials → Add credential → Google Drive OAuth2 API Complete OAuth authentication Open "Download Image from Google Drive" node Select your Google Drive credential Update LinkedIn Organization ID Open these nodes and replace "56420402" with your organization ID: "Publish Creative Post to LinkedIn"** "Publish Article Link to LinkedIn"** Adjust timezone (if needed) If your content calendar uses a different timezone than Eastern: Open "Wait Until Scheduled Time" node Change { zone: 'America/New_York' } to your timezone Common values: 'America/Los_Angeles' (Pacific), 'UTC', 'Europe/London' If your n8n server is not in India Time: Change .setZone('Asia/Kolkata') to your server's timezone Test the workflow Add a test post scheduled for 5 minutes from now Set Platform = "LinkedIn", Post Type = "Creative Post", Approval Status = "Good" Manually trigger the workflow (or wait for next hourly run) Verify: Sheet updated to "Scheduled" Workflow execution shows as "Waiting" in n8n At scheduled time, post publishes to LinkedIn Sheet updated to "Published" with URL Activate the workflow Toggle the workflow to Active The workflow will now run automatically 4 times daily Check your LinkedIn page to verify posts are publishing correctly Use cases Social media managers: Schedule 15-20 LinkedIn posts per week from one Google Sheet. Team members add content, you approve, workflow handles precise timing and publishing—no manual LinkedIn.com logins. B2B marketing teams: Maintain consistent LinkedIn company page presence with thought leadership articles, product updates, and team highlights. Schedule weeks in advance, let automation publish at optimal times. Content creators: Batch-create LinkedIn content on Mondays, schedule throughout the week with precise timing. Focus on creation, not distribution—workflow handles publishing. Agencies managing client pages: One Google Sheet per client, separate workflows per organization ID. Centralized content calendar with approval workflow before posting to client pages. Recruiting teams: Schedule hiring posts, culture updates, and employee spotlights to maintain active company presence. Track all post URLs for performance analysis. Personal brands using company pages: If you manage a LinkedIn company page for your personal brand or business, schedule promotional content, case studies, and announcements with professional timing control. Customization options Process multiple posts per run Change "Process First Post Only" node logic: Current: Returns only item 0 Modified: Return all items (use Loop node to process sequentially) Note: Wait nodes won't work with loops—consider using scheduled_publish_time if LinkedIn API supports it Change scheduling frequency Edit the "Run Every Hour" cron expression: Current: 45 9-12 * * * (9:45-12:45 AM hourly) All day: 45 * * * * (every hour at :45) Business hours extended: 45 9-17 * * 1-5 (9 AM-5 PM, Monday-Friday) Twice daily: 0 9,15 * * * (9:00 AM and 3:00 PM) Add video post support LinkedIn supports video posts via Community Management API: Add "Post Type" = "Video" Download video from Google Drive (instead of image) Change share media category to VIDEO Upload video to LinkedIn media upload endpoint first, then create post Support personal profiles If you want to post to personal profiles (not organization): Change authentication from "communityManagement" to "oAuth2" Change "Post as" from "organization" to "person" Use LinkedIn OAuth2 API credentials (not Community Management) Add Slack notifications After publishing nodes, add: Slack node** to send confirmation Format:** "Published LinkedIn post: [URL] at [time]" Include:** Post caption preview for context Multi-organization support Modify .env sheet to support multiple company pages: | Organization Name | LinkedIn Organization ID | |---|---| | Main Brand | 56420402 | | Sub Brand | 78901234 | Add "Organization Name" column to Post URL sheet, then filter and route by organization. Troubleshooting Posts not publishing OAuth expired:** Re-authenticate LinkedIn Community Management API credentials in n8n. Organization permissions:** Verify your LinkedIn account has admin/content creator role on the organization page. API access:** Ensure your LinkedIn app has Community Management API product added and approved. Organization ID wrong:** Double-check the ID matches your actual company page. Wait node not working Scheduled time in past:** n8n Wait node requires future times. If "Scheduled On" is in the past when workflow runs, it fails. Ensure posts are scheduled for future times only. Timezone mismatch:** If posts publish at wrong times, verify timezone conversion is correct (Eastern → your server timezone). DateTime format error:** Ensure "Scheduled On" uses exactly "YYYY-MM-DD HH-MM" format with space between date and time. Images not downloading from Google Drive OAuth expired:** Re-authenticate Google Drive credentials. File permissions:** Ensure the Google account connected to n8n has "Viewer" access to Drive files. Sharing link format:** Media URL must be full Google Drive URL (https://drive.google.com/file/d/FILE_ID/view), not shortened. Multiple posts with same time Current limitation:** This workflow processes ONE post per run. If multiple posts share the same scheduled time, only the first will publish. Solution:** Stagger times by 1 minute (10:00, 10:01, 10:02) or modify workflow to process multiple posts. Sheet not updating OAuth expired:** Re-authenticate Google Sheets credentials. Sheet name mismatch:** Verify sheet tab name is exactly "Post URL" and ".env" (case-sensitive). row_number missing:** Ensure the sheet has a row_number column auto-generated by formula: =ROW()-1 Article previews not showing URL not accessible:** LinkedIn needs to scrape the article URL. Ensure it's publicly accessible (not behind login/paywall). No Open Graph tags:** Article pages need Open Graph meta tags (og:title, og:description, og:image) for LinkedIn to generate previews. LinkedIn cache:** Sometimes LinkedIn caches old previews. Use LinkedIn Post Inspector to refresh cache. Resources n8n documentation LinkedIn Community Management API LinkedIn OAuth Guide Google Sheets API Google Drive API n8n Wait node n8n LinkedIn node Support Need help or custom development? 📧 Email: [email protected] 🌐 Website: https://isawow.com/

Who it's for This n8n workflow is designed for content creators, digital marketers, and social media managers who want to automate their entire content creation and publishing process across multiple platforms. It provides a complete end-to-end system capable of taking a single specific idea and automatically generating a full piece of content from it—complete with images, translations, and platform-optimized formatting. The workflow then publishes the final content to WordPress, Facebook, LinkedIn, and Telegram. Features Multi-platform publishing:** WordPress, Facebook, LinkedIn, Telegram AI-powered content generation using OpenAI (LangChain):* Can generate a full article or content piece from a single specific idea or topic* Multi-language support:** Automatic translation via Google Translate API Automatic image processing:** Resizing, optimization, and WordPress upload Google Sheets integration:** For topic management, content queueing, and status tracking Notifications:** Send updates via Discord, Telegram, WhatsApp, and Gmail Flexible workflow triggers:** Supports both manual form submissions and automated scheduled publishing Requirements OpenAI API access for content generation Google Translate API credentials WordPress API access Social media API credentials (Facebook, Telegram, LinkedIn) Google Sheets OAuth2 credentials Google Drive access for image storage Configure Credentials Google APIs**: Configure Google Sheets, Google Drive, and Google Translate with proper OAuth2 credentials OpenAI API**: Set up with appropriate model access (gpt-4.1-mini) WordPress API**: Configure with your WordPress site credentials Social Media APIs**: Set up each platform with proper API keys and target IDs Notification Services**: Configure each service with proper API keys and target IDs Important Notes Form captures topic, type, user, word count, company info, domain, language, and image AI content generation uses customizable prompts Images resized up to 5000x5000 px before upload Content can be translated via Google Translate API Workflow publishes text and image posts across platforms Google Sheets tracks content status in real-time Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Social Media Posting Automation with Image and Caption How it works This AI-powered workflow streamlines your social media posting process, transforming hours of manual caption writing, image uploading, and scheduling into a fully automated system. You define the topic and image once, and the workflow handles caption generation, review, approval, and posting to your selected platforms. Automated Flow Generate Caption Trigger the workflow manually and set your post topic and image URL in the Set node. The AI (GPT-4.1-mini) generates a high-quality, engaging social media caption tailored to your audience, platform, and content goals. Store in Google Sheet The generated caption, along with your image URL and post metadata, is automatically appended to your Google Sheet. This creates a central location to review and manage all your social media content. Review and Approve You review the generated caption in the sheet, make any edits if needed, and update the status to Approved. You can also select the platform(s) where you want to post. Automatic Posting Once the status is updated to Approved, the next workflow is triggered automatically. It posts your caption and image to the selected social media platform(s) without any further manual effort. The result? A seamless, end-to-end social media posting process where captions are AI-generated, stored, reviewed, and posted automatically. Focus on strategy and engagement instead of repetitive manual posting. Setup Steps Setup time: ~10–15 minutes What you’ll need: OpenAI API key, Google account, access to your social media platform(s) Connect Your Google Account Click on the Google Sheets node in your workflow. Select the Credential dropdown and choose + Create New Credential. Authenticate your Google account and grant the necessary permissions. Initialize Your Spreadsheet Run the workflow once by clicking the play button on the start node. This will automatically create a Google Sheet with all the required columns for caption tracking and approval. Add Your OpenAI API Key Navigate to the AI Agent node. Click the Credential dropdown and select + Create New Credential. Paste your OpenAI API key and save. Get your API key from platform.openai.com/api-keys. Set Post Topic and Image Update the title in the Set node with the topic you want to post. Add the image URL associated with your post. Review Captions and Approve Open your Google Sheet, review the generated captions, and update the status to Approved. Select the platform(s) where the post should go live. Go Live Once the status is updated, the workflow will automatically post your content to the selected social media platform(s). Sit back and watch your AI-generated captions and images go live automatically. Ready to automate your social media? Activate your workflow and start posting smarter today! 🚀💡✅

Schedule and optimize social media posts to Twitter and LinkedIn using AI This workflow automates the entire lifecycle of social media management—from fetching draft content to AI-driven optimization and multi-platform publishing. Who’s it for Social media managers, marketing teams, and content creators who use Google Sheets to plan their content but want to leverage AI for better engagement and automate the repetitive task of cross-platform posting. How it works The workflow is triggered either hourly or manually via a webhook. It fetches scheduled content from a designated Google Sheet and identifies posts ready for publication. An AI Agent (OpenAI) then analyzes the raw content to generate two optimized versions: a punchy, character-limited post for Twitter and a more professional, detailed version for LinkedIn. After generating relevant hashtags and engagement tips, the workflow publishes the posts simultaneously. Finally, it logs the live URLs back to your spreadsheet and sends a performance summary to a Slack channel for easy tracking. How to set up Google Sheet: Create a sheet with columns for status, content, platforms, scheduled_time, hashtags, and tone. Credentials: Connect your Google Sheets, OpenAI, Twitter (X), LinkedIn, and Slack accounts. Node Configuration: Select your specific spreadsheet and worksheet in both the "Fetch Content" and "Update Content" nodes. Slack: Specify the channel name or ID in the Slack node to receive notifications. Activation: Test with the Manual Webhook, then toggle the workflow to "Active." Requirements Google Sheets OAuth2** OpenAI API Key** (using GPT-4o-mini or higher) Twitter (X) OAuth2** LinkedIn OAuth2** Slack Bot Token** How to customize the workflow AI Tone**: Modify the "System Message" in the AI Content Optimizer node to match your brand's unique voice. Additional Platforms**: Extend the branching logic after the AI Parse node to include platforms like Discord, Facebook, or Mastodon. Advanced Scheduling**: Adjust the Filter node's JavaScript code if you use a different date format or status labels in your spreadsheet.

📌 Workflow Overview This workflow enables multi-platform social media posting using Google Sheets as the control center. Whenever a new row is added to the sheet, the workflow automatically posts the content to Instagram, Facebook, and/or LinkedIn based on platform flags, then updates the post status to prevent duplicates. Supported Platforms Instagram (Business) Facebook Pages LinkedIn Pages 🧠 Key Concept Google Sheets acts as a lightweight CMS and automation trigger. Each row represents one post, and simple TRUE/FALSE columns decide where that post should be published. 📄 Required Google Sheets Columns The content sheet must include the following columns: Content** – Text to publish Instagram** – TRUE / FALSE Facebook** – TRUE / FALSE LinkedIn** – TRUE / FALSE Status** – Updated after posting Row Number** – Used for precise updates ⚙️ How This Workflow Works 1️⃣ Trigger: New Content Added The workflow starts when a new row is added to Google Sheets. This allows near real-time publishing without manual execution. 2️⃣ Configuration Setup Platform-specific values like: Instagram Business Account ID Facebook Page ID Are defined once in a configuration node for easy reuse and maintenance. 3️⃣ Platform Routing Logic IF nodes check each platform column: Instagram = TRUE → post to Instagram Facebook = TRUE → post to Facebook LinkedIn = TRUE → post to LinkedIn One row can trigger posting to multiple platforms. 4️⃣ Platform Posting Posts are published using: Facebook Graph API (Instagram + Facebook) LinkedIn API (LinkedIn Pages) The Content column is used directly as the post body. 5️⃣ Status Update (Per Platform) After posting: The workflow updates the same row using Row Number Marks the post as completed for that platform This prevents duplicate or accidental re-posts. 🔄 Current Capabilities Multi-platform posting from one sheet Platform-specific routing logic Real-time execution on new content Safe status updates using row matching 🚀 Designed for Easy Expansion This workflow is intentionally modular and can be extended with: Scheduled posting (date/time columns) Image & media handling AI-generated captions Hashtag optimization Engagement analytics Retry & error handling logic ✅ Best Practices Use TRUE / FALSE consistently in platform columns Keep Google Sheets as the single source of truth Add validation or approval columns if used by teams 📦 Ideal Use Cases Social media managers Marketing teams Founders & creators Agencies handling multiple platforms This workflow provides a scalable foundation for social media automation while remaining simple, transparent, and easy to maintain.

✅ What problem does this workflow solve? Managing content for multiple social media platforms manually is time-consuming and error-prone. This workflow automates content creation, image generation, approval flows, and publishing for LinkedIn, Twitter (X), and Instagram using AI—while still keeping human oversight in place. 💡 Main Use Cases 📝 Automatically generate AI-powered social media content and images. 🧠 Create platform-specific posts for LinkedIn, Twitter (X), and Instagram. ✅ Route each post through human approvals—first for prompt, then for final content. 📤 Publish approved posts to all platforms seamlessly. 📊 Maintain an audit trail with all steps logged in Google Sheets. 🧠 How It Works – Step-by-Step ✍️ Topic Input A new topic and description is added to a Google Sheet. A scheduled trigger starts the automation at regular intervals (daily, weekly, etc.). 🧠 AI-Powered Prompt Generation AI generates tailored prompts for each platform: LinkedIn Twitter (X) Instagram Prompts are logged in the sheet and paused for human approval. 🖼️ Content + Image Creation (Post Drafts) Once approved, the workflow: Uses AI to write full post captions Generates platform-specific images (via DALL·E, Stable Diffusion, or other AI image tools) Draft content is stored in Google Sheets. 🧑‍💻 Final Content Approval Posts pause again for final manual approval. If approved → move to publishing. If rejected → status updated in the sheet, post is skipped. 📤 Auto-Publishing to Social Platforms Approved content is published automatically: ✅ LinkedIn – via LinkedIn API 🐦 Twitter (X) – post text + media via Twitter API 📸 Instagram – via Meta Graph API (image + caption) 📊 Logging & Reporting Google Sheets is updated with: Final post text Approval timestamps Post URLs Status (Posted / Rejected) 🔧 Tools & Integrations Used OpenAI / GPT-4** – for prompt and content generation AI Image Generator** – DALL·E, Replicate, etc. Google Sheets** – as the central control + approval hub LinkedIn API** Twitter API (X)** Instagram Graph API** n8n Scheduler, If Nodes, and Pauses** – to handle flow control & approvals 👤 Who can use this? This is perfect for: 📢 Marketing teams 🧑‍💼 Solo founders managing content 🧠 Agencies offering social media management ⚙️ Ops teams building internal automation Whether you're managing 3 posts a week or 30, this system keeps your content AI-powered and human-approved—on autopilot. 🛠 Customization Ideas Add Slack or email alerts for approval stages Pull trending topics using a news API or Twitter Trends Add a weekly content summary report sent via email Expand to Facebook, Threads, or Pinterest 🚀 Ready to Launch? Just configure: ✅ Google Sheet with topic list & approval columns ✅ API credentials for LinkedIn, Twitter, and Instagram ✅ OpenAI and image generation API keys …and your fully automated, human-approved social content engine is ready to go!

This workflow automates the post-publish process for YouTube videos, combining advanced SEO optimization, cross-platform promotion, and analytics reporting. It is designed for creators, marketers, and agencies who want to maximize the reach and performance of their YouTube content with minimal manual effort. Features SEO Automation** Fetches video metadata and analyzes competitor and trending data. Uses AI to generate SEO-optimized titles, descriptions, and tags. Calculates an SEO score and applies A/B testing logic to select the best title. Updates the video metadata on YouTube automatically. Cross-Platform Promotion** Generates platform-specific promotional content (LinkedIn, X/Twitter, Instagram, Facebook, etc.) using AI. Publishes posts to each connected social channel. Extracts video clips and analyzes thumbnails for enhanced promotion. Engagement Monitoring & Analytics** Monitors YouTube comments, detects negative sentiment, and drafts AI-powered replies. Logs all key data (videos, comments, analytics) to Google Sheets for tracking and reporting. Runs a weekly analytics job to aggregate performance, calculate engagement/viral indicators, and email a detailed report. Notifications & Alerts** Sends Slack alerts when a new video is published or when viral potential/negative comments are detected. How It Works Trigger The workflow starts automatically when a new YouTube video is published (via webhook) or on a weekly schedule for analytics. Video Intake & SEO Fetches video details (title, description, tags, stats). Gathers competitor and trending topic data. Uses AI to generate improved SEO assets and calculates an SEO score. Selects the best title (A/B test) and updates the video metadata. Clip & Thumbnail Processing If the video is long enough, runs thumbnail analysis and extracts short clips for social media. Cross-Platform Promotion Generates and formats promotional posts for each social platform. Publishes automatically to enabled channels. Engagement & Comment Monitoring Fetches comments, detects negative sentiment, and drafts AI-powered replies. Logs comments and responses to Google Sheets. Analytics & Reporting Aggregates weekly analytics, calculates engagement and viral indicators. Logs insights and sends a weekly report via email. Notifications Sends Slack alerts for new video publications and viral/negative comment detection. Setup Instructions Connect YouTube Set up YouTube API credentials and required IDs in the Workflow Configuration node. Connect OpenAI Add your OpenAI credentials for AI-powered content generation. Connect Slack Configure Slack credentials and specify alert channels. Connect Google Sheets Set up service account credentials for logging video, comment, and analytics data. Configure Social Platforms Add credentials for LinkedIn, Twitter (X), Instagram, and Facebook as needed. Test the Workflow Publish a test video and verify that metadata updates, social posts, logging, and weekly reports are working as expected. Use Cases YouTube Creators:** Automate SEO, promotion, and analytics to grow your channel faster. Marketing Teams:** Streamline multi-channel video campaigns and reporting. Agencies:** Deliver consistent, data-driven YouTube growth for multiple clients. Requirements YouTube API credentials OpenAI API key Slack API token Google Sheets service account (Optional) LinkedIn, Twitter, Instagram, Facebook API credentials Limitations Requires valid API credentials for all connected services. AI-powered features depend on OpenAI API access. Social posting is limited to platforms with available n8n nodes and valid credentials. Tip: You can easily customize prompts, scoring logic, and enabled platforms to fit your channel’s unique needs.

Who’s it for This workflow is designed for marketers, content creators, agency owners, and solopreneurs who want to automate LinkedIn content creation using AI. It helps turn Google Sheets entries into complete LinkedIn posts, including text, image prompts, and AI-generated images. What it does / How it works The workflow monitors a Google Sheet for new campaign entries. When a row is added, it automatically collects details about the campaign, searches LinkedIn via Tavily to identify relevant trends, and turns the information into an AI-generated LinkedIn post using a local Ollama model or an LLM of your choice. A second approval step lets you refine the text directly inside the sheet. Once approved, the workflow generates an image prompt, creates a ready-to-post visual with OpenAI Images, and finally publishes the post to LinkedIn. How to set up • Add your own Google Sheets Trigger credentials. • Add Tavily, Ollama/OpenAI, and LinkedIn OAuth credentials. • Replace the sample Sheet URL with your own. • Set your LinkedIn account/person ID in the posting node. Requirements • Google Sheets account • LinkedIn OAuth app • Tavily API key • Ollama (local) or OpenAI image generation How to customize You can change: • AI model • Image generation provider • Search query logic • Content tone • Approval step (manual or automatic)

Overview: Automated LinkedIn Job Posting with AI This workflow automates the publication of new job vacancies on LinkedIn immediately after they are created in the Recrutei ATS (Applicant Tracking System). It leverages a Code node to pre-process the job data and a powerful AI model (GPT-4o-mini, configured via the OpenAI node) to generate compelling, marketing-ready content. This template is designed for Recruitment and Marketing teams aiming to ensure consistent, timely, and high-quality job postings while saving significant operational time. Workflow Logic & Steps Recrutei Webhook Trigger: The workflow is instantly triggered when a new job vacancy is published in the Recrutei ATS, sending all relevant job data via a webhook. Data Cleaning (Code Node 1): The first Code node standardizes boolean fields (like remote, fixed_remuneration) from 0/1 to descriptive text ('yes'/'no'). Prompt Transformation (Code Node 2): The second, crucial Code node receives the clean job data and: Maps the original data keys (e.g., title, description) to user-friendly labels (e.g., Job Title, Detailed Description). Cleans and sanitizes the HTML description into readable Markdown format. Generates a single, highly structured prompt containing all job details, ready for the AI model. AI Content Generation (OpenAI): The AI Model receives the structured prompt and acts as a 'Marketing Copywriter' to create a compelling, engaging post specifically optimized for the LinkedIn platform. LinkedIn Post: The generated text is automatically posted to the configured LinkedIn profile or Company Page. Internal Logging (Google Sheets): The workflow concludes by logging the event (Job Title, Confirmation Status) into a Google Sheet for internal tracking and auditing. Setup Instructions To implement this workflow successfully, you must configure the following: Credentials: Configure OpenAI (for the Content Generator). Configure LinkedIn (for the Post action). Configure Google Sheets (for the logging). Node Configuration: Set up the Webhook URL in your Recrutei ATS settings. Replace YOUR_SHEET_ID_HERE in the Google Sheets Logging node with your sheet's ID. Select the correct LinkedIn profile/company page in the Create a post node.

This workflow is a complete, AI-powered content engine designed to help automation experts build their personal brand on LinkedIn. It transforms a technical n8n workflow (in JSON format) into a polished, engaging LinkedIn post, complete with a custom-generated AI image and a strategic call-to-action. This system acts as your personal content co-pilot, handling the creative heavy lifting so you can focus on building, not just writing. Who’s it for? This template is for n8n developers, automation consultants, and tech content creators who want to consistently showcase their work on LinkedIn but lack the time or desire to write marketing copy and design visuals from scratch. If you want to turn your projects into high-quality content with minimal effort, this is your solution. How it works This workflow is divided into two main parts that work together through Telegram: Content Generation & Image Creation: You send an n8n workflow's JSON file to your first Telegram bot. The workflow sends the JSON to Google Gemini with a sophisticated prompt, instructing it to analyze the workflow and write a compelling LinkedIn post in one of two high-engagement styles ("Builder" or "Strategist"). Gemini also generates a detailed prompt for an AI image model, including a specific headline to be embedded in the visual. This image prompt is then sent to the Cloudflare Workers AI model to generate a unique, high-quality image for your post. The final image and the AI-generated text prompt are sent back to you via Telegram for review. Posting to LinkedIn: You use a second Telegram bot for publishing. Simply reply to the image you received from the first bot with the final, polished post text. The workflow triggers on your reply, grabs the image and the text, and automatically publishes it as a new post on your LinkedIn profile. Why Two Different Workflows? The first workflow sends you the image and the post content. You can make changes in the content or the image and send the image to BOT-2. Then copy the post content send it to BOT-2 as a reply to the image. Then both the image and Content will be posted on LinkedIn as a single post. How to set up Create Two Telegram Bots: You need two separate bots. Use BotFather on Telegram to create them and get their API tokens. Bot 1 (Generator): For submitting JSON and receiving the generated content/image. Bot 2 (Publisher): For replying to the image to post on LinkedIn. (After Human Verification) Set Up Accounts & Credentials: Add credentials for Google Gemini, Cloudflare (with an API Token), Google Sheets, and LinkedIn. For Cloudflare, you will also need your Account ID. Google Sheet for Tracking: Create a Google Sheet with the columns: Keyword, Image Prompt, Style Used to keep a log of your generated content. Configure Nodes: In all Telegram nodes, select the correct credential for each bot. In the Google Gemini node, ensure your API credential is selected. In the Cloudflare nodes ("Get accounts" and "Get Flux Schnell image"), select your Cloudflare credential and replace the placeholder with your Account ID in the URL. In the LinkedIn node, select your credential and choose the author (your profile). In the Google Sheets node, enter your Sheet ID. Activate: Activate both Telegram Triggers in the workflow. Requirements An n8n instance. Credentials for: Google Gemini, Cloudflare, LinkedIn, Google Sheets. Two Telegram bots with their API tokens. A Cloudflare Account ID.

What it does This workflow automates content syndication and posting to LinkedIn and X/Twitter. It takes existing long-form articles and generates from them engaging social posts optimized for each platform. The workflow takes links to existing articles from a given sitemap. It randomly selects the next article to republish, making sure that articles are not repeated. For simplicity it uses a Google spreadsheet to track the articles that have already been republished. Requirements Existing sitemap Google Gemini API key (or other model provider's key) Google Sheets credentials LinkedIn credentials X/Twitter credentials How to set up Adjust the schedule as needed (by default triggers daily at noon) Configure parameters in the parameters node: Set the sitemap URL (e.g. https://example.com/sitemap.xml) Set the language of the posts Enable/disable channels as needed Configure Google Sheets credentials for get processed articles and add processed articles nodes Create a new Google spreadsheet document with "url", "status", "timestamp", "LinkedIn post" and "Twitter post" columns Specify that spreadsheet document in get processed articles node (other nodes will take it from here) Add Google Gemini API key for the model (or change to any other model of choice) Configure LinkedIn and X/Twitter credentials for publishing

How it works This workflow turns any URL sent to a Telegram bot into ready-to-publish social posts: Trigger: Telegram message (checks if it contains a URL). Fetch & parse: Downloads the page and extracts readable text + title. AI writing: Generates platform-specific copy (Facebook, Instagram, LinkedIn). Image: Creates an AI image and stores it in Supabase Storage. Publish: Posts to Facebook Pages, Instagram Business, LinkedIn. Logging: Updates Google Sheets with post URLs and sends a Telegram confirmation (image + links). Setup Telegram – create a bot, connect via n8n Telegram credentials. OpenAI / Gemini – add API key in n8n Credentials and select it in the AI nodes. Facebook/Instagram (Graph API) – create a credential called facebookGraph with: • accessToken (page-scoped or system user) • pageId (for Facebook Page photos) • igUserId (Instagram Business account ID) • optional fbApiVersion (default v19.0) LinkedIn – connect with OAuth2 in the LinkedIn node (leave as credential). Supabase – credential supabase with url and apiKey. Ensure a bucket exists (default used in the Set node is social-media). Google Sheets – replace YOUR_GOOGLE_SHEET_ID and Sheet1. Grant your n8n Google OAuth2 access. Notes • No API keys are stored in the template. Everything runs via n8n Credentials. • You can change bucket name, image size/quality, and AI prompts in the respective nodes. • The confirmation message on Telegram includes direct permalinks to the published posts. Required credentials • Telegram Bot • OpenAI (or Gemini) • Facebook/Instagram Graph • LinkedIn OAuth2 • Supabase (url + apiKey) • Google Sheets OAuth2 Inputs • A Telegram message that contains a URL. Outputs • Social posts published on Facebook, Instagram, LinkedIn. • Row appended/updated in Google Sheets with post URLs and image link. • Telegram confirmation with the generated image + post links.

Reddit Pain Point to LinkedIn Content Automation Auto-discover real marketing problems and create viral LinkedIn content automatically This workflow transforms scattered Reddit discussions into a systematic lead generation machine by discovering actual marketing problems businesses face and automatically converting them into authoritative LinkedIn content that attracts qualified prospects. Overview This workflow handles the complete pain point discovery and content creation process using advanced AI analysis and automation. It manages Reddit API authentication, multi-source community monitoring, intelligent problem identification, solution development, and LinkedIn publishing with built-in error handling and content optimization for maximum engagement. Core Function: Real-time market intelligence that transforms Reddit conversations into high-converting LinkedIn content, positioning you as the expert who understands and solves specific business problems in your target industries. Key Capabilities Real-time pain point discovery** - Monitor 10+ specialized B2B subreddits for actual marketing problems being discussed right now Multi-industry intelligence** - Track Dentistry, Beauty, Accounting, Real Estate, Lawyer, Ecommerce, HR, Online Education, Coaching, and Interior Design sectors simultaneously AI-powered problem translation** - GPT-4.1 mini converts technical Reddit complaints into clear business problems with realistic context Solution architecture** - Automatically proposes specific automation solutions with viability scoring and ROI estimates LinkedIn content automation** - Gemini 2.5 Pro creates Spanish PYME-focused posts with professional imagery via Freepik Seedream V4 Compound intelligence** - System learns and improves, building a comprehensive database of market problems and solutions over time Authority positioning** - Creates content that makes prospects think "this person understands exactly what we're facing" Tools Used n8n**: The automation platform orchestrating both discovery and content creation systems Reddit API**: Direct access to community discussions and pain point identification OpenRouter**: Gateway to advanced AI models (GPT-4.1 mini, Gemini 2.5 Pro) GPT-4.1 mini**: Lightning-fast pain point detection and solution architecture Gemini 2.5 Pro**: Advanced copywriting and visual prompt creation SerpAPI**: Real-time market research and trend integration Freepik API**: Ultra-realistic business imagery generation with Seedream V4 Google Sheets**: Smart knowledge base for pain point storage and tracking LinkedIn Business API**: Professional content publishing and distribution How to Install Setup Time: 20-25 minutes for complete configuration Import the Workflow: Download the .json file and import it into your n8n instance Configure Reddit Access: Set up Reddit OAuth2 credentials for community monitoring Set Up AI Processing: Add your OpenRouter API key for GPT-4.1 mini and Gemini 2.5 Pro access Configure Market Research: Add SerpAPI credentials for real-time trend integration Set Up Image Generation: Configure Freepik API access for professional imagery Configure LinkedIn Publishing: Set up LinkedIn Business API for automated posting Create Knowledge Base: Copy the provided Google Sheets template and configure access Test Both Systems: Run research cycle and content creation independently Deploy Automation: Activate schedules (research every 10 days, content daily 9:30 AM) Use Cases Marketing Agencies: Discover client industry problems automatically and create content that demonstrates deep market understanding, positioning your agency as the one that "gets" specific industry challenges. Automation Consultants: Identify businesses struggling with manual processes through their Reddit discussions, then create educational content showcasing relevant automation solutions that attract pre-qualified leads. Business Coaches: Build authority through market insight by addressing real problems business owners are actively discussing, establishing credibility as the expert with solutions to specific industry challenges. Freelance Specialists: Develop niche expertise by focusing content on specific industry pain points discovered through community monitoring, enabling premium positioning and higher rates. Content Creators: Generate endless content ideas based on real market problems rather than guessing what to write about, ensuring every post addresses actual audience needs. B2B SaaS Companies: Monitor target market discussions to identify feature gaps, positioning opportunities, and create educational content that demonstrates product-market fit. Enterprise Sales Teams: Stay informed about prospect challenges through community intelligence, enabling more relevant outreach and positioning discussions. Pre-configured Google Sheets Template Knowledge Base Template Make a copy of the template to your Google Drive and update the sheet ID in the workflow nodes for proper pain point storage and retrieval. Connect with Me LinkedIn: https://www.linkedin.com/in/daniel-lianes/ Discovery Call: https://cal.com/averis/asesoria Consulting Session: https://cal.com/averis/consultoria-personalizada Was this helpful? Let me know! Your feedback is very valuable and helps me create better resources for the n8n community. Want to take automation to the next level? If you're looking to optimize your business processes or need expert help with a project, here's how I can assist you: Advisory (Discovery Call): Do you have a process in your business that you'd like to automate but don't know where to start? In this initial call, we'll explore your needs and see if automation is the ideal solution for you. Schedule a Discovery Call Personalized Consulting: If you already have a specific problem, an integration challenge, or need hands-on help building a custom workflow, this session is for you. Together, we'll find a powerful solution for your case. Book Your Consulting Session Stay Up to Date For more tricks, ideas, and news about automation and AI, let's connect on LinkedIn! Follow me on LinkedIn #n8n #automation #reddit #linkedin #ai #painpoints #seedream #contentcreation #leadgeneration #gemini #businessautomation #marketresearch #contentmarketing #socialmedia #freepik #gpt4 #productivity #entrepreneurship #pymes #averistech

Template Description: > Never run out of high-quality LinkedIn content again. This workflow is a complete content factory that takes a simple topic from a Google Sheet, uses AI to research a trending angle, writes a full post, generates a unique and on-brand image, and publishes it directly to your LinkedIn profile. This template is designed for brands and creators who want to maintain a consistent, high-quality social media presence with minimal effort. The core feature is its ability to generate visuals that adhere to a specific, customizable brand style guide. 🚀 What does this workflow do? Pulls content ideas from a Google Sheet acting as your content calendar. Uses an AI Researcher (OpenAI + SerpAPI) to find the most recent and engaging news or trends related to your topic. Employs an AI Writer to draft a complete, professional LinkedIn post with a catchy title, engaging text, and relevant hashtags. Generates a unique, on-brand image for every post using Replicate, based on a customizable style guide (colors, composition, mood) defined within the workflow. Publishes the post with its image** directly to your LinkedIn profile. Updates the status** in your Google Sheet to "done" to avoid duplicate posts. 🎯 Who is this for? Marketing Teams:** Automate your content calendar and ensure brand consistency across all visuals. Social Media Managers:** Save hours of research, writing, and design work. Solopreneurs & Founders:** Maintain an active, professional LinkedIn presence without a dedicated content team. Content Creators:** Scale your content production and focus on strategy instead of execution. ✨ Benefits End-to-End Automation:** From a single keyword to a published post, the entire process is automated. Brand Consistency:** The AI image generator follows a strict, customizable style guide, ensuring all your visuals feel like they belong to your brand. Always Relevant Content:** The AI research step ensures your posts are based on current trends and news, increasing engagement. Massive Time Savings:** Automates research, copywriting, and graphic design in one seamless flow. Content Calendar Integration:** Easily manage your content pipeline using a simple Google Sheet. ⚙️ How it Works Get Topic: The workflow fetches the next "Pending" topic from your Google Sheet. AI Research: An AI Agent uses SerpAPI to research the topic and identify a viral angle. AI Writing: A second AI Agent takes the research and writes the full LinkedIn post. Generate Image Prompt: A Code node constructs a detailed prompt, merging the post's content with your defined brand style guide. Generate Image: The prompt is sent to Replicate. The workflow waits and checks periodically until the image is ready. Publish: The generated text and image are published to your LinkedIn account. Update Status: The workflow archives the image to Google Drive and updates the topic's status in your Google Sheet to "done". 📋 n8n Nodes Used Google Sheets Langchain Agent (with OpenAI & SerpAPI) Code HTTP Request Wait / If LinkedIn Google Drive 🔑 Prerequisites An active n8n instance. Google Account** with Sheets & Drive access (OAuth2 Credentials). OpenAI Account & API Key**. SerpAPI Account & API Key** (for the research tool). Replicate Account & API Token**. LinkedIn Account** (OAuth2 Credentials). A Google Sheet** with "Topic" and "Status" columns. 🛠️ Setup Import the workflow into your n8n instance. Configure All Credentials: Go through the workflow and connect your credentials for Google, OpenAI, SerpAPI, Replicate, and LinkedIn in their respective nodes. Link Your Google Sheet: In the 1. Get Pending Topic... node, select your spreadsheet and sheet. Do the same for the final 8. ...Update Status node. Customize Your Brand Style (Highly Recommended): In the 4. Generate Branded Image Prompt (Code) node, edit the fixedImageStyleDetails variable. Change the RAL color codes and descriptive words to match your brand's visual identity. Populate Your Content Calendar: Add topics to your Google Sheet and set their status to "Pending". Activate the workflow!

Target audience Solo creators, PMs, and content teams who queue LinkedIn ideas in Google Sheets and want them posted on a fixed schedule with AI-generated copy. How it works The workflow runs on a schedule (Mon/Wed/Fri at 09:30). It pulls the first Google Sheet row with Status = Pending, generates a LinkedIn-ready post from Post title using an OpenAI prompt, publishes to your LinkedIn profile, then updates the same row to Done and writes the final post back to the sheet. Prerequisites (use your own credentials) Google Sheets (OAuth2)** with access to the target sheet LinkedIn OAuth2* tied to the account that should post — set the person* field to your profile’s URN in the LinkedIn node OpenAI API key** for the Chat Model node Store secrets in n8n Credentials. Never hard-code keys in nodes. Google Sheet structure (exact columns) Minimum required columns id — unique integer/string used to update the same row later Status — allowed values: Pending or Done Post title — short prompt/topic for the AI model Recommended columns Output post — where the workflow writes the final text (use this header, or keep your existing Column 5) Hashtags (optional) — comma-separated list (the prompt can append these) Image URL (optional) — public URL; add an extra LinkedIn “Create Post” input if you post with media later Notes (optional) — extra hints for tone, audience, or CTA Example header row id | Status | Post title | Hashtags | Image URL | Output post | Notes Example rows (inputs → outputs) 1 | Pending | Why I moved from Zapier to n8n | #automation,#nocode | | | Focus on cost + flexibility 2 | Done | 5 lessons from building a rules engine | #product,#backend | | This is the final posted text... | Resulting Output post (for row 1 after publish) I switched from Zapier to n8n for three reasons: control, flexibility, and cost. Here’s what changed in my stack and what I’d repeat if I had to do it again. #automation #nocode > If your sheet already has a column named Column 5, either rename it to Output post and update the mapping in the final Google Sheets Update node, or keep Column 5 as is and leave the node mapping untouched. Step-by-step Schedule Trigger Runs on Mon/Wed/Fri at 09:30. Fetch pending rows (Google Sheets → Get Rows) Reads the sheet and filters rows where Status = Pending. Limit Keeps only the first pending row so one post goes out per run. Writing the post (Agent + OpenAI Chat Model + Structured Output Parser) Uses Post title (and optional Notes/Hashtags) as input. The agent returns JSON with a post field. Model set to gpt-4o-mini by default. Create a post (LinkedIn) Publishes {{$json.output.post}} to the configured person (your profile URN). Update the sheet (Google Sheets → Update) Matches by id, sets Status = Done, and writes the generated text into Output post (or your existing output column). Customization Schedule** — change days/time in the Schedule node. Consider your n8n server timezone. Posts per run* — remove or raise the Limit* to post more than one item. Style and tone** — edit the Agent’s system prompt. Add rules for line breaks, hashtags, or a closing CTA. Hashtags handling** — parse the Hashtags column in the prompt so the model appends them cleanly. Media posts** — add a branch that attaches Image URL (requires LinkedIn media upload endpoints). Company Page* — switch the person field to an organization* URN tied to your LinkedIn app scope. Troubleshooting No post created** Check the If/Limit path: is there any row with Status = Pending? Confirm the sheet ID and tab name in the Google Sheets nodes. Sheet not updating** The Update node must receive the original id. If you changed field names, remap them. Make sure id values are unique. LinkedIn errors (403/401/404)** Refresh LinkedIn OAuth2 in Credentials. The person/organization URN is wrong or missing. Copy the exact URN from the LinkedIn node helper. App lacks required permissions for posting. Rate limit (429) or model errors** Add a short Wait before retries. Switch to a lighter model or simplify the prompt. Post too long or broken formatting** LinkedIn hard limit is \~3,000 characters. Add a truncation step in Code or instruct the prompt to cap length. Replace double line breaks in the LinkedIn node if you see odd spacing. Timezone mismatch** The Schedule node uses the n8n instance timezone. Adjust or move to a Cron with explicit TZ if needed. Need to post at a different cadence, or push two posts per day? Tweak the Schedule and Limit nodes and you’re set.

Turn a simple email workflow into a LinkedIn content machine. Generate post ideas, draft full posts, and auto-publish to LinkedIn all controlled by replying to emails. 📌 Purpose Automate your LinkedIn posting pipeline using AI + Email approvals. Generate 10 scroll-stopping post ideas tailored to your niche & audience. Approve your favorite by replying to the email with a number. Receive 3 AI-written drafts for the chosen idea. Pick your favorite draft via email reply. The selected post gets auto-published to LinkedIn ✅. All steps are logged in Google Sheets. 🔗 Apps Used Google Gemini** → generates ideas & drafts Gmail** → email-based approval workflow Google Sheets** → tracks ideas, drafts, and published posts LinkedIn API** → posts directly to your company or personal account ✨ Highlights 📬 Email-based approval → no dashboards, just reply with a number 📝 10 AI-generated content ideas + 3 full drafts per topic 🔄 End-to-end tracking in Google Sheets (ideas → drafts → published) ⚡ Auto-posting directly to LinkedIn ✅ Final confirmation email with preview 👤 Best For Startup founders Agencies managing multiple clients’ LinkedIn Solopreneurs & creators who want consistent posting 🛠️ Workflow Overview flowchart TB A["Manual Trigger"] --> B["AI Agent - Generate 10 Ideas"] B --> C["Code - Parse JSON + Correlation ID"] C --> D["Google Sheets - Append Ideas"] D --> E["Gmail - Send Ideas Email"] E --> F["Gmail Trigger - Await Reply"] F --> G["Code1 - Extract Reply Number"] G --> H["Google Sheets - Fetch Row"] H --> I{"Switch Stage"} I -- Ideas --> J["AI Agent - Generate 3 Drafts"] J --> K["Code3 - Parse Drafts"] K --> L["Google Sheets - Update Drafts"] L --> M["Gmail - Send Drafts Email"] I -- Drafts --> N["Code4 - Select Final Draft"] N --> O["LinkedIn - Publish Post"] O --> P["Google Sheets - Update Posted"] P --> Q["Gmail - Send Confirmation"] `

LinkedIn Viral Post Scraper + AI Content Generator with Auto Publishing Who's it for Content creators, social media managers, marketing agencies, and LinkedIn growth hackers who want to automate their content strategy by analyzing viral posts and generating original, high-engagement content at scale. What it does This comprehensive automation pipeline combines LinkedIn data intelligence with AI-powered content creation to build a complete content marketing system: Data Collection Phase: Automatically scrapes high-engagement posts from target LinkedIn profiles Filters content based on viral metrics (20+ likes, comments, or reposts) Stores trending content data in Google Sheets for analysis Runs on a 12-hour schedule with built-in rate limiting Content Generation Phase: AI analyzes trending patterns and engagement triggers from collected data Generates original LinkedIn posts using Google Gemini's advanced language model Creates custom visuals using AI image generation (HuggingFace Flux model) Automatically publishes complete posts with images to your LinkedIn company page Tracks processed content to prevent duplicate analysis How it works The workflow operates in two connected phases. The scraping phase monitors specified LinkedIn profiles, collecting high-performing posts into a centralized database. When new viral content is detected, the AI analysis phase triggers automatically, identifying trending topics and creating original content that leverages proven engagement patterns while maintaining authenticity. Requirements APIs and Credentials: Google Sheets API (for data storage and profile management) Apify API key (for LinkedIn post scraping) Google Gemini API access (for content generation) HuggingFace API token (for image generation) LinkedIn API access (for publishing) Setup Prerequisites: Google Sheets document with LinkedIn profile URLs LinkedIn company page for publishing Self-hosted n8n instance (uses community nodes) How to set up Configure Data Sources: Create a Google Sheet with two tabs - one for target LinkedIn profile URLs and another for storing scraped data API Integration: Add all required API credentials to n8n credential manager Customize Filters: Adjust engagement thresholds (currently 20+ for each metric) based on your niche AI Prompt Tuning: Modify the content generation prompt to match your brand voice and industry focus Publishing Settings: Configure your LinkedIn organization ID and posting preferences Schedule Optimization: Set scraping frequency based on your content needs and API limits How to customize the workflow Content Targeting: Modify the profile list in Google Sheets to focus on specific industries, thought leaders, or competitors in your niche. Engagement Thresholds: Adjust the filter conditions to be more or less selective about which posts qualify as "viral" content. AI Voice Customization: Edit the comprehensive system prompt in the LinkedIn Content Strategy AI node to match your brand personality, industry terminology, and content style preferences. Visual Branding: Customize image generation prompts to include your brand colors, logo elements, or specific visual styles. Publishing Schedule: Modify the trigger frequency and add conditional logic to publish at optimal times for your audience. Data Retention: Add cleanup nodes to manage historical data and prevent Google Sheets from becoming unwieldy over time.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. AI-Powered LinkedIn Publishing via Telegram Workflow Transform your LinkedIn presence with this intelligent n8n workflow that converts simple Telegram messages into professional LinkedIn posts through AI-powered content generation and approval workflows. 🎯 Who Is This For? Content Creators & Influencers** seeking to maintain consistent LinkedIn presence Marketing Professionals** managing multiple client accounts Business Owners** wanting to automate thought leadership content Social Media Managers** streamlining content workflows Entrepreneurs** maximizing content efficiency while maintaining quality 🚀 Benefits Time Efficiency**: Reduces content creation time by 80-90% Quality Consistency**: Maintains professional standards across all posts Content Diversity**: Leverages multiple sources for rich, varied content Real-Time Relevance**: Incorporates latest industry trends and news Approval Control**: Human oversight ensures brand alignment Scalability**: Handles multiple users and high-volume content creation 🔧 Core Features Smart Content Classification Multi-Input Processing**: Handles URLs, topics, direct content, or combinations Intelligent Routing**: Automatically determines whether to scrape, search, or generate directly Context Preservation**: Maintains original user intent throughout the process Advanced Content Gathering Web Scraping**: Firecrawl integration for extracting article content from URLs Real-Time Search**: Brave Search API for latest industry trends and news Content Synthesis**: Merges multiple sources into coherent, valuable insights AI-Powered Content Generation Google Gemini Integration**: Creates professional, LinkedIn-optimized posts Platform-Specific Formatting**: Mobile-friendly paragraphs, engaging hooks, strategic CTAs SEO Optimization**: Relevant hashtags and keyword integration Character Management**: Ensures posts stay within LinkedIn's 2800 character limit Interactive Approval System Telegram Preview**: Rich preview with post analytics and formatting Action Buttons**: Approve, Edit, or Reject with single-click convenience Edit Workflow**: AI-powered rewriting based on user feedback Real-Time Updates**: Instant feedback and status notifications Comprehensive Content Tracking Google Sheets Integration**: Complete audit trail of all posts and content metrics Content Analytics**: Character counts, hashtag usage, source attribution User Authorization**: Secure access control with authorized user validation Post Management**: Unique ID generation for tracking and reference 🔄 How It Works Message Reception: Secure Telegram trigger with user validation Content Classification: AI analyzes input type and extracts actionable elements Dynamic Routing: Intelligent branching based on content requirements: URL Path: Web scraping → content extraction → processing Topic Path: Web search → latest information gathering → synthesis Direct Path: Immediate processing for ready-to-post content Content Synthesis: Merges all gathered information into comprehensive context AI Generation: Creates LinkedIn-optimized post with professional formatting Interactive Approval: Telegram preview with approval workflow Publishing: Direct LinkedIn posting upon approval Content Logging: Complete tracking in Google Sheets 📈 Use Cases Daily Industry Updates: Transform news URLs into thought leadership posts Content Repurposing: Convert articles and research into LinkedIn insights Trend Commentary: Generate posts about trending topics with real-time data Educational Content: Create informative posts from technical documentation Personal Branding: Maintain consistent professional presence with minimal effort 🛠️ Technical Requirements Required Community Nodes Install these community nodes in your n8n instance: Brave Search Integration @brave/n8n-nodes-brave-search Firecrawl Web Scraping @mendable/n8n-nodes-firecrawl LangChain AI Integration @n8n/n8n-nodes-langchain APIs & Services Required Google Gemini (Content generation and classification) Firecrawl API (Web scraping) Brave Search API (Real-time search) Telegram Bot API (Interface and notifications) LinkedIn API (Content publishing) Google Sheets API (Content tracking and logging) 🔑 Setup Guide Telegram Bot Setup Search for @BotFather on Telegram Send /newbot and follow prompts Copy the bot token Send /setprivacy to BotFather and set to Disable Google Gemini API Visit Google AI Studio Sign in and click "Get API Key" → "Create API Key" Copy your API key Free tier: 60 requests per minute Firecrawl API Visit Firecrawl.dev Sign up and go to Dashboard → API Keys Copy your API key Free tier: 500 pages/month Brave Search API Visit Brave Search API Sign up and create application Copy subscription key Free tier: 1,000 queries/month LinkedIn API Visit LinkedIn Developers Create app with required details Request "Share on LinkedIn" product Copy Client ID and Client Secret Add redirect URL: https://your-n8n-domain.com/rest/oauth2-credential/callback Google Sheets API Visit Google Cloud Console Enable Google Sheets API Create OAuth 2.0 Client ID Copy Client ID and Client Secret 🛠️ Installation Steps Phase 1: Preparation Install required community nodes Restart n8n after installation Create Google Sheet for logging Set up Telegram Bot Phase 2: Import and Configure Import workflow JSON in n8n Configure all API credentials Test each connection Phase 3: Customization Update authorized user ID in "Authorized Telegram Users" node Configure Google Sheets document ID Test Telegram connection Phase 4: Testing Test with different input types: URL only: https://example.com/article Topic only: artificial intelligence trends Mixed: AI trends https://example.com/ai-news 🎨 Customization Options Content Personalization Modify AI prompts to match your brand voice Adjust content length and formatting preferences Customize hashtag strategies and CTA approaches Configure approval workflow steps Source Integration Add additional search engines or content sources Integrate with RSS feeds or news APIs Connect to internal knowledge bases Customize web scraping parameters 🔒 Security Features User Authorization**: Whitelist-based access control Secure Token Management**: Encrypted API key handling Data Privacy**: Secure processing of scraped content Audit Trail**: Complete logging of all user interactions 🔮 Future Expansion Possibilities This workflow serves as a foundation for: Performance Analytics Module**: LinkedIn engagement tracking Content Optimization Engine**: A/B testing and refinement Multi-Platform Publishing**: Expand to Twitter, Facebook, Instagram Advanced Scheduling**: Time-optimized posting Content Series Management**: Automated follow-ups 💡 Why Choose This Workflow This represents a complete LinkedIn content automation solution that maintains quality and personal touch while dramatically reducing time and effort. Perfect for professionals who want to maximize LinkedIn impact without sacrificing content quality or spending hours on manual creation. Ready to transform your LinkedIn presence? Install this workflow and start automating your professional content creation today!

Build a completely automated LinkedIn content engine using n8n, OpenAI, Google Sheets, and the LinkedIn API. This workflow reads unpublished topics from a Google Sheet, generates engaging AI-powered post content and a relevant image, and publishes directly to LinkedIn — no manual effort required. How It Works This system uses a scheduled trigger (e.g., daily at 9 AM) to: Fetch the first Unpublished topic from your Google Sheet. Generate a compelling, SEO-optimized post description using OpenAI. Create a marketing image that includes the topic title visually. Merge the content and image. Publish the post to your LinkedIn profile. Update the sheet to mark the topic as Published. Prerequisites 1.A Google Sheet with two columns: Topics and Status 2.A verified LinkedIn developer account and app 3.OpenAI API key 4.n8n cloud or self-hosted instance 5.LinkedIn OAuth2 credentials in n8n 6.Google Sheets OAuth2 credentials in n8n Google Sheet Example | Topics | Status | | -------------------------- | ----------- | | How to Automate LinkedIn | Unpublished | | Top AI Tools for Marketers | Unpublished | Step-by-Step Setup Clone or import the provided n8n workflow. Create a Google Sheet with your post topics and mark them as Unpublished Set up OAuth2 credentials in n8n for Google Sheets and LinkedIn. Use the Schedule Trigger node to control posting frequency. Adjust the OpenAI prompt to better match your tone. Add a test topic and verify it generates, posts, and updates correctly. Customization Tips Change posting frequency (daily/hourly) in the Schedule Trigger. Modify the OpenAI prompt for different tones (professional, fun, educational). Use a different image generation model or remove image generation if not needed. Add approval steps before publishing, using Telegram/Slack/email nodes.

Okay, here are the "How It Works" and "Setup Steps" for your "Automated Social Media Content Distribution System," presented clearly in Markdown. How It Works (Workflow Stages) ⚙️ This system transforms manual, repetitive tasks into a smooth, automated content distribution pipeline: Content Submission & Trigger: You add a new row to your designated Google Sheet with all the content details (Title, URL, Short_Description, Image_URL, Hashtags, and boolean flags for which platforms to post to). The Google Sheets Trigger node immediately detects this new entry, initiating the workflow. Content Preparation: The Set node takes the raw data from your Google Sheet and formats it into a cohesive text string (social_media_text_core) that is suitable for posting across different social media platforms. Conditional Social Media Posting: A series of If nodes (Check Facebook Post, Check Twitter Post, Check LinkedIn Post) sequentially check your preferences (based on the Post_to_Facebook, Post_to_Twitter, Post_to_LinkedIn columns in your sheet). If a platform is marked TRUE, the corresponding social media node (Facebook, Twitter, LinkedIn) is activated to publish your content. If FALSE, that platform is skipped, and the workflow moves to the next check. Status Update & Notification: After attempting to post to all selected platforms, the Google Sheets (Update) node updates the Publication_Status column of your original row to "Published." This prevents re-posting and provides a clear record. Finally, the Slack (Notification) node sends an alert to your chosen Slack channel, confirming that the content has been successfully distributed. Setup Steps 🛠️ (Build It Yourself!) Follow these detailed steps to build and implement this workflow in your n8n instance: Prepare Your Google Sheet: Create a new Google Sheet (e.g., named "Social Media Posts"). Set up the following exact column headers in the first row: Title, URL, Short_Description, Image_URL, Hashtags, Post_to_Facebook, Post_to_Twitter, Post_to_LinkedIn, Publication_Status Fill in a test row with some sample data, ensuring TRUE/FALSE values for the posting flags. Gather Your API Keys & Credentials: Google Sheets Credential: You'll need an OAuth2 credential for Google Sheets in n8n to allow read/write access to your sheet. Facebook Credential: An OAuth2 credential for Facebook with permissions to post to your selected Page. Twitter Credential: A Twitter API credential (API Key, API Secret, Access Token, Access Token Secret) from your Twitter Developer App. LinkedIn Credential: An OAuth2 credential for LinkedIn with permissions to share updates to your profile or organization page. Slack Credential: A Slack API token (Bot User OAuth Token) for sending messages to your channel. Build the n8n Workflow Manually (10 Nodes): Start a new workflow in n8n. Drag and drop each of the following nodes onto the canvas and connect them as described below: Google Sheets Trigger Name: Google Sheets Trigger Parameters: Authentication: Select your Google Sheets credential. Spreadsheet ID: [Copy the ID from your Google Sheet's URL] Sheet Name: [Your Sheet Name, e.g., 'Sheet1' or 'Content'] Watch For: Rows Events: Added Connections: Output to Set Content Parameters. Set Name: Set Content Parameters Parameters: Values to Set: Add a new value: Type: String Name: social_media_text_core Value: ={{ $json.Title }} - {{ $json.Short_Description }}\nRead more: {{ $json.URL }}\n{{ $json.Hashtags }} Connections: Output to Check Facebook Post. If Name: Check Facebook Post Parameters: Value 1: ={{ $json.Post_to_Facebook }} Operation: is true Connections: True output to Post Facebook Message. False output to Check Twitter Post. Facebook Name: Post Facebook Message Parameters: Authentication: Select your Facebook credential. Page ID: [YOUR_FACEBOOK_PAGE_ID] Message: ={{ $json.social_media_text_core }} Link: ={{ $json.URL }} Picture: ={{ $json.Image_URL }} Options: Published (checked) Connections: Output to Check Twitter Post. If Name: Check Twitter Post Parameters: Value 1: ={{ $json.Post_to_Twitter }} Operation: is true Connections: True output to Create Tweet. False output to Check LinkedIn Post. Twitter Name: Create Tweet Parameters: Authentication: Select your Twitter credential. Tweet: ={{ $json.social_media_text_core }} Image URL: ={{ $json.Image_URL }} Connections: Output to Check LinkedIn Post. If Name: Check LinkedIn Post Parameters: Value 1: ={{ $json.Post_to_LinkedIn }} Operation: is true Connections: True output to Share LinkedIn Update. False output to Update Publication Status. LinkedIn Name: Share LinkedIn Update Parameters: Authentication: Select your LinkedIn credential. Resource: Share Update Type: Organization or Personal (Choose as appropriate) Organization ID: [YOUR_LINKEDIN_ORG_ID] (If Organization type selected) Content: ={{ $json.social_media_text_core }} Content URL: ={{ $json.URL }} Image URL: ={{ $json.Image_URL }} Connections: Output to Update Publication Status. Google Sheets Name: Update Publication Status Parameters: Authentication: Select your Google Sheets credential. Spreadsheet ID: [YOUR_GOOGLE_SHEET_CONTENT_ID] Sheet Name: [Your Sheet Name, e.g., 'Sheet1' or 'Content'] Operation: Update Row Key Column: URL Key Value: ={{ $json.URL }} Values: Add a new value: Column: Publication_Status Value: Published Connections: Receives connections from both Share LinkedIn Update and the False branch of Check LinkedIn Post. Slack Name: Send Slack Notification Parameters: Authentication: Select your Slack credential. Chat ID: [YOUR_SLACK_CHANNEL_ID] Text: New content "{{ $json.Title }}" successfully published to social media! 🎉 Check: {{ $json.URL }} Connections: Output to Update Publication Status. Final Steps & Activation: Test the Workflow: Before activating, manually add a new row to your Google Sheet or use n8n's "Execute Workflow" button (if available for triggers). Observe the flow through each node to ensure it behaves as expected and posts to your social media accounts. Activate Workflow: Once you are confident it's working correctly, turn the workflow "Active" in the top right corner of your n8n canvas.

Transform Your Social Media Strategy with AI-Powered Content Generation! Stop spending hours crafting social media posts. This automated workflow uses AI to generate professional, platform-specific content and publishes it across your social channels on schedule. What This Workflow Does? This workflow creates a complete social media publishing system, incorporarint automated actions such as: Content Planning: Pull post ideas from a Google Sheet on schedule AI Content Creation: Generate tailored content for each platform using OpenAI Multi-Platform Publishing: Post to LinkedIn and Twitter with proper formatting Content Tracking: Log all scheduled posts in a Google Sheet Notification System: Get email confirmations when content is scheduled Perfect For: Marketing teams looking to scale content creation Social media managers handling multiple accounts Small businesses without dedicated social media staff Content creators needing consistent publishing schedules Setup Instructions: Required Accounts Before setting up the workflow, make sure you have: OpenAI API Key: For AI-powered content generation Google Account: To access Google Sheets for content ideas and tracking LinkedIn Account: With developer access for publishing Twitter/X Account: With developer access for publishing Email Account: For sending notifications

How It Works ⚙️ This workflow is a comprehensive, AI-powered system that acts as a virtual content manager for creators and marketing teams. It automates the entire content lifecycle, from ingestion and analysis to multi-channel distribution and performance logging. Multi-Source Ingestion: The workflow starts by ingesting new content from a trigger, such as a WordPress blog post or an RSS Feed from a YouTube channel. AI-Powered Analysis: The new content is sent to an OpenAI (GPT-4) node, which performs a series of high-value tasks. It instantly creates a summary, extracts keywords, analyzes the sentiment, and generates tailored post drafts for different social media platforms. Smart Distribution: A Buffer node then takes these AI-generated, platform-specific posts and schedules them for optimal times across your social media channels like Twitter, LinkedIn, and Facebook. Centralized Archiving: All of the content data, including the AI-generated summaries and insights, are automatically logged into a Google Sheets database. This creates a powerful, searchable archive and an analytics dashboard for tracking content performance. How to Set Up 🛠️ Import the Workflow: Copy the provided workflow JSON and import it into your n8n instance. Configure Credentials: OpenAI: Add your API Key. WordPress: Add your API credentials. Buffer: Add your API credentials. Google Sheets: Add your OAuth2 credentials. Customize Workflow Nodes: Node 1 (WordPress Trigger): Select your WordPress credential. You can also add other trigger nodes like RSS Feed Read Trigger if needed. Node 2 (OpenAI): You can customize the prompt to get different kinds of output or translate into more languages. Node 4 (Buffer): Select the social media profiles you want to post to. Node 5 (Google Sheets): Replace the placeholder [YOUR SPREADSHEET ID] and [YOUR CONTENT LOG SHEET NAME] with your own details and map the data columns. Save & Activate: Once all settings and credentials are configured, save the workflow and click the "Inactive" toggle in the top-right corner to make it live.

Whether you’re a product manager, developer, or simply curious about workflow automation, you’re in the right place. This n8n workflow is designed to help you streamline and automate your social media content creation, approval, and publishing process—all with minimal manual effort. I’ve put together this guide to make it easy for you to get started, even if you’re new to n8n or automation tools. You’ll find step-by-step instructions, helpful links, and tips to ensure a smooth setup. Feel free to explore, experiment, and make this workflow your own! Let’s dive in and unlock the power of automation together! What This Workflow Does This workflow automates the process of creating, reviewing, and publishing social media posts for LinkedIn and Twitter (X), including image generation and approval steps. It also notifies via Slack and logs posts in Google Sheets. Workflow json: https://drive.google.com/drive/folders/1zE5W0Ff6EBoAFRHupWPybC-fnGZqE84r?usp=sharing Prerequisites An n8n account (sign up for free: n8n Cloud) API credentials for: OpenAI (for content and image generation) LinkedIn Gmail (for approval emails) Twitter/X Slack Google Sheets You’ll find help to set up auth at the end of this doc! How to Use This Workflow Step 1: Import the Workflow Download or copy the workflow JSON. In n8n, click Import and paste/upload the workflow. Step 2: Set Up Credentials For each service node (OpenAI, LinkedIn, Gmail, Twitter, Slack, Google Sheets), click the node and select or create the required credentials. Use the official setup links provided earlier for each service. Step 3: Configure the Trigger The workflow starts with a Form Trigger node. Open the node to customize the form fields if needed. Step 4: Test the Workflow Click Test Workflow to run it manually. Fill out the form to generate a post. The workflow will: Generate platform-specific content using AI. Send an approval email. If approved, generate an image (if selected). Publish to LinkedIn and Twitter. Notify via Slack. Log the post in Google Sheets. Step 5: Review and Adjust Check each node for errors or missing credentials. Adjust content prompts, approval logic, or output formatting as needed. Helpful n8n Resources n8n Quickstart Guide How to use workflow templates Working with credentials Using expressions in n8n

Automates the process of generating, storing, and publishing engaging LinkedIn posts derived from books (PDFs) using AI and vector search. 🧠 Overview This workflow: Watches a Google Drive folder for new or updated book PDFs. Extracts and embeds the content using OpenAI. Stores the data in a Pinecone vector database. Uses a LangChain agent to generate post ideas. Creates concise LinkedIn posts with hook, insight, CTA. Updates a Google Sheet and posts to LinkedIn. 🛠 Workflow Breakdown 📥 1. Google Drive Trigger Trigger:** Watches a folder for new or updated PDF files. Action:** Downloads the updated PDF. 📄 2. Extract and Embed Content Extract from File:** Parses PDF to extract text. Text Splitter:** Breaks text into chunks. Embeddings (OpenAI):** Converts chunks into vector embeddings. Pinecone Vector Store:** Saves the embeddings with the book name as namespace. 🧠 3. Post Idea Generation (LangChain Agent) Uses a prompt to: Search Pinecone DB Extract insights Format into 5 LinkedIn post ideas with: Hook Insight CTA Memory buffer** and structured output parser are used for clean AI interaction. ✍️ 4. Post Creation Each idea is: Split Rewritten with a GPT model prompt to match LinkedIn tone Styled for under 600 characters Includes emojis, hashtags, and tone guidelines 📊 5. Google Sheet Integration Saves all generated posts to a Google Sheet. Marks status: "published" or "no". 🔁 6. Scheduled Publishing Every day: Pulls an unpublished post Publishes it to LinkedIn Updates the post's status and timestamp in the Google Sheet ⚙️ Setup Guide 📂 Google Drive Create a folder for book PDFs Connect your Google Drive account to n8n Provide access token with file read permission 📊 Google Sheets Create a Google Sheet with columns: bookname, hook, insight, cta, postContent, published, date Add credentials in n8n with read/write permission 🧠 Pinecone Set up a Pinecone project and index (linkdenpost) Namespace will be auto-named using the book filename 🔑 API Credentials Required OpenAI API** (for embeddings and post generation) Pinecone API** (for vector storage and retrieval) LinkedIn OAuth2** (to publish posts) Google Drive & Sheets** credentials 🔁 Flow Summary graph TD A[Google Drive Trigger] --> B[Download PDF] B --> C[Extract Text] C --> D[Text Splitter] D --> E[Create Embeddings] E --> F[Pinecone Vector Store] F --> G[LangChain Agent] G --> H[Structured Output (5 Post Ideas)] H --> I[Split Ideas] I --> J[Format as LinkedIn Post (GPT)] J --> K[Store in Google Sheet] L[Schedule Trigger] --> M[Get Unpublished Post] M --> N[Post to LinkedIn] N --> O[Mark as Published] 🧪 Prompt Example (Used in LangChain Agent) You are a content strategist. Search the Pinecone vector DB containing a book. Generate 5 unique LinkedIn post ideas with: A Hook (curiosity driven) Insight (summary < 100 words) CTA ("Agree or disagree?", etc.) Respond in structured JSON: [ { "Hook": "...", "Insight": "...", "CTA": "..." }, ... ] ✅ Output Sample { "Hook": "Why your lab's results might be invalid 😱", "Insight": "ISO/IEC 17025 stresses that labs must plan and address risks to impartiality and validity.", "CTA": "Does your lab audit for these risks?" } 📆 Schedule Control Uses Schedule Trigger to post daily at a set time. Ensures automation with LinkedIn and accurate Google Sheet syncing. 📝 Notes Posts remain professional and concise for a LinkedIn audience Works with any PDF book Supports multi-book pipelines You can filter and tag books by filename or folder for segmenting post styles