APITemplate.io and Google Sheets integration

Who Is This For? 🚘This workflow is designed for auto service / car repair businesses looking to streamline their social media marketing with Ai tools and automation via n8n. Whether you’re a small garage owner, a car repair shop, an automotive specialist or automechanic - this tool helps you maintain an active online presence without spending hours creating content. 💪🏼 Though this template is set up for Auto Service daily content uploads, but the underlying logic is universal. You can easily adapt it for any niche by editing prompts, adding nodes, and creating or uploading a variety of content to any platform. You can use any LLM and generative AI of your choice. Personally, I prefer the smooth and effective results from ChatGPT 4.1 combined with GPT Image 1. But you can generate videos instead of images for your posts as well 😉 What Problem Is This Workflow Solving? 🤦‍♂️ Many auto service businesses struggle with consistently posting engaging content due to time constraints or lack of marketing expertise. 💎This workflow solves that by automating the content creation and posting process, ensuring your social media channels stay fresh and active, ultimately attracting more customers. What This Workflow Does: Generates daily social media posts tailored specifically to the auto service niche using AI. Allows easy customization of post and image prompts. Integrates research links through the Tavily Internet Search tool for relevant content. Supports starting posts based on reference article links via Google Sheets. Automatically publishes posts to your connected social media platforms. Enables scheduled or trigger-based posting for maximum flexibility. How It Works? Easy, actually ☺️ AI creates daily social media content made just for Auto Service. You can simply edit prompts for both posts and images, set up news or articles research links via the Tavily Internet Search tool. You can also start the workflow with a reference article link through Google Sheets. 🎯 Consistently posting relevant and actual niche content helps attract new customers, all while leveraging AI and n8n tools to keep the process seamless and cost-effective. Set Up Steps: I kept it quick and simple for you ✨ If you’re happy with the current LLM and image model configurations, just connect your OpenAI API credentials to enable AI content generation. Link your social media accounts (Facebook, Telegram, X, etc.) for autoposting. Optionally connect Google Sheets if you want to trigger posts based on sheet updates with reference links. Customize prompts as needed to match your brand voice, style and marketing tasks. Choose between: 1) Scheduled automatic generation and posting at the same time as socials algorythms like it. 2) Google Sheets trigger with reference. 3) Manual start. How to Customize This Workflow to Your Needs? Switch AI models and edit prompts to better reflect your specific services or promotions. Add or modify research links in Tavily to keep your posts timely and relevant. Adjust posting schedules to match peak engagement times for your audience. Expand or reduce the number of social platforms integrated depending on your marketing strategy. Use Google Sheets to batch upload ideas or curate specific content topics. After adjusting a few settings, activate the workflow and let it run. 🤖 The system will then automatically publish your content across your selected social platforms — saving you time and effort. 📌 You’ll find more detailed tips and additional ai models for customizing ai generation process inside the workflow via sticky notes. 💬 Need help? For additional guidance, feel free to message me — here’s my profile in the n8n community for direct contact 👈 click!

Who is this for Content creators, solopreneurs, and marketing teams who produce long-form content (podcasts, newsletters, interviews, scripts) and want to automatically turn it into multiple social media assets -- Instagram carousels, LinkedIn carousels, LinkedIn text posts, and LinkedIn media posts -- with human-in-the-loop approval via Microsoft Teams. What this workflow does This workflow takes a long-form content file sent via email, extracts strategic content pillars using AI, then fans out into four parallel branches -- each producing a different social media format. Every draft is reviewed and approved in Microsoft Teams before images are generated, assets are saved to Google Drive, and posts are published via Blotato. How it works Email trigger -- A Gmail Trigger watches for emails with a specific subject line (e.g. "Content Repurposing"). The email contains a text attachment (podcast transcript, newsletter, etc.) and optionally a link to the original content. File extraction & storage -- The attachment is extracted, saved as a Google Doc in a timestamped project subfolder on Google Drive, and the source URL is parsed from the email body. AI content strategist -- The Repurpose Strategist agent (OpenAI) analyzes the full text and extracts 5 strategic content pillars, each with a hook headline, core insight, virality factor, and relevant quote. Results are logged in Google Sheets. Four parallel content branches -- The 5 pillars feed into four specialized AI agents that each produce a different format: Instagram/YouTube carousel -- 5 punchy one-liners (max 25 words each) + a social media caption LinkedIn carousel -- 5 slide texts with hooks + a companion caption, plus a styled PDF carousel via HTML-to-PDF LinkedIn text post -- A single strong LinkedIn post (max 100 words) LinkedIn media post -- A post with a guiding statement rendered as an image Human review loop -- Each branch sends its draft to Microsoft Teams for approval via a custom form (approve/reject with feedback). If rejected, feedback is routed back to the AI agent for targeted revisions. Asset generation & storage -- On approval, carousel images are generated via APITemplate.io, all assets (images, post texts, PDFs) are saved to organized Google Drive subfolders, and results are logged back to Google Sheets. Publishing -- Approved posts are published to Instagram and LinkedIn via Blotato, with status monitoring and Teams notifications on success or failure. Setup steps Gmail -- Create OAuth2 credentials. The trigger watches for emails with "Content Repurposing" in the subject. You can customize this filter. Google Drive & Docs -- Create OAuth2 credentials. Set the target folder ID in the Google Drive Trigger node where project subfolders will be created. Google Sheets -- Create a spreadsheet to serve as the content tracker. It will store pillars, carousel texts, post texts, and metadata. Update the Sheet ID in all Google Sheets nodes. OpenAI -- Add your API key. Used by 5 AI agents (strategist + 4 content specialists). Microsoft Teams -- Create OAuth2 credentials. Set the Teams chat ID in the 4 review nodes to route drafts to your approval channel. APITemplate.io -- Create an account and design carousel slide templates. Set the template ID in the image generation nodes. Blotato -- Connect your Instagram and LinkedIn accounts. Add the Blotato API credential and update account IDs in the publishing nodes. HTML-to-PDF -- Install the community node n8n-nodes-htmlcsstopdf (self-hosted only). Customize the carousel slide HTML/CSS template with your branding (logo, colors, profile photo). Requirements Community nodes:** @blotato/n8n-nodes-blotato n8n-nodes-htmlcsstopdf Self-hosted n8n only** (due to community nodes) Gmail OAuth2 credentials Google Drive, Docs & Sheets OAuth2 credentials OpenAI API key Microsoft Teams OAuth2 credentials APITemplate.io account and template Blotato account with connected Instagram and LinkedIn profiles How to customize AI prompts** -- Each of the 5 AI agents has a detailed system prompt you can adjust for tone, word count, language, or output structure. Carousel design** -- Edit the HTML/CSS in the "HTML to PDF" node to match your brand (colors, fonts, logo, profile photo). Update the APITemplate.io template IDs for Instagram-style slides. Platforms** -- Add or remove publishing branches. Currently supports Instagram (via Blotato) and LinkedIn (text post, carousel, media post). Review channel** -- Change the Teams chat ID to route to different teams or channels. Trigger** -- Swap Gmail for another trigger (e.g. Google Drive, webhook, or manual) depending on your content intake workflow. Feedback loop** -- Each branch supports unlimited revision cycles. The AI applies feedback minimally without rewriting from scratch.

Who is this for Content creators, social media managers, and solopreneurs who want to automate carousel post creation and multi-platform publishing from a single Telegram message. What this workflow does This workflow turns a Telegram message or voice note into a fully designed carousel post published simultaneously to Instagram, Facebook, and TikTok. An AI agent drafts quotes and captions, you approve via chat, and the rest happens automatically -- image generation, publishing, and status tracking. How it works Telegram input -- Send a topic or idea to the Telegram bot as a text message or voice note. Voice transcription -- If a voice note is detected, OpenAI Whisper transcribes it to text. AI drafting -- An AI Agent (OpenAI GPT with conversation memory and structured output) generates a short script, 5 carousel quotes, and a social media caption with hashtags. Review loop -- The draft is sent back to Telegram. You can request changes -- the agent refines until you approve. Data logging -- Approved quotes and the caption are saved to a Google Sheets spreadsheet for reference. Image generation -- Each of the 5 quotes is rendered as a styled carousel slide using your APITemplate.io template. Multi-platform publishing -- The carousel is posted to Instagram, Facebook (with page selection), and TikTok via Blotato. Status monitoring -- Each platform's publish status is polled in a retry loop. You receive a Telegram confirmation on success or an error notification if something fails. Setup steps Telegram Bot -- Create a bot via @BotFather and add the API token as a Telegram credential in n8n. OpenAI -- Add your API key as an OpenAI credential. Used for both the AI Agent and Whisper transcription. Google Sheets -- Create an OAuth2 credential. Set up a spreadsheet with columns: run_id, quote1–quote5, social_media_text. Update the Sheet ID and tab in the Google Sheets node. APITemplate.io -- Create an account and design a carousel slide template. Set the template ID in the five image generation nodes. Blotato -- Connect your Instagram, Facebook, and TikTok accounts in Blotato. Add the Blotato API credential in n8n. Update the account and page IDs in the three publishing nodes. Requirements Community node:* @blotato/n8n-nodes-blotato -- self-hosted n8n only* OpenAI API key Google Sheets OAuth2 credentials APITemplate.io account and template Blotato account with connected social media profiles Telegram Bot token How to customize AI prompt** -- Edit the system message in the "AI: Draft & Revise Post" node to change tone, quote count, or output structure. Carousel design** -- Modify or replace the APITemplate.io template ID to use your own visual design. Platforms** -- Remove or add publishing nodes if you only need some platforms (e.g., Instagram only). Approval flow** -- Adjust the approval keywords in the AI prompt (currently: "approved", "ok", "looks good", "ship it"). Retry timing** -- Change the wait durations in the status-check loops to match your preferred polling interval.

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

Overview An AI-powered, end-to-end interview preparation and mentoring automation system for campus placements. It enables placement cells to generate hyper-personalized 4-page interview preparation PDFs for shortlisted students, by combining job descriptions (JDs), candidate data, and LLMs via LangChain and Ollama. Note: This template requires self-hosted n8n to run community nodes like LangChain and Ollama. What This Workflow Does Accepts a CSV of shortlisted students and a JD via form upload Analyzes student profile vs JD using Ollama LLM via LangChain Generates personalized interview preparation PDFs Sends the PDF to each student via email Logs all data in Google Sheets and prevents duplicate processing Workflow Preview 📷 Please add a workflow screenshot here showing the main nodes and flow Step-by-Step Flow Form Submission CSV of shortlisted students + JD + company name is submitted via HTTP Request form trigger. Data Parsing and Google Sheet Logging CSV parsed → structured rows added to Google Sheet named with company + batch. Candidate Filtering Only students with N8N_Agent = Not Generated are selected to avoid reprocessing. AI-Powered Report Generation LangChain agent (via Ollama + Gemini Search Tool) generates a 4-page Markdown report: Page 1: Profile Summary, Skill Gap Analysis, Company Insights Page 2: 15–20 Personalized Interview Questions Page 3: 5 Group Discussion Topics + Strategy Page 4: Custom Preparation Plan + Suggested Resources PDF Creation Markdown → Stylish PDF via APITemplate.io Email Delivery Each student receives a personalized email with the attached report. Google Sheet Status Update Marks the student’s row as “Generated” in N8N_Agent column. Prerequisites Self-hosted n8n with Community Nodes enabled Local or Docker-hosted Ollama with LLaMA3.2 or equivalent model Activated LangChain and Gemini Search Tool nodes APITemplate.io API Key Connected Google Sheets account SMTP setup or Gmail node for email delivery Customization Tips Replace the LLM prompt in the LangChain node with your own tone/style Modify the PDF template on APITemplate.io to reflect your institution branding Update the email copy for formal or informal tones Add new filters (e.g., minimum CGPA, branch) for student selection