Google Drive and LinkedIn integration

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

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.

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

Who is this for? This workflow is designed for content creators, social media managers, digital marketers, and business owners who want to automate their content creation and distribution process across multiple platforms. It's perfect for those who regularly create content from PDFs or images and want to streamline their social media posting workflow. Key Features Monitors a specific Google Drive folder for new PDFs or images Extracts text from PDFs or images using AI Optionally generates new images from text using OpenAI's DALL-E Automatically posts content with images to multiple platforms Sends notifications about successful posts Handles different file types with specialized extraction methods Workflow Does This workflow automates monitoring a Google Drive folder for new PDFs and images, extracting content using AI, and distributing it across social media platforms like WordPress, Facebook, Telegram, LinkedIn, and Discord. It can also generate new images from text and sends notifications about successful posts. The process ensures efficient handling of different file types and streamlines content sharing across multiple channels. Requirements Google Drive account with a dedicated folder for content OpenAI API credentials for image generation WordPress API credentials for website posting Social media API credentials: Facebook Graph API Telegram Bot API LinkedIn OAuth2 API Discord Bot API X/Twitter OAuth2 API Gmail credentials for email notifications Rapiwa account for WhatsApp notifications Important Notes Make sure all API credentials are properly configured before running the workflow The workflow handles both PDF and image files differently based on their MIME type Image generation is optional and can be disabled if not needed All social media posting nodes can be individually enabled or disabled based on your needs The workflow includes rate limiting to avoid API restrictions Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen

What it is An automated LinkedIn content system that takes a simple form (idea + optional file), generates LinkedIn posts with OpenAI, stores them in Notion, builds Google Slides carousels, and auto-publishes posts (text, image, or document) to LinkedIn on a schedule while keeping Notion in sync. Setup steps Connect integrations: link your Notion database, LinkedIn account, Google Drive/Slides, OpenAI, and Gmail in n8n. Configure the form: set up the “LinkedIn Post Generator” form with the idea field and optional file upload. Map AI outputs: wire the OpenAI nodes so they write post title, funnel stage, and content into your Notion “LinkedIn Auto Posts” database. Enable carousel flow: connect Notion → OpenAI → Google Slides template → Google Drive copy → Notion update for “Create Carousel” items. Set scheduling: use the Schedule Trigger + Notion filters (“Ready for Post” + Scheduled Date) to pick which posts go out each hour. Publish & track: send posts to LinkedIn (text, image, or document), then update Notion status to “Posted” and, if needed, send yourself an email reminder for manual carousel actions.

Automated Social Media Content Publishing Factory + System Prompt Composition This workflow is a powerful automation for creating and publishing social media content. It uses AI to generate content and images based on external prompts and schemas, and routes the final posts to various social media platforms. How it Works This workflow operates as a "Content Publishing Factory". It generates platform-optimized content for platforms like LinkedIn, Instagram, Facebook, X (Twitter), Threads, and YouTube Shorts. A key feature is its dynamic system prompt and output schema composition, which pulls content from external Google Docs to ensure consistency. The workflow can also create images to match the content and send the final draft for approval via email before publishing. Use Cases Centralized Content Management**: Store and manage all system prompts and schemas in Google Docs for easy team collaboration and version control. Brand Consistency**: Ensure a consistent brand voice across all social media platforms by centralizing brand guidelines and content rules. Automated Publishing**: Automate content creation, image generation, and publishing, reducing manual effort and design bottlenecks. Fact-checking and Contextual Relevance**: Incorporate real-time research and fact-checking into content to ensure accuracy and relevance. Setup Instructions Google Docs: Create two Google Docs: one for the social media schema and one for the system prompt, and update the respective node IDs in the workflow. API Credentials: Provide credentials for the following services: OpenAI: For the AI agents and content creation. SerpAPI: For the web search tool to perform research. Gmail: For sending content for approval and notifications. Google Drive: For archiving images and final posts. Social Media Platforms: You'll need credentials for the platforms you wish to publish to (X, Instagram, Facebook, LinkedIn, etc.). Image Hosting: The workflow uses imgbb.com to host generated images, requiring an API key. Workflow Logic Routing Agent: The Social Media Router Agent receives a user prompt and uses a toolWorkflow node to route the request to the appropriate content generation workflow. Prompt & Schema Composition: The workflow fetches the system prompt and platform-specific schemas from Google Docs, parses them, and composes a dynamic prompt for the AI agent. Content Creation: The Social Media Content Creator agent uses the composed prompt and a web search tool to generate platform-optimized content and an image suggestion. Image Generation & Archiving: The workflow generates an image from the AI suggestion using an external service and archives both the image and the final post content in Google Drive. Approval Process: The draft content is sent to a Gmail address for approval. Publishing: If the content is approved, the Social Media Publishing Router node directs the content to the correct publishing node for the specified platform (e.g., X Post, Instagram Image, Facebook Post, etc.). Node Descriptions | Node Name | Description | |-----------|-------------| | When chat message received | A trigger node that initiates the workflow based on a chat message. | | Social Media System Prompt | A Google Docs node that retrieves the main system prompt for the AI agent. | | Social Media Schema | A Google Docs node that retrieves the JSON schema for each social media platform's output. | | Social Media Content Creator | An AI agent that generates content based on user prompts, system prompts, and schemas, using a web search tool for research. | | pollinations.ai1 | An HTTP Request node that generates an image from a text prompt using an external service. | | Gmail User for Approval | Sends a draft of the social media post for approval and pauses the workflow until a decision is made. | | Social Media Publishing Router | A Switch node that routes the workflow to the correct publishing node based on the user's selected platform. | | X Post, Instagram Post, Facebook Post, LinkedIn Post | These nodes publish the final, approved content to their respective social media platforms. | Customization Tips You can replace the pollinations.ai image generation service with any other online service that produces an image file. Replace the gpt-4o and gpt-4o-mini models with other LLMs and web search tools to suit your needs. Adjust the content and parameters for each social media platform to better fit your brand and audience. Suggested Sticky Notes for Workflow Start Here**: "Update all Social Media Platform Credentials as required. Adjust parameters and content for each platform to suit your needs". External System Prompt and Schema**: "Create Google Doc for the Social Media Schema and copy the provided schema. Update the Google Doc ID in the Social Media Schema node.". Create Post Image**: "Replace pollinations.ai with any online image generation service that produces an image file you can download". Social Media Content Creator**: "Replace Chat model with other LLMs and test out the results. Add more tools or try other web search tools to suit your use case." Testing Tips Start the workflow with a manual trigger and verify that the social media content and a related image are generated and sent for approval via Gmail. Approve the content in the Gmail email to test the publishing side of the workflow. Check the specified social media accounts to confirm that the post was published correctly. Suggested Tags & Categories SocialMedia Automation AI ContentCreation Publishing GoogleDocs OpenAI

⚙ AI-Powered Social Media Automation for LinkedIn How It Works This workflow automates the entire social media content creation and publishing process for LinkedIn. It starts with a simple form to collect a topic or idea. The workflow then uses two AI agents to automatically generate both the written content and a unique image prompt. The AI-generated image is created, uploaded, and then downloaded before the final step, where both the content and the image are posted to your LinkedIn account. Setup Steps Follow these steps to get the workflow running in your n8n instance. Prerequisites You will need a working n8n instance and accounts for the following services: OpenAI:** For AI content and image generation. Google Drive:** To temporarily store the generated image. Gmail:** For the file upload process. LinkedIn:** To publish the final post. Workflow Import Import the provided .json file into your n8n instance. All the necessary nodes will appear on your canvas. Configure Credentials Connect the following credentials to their respective nodes: OpenAI:** Connect to the OpenAI Chat Model, AI Agent Content Generator, Ai Agent Prompt Image generator, and Image-1 nodes. Google Drive:** Connect to the Upload file and Download file nodes. Gmail:** Connect to the Send a message node. LinkedIn:** Connect to the Create a post node. Customize the Trigger Form Click on the On form submission node. Review and customize the form fields to fit your specific needs (e.g., add fields for hashtags, target audience, etc.). Click "Share Form" to get the unique URL for your content ideas form. Customize AI Prompts Click on the AI Agent Content Generator node. Review and adjust the System Message to refine the writing style, tone, and character limits for your LinkedIn posts. Similarly, open the Ai Agent Prompt Image generator node and modify the System Message to guide the AI in creating images that match your brand identity. Configure Google Drive Click on the Upload file node. Under the Parameters tab, select the specific Drive ID and Folder ID where you want to temporarily store the generated images. Configure the LinkedIn Post Click on the Create a post node. Ensure that the Text and shareMediaCategory parameters are correctly mapped to the output of the preceding nodes to use the AI-generated text and image. Activate the Workflow Once all credentials and node configurations are complete, click "Save" at the top of the canvas. Finally, toggle the workflow to "Active". The workflow is now live and will automatically create and publish content upon every form submission.

Automated n8n Workflow Documentation and LinkedIn Promotion Streamline your n8n workflow management! This powerful workflow automatically documents your n8n creations in Notion and promotes them on LinkedIn, all triggered by a simple file upload to Google Drive. Leverage Google Gemini AI to generate comprehensive descriptions and engaging social media content effortlessly. Who is this For This workflow is perfect for: n8n Developers** who want to save time on manual documentation Content Creators** regularly sharing n8n workflow templates Teams** needing a centralized, updated database of their automation solutions Consultants** showcasing their n8n expertise and offerings Anyone** looking to automate their workflow publishing and promotion process Features Automated Trigger**: Starts when an n8n workflow JSON is uploaded to a designated Google Drive folder. AI-Powered Description Generation**: Google Gemini AI analyzes your workflow JSON and creates a detailed, human-readable description. Notion Database Integration**: Automatically creates a new page in your Notion database, populated with the workflow's title, AI-generated description, and a direct download link. Dynamic LinkedIn Post Creation**: Transforms the workflow description into an engaging, shareable LinkedIn post. Seamless LinkedIn Publishing**: Automatically posts the generated content to your LinkedIn profile to reach your audience. Centralized Documentation**: Maintains an organized and always-current record of your n8n templates. How It Works Upload Workflow JSON to Google Drive: Simply drag and drop your n8n workflow's JSON file into a specific Google Drive folder configured in the workflow. AI Analyzes and Generates Content: The workflow automatically detects the new file and downloads its content. Google Gemini AI then analyzes the workflow JSON to understand its functionality. The AI crafts a comprehensive description and an engaging LinkedIn post based on the analysis. Notion Documentation: A new page is automatically created in your specified Notion database. This page includes the workflow's title, the AI-generated description, and a direct link to the original JSON file on Google Drive for easy download. LinkedIn Promotion: The AI-generated LinkedIn post is automatically published to your LinkedIn profile. This allows you to effortlessly share your latest n8n creations with your network. Video Demo: See this youtube Video to explore "how it works". Setting Up Google Drive and AI Import the Workflow Create a new workflow in n8n Import the JSON file by clicking "three dots" (upper right corner) > "Import from file..." Configure Google Drive Credentials In the "wait for the json file upload" node, connect your "Google Drive OAuth2 API" credential. Select the specific Google Drive folder where you will upload your n8n workflow JSON files. In the "Download the json" node, connect the same "Google Drive OAuth2 API" credential. Configure Google Gemini API Get your Google AI Studio API key from Google AI Studio Create a "Google Gemini (PaLM) API" credential in n8n. Connect this credential to both the "Description generator" and "Linkedin post generator" nodes. Setting Up Notion and LinkedIn Set Up Notion Integration In the "Create the notion page" node, connect your "Notion API" credential. Select your Notion database. Ensure your Notion database has at least the following properties: "Title" (Title type), "Description" (Rich text type), "Automation Tools" (Select type), "Status" (Select type), and "Template-Download-Link" (URL type). Set Up LinkedIn Integration In the "Create the linkedIn post" node, connect your "LinkedIn OAuth2 API" credential. Specify the Person ID to whom the post should be published (this is usually your profile ID). Test the Workflow Activate the workflow. Upload an n8n workflow JSON file to your designated Google Drive folder. Verify that a Notion page is created and a LinkedIn post is published successfully. Pre-requisites Necessary Accounts:** Google Account (for Google Drive access) Google AI Studio Account (for Gemini API access) Notion Account (with a database for templates) LinkedIn Account (for posting) n8n Instance (cloud or self-hosted) API Access:** Google Generative AI API access Valid Google Drive, Notion, and LinkedIn OAuth/API credentials N8N Requirements:** n8n version 1.0.0 or higher LangChain nodes package installed Internet access for API calls Customization Guidance AI Prompt Tuning: Modify the prompts in the "Generate the description" and "Generate the linkedin post" nodes to adjust the tone, style, length, or specific information requested from the AI. Notion Database Structure: Customize the Notion database properties in the "Create the notion page" node to include additional fields like tags, video demos, or integration details. LinkedIn Post Strategy: Adjust the LinkedIn post generation prompt to include specific hashtags, mentions, or calls to action to optimize for your audience. Technical Specifications Trigger Source**: Google Drive file upload (JSON files) AI Model**: Google Gemini Output Destinations**: Notion database page, LinkedIn personal feed Input Format**: n8n workflow JSON Processing Time**: Typically under 1 minute (depends on AI response time and API calls) Limitations & Considerations Ensure the Google Drive folder specified in the trigger is exclusively for n8n workflow JSONs to prevent accidental triggers from other file types. While AI-generated, it's recommended to manually review descriptions and LinkedIn posts, especially for critical content, before relying solely on automation. API rate limits for Google Gemini, Notion, and LinkedIn should be considered for very high-volume usage. The Notion database must be pre-configured with the correct property types (Title, Rich Text, URL, Select) for the workflow to function as intended. Ready to Automate Your Workflow Documentation and Promotion? This workflow empowers you to effortlessly share and document your n8n creations, allowing you to focus more on building and less on administrative tasks.

Who’s it for This workflow is ideal for marketers, content creators, agencies, and small businesses that want to streamline the process of creating and publishing platform-optimized posts across multiple social media channels. How it works / What it does From a single user prompt, the workflow uses a custom system prompt and schema to generate tailored social media content for LinkedIn, Instagram, Facebook, Twitter (X), Threads, and YouTube Shorts. It creates platform-specific captions, hashtags, calls to action, and even AI-generated image suggestions, then routes the content to the correct publishing channel. How to set up Connect your social media platform credentials in n8n. Add your Google Docs links for the system prompt and content schema. Configure the IMGBB_API_KEY and any other required API credentials. Optionally connect Gmail and Telegram for approval workflows and notifications. Requirements n8n instance (self-hosted or cloud) API credentials for desired platforms Google Docs and Google Drive accounts How to customize the workflow Edit the system prompt and schema in Google Docs to adjust tone, style, and content format for each platform. Modify routing logic or add new platform integrations as needed.

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