Workflow Templates

Social Media Analysis and Automated Email Generation > by Thomas Vie Thomas@pollup.net Who is this for? This template is ideal for marketers, lead generation specialists, and business professionals seeking to analyze social media profiles of potential leads and automate personalized email outreach efficiently. What problem is this workflow solving? Manually analyzing social media profiles and crafting personalized emails can be time-consuming and prone to errors. This workflow streamlines the process by integrating social media APIs with AI to generate tailored communication, saving time and increasing outreach effectiveness. What this workflow does: Google Sheets Integration: Start with a Google Sheet containing lead information such as LinkedIn URL, Twitter handle, name, and email. Social Media Data Extraction: Automatically fetch profile and activity data from Twitter and LinkedIn using RapidAPI integrations. AI-Powered Content Generation: Use OpenAI's Chat Model to analyze the extracted data and generate personalized email subject lines and cover letters. Automated Email Dispatch: Send the generated email directly to the lead, with a copy sent to yourself for tracking purposes. Progress Tracking: Update the Google Sheet to indicate completed actions. Setup: Google Sheets: Create a sheet with the columns: LinkedIn URL, name, Twitter handle, email, and a "done" column for tracking. Populate the sheet with your leads. RapidAPI Accounts: Sign up for RapidAPI and subscribe to the Twitter and LinkedIn API plans. Configure API authentication keys in the workflow. AI Configuration: Connect OpenAI Chat Model with your API key for text generation. Email Integration: Add your email credentials or service (SMTP or third-party service like Gmail) for sending automated emails. How to customize this workflow to your needs: Modify the AI Prompt:** Adapt the prompt in the AI node to better align with your tone, style, or specific messaging framework. Expand Data Fields:** Add additional data fields in Google Sheets if you require further personalization. API Limits:** Adjust API configurations to fit your usage limits or upgrade to higher tiers for increased data scraping capabilities. Personalize Email Templates:** Tweak email formats to suit different audiences or use cases. Extend Functionality:** Integrate additional social media platforms or CRM tools as needed. By implementing this workflow, you’ll save time on repetitive tasks and create more effective lead generation strategies.

Sort New Gmail messages by category with AI 👥 Who's it for This workflow is perfect for individuals or teams who receive a high volume of emails 📥 and want to automatically organize them into Gmail labels 🏷️ using AI. No coding required! For sorting existing emails messages in your gmail inbox, please use this free workflow: Categorize and Label Existing Gmail Emails Automatically with GPT-4o mini. 🤖 What it does It automatically processes new Gmail emails, skips those that already have labels, sends the content to an AI Agent powered by GPT-4o mini 🧠, and applies a relevant label based on the content. All labels must exist in Gmail beforehand. ⚙️ How it works 📬 Gmail Trigger – Activates on new email received. 🚫 Filter – Skips emails that already have a label. 🧠 AI Agent (GPT-4o mini) – Analyzes the message and decides which label fits best. 🧾 Structured Output Parser – Formats the AI output into a clean JSON. 🔀 Switch Node – Routes each email to the correct label path based on the AI result. 🏷️ Gmail Nodes – Assign the Gmail label to the original email. 📋 Requirements Gmail account connected to n8n Pre-created labels in Gmail matching the AI categories OpenAI credentials with GPT-4o mini access n8n's AI Agent & Structured Output Parser nodes 🛠️ How to set up Open the workflow and adjust the trigger interval (e.g., every minute, hours or Custom using Cron ⏱️) Check that the Filter skips emails with existing labels Define your categories in the AI Agent prompt and make sure they match the Gmail labels Configure the Switch Node conditions for each category Ensure each Gmail Label Node applies the correct label Save and activate the workflow ✅ 🎨 How to customize the workflow Add or remove categories in the AI prompt & Switch Node Fine-tune prompt instructions to match your specific use case

✨😃 Automated Workflow Backups to Google Drive This workflow automates the process of backing up your n8n workflows to Google Drive daily. It creates timestamped folders, saves workflows as JSON files, and manages old backups by retaining only the most recent seven days of data. Notifications are sent via Telegram to keep you informed of the backup status. How It Works Backup Creation Process 🗂️ Triggering Backups**: The workflow starts with either a manual trigger or a scheduled trigger that runs daily. Folder Creation**: Creates a new folder in Google Drive with a timestamped name (e.g., n8n-Workflow-Backups-YYYY-MM-DD). Workflow Retrieval**: Fetches all workflows from your n8n instance. File Conversion**: Converts each workflow into a JSON file for storage. File Upload**: Saves the JSON files into the newly created Google Drive folder. Backup Management 🔄 Folder Search**: Searches for existing backup folders in Google Drive with names matching n8n-Workflow-Backups. Retention Policy**: Identifies folders older than seven days using a custom JavaScript function and deletes them permanently to free up space. Notifications 📲 Telegram Alerts**: Sends a message via Telegram once the backup process is complete, including the folder name and a link to access it in Google Drive. Setup Steps API Configuration 🔑 Google Drive Integration: Set up Google Drive OAuth2 credentials in n8n. Specify the root folder or desired location for backups. n8n API Access: Configure n8n API credentials to allow fetching workflows. Telegram Notifications: Add your Telegram bot credentials and chat ID for notification delivery. Workflow Customization ⚙️ Define the schedule for automatic backups (e.g., daily at midnight). Adjust the retention period if you need more or fewer days of backups. Customize the Telegram message format as needed. Testing & Deployment 🚀 Run the workflow manually to verify folder creation and file uploads. Check that old folders are deleted correctly after seven days. Confirm Telegram notifications are sent with accurate details. Use Case Scenarios This workflow is perfect for teams or individuals who want to ensure their n8n workflows are securely backed up and organized. It is especially useful for: Protecting against accidental data loss. Automating routine administrative tasks. By combining automated backups, retention management, and real-time notifications, this workflow ensures your n8n workflows are always safe and accessible!

✅ What problem does this workflow solve? Tired of the back-and-forth involved in scheduling meetings? This workflow lets you offer a seamless, voice-based appointment booking experience. It automatically checks your Cal.com availability and either books a meeting or helps the caller choose another time—powered by ElevenLabs for a human-like voice interaction. ⚙️ What does this workflow do? Receives an inbound voice call (e.g., from a website or IVR system). Uses ElevenLabs to drive the voice interaction with natural, AI-generated speech. Checks real-time availability from your Cal.com calendar. Books a meeting if a slot is available. If not, asks the user to suggest a new time and checks availability again. Confirms the appointment with a verbal response and optional email or SMS. 🔧 Setup 🧠 ElevenLabs Custom Tools Setup Add two tools in Custom Tools in ElevenLabs with the following details. Name: bookSlot Description: Use this tool when the user confirms their slot and appointment. When you have the proper name and email of theirs. POST: {n8n_webhook_url} Name: checkAvailableSlot Description: Use this slot to check Available slots in our calendar. POST: {n8n_webhook_url} 🗣 ElevenLabs Prompt Configuration First Message: Thanks for calling InfyOm Technologies. How can I help you? Use the following System Prompt: 1. Personality You are a clear, helpful, and respectful assistant focused solely on booking appointments for clients. Identity**: A virtual appointment scheduler. Core Traits**: Polite, efficient, conversational, respectful. Role**: Guide users through choosing a time, checking availability, and finalizing the booking. 2. Tone Your tone is polite, professional, and engaging—friendly enough to feel human, but focused enough to stay on task. Use conversational cues like “Okay,” “Got it,” “Sounds good,” etc. Maintain a warm but efficient pace. Speak clearly and respectfully at all times. Ensure the conversation is on both topics. 3. Goal Your task is to book an appointment for the client. Step-by-step Conversation Flow Greeting & Purpose Greet politely and state the purpose. Example: “Hi! I’m here to help you book an appointment.” Request Preferred Time Ask: “Can you please tell me your preferred time slot for the appointment?” Understand the user's date, and if it is not clear, then ask for the full date with month and year. Check Availability Use the checkAvailableSlot tool with the user’s preferred time. If the slot is available: Confirm with the user: “That slot is available. Should I go ahead and book it for you?” If the user agrees, → Use bookSlot. If the slot is not available: Say: “It looks like that time isn’t available... Would you like to look for the same time on the next day?” Handle Next-Day Option If the user agrees, check availability for the same time on the next day using checkAvailableSlot. If available, → confirm and use bookSlot. If not, → politely inform and ask for a different time. Close the Call Confirm the booking if done. Example: “Great! Your appointment is booked. Thank you and have a wonderful day!” 4. Guardrails Do not** discuss anything unrelated to appointment booking. If the user asks for something outside your scope: Say: “I’m only here to help with appointment bookings. For other questions, please contact our support team.” Never speculate about unavailable data or functions. Never ask for a date format from the User, like Say date in Day Month and Year format. If you can't understand the user's date, then say Please speak the full date. 5. Tools You can use the following tools to help book appointments: checkAvailableSlot: Use this to check if the user’s requested time is open. bookSlot: Use this to confirm the appointment after the user agrees. End call Always says Thanks for reaching out to us. Have a nice day. 📅 Cal.com API Setup Go to cal.com and generate an API Key. Create new Cal API credentials in n8n. Set this API Key in the credentials. 🧠 How it Works ☎️ 1. Incoming Call An inbound call is received by the system, and the user begins the conversation with your voice AI agent. 🧏 2. Voice Interaction via ElevenLabs The caller is greeted and asked for their preferred appointment time. All conversations are powered by natural AI speech from ElevenLabs. 🗓 3. Availability Check (Cal.com) The requested time is validated against your Cal.com availability: ✅ If available, the appointment is booked instantly. ❌ If unavailable, the agent informs the caller and asks for another time. 🔁 4. Retry Loop (If Slot Unavailable) If the initial slot is unavailable: The agent asks for a new preferred time. The process repeats until a valid slot is found or a fallback message is delivered. ✅ 5. Appointment Confirmation Once booked, the AI confirms the appointment verbally. You may also configure it to send: 📧 Email confirmations 📱 SMS reminders (optional) 👤 Who can use it? This is perfect for: 🧑‍⚕️ Clinics or Therapists 🧑‍💼 Consultants & Coaches 🏢 Sales Teams 🧠 AI-first SaaS Tools If your business relies on scheduled meetings and you'd like to automate bookings using a conversational voice experience, this is your go-to no-code solution.

Who’s it for This workflow is perfect for HR teams, recruiters, or hiring managers who collect applicant information via a web form and want to automatically forward both candidate details and attached resumes into a dedicated Telegram channel or group. It streamlines manual email checks, speeding up review and collaboration. How it works On form submission: A Form Trigger node captures all applicant fields (name, age, WhatsApp number, education, desired role, availability date, expected salary, resume file, and additional comments). Date & Time: Formats the “fastest start date” into a human-readable string. Edit Fields: A Set node renames and reshapes incoming JSON into clear key/value pairs. If Have Resume: An If node routes submissions with an attached resume to one branch (sending both info and document) and submissions without a resume to a simpler info-only branch. Merge: Combines branches so both message types terminate in a single unified flow. Send a Resume & Send a Info: Two Telegram nodes post Markdown-formatted messages (and the PDF resume when available) to your specified Telegram chat. How to set up Install and enable the n8n-nodes-base.formTrigger and n8n-nodes-base.telegram community nodes (preview). Copy this JSON into your n8n instance (Workflow → Import from clipboard). Create environment variables for credentials: TELEGRAM_BOT_TOKEN TELEGRAM_CHAT_ID In each Telegram node, reference these variables instead of hard-coding ({{$env.TELEGRAM_BOT_TOKEN}}, {{$env.TELEGRAM_CHAT_ID}}). Requirements n8n version ≥ 0.200.0 Community nodes: Form Trigger, Telegram A Telegram bot with chat permissions A hosted form endpoint or embedded form at path /mmc-newjob How to customize the workflow Form fields: Edit the **Form Trigger node’s formFields.values to add or remove fields. Telegram formatting: Tweak captions under **Send a Resume and Send a Info to adjust the MarkdownV2 styling. Conditional logic: Modify the **If Have Resume node to branch on other criteria (e.g., education level). Styling: Update the customCss section in **Form Trigger to match your brand’s look. Good to know Community nodes may be in preview; test thoroughly before production. Webhook URLs change when you rename the workflow—revisit your form’s embed or webhook settings after renaming. Consider adding an Error Trigger node to capture failures and notify your team.

Description This workflow automates your email communication by listening for incoming emails and notifying you via Telegram. It then prompts you to provide a quick response, which it transforms into a polished, professional message inspired by Chick-fil-A’s renowned customer support style—super friendly, thoughtful, and smooth. This ensures your replies always sound top-notch, even if you’re not naturally great at writing customer messages. I use this exact flow for my own business to handle customer interactions with ease and exceptional care. Step-by-Step Setup Instructions 1. Email Connection Connect your email inbox (e.g., Gmail, Outlook) to the workflow to monitor incoming emails. Set the trigger to listen for new messages or specific labels/folders as needed. 2. Telegram Connection Connect your Telegram account using a Telegram Bot token. Configure the bot to send notifications when a new email arrives and to receive your reply input directly in Telegram. 3. OpenAI Connection Connect your OpenAI account by adding your API key. Use OpenAI to rephrase your raw responses into highly polished, friendly customer support messages. Workflow Description The system continuously monitors your email inbox. When a new email arrives, you receive an instant Telegram notification with the email summary. You reply quickly on Telegram with your initial thoughts or answers. The reply is sent to OpenAI, which “translates” it into a Chick-fil-A style, ultra-courteous response. The final message is either emailed back to the customer or saved for you to review and send manually. Target Audience and Problem Solved This workflow is perfect for: Small business owners who handle customer support alone. Entrepreneurs who want to maintain a high level of professionalism in their responses but struggle with wording. Teams looking to streamline email replies with fast, human-like, and warm communication. Problem solved: It removes the stress of crafting perfectly polite and engaging customer support emails from scratch, saving time and boosting customer satisfaction. Customization Guidance Adapting tone and style:** Change the OpenAI prompt to match your brand voice, whether more formal, casual, or playful. Different business contexts:** Adjust email filters or Telegram notifications to prioritize specific types of inquiries. Response automation:** Add extra steps to automatically send replies or integrate with CRM tools. Multilingual support:** Incorporate language detection and translation if your business serves customers in multiple languages.

Generate & Schedule Social Media Posts with GPT-4 and Telegram Approval Workflow This comprehensive content automation system features 23 nodes that seamlessly orchestrate AI-powered content creation, validation, and multi-platform publishing through Telegram interaction. It supports posting to major platforms like Twitter, LinkedIn, Facebook, Instagram, and more via the Upload-Post API. Core Components Telegram Integration: Bidirectional messaging with approval workflows and real-time notifications. AI Content Engine: Configurable language models (GPT-4, Claude, etc.) via OpenRouter with structured output parsing. Content Validation: Character count enforcement (240-265), format checking, and quality threshold monitoring. Multi-Platform Publishing: Post on any social media platform with Upload-Post API - better and easier to use than Blotato, with a dedicated n8n community node. Approval System: Preview and approve/reject functionality before content goes live. Web Research: Optional Tavily integration for real-time information gathering. Target Users Content creators seeking consistent social media presence. Digital marketers managing multiple brand accounts. Entrepreneurs wanting automated thought leadership. Agencies needing scalable content solutions. Small businesses without dedicated social media teams. Setup Requirements To get started, you'll need: Telegram Bot: Create via @BotFather and configure webhook. Required APIs: OpenRouter (for AI model access). Upload-Post API (superior alternative to Blotato with community node support). Tavily API (optional for research). n8n Prerequisites: Version 1.7+ with Langchain nodes. Webhook configuration enabled. Proper credential storage setup. Disclaimer: This template uses community-supported nodes, such as the Upload-Post API node. These may require additional setup and could change with n8n updates. Always verify compatibility and test in a safe environment. Step-by-Step Setup Guide Install n8n: Ensure you're running n8n version 1.7 or higher. Enable webhook configurations in your settings. Set Up Credentials: In n8n, add credentials for OpenRouter, Upload-Post API, and optionally Tavily. Store them securely. Create Telegram Bot: Go to Telegram, search for @BotFather, and create a new bot. Note the token and set up a webhook pointing to your n8n instance. Import the Workflow: Copy the workflow JSON (available in the template submission) and import it into your n8n dashboard. Configure Nodes: Set your AI model preferences in the OpenRouter node. Link your social media accounts via the Upload-Post API node. Adjust validation settings (e.g., character limits, retry attempts) as needed. Test the Workflow: Trigger a test run via Telegram by sending a content request. Approve or reject the preview, and monitor the output. Schedule or Automate: Use n8n's scheduling features for automated triggers, or run manually for on-demand posts. Usage Instructions Initiate via Telegram: Send a message to your bot with a topic or prompt (e.g., "Create a post about AI automation for entrepreneurs"). AI Generation: The system generates content using your chosen model, with optional web research. Validation Check: Content is automatically validated for length, quality (70% pass threshold), and format. Approval Workflow: Receive a preview in Telegram. Reply with "approve" to post, or "reject" to retry (up to 3 attempts). Publishing: Approved content posts to your selected platforms. Get notifications on success or errors. Customization: Adapt for single posts, 3-6 post threads, or different tones (business, creative, educational, personal, technical). Use scheduling for consistent posting. Workflow Features Universal Platform Support: Post to any social media platform via Upload-Post API. Scheduling Flexibility: Automated triggers or manual execution. Content Types: Single posts or multi-post threads. Quality Control: 30% error tolerance with detailed validation reporting. Character Optimization: Enforced 240-265 character range for maximum engagement. Topic Versatility: Adapts tone and style based on content type. Error Handling: Comprehensive validation with helpful user feedback. Performance Specifications: AI retry attempts: 3 for reliability. Validation threshold: 70% pass rate. Format support: Single posts and 3-6 post threads. Platform coverage: Any social media platform through Upload-Post API. Research capability: Optional web search for trending topics. Why Upload-Post API? Community-supported n8n node for easier integration. More reliable and feature-rich than Blotato. Supports all major social platforms. Active development and support. Workflow Image Need help customizing this workflow for your specific use case, Femi? As a fellow entrepreneur passionate about automation and business development, I'd be happy to consult. Connect with me on LinkedIn: https://www.linkedin.com/in/femi-adedayo-h44/ or email for support. Let's make your AI automation agency even more efficient!

UptimeRobot Alerts to Telegram with Visual Verification Automatically sends Telegram notifications with optional screenshots when monitors change status (✅ UP/🔴 DOWN/⏸️ PAUSED) Example Message in Telegram: Who Is This For? Teams or individuals needing to: Get alerts when websites/services go down Verify outages with visual screenshots Monitor infrastructure from Telegram What Does This Workflow Solve? 🚨 Missed Alerts: Get immediate notifications in Telegram 🖼️ Visual Verification: Optional screenshot confirmation of outages 📊 Status Tracking: Clear records of when issues began/resolved 🔗 One-Click Access: Direct links to affected monitors ⏱️ Time Savings: No need to check dashboards manually Setup Guide 1. Pre-Requisites UptimeRobot Account**: With at least one monitor configured Gmail Account**: To receive alert notifications Telegram Account**: To receive alerts (mobile/desktop app recommended) (Optional) ScreenshotMachine free/paid account 2. Credentials Setup Make sure your n8n instance is connected with: Gmail Account** (via OAuth2) UptimeRobot API** (via API key) Telegram Bot** (via bot token) (Optional) ScreenshotMachine (via customer key) 3. Configure Your n8n Workflow Nodes 1. Alert Trigger Gmail Trigger**: Configure to watch for emails from alert@uptimerobot.com Set appropriate polling interval (e.g., every 5 minutes) 2. Monitor Configuration Conf Node**: Set your preferences: { "take_screenshot": true, "screenshotmachine_secret": "your-secret-here", "screenshotmachine_device": "desktop", "screenshotmachine_dimension": "1366xfull", "screenshotmachine_format": "png" } 3. Notification Settings Telegram Nodes**: Set your Chat ID (find with @getidsbot) Customize message formatting if needed 4. Service-Specific Setup UptimeRobot: Go to Dashboard → My Settings → API Settings Create API key with "Monitor Read" permissions Enable email alerts in monitor settings Telegram Bot: Message @BotFather to create new bot Get your Chat ID using @getidsbot Add bot token to n8n credentials ScreenshotMachine (Optional): Sign up at screenshotmachine.com Get Customer Key from account dashboard Set your secret phrase if using hash verification Final Steps Test your workflow by manually triggering a monitor status change Verify Telegram notifications arrive as expected Check screenshot quality if enabled Monitor for a few days to fine-tune alert preferences Happy Monitoring!

Overview This comprehensive n8n workflow automatically transforms trending Google search queries into engaging LinkedIn posts using AI. The system runs autonomously, discovering viral topics, researching content, and publishing professionally formatted posts to grow your social media presence. Workflow Description Automate your entire social media content pipeline - from trend discovery to publication. This workflow monitors Google Trends, selects high-potential topics, creates human-like content using advanced AI, and publishes across multiple social platforms with built-in tracking. Key Features Automated Trend Discovery**: Pulls trending topics from Google Trends API with customizable filters Intelligent Topic Selection**: AI chooses the most relevant trending topic for your niche Multi-AI Content Generation**: Combines Perplexity for research and OpenAI for content curation Human-Like Writing**: Advanced prompts eliminate AI detection markers LinkedIn Optimization**: Proper formatting with Unicode characters, emojis, and engagement hooks Multi-Platform Support**: Ready for LinkedIn, Twitter/X, and Facebook posting Automated Scheduling**: Configurable posting times (default: 6 AM & 6 PM daily) Performance Tracking**: Automatic logging to Google Sheets with timestamps and metrics Error Handling**: Built-in delays and retry mechanisms for API stability Technical Implementation Workflow Architecture Schedule Trigger: Automated execution at specified intervals Google Trends API: Fetches trending search queries with geographical filtering Data Processing: JavaScript code node filters high-volume keywords (30+ search volume) Topic Selection: OpenAI GPT-3.5 evaluates and selects optimal trending topic Content Research: Perplexity AI researches selected topic for current information Content Generation: Advanced prompt engineering creates LinkedIn-optimized posts Content Distribution: Multi-platform posting with platform-specific formatting Analytics Tracking: Google Sheets integration for performance monitoring Node Breakdown Schedule Trigger**: Configurable timing for automated execution HTTP Request (Google Trends)**: SerpAPI integration for trend data Set Node**: Structures trending data for processing Code Node**: JavaScript filtering for high-volume keywords OpenAI Node**: Intelligent topic selection based on relevance and trend strength HTTP Request (Perplexity)**: Advanced AI research with anti-detection prompts Wait Node**: Rate limiting and API respect Split Out**: Prepares content for multi-platform distribution LinkedIn Node**: Authenticated posting with community management Google Sheets Node**: Automated tracking and analytics Social Media Nodes**: Twitter/X, LinkedIn and Facebook ready for activation Use Cases Content Creators**: Maintain consistent posting schedules with trending content Marketing Agencies**: Scale content creation across multiple client accounts Business Development**: Build thought leadership with timely industry insights Personal Branding**: Establish authority by commenting on trending topics SEO Professionals**: Create content around high-search-volume keywords Configuration Requirements API Integrations SerpAPI**: Google Trends data access Perplexity AI**: Advanced content research capabilities OpenAI**: Content curation and topic selection LinkedIn Community Management API**: Professional posting access Google Sheets API**: Analytics and tracking Authentication Setup LinkedIn OAuth2 community management credentials Google Sheets OAuth2 integration HTTP header authentication for AI services Customization Options Industry Targeting**: Modify prompts for specific business verticals Posting Schedule**: Adjust timing based on audience activity Content Tone**: Customize voice and style through prompt engineering Platform Selection**: Enable/disable specific social media channels Trend Filtering**: Adjust search volume thresholds and geographic targeting Content Length**: Modify character limits for different platforms Advanced Features Anti-AI Detection**: Sophisticated prompts create human-like content Rate Limit Management**: Built-in delays prevent API throttling Error Recovery**: Robust error handling with retry mechanisms Content Deduplication**: Prevents posting duplicate content Engagement Optimization**: LinkedIn-specific formatting for maximum reach Performance Metrics Time Savings**: Eliminates 10+ hours of weekly content creation Consistency**: Maintains regular posting schedule without manual intervention Relevance**: Content always based on current trending topics Engagement**: Optimized formatting increases social media interaction Scalability**: Single workflow manages multiple platform posting Installation Notes Import JSON workflow file into n8n instance Configure all required API credentials Set up Google Sheets tracking document Test workflow execution with manual trigger Enable schedule trigger for automated operation Best Practices Monitor API usage to stay within rate limits Regularly update prompts based on content performance Review and adjust trending topic filters for your niche Maintain backup of workflow configuration Test content output before enabling automation Support & Updates Comprehensive setup documentation included Configuration troubleshooting guide provided Regular workflow updates for API changes Community support through n8n forums Tags social-media content-automation linkedin ai-generation google-trends perplexity openai marketing trend-analysis content-creation Compatibility n8n Version: 1.0+ Node Requirements: Standard n8n installation External Dependencies: API access to listed services Hosting: Compatible with cloud and self-hosted n8n instances

Description: Create Social Media Content from Telegram with AI This n8n workflow empowers you to effortlessly generate social media content and captivating image prompts, all powered by AI. Simply send a topic request through Telegram (as a voice or text message), and watch as the workflow conducts research, crafts engaging social media posts, and creates detailed image prompts ready for use with your preferred AI art generation tool. What does this workflow do? This workflow streamlines the content creation process by automating research, social media content generation, and image prompt creation, triggered by a simple Telegram message. Who is this for? Social Media Managers:** Quickly generate engaging content and image ideas for various platforms. Content Creators:** Overcome writer's block and discover fresh content ideas with AI assistance. Marketing Teams:** Boost productivity by automating social media content research and drafting. Anyone** looking to leverage AI for efficient and creative social media content creation. Benefits Effortless Content and Image Prompt Generation:** Automate the creation of social media posts and detailed image prompts. AI-Powered Creativity:** Leverage the power of LLMs to generate original content ideas and captivating image prompts. Increased Efficiency:** Save time and resources by automating the research and content creation process. Voice-to-Content:** Use voice messages to request content, making content creation even more accessible. Enhanced Engagement:** Create high-quality, attention-grabbing content that resonates with your audience. How it Works Receive Request: The workflow listens for incoming voice or text messages on Telegram containing your content request. Process Voice (if necessary): If the message is a voice message, it's transcribed into text using OpenAI's Whisper API. AI Takes Over: The AI agent, powered by an OpenAI Chat Model and SerpAPI, conducts online research based on your request. Content and Image Prompt Generation: The AI agent generates engaging social media content and a detailed image prompt based on the research. Image Generation (Optional): You can use the generated image prompt with your preferred AI art generation tool (e.g., DALL-E, Stable Diffusion) to create a visual. Output: The workflow provides you with the social media content and the detailed image prompt, ready for you to use or refine. n8n Nodes Used Telegram Trigger Switch Telegram (for fetching voice messages) OpenAI (Whisper API for voice-to-text) Set (for preparing variables) AI Agent (with OpenAI Chat Model and SerpAPI tool) HTTP Request (for optional image generation) Extract from File (for optional image processing) Set (for final output) Prerequisites Active n8n instance Telegram account with a bot OpenAI API key SerpAPI account Hugging Face API key (if you want to generate images within the workflow) Setup Import the workflow JSON into your n8n instance. Configure the Telegram Trigger node with your Telegram bot token. Set up the OpenAI and SerpAPI credentials in the respective nodes. If you want to generate images directly within the workflow, configure the HTTP Request node with your Hugging Face API key. Test the workflow by sending a voice or text message to your Telegram bot with a topic request. This workflow combines the convenience of Telegram with the power of AI to provide a seamless content creation experience. Start generating engaging social media content today!

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Who is this for? If your inbox is full of unread emails, this workflow is for you. Instead of reading through them one by one, let AI do the sorting. It reads your emails and flags only what needs action. What does it solve? This workflow reads your unread Gmail emails and uses AI to decide what’s important — and what’s not. It labels emails that need your attention, identifies receipts, and trashes everything else. No more manual reading. Just an inbox that uses AI to take care of itself. How it works Every hour, the workflow runs automatically. It searches for unread emails in your Gmail inbox. For each email: It extracts the content and sends it to OpenAI. The AI returns one of four labels: Action, Receipt, Informational or Spam. Based on the label: Emails are marked with the appropriate label. Or moved to trash it is spam. It marks the email as read once processed. How to set up? Connect these services in your n8n credentials: Gmail (OAuth2) OpenAI (API key) Create the Gmail labels: In your Gmail account, create these labels exactly as written: Action, Receipt, and Informational The workflow will apply these labels based on AI classification. How to customize this workflow to your needs Change the AI prompt to detect more types of emails like Meeting or Newsletter. Add more branches to the Switch node to apply custom logic. Change the schedule to fit your workflow. By default, it runs every hour, but you can update this in the Schedule Trigger node.

Follow me on LinkedIn for more! Category: Lead Generation, Data Collection, Business Intelligence Tags: lead-generation, google-maps, rapidapi, business-data, contact-extraction, google-sheets, duplicate-prevention, automation Difficulty Level: Intermediate Estimated Setup Time: 15-20 minutes Template Description Overview This powerful n8n workflow automates the extraction of comprehensive business information from Google Maps using keyword-based searches via RapidAPI's Local Business Data service. Perfect for lead generation, market research, and competitive analysis, this template intelligently gathers business data including contact details, social media profiles, and location information while preventing duplicates and optimizing API usage. Key Features 🔍 Keyword-Based Google Maps Scraping**: Search for any business type in any location using natural language queries 📧 Contact Information Extraction**: Automatically extracts emails, phone numbers, and social media profiles (LinkedIn, Instagram, Facebook, etc.) 🚫 Smart Duplicate Prevention**: Two-level duplicate detection saves 50-80% on API costs by skipping processed searches and preventing duplicate business entries 📊 Google Sheets Integration**: Seamless data storage with automatic organization and structure 🌍 Multi-Location Support**: Process multiple cities, regions, or countries in a single workflow execution ⚡ Rate Limiting & Error Handling**: Built-in delays and error handling ensure reliable, uninterrupted execution 💰 Cost Optimization**: Intelligent batching and duplicate prevention minimize API usage and costs 📱 Comprehensive Data Collection**: Gather business names, addresses, ratings, reviews, websites, verification status, and more Prerequisites Required Services & Accounts RapidAPI Account with subscription to "Local Business Data" API Google Account for Google Sheets integration n8n Instance (cloud or self-hosted) Required Credentials RapidAPI HTTP Header Authentication** for Local Business Data API Google Sheets OAuth2** for data storage and retrieval Setup Instructions Step 1: RapidAPI Configuration Create RapidAPI Account Sign up at RapidAPI.com Navigate to "Local Business Data" API Subscribe to a plan (Basic plan supports 1000 requests/month) Get API Credentials Copy your X-RapidAPI-Key from the API dashboard Note the host: local-business-data.p.rapidapi.com Configure n8n Credential In n8n: Settings → Credentials → Create New Type: HTTP Header Auth Name: RapidAPI Local Business Data Add headers: X-RapidAPI-Key: YOUR_API_KEY X-RapidAPI-Host: local-business-data.p.rapidapi.com Step 2: Google Sheets Setup Enable Google Sheets API Go to Google Cloud Console Enable Google Sheets API for your project Create OAuth2 credentials Configure n8n Credential In n8n: Settings → Credentials → Create New Type: Google Sheets OAuth2 API Follow OAuth2 setup process Create Google Sheet Structure Create a new Google Sheet with these tabs: keyword_searches sheet: | select | query | lat | lon | country_iso_code | |--------|-------|-----|-----|------------------| | X | Restaurants Madrid | 40.4168 | -3.7038 | ES | | X | Hair Salons Brooklyn | 40.6782 | -73.9442 | US | | X | Coffee Shops Paris | 48.8566 | 2.3522 | FR | stores_data sheet: The workflow will automatically create columns for business data including: business_id, name, phone_number, email, website, full_address, rating, review_count, linkedin, instagram, query, lat, lon, and 25+ more fields Step 3: Workflow Configuration Import the Workflow Copy the provided JSON In n8n: Import from JSON Update Placeholder Values Replace YOUR_GOOGLE_SHEET_ID with your actual Google Sheet ID Update credential references to match your setup Configure Search Parameters (Optional) Adjust limit: 1-100 results per query (default: 100) Modify zoom: 10-18 search radius (default: 13) Change language: EN, ES, FR, etc. (default: EN) How It Works Workflow Process Load Search Criteria: Reads queries marked with "X" from keyword_searches sheet Load Existing Data: Retrieves previously processed data for duplicate detection Filter New Searches: Smart merge identifies only new query+location combinations Process Each Location: Sequential processing prevents API overload Configure Parameters: Prepares search parameters from sheet data API Request: Calls RapidAPI to extract business information Parse Data: Structures and cleans all business information Save Results: Stores new leads in stores_data sheet Rate Limiting: 10-second delay between requests Loop: Continues until all new searches are processed Duplicate Prevention Logic Search Level: Compares new queries against existing data using query+latitude combination, skipping already processed searches. Business Level: Each business receives a unique business_id to prevent duplicate entries even across different searches. Data Extracted Business Information Business name, full address, phone number Website URL, Google My Business rating and review count Business type, price level, verification status Geographic coordinates (latitude/longitude) Detailed location breakdown (street, city, state, country, zip) Contact Details Email addresses (when publicly available) Social media profiles: LinkedIn, Instagram, Facebook, Twitter, YouTube, TikTok, Pinterest Additional phone numbers Direct Google Maps and reviews links Search Metadata Original search query and parameters Extraction timestamp and geographic data API response details for tracking Use Cases Lead Generation Generate targeted prospect lists for B2B sales Build location-specific customer databases Create industry-specific contact lists Develop territory-based sales strategies Market Research Analyze competitor density in target markets Study business distribution