19 templates found
Category:
Author:
Sort:

Generate logos and images with consistent visual styles using Imagen 3.0

This n8n template allows you to use AI to generate logos or images which mimic visual styles of other logos or images. The model used to generate the images is Google's Imagen 3.0. With this template, users will be able to automate design and marketing tasks such as creating variants of existing designs, remixing existing assets to validate different styles and explore a range of designs which would have been otherwise too expensive and time-consming previously. How it works A form trigger is used to capture the source image to reference styles from and a prompt for the target image to generate. The source image is passed to Gemini 2.0 to be analysed and its visual style and tone extracted as a detailed description. This visual style description is then combined with the user's initial target image prompt. This final prompt is given to Imagen 3.0 to generate the images. A quick webpage is put together with the generated images to present back to the user. If the user provided an email address, a copy of this HTML page will be sent. How to use Ensure the workflow is live to share the form publicly. The source image must be accessible to your n8n instance - either a public image of the internet or within your network. For best results, select a source image which has strong visual identity as these will allow the LLM to better describe it. For your prompt, refer to the imagen prompt guide found here: https://ai.google.dev/gemini-api/docs/image-generationimagen-prompt-guide Requirements Gemini for LLM and Imagen model. Cloudinary for image CDN. Gmail for email sending. Customising this workflow Feel free to swap any of these out for tools and services you prefer. Want to fully automate? Switch the form trigger for a webhook trigger!

JimleukBy Jimleuk
23314

Ai fitness coach Strava data analysis and personalized training insights

Detailed Title "Triathlon Coach AI Workflow: Strava Data Analysis and Personalized Training Insights using n8n" --- Description This n8n workflow enables you to build an AI-driven virtual triathlon coach that seamlessly integrates with Strava to analyze activity data and provide athletes with actionable training insights. The workflow processes data from activities like swimming, cycling, and running, delivers personalized feedback, and sends motivational and performance improvement advice via email or WhatsApp. --- Workflow Details Trigger: Strava Activity Updates Node: Strava Trigger Purpose: Captures updates from Strava whenever an activity is recorded or modified. The data includes metrics like distance, pace, elevation, heart rate, and more. Integration: Uses Strava API for real-time synchronization. Step 1: Data Preprocessing Node: Code Purpose: Combines and flattens the raw Strava activity data into a structured format for easier processing in subsequent nodes. Logic: A recursive function flattens JSON input to create a clean and readable structure. Step 2: AI Analysis with Google Gemini Node: Google Gemini Chat Model Purpose: Leverages Google Gemini's advanced language model to analyze the activity data. Functionality: Identifies key performance metrics. Provides feedback and insights specific to the type of activity (e.g., running, swimming, or cycling). Offers tailored recommendations and motivational advice. Step 3: Generate Structured Output Node: Structure Output Purpose: Processes the AI-generated response to create a structured format, such as headings, paragraphs, and bullet lists. Output: Formats the response for clear communication. Step 4: Convert to HTML Node: Convert to HTML Purpose: Converts the structured output into an HTML format suitable for email or other presentation methods. Output: Ensures the response is visually appealing and easy to understand. Step 5: Send Email with Training Insights Node: Send Email Purpose: Sends a detailed email to the athlete with performance insights, training recommendations, and motivational messages. Integration: Utilizes Gmail or SMTP for secure and efficient email delivery. Optional Step: WhatsApp Notifications Node: WhatsApp Business Cloud Purpose: Sends a summary of the activity analysis and key recommendations via WhatsApp for instant access. Integration: Connects to WhatsApp Business Cloud for automated messaging. --- Additional Notes Customization: You can modify the AI prompt to adapt the recommendations to the athlete's specific goals or fitness levels. The workflow is flexible and can accommodate additional nodes for more advanced analysis or output formats. Scalability: Ideal for individual athletes or coaches managing multiple athletes. Can be expanded to include additional metrics or insights based on user preferences. Performance Metrics Handled: Swimming: SWOLF, stroke count, pace. Cycling: Cadence, power zones, elevation. Running: Pacing, stride length, heart rate zones. --- Implementation Steps Set Up Strava API Key: Log in to Strava Developers to generate your API key. Integrate the API key into the Strava Trigger node. Configure Google Gemini Integration: Use your Google Gemini (PaLM) API credentials in the Google Gemini Chat Model node. Customize Email and WhatsApp Messaging: Update the Send Email and WhatsApp Business Cloud nodes with the recipient’s details. Automate Execution: Deploy the workflow and use n8n's scheduling features or cron jobs for periodic execution. --- GET n8n Now N8N COURSE n8n Book Developer Notes Author: Amjid Ali improvements. Resources: See in Action: Syncbricks Youtube PayPal: Support the Developer Courses : SyncBricks LMS By using this workflow, triathletes and coaches can elevate training to the next level with AI-powered insights and actionable recommendations.

Amjid AliBy Amjid Ali
12376

Auto-publish social videos to 9 platforms via Google Sheets and Blotato

Auto-Publish Social Videos to 9 Platforms via Google Sheets and Blotato Who is this workflow for? This workflow is ideal for marketers, content creators, virtual assistants, and automation specialists managing multi-platform video content. It’s especially useful for teams who want to centralize publishing via a spreadsheet and automate social distribution in one shot. What problem does this workflow solve? Manually posting videos to multiple social platforms is tedious and time-consuming. This workflow allows you to streamline video distribution using Blotato’s API — no more switching between platforms or re-uploading the same video multiple times. What this workflow does This automation reads video metadata (URL, caption, title) from a Google Sheet, uploads the video to Blotato, and automatically publishes it to Instagram, YouTube, TikTok, Facebook, LinkedIn, Threads, Twitter (X), Pinterest, and Bluesky. It also updates the sheet to reflect the publishing status (STATUS = DONE), ensuring that your data remains clean and trackable. Setup Set up your Google Sheet with the required columns: PROMPT, DESCRIPTION, URL VIDEO, Titre, row_number, and STATUS. Add your Blotato API key in the headers of the Upload Video and Post to X nodes. Replace the platform-specific IDs in the Assign Social Media IDs node (Instagram ID, Facebook Page ID, etc.). Set the schedule in the Schedule Trigger node to define when the publishing happens. > ⚠️ Disclaimer: This workflow uses Community Nodes. These are only available on self-hosted n8n instances. How to customize this workflow Add logic to skip rows already marked as DONE. Expand to more platforms supported by Blotato. Use a webhook or Telegram trigger instead of the scheduler for more interactivity. Modify content per platform if needed (caption formatting, hashtags, etc.). 📄 Documentation: Notion Guide Demo Video 🎥 Watch the full tutorial here: YouTube Demo

Dr. FirasBy Dr. Firas
11989

IT support chatbot with Google Drive, Pinecone & Gemini | AI doc processing

This n8n template empowers IT support teams by automating document ingestion and instant query resolution through a conversational AI. It integrates Google Drive, Pinecone, and a Chat AI agent (using Google Gemini/OpenRouter) to transform static support documents into an interactive, searchable knowledge base. With two interlinked workflows—one for processing support documents and one for handling chat queries—employees receive fast, context-aware answers directly from your support documentation. Overview Document Ingestion Workflow Google Drive Trigger: Monitors a specified folder for new file uploads (e.g., updated support documents). File Download & Extraction: Automatically downloads new files and extracts text content. Data Cleaning & Text Splitting: Utilizes a Code node to remove line breaks, trim extra spaces, and strip special characters, while a text splitter segments the content into manageable chunks. Embedding & Storage: Generates text embeddings using Google Gemini and stores them in a Pinecone vector store for rapid similarity search. Chat Query Workflow Chat Trigger: Initiates when an employee sends a support query. Vector Search & Context Retrieval: Retrieves the top relevant document segments from Pinecone based on similarity scores. Prompt Construction: A Code node combines the retrieved document snippets with the user’s query into a detailed prompt. AI Agent Response: The constructed prompt is sent to an AI agent (using OpenRouter Chat Model) to generate a clear, step-by-step solution. Key Benefits & Use Case Imagine a large organization where every IT support document—from troubleshooting guides to system configurations—is stored in a single Google Drive folder. When an employee encounters an issue (e.g., “How do I reset my VPN credentials?”), they simply type the query into a chat interface. Instantly, the workflow retrieves the most relevant context from the ingested documents and provides a detailed, actionable answer. This process reduces resolution times, enhances support consistency, and significantly lightens the load on IT staff. Prerequisites A valid Google Drive account with access to the designated folder. A Pinecone account for storing and retrieving text embeddings. Google Gemini (or OpenRouter) credentials to power the Chat AI agent. An operational n8n instance configured with the necessary nodes and credentials. Workflow Details 1 Document Ingestion Workflow Google Drive Trigger Node: Listens for file creation events in the specified folder. Google Drive Download Node: Downloads the newly added file. Extract from File Node: Extracts text content from the downloaded file. Code Node (Data Cleaning): Cleans the extracted text by removing line breaks, trimming spaces, and eliminating special characters. Recursive Text Splitter Node: Segments the cleaned text into manageable chunks. Pinecone Vector Store Node: Generates embeddings (via Google Gemini) and uploads the chunks to Pinecone. 2 Chat Query Workflow Chat Trigger Node: Receives incoming user queries. Pinecone Vector Store Node (Query): Searches for relevant document chunks based on the query. Code Node (Context Builder): Sorts the retrieved documents by relevance and constructs a prompt merging the context with the query. AI Agent Node: Sends the prompt to the Chat AI agent, which returns a detailed answer. How to Use Import the Template: Import the template into your n8n instance. Configure the Google Drive Trigger: Set the folder ID (e.g., 1RQvAHIw8cQbtwI9ZvdVV0k0x6TM6H12P) and connect your Google Drive credentials. Set Up Pinecone Nodes: Enter your Pinecone index details and credentials. Configure the Chat AI Agent: Provide your Google Gemini (or OpenRouter) API credentials. Test the Workflows: Validate the document ingestion workflow by uploading a sample support document. Validate the chat query workflow by sending a test query and verifying the returned support information. Additional Notes Ensure all credentials (Google Drive, Pinecone, and Chat AI) are correctly set up and tested before deploying the workflows in production. The template is fully customizable. Adjust the text cleaning, splitting parameters, or the number of document chunks retrieved based on your support documentation's size and structure. This template not only enhances IT support efficiency but also offers a scalable solution for managing and leveraging growing volumes of support content.

AI IncarnationBy AI Incarnation
11888

Bulk file upload to Google Drive with folder management

🗂️ Bulk File Upload to Google Drive with Folder Management How it works User submits files and target folder name via form Workflow checks if folder exists in Drive Creates folder if needed or uses existing one Processes and uploads all files maintaining structure Set up steps (Est. 10-15 mins) Set up Google Drive credentials in n8n Replace parent folder ID in search query with your Drive folder ID Configure form node with: Multiple file upload field Folder name text field Test workflow with sample files 💡 Detailed configuration steps and patterns are documented in sticky notes within the workflow. Perfect for: Bulk file organization Automated Drive folder management File upload automation Maintaining consistent file structures

Julian KaiserBy Julian Kaiser
6699

Download recently liked songs automatically with Spotify

Purpose This workflow enables you to listen to your recent favorites in very hight quality offline without sacrificing all of your storage. How it works This workflow automatically creates a playlist in Spotify named "Downloads" which periodically gets updated so it always contains only a defined amount of the latest liked songs. This enables only the Downloads playlist to set for automatic downloading and thus free up space on the device. Setup The workflow is ready to go. Just select your Spotify credentials and activate the workflow. In Spotify just enable automatic downloads on the automatically created Downloads folder after the first workflow run. Current limitations This setup currently supports a maximum of 50 songs in the Downloads Playlist. This is due to the paylod limits defined by Spotify encountered in the Get liked songs node. Implementing batching would solve the issue.

MarioBy Mario
3330

Multi-channel workflow error alerts with Telegram, Gmail & messaging apps

The Error Notification workflow is designed to instantly notify you whenever any other n8n workflow encounters an error, using popular communication channels like Telegram and Gmail—with optional support for Discord, Slack, and WhatsApp. 💡 Why Use Error Notification workflow? Immediate Awareness: Get instant alerts when workflows fail, preventing unnoticed errors and downtime. Multi-Channel Flexibility: Notify your team via Telegram, Gmail, and optionally Slack, Discord, or WhatsApp. Detailed Context: Receive rich error information including the error message, node name, time, and execution link for quicker fixes. Easy Integration: Built with native n8n nodes and customizable code, simple to adopt without complex setup. Open Source & Free: Use and adapt this workflow at no cost, making professional error monitoring accessible. ⚡ Who Is This For? n8n Workflow Developers: Quickly spot and respond to automation issues in development or production. Operations Teams: Maintain uptime and swiftly troubleshoot errors across multiple workflows. Small to Medium Businesses: Gain professional error alerting without expensive monitoring tools. Automation Enthusiasts: Enhance your automation reliability with real-time failure notifications. ❓ What Problem Does It Solve? This workflow embedd error detection and notification directly within your n8n instance. It automates the process of catching errors as they occur, compiling meaningful context, and delivering it instantly via your preferred messaging platforms. This drastically reduces your response time to issues and streamlines error management, improving your automation reliability and operational confidence. 🔧 What This Workflow Does ⏱ Trigger: Listens for any error generated in your n8n workflows using the n8n Error Trigger node. 📎 Step 2: Executes a Code node that formats a detailed error message capturing workflow name, error node, description, timestamp, and an execution URL. 🔍 Step 3: Sends the formatted error notification to multiple communication channels: Telegram and Gmail by default, plus optionally Discord, Slack, and WhatsApp (disabled by default). 💌 Step 4: Delivers rich, parsed HTML-formatted messages to ensure error readability and immediate actionability. 🔐 Setup Instructions Import the provided .json file into your n8n instance (Cloud or self-hosted). Set up credentials: Gmail OAuth credentials for sending emails via Gmail node Telegram API credentials for Telegram notifications (Optional) Discord Webhook URL credential for Discord notifications (Optional) Slack Webhook credential for Slack notifications (Optional) WhatsApp connection credentials (if enabled) Customize the Code node if needed to adjust the error message format or target chat IDs. Update the chat IDs and recipient details in each notification node according to your channels. Test the workflow by manually triggering an error in another workflow to verify proper notifications. 🧩 Pre-Requirements Active n8n instance (cloud or self-hosted) with version supporting Error Trigger node Telegram bot credentials and chat ID (Optional) Gmail, Discord, Slack, or WhatsApp accounts and webhook credentials if you want to use those channels 🛠️ Customize It Further Enable and configure additional notification nodes like Slack or WhatsApp to fit your team's communication style. Customize the error message template in the Code node to include extra metadata or format it differently (e.g., markdown). Integrate with incident management tools via webhook nodes or create tickets automatically on error. 🧠 Nodes Used Error Trigger Code Telegram Gmail Discord (disabled) Slack (disabled) WhatsApp (disabled) Sticky Note (for description) 📞 Support Made by: khaisa Studio Tag: notification,error,monitoring,workflow,automation,alerts Category: Monitoring & Alerts Need a custom? Need a custom? contact me on LinkedIn or Web

Khairul MuhtadinBy Khairul Muhtadin
3028

🛠️ Auto workflow positioning

Check Online Version ! [https://n8n-tools.streamlit.app/](https://n8n-tools.streamlit.app/ ) Who is it for? This workflow is perfect for n8n users who want to maintain clean and organized workflows without manually repositioning nodes. Whether you're building complex workflows or sharing them with a team, maintaining visual clarity is essential for efficiency and collaboration. This template automates the positioning process, saving time and ensuring consistent layout standards. --- How does it work? The template is divided into two parts: Positioning Engine: A webhook node kicks off the process by receiving a workflow ID. Using the provided workflow ID, an n8n API node fetches the workflow details. The fetched workflow is sent to a processing webhook that calculates optimized positions for the nodes. Finally, an n8n API node updates the workflow with the newly positioned nodes, ensuring a clean and professional layout. Reusable Positioning Block: This is an HTTP Request node that can be seamlessly integrated into any workflow you create. When triggered, it sends the current workflow for automatic positioning via the first part of this template. --- How to set it up? Enable n8n API Access: Ensure that your n8n instance has API access enabled with the appropriate credentials. Input Your n8n API URL and Credentials: Open the template, locate the n8n API nodes, and update them with your instance API key. Update the URL of the 'Magic Positioning' Http Request node to point to your n8n instance webhook URL. Embed the Reusable Block: Add the provided HTTP Request node to any of your workflows to instantly connect to the auto-positioning engine.

Lucas PeyrinBy Lucas Peyrin
2677

🛠️ Re-Access Binary Data from Any Previous Node

How it works Ever had binary data (like images, PDFs, or files) disappear in your n8n workflow after an intermediate node processed it? This workflow provides a powerful solution by demonstrating how to re-access and re-attach binary data from any previous node, even if it was dropped along the way. Think of it like having a reliable backup copy of your file always available, no matter what happens to the original as it moves through your workflow. Here's how this template works step-by-step: Initial Binary Fetch: The workflow starts by fetching a binary image (the n8n logo) from a URL using an HTTP Request node. This is our original binary data. Simulated Data Loss: A Set node then processes this data. Crucially, by default, Set nodes (and many others) do not pass binary data to subsequent nodes. This step intentionally simulates a common scenario where your binary data might seem to "disappear" from the workflow's output. Re-Access and Re-Attach: The core of the solution is a Code node. It uses a specific n8n expression ($(nodeName).item) to reach back to the original node that produced the binary data (Get n8n Logo (Binary)). It then retrieves that binary data and uses this.helpers.prepareBinaryData() to correctly re-attach it to the current item, making it available for all subsequent nodes. Set up steps Setup time: 0 minutes! This is a self-contained tutorial workflow, so no external accounts or credentials are required. Simply click the "Execute Workflow" button to run it. Observe the output of the Re-Access Binary Data from Previous Node to see the binary data successfully re-attached. Important for Customization: If you adapt this technique to your own workflows, remember to update the previousNodeName variable within the Re-Access Binary Data from Previous Node (Code node) to match the exact name of the node that originally produced the binary data you wish to retrieve.

Lucas PeyrinBy Lucas Peyrin
1203

AI-Powered Invoice Processing Automation with Mistral OCR & GPT-5.2

🚀 Automate Invoice Processing with an End-to-End AI Workflow Powered by GPT-5.2 Transform your invoice management with a fully automated, AI-driven invoice processing workflow built on n8n, combining Mistral AI OCR and OpenAI GPT-5.2 for unmatched accuracy, scalability, and speed. This intelligent document automation system automatically extracts, structures, validates, and standardizes invoice data from PDFs and scanned documents—eliminating manual data entry and reducing accounting errors to near zero. 🔍 Key Features of This AI Invoice Automation Workflow ✅ Advanced OCR for Invoice Recognition Powered by Mistral AI’s state-of-the-art OCR, optimized for: Complex invoice layouts Multi-language documents Scanned PDFs and low-quality images Tables, line items, and financial fields ✅ Intelligent Invoice Data Extraction with GPT-5.2 Uses OpenAI GPT-5.2, the latest-generation language model, to: Understand invoice context and structure Identify vendors, customers, and payment terms Normalize inconsistent formats across suppliers Convert unstructured OCR text into clean, structured data ✅ Multi-Page Invoice Processing Automatically merges and processes multi-page invoices, ensuring: Accurate line-item continuity Correct totals and tax calculations Reliable page-by-page data consolidation ✅ Fully Automated, No-Code Workflow (n8n) From file upload to structured JSON output in seconds: Zero manual intervention Scalable for high invoice volumes Ideal for SMEs, enterprises, and finance teams ✅ Custom JSON Schema for Accounting Systems Exports standardized invoice data ready for: ERP systems Accounting software Finance dashboards Data warehouses 📊 Invoice Data Automatically Extracted Supplier and customer details Invoice number, issue date, due date Payment terms and currency Detailed line items (description, quantity, unit price, tax) Subtotals, VAT / tax breakdowns, grand totals User metadata and workflow query context 🔧 Technical Architecture & Workflow Overview This AI-powered invoice processing pipeline demonstrates how to: Monitor Google Drive for new invoice uploads Convert PDF or image files to Base64 Call Mistral AI OCR APIs with authentication Combine and clean multi-page OCR outputs Use GPT-5.2 AI agents with optimized system prompts Transform raw text into validated, structured JSON schemas Deliver production-ready data for downstream systems ⚡ Getting Started in Minutes Create a Mistral AI account → https://console.mistral.ai/ Configure your OpenAI API key for GPT-5.2 Connect your Google Drive credentials Import the n8n workflow and run 🚀 💼 Real-World Business Use Cases 📌 Finance & Accounting Automation Automatic invoice capture and reconciliation Faster month-end closing Reduced human error 📌 Accounts Payable & Expense Management Streamline vendor invoice processing Accelerate approval workflows Improve cash flow visibility 📌 Document Digitization & Data Extraction Convert PDFs and scanned invoices into structured data Centralize document intelligence 📌 Business Intelligence & Spend Analysis Analyze supplier spending Track cost categories Enable data-driven financial decisions 🌍 Why Combine OCR + GPT-5.2 for Invoice Processing? By combining best-in-class OCR technology with GPT-5.2’s deep contextual understanding, this workflow delivers: Higher extraction accuracy than rule-based systems Faster processing at scale Future-proof AI automation for finance operations 🔑 Keywords & SEO Tags invoiceProcessingAutomation AIInvoiceProcessing OCRInvoiceExtraction GPT52 OpenAIGPT52 MistralAI n8nAutomation AccountsPayableAutomation FinanceAutomation DocumentAI IntelligentDocumentProcessing InvoiceOCR

BadrBy Badr
949

AI-driven competitor & market intelligence with GPT 4 & Apify

Automated AI-Driven Competitor & Market Intelligence System Problem Solved: Small and Medium-sized IT companies often struggle to stay ahead in a rapidly evolving market. Manually tracking competitor moves, pricing changes, product updates, and emerging market trends is time-consuming, inconsistent, and often too slow for agile sales strategies. This leads to missed sales opportunities, ineffective pitches, and a reactive rather than proactive market approach. Solution Overview: This n8n workflow automates the continuous collection and AI-powered analysis of competitor data and market trends. By leveraging web scraping, RSS feeds, and advanced AI models, it transforms raw data into actionable insights for your sales and marketing teams. The system generates structured reports, notifies relevant stakeholders, and stores intelligence in your database, empowering your team with real-time, strategic information. For Whom: This high-value workflow is perfect for: IT Solution Providers & SaaS Companies: To maintain a competitive edge and tailor sales pitches based on competitor weaknesses and market opportunities. Sales & Marketing Leaders: To gain comprehensive, automated market intelligence without extensive manual research. Product Development Teams: To identify market gaps and validate new feature development based on competitive landscapes and customer sentiment. Business Strategists: To inform strategic planning with data-driven insights into industry trends and competitive threats. How It Works (Scope of the Workflow) ⚙️ This system establishes a powerful, automated pipeline for market and competitor intelligence: Scheduled Data Collection: The workflow runs automatically at predefined intervals (e.g., weekly), initiating data retrieval from various online sources. Diverse Information Gathering: It pulls data from competitor websites (pricing, features, blogs via web scraping services), industry news and blogs (via RSS feeds), and potentially other sources. Intelligent Data Preparation: Collected data is aggregated, cleaned, and pre-processed using custom code to ensure it's in an optimal format for AI analysis, removing noise and extracting relevant text. AI-Powered Analysis: An advanced AI model (like OpenAI's GPT-4o) performs in-depth analysis on the cleaned data. It identifies competitor strengths, weaknesses, new offerings, pricing changes, customer sentiment from reviews, emerging market trends, and suggests specific opportunities and threats for your company. Automated Report Generation: The AI's structured insights are automatically populated into a professional Google Docs report using a predefined template, making the intelligence easily digestible for your team. Team Notification: Stakeholders (sales leads, marketing managers) receive automated notifications via Slack (or email), alerting them to the new report and key insights. Strategic Data Storage & Utilization: All analyzed insights are stored in a central database (e.g., PostgreSQL). This builds a historical record for long-term trend analysis and can optionally trigger sub-workflows to generate personalized sales talking points directly relevant to ongoing deals or specific prospects. --- Setup Steps 🛠️ (Building the Workflow) To implement this sophisticated workflow in your n8n instance, follow these detailed steps: Prepare Your Digital Assets & Accounts: Google Sheet (Optional, if using for CRM data): For simpler CRM, create a sheet with CompetitorName, LastAnalyzedDate, Strengths, Weaknesses, Opportunities, Threats, SalesTalkingPoints. API Keys & Credentials: OpenAI API Key: Essential for the AI analysis. Web Scraping Service API Key: For services like Apify, Crawlbase, or similar (e.g., Bright Data, ScraperAPI). Database Access: Credentials for your PostgreSQL/MySQL database. Ensure you've created necessary tables (competitorprofiles, markettrends) with appropriate columns. Google Docs Credential: To link n8n to your Google Drive for report generation. Create a template Google Doc with placeholders (e.g., {{competitorName}}, {{strengths}}). Slack Credential: For sending team notifications to specific channels. CRM API Key (Optional): If directly integrating with HubSpot, Salesforce, or custom CRM via API. Identify Data Sources for Intelligence: Compile a list of competitor website URLs you want to monitor (e.g., pricing pages, blog sections, news). Identify relevant online review platforms (e.g., G2, Capterra) for competitor products. Gather RSS Feed URLs from key industry news sources, tech blogs, and competitor's own blogs. Define keywords for general market trends or competitor mentions, if using tools that provide RSS feeds (like Google Alerts). Build the n8n Workflow (10 Key Nodes): Start a new workflow in n8n and add the following nodes, configuring their parameters and connections carefully: Cron (Scheduled Analysis Trigger): Set this to trigger daily or weekly at a specific time (e.g., Every Week, At Hour: 0, At Minute: 0). HTTP Request (Fetch Competitor Web Data): Configure this to call your chosen web scraping service's API. Set Method to POST, URL to the service's API endpoint, and build the JSON/Raw Body with the startUrls (competitor websites, review sites) for scraping, including your API Key in Authentication (e.g., Header Auth). RSS Feed (Fetch News & Blog RSS): Add the URLs of competitor blogs and industry news RSS feeds. Merge (Combine Data Sources): Connect inputs from both Fetch Competitor Web Data and Fetch News & Blog RSS. Use Merge By Position. Code (Pre-process Data for AI): Write JavaScript code to iterate through merged items, extract relevant text content, perform basic cleaning (e.g., HTML stripping), and limit text length for AI input. Output should be an array of objects with content, title, url, and source. OpenAI (AI Analysis & Competitor Insights): Select your OpenAI credential. Set Resource to Chat Completion and Model to gpt-4o. In Messages, create a System message defining AI's role and a User message containing the dynamic prompt (referencing {{ $json.map(item => ... ).join('\\n\\n') }} for content, title, url, source) and requesting a structured JSON output for analysis. Set Output to Raw Data. Google Docs (Generate Market Intelligence Report): Select your Google Docs credential. Set Operation to Create document from template. Provide your Template Document ID and map the Values from the parsed AI output (using JSON.parse($json.choices[0].message.content).PropertyName) to your template placeholders. Slack (Sales & Marketing Team Notification): Select your Slack credential. Set Chat ID to your team's Slack channel ID. Compose the Text message, referencing the report link ({{ $json.documentUrl }}) and key AI insights (e.g., {{ JSON.parse($json.choices[0].message.content).Competitor_Name }}). PostgreSQL (Store Insights to Database): Select your PostgreSQL credential. Set Operation to Execute Query. Write an INSERT ... ON CONFLICT DO UPDATE SQL query to store the AI insights into your competitorprofiles or markettrends table, mapping values from the parsed AI output. OpenAI (Generate Personalized Sales Talking Points - Optional Branch): This node can be part of the main workflow or a separate, manually triggered workflow. Configure it similarly to the main AI node, but with a prompt tailored to generate sales talking points based on a specific sales context and the stored insights. Final Testing & Activation: Run a Test: Before going live, manually trigger the workflow from the first node. Carefully review the data at each stage to ensure correct processing and output. Verify that reports are generated, notifications are sent, and data is stored correctly. Activate Workflow: Once testing is complete and successful, activate the workflow in n8n. This system will empower your IT company's sales team with invaluable, data-driven intelligence, enabling them to close more deals and stay ahead in the market.

MarthBy Marth
910

Publish content to Instagram, TikTok & more from Google Drive using PostPulse

Description This automation template enables you to publish content from a Google Drive folder directly to multiple social platforms — TikTok, Instagram, YouTube, LinkedIn, Telegram, Bluesky, X (Twitter), and Threads. By connecting PostPulse with n8n, you can transform a manual posting routine into a seamless automated workflow, ensuring consistent cross-platform publishing without repetitive tasks. ⚠️ Disclaimer: This workflow uses the community node @postpulse/n8n-nodes-postpulse. Make sure community nodes are enabled in your n8n instance before importing and using this template. 👉 To install it: Go to Settings → Community Nodes → Install and enter:"@postpulse/n8n-nodes-postpulse". 💡 For more details, see n8n Integration Guide: PostPulse Developers – n8n Integration. Who Is This For? Marketers who want to manage multiple accounts at once. Creators who store media on Google Drive and want to quickly expand it. Teams for whom it is important to centralize the content plan and have a transparent publishing system. What Problem Does This Workflow Solve? Instead of manually uploading photos or videos to TikTok, Instagram, YouTube or other social networks, you get: Centralizing uploads: Add your media once to Google Drive, and the system takes care of publishing it everywhere. Multi-platform posting: Publish simultaneously to TikTok, Instagram, YouTube, LinkedIn, Telegram, Bluesky, X, and Threads. Streamlined scheduling: Schedule future posts with PostPulse directly through n8n. Error reduction: Avoid mistakes caused by copy-pasting across platforms. How It Works File Upload: Place your media file (image or video) into a designated Google Drive folder. File Processing: n8n automatically downloads the file and prepares it for upload. Account Retrieval: PostPulse retrieves your connected accounts (TikTok, Instagram, YouTube, etc.). Media Upload: The file is uploaded to PostPulse via n8n. Automation: PostPulse automatically distributes it to TikTok, Instagram, YouTube, LinkedIn, Telegram, Bluesky, X, and Threads. Publishing: PostPulse schedules or directly publishes the post to the selected platforms. Setup Connect PostPulse to n8n Request your OAuth client key and secret from support@post-pulse.com. Add your PostPulse account in n8n Credentials. Connect Google Drive Create a Google Cloud project. Enable the Google Drive API. Configure OAuth credentials and connect your Google Drive account to n8n. Configure Google Drive Trigger Point it to the folder where you will upload your media. Upload Media Node Add the PostPulse “Upload Media” node to process files from Google Drive. Schedule Posts Add the PostPulse “Schedule Post” node. Map content, media path, and connected account IDs. (Optional) Metadata from Google Sheets Use Google Sheets as a source of captions, hashtags, or scheduling details. Requirements Connected Accounts at PostPulse (TikTok, Instagram, YouTube, LinkedIn, Telegram, Bluesky, X, Threads). OAuth client key and secret requested from support@post-pulse.com. Google Cloud Project with the Google Drive API enabled and valid OAuth credentials. ✨ With this workflow, PostPulse and n8n become your all-in-one automation hub for social publishing.

DmytroBy Dmytro
810