Google Docs and Slack integration

Stop forgetting to send follow-up surveys. This workflow automatically generates a tailored post-meeting survey from your Google Meet notes the moment a meeting ends, and sends it to all attendees with one Slack approval. Who is it for Teams and individuals who run recurring meetings and want structured feedback without manually writing and sending surveys after every call. How it works Google Calendar detects when a meeting ends Waits 10 minutes for Gemini to attach notes to the event Reads the meeting notes from Google Docs An AI agent generates 5 to 7 tailored survey questions based on what was discussed Weavely MCP builds and publishes the form automatically A Slack message is sent to the organiser to review and approve On approval, all attendees receive a branded email with the survey link How to set up Update the Configuration node with your calendar email and Slack user ID Connect Google Calendar, Google Docs, Gmail, OpenAI, and Slack credentials Enable Interactivity in your Slack app settings Requirements Google Workspace Business Standard or higher (required for Gemini meeting notes) OpenAI API key Weavely account, free at weavely.ai Slack workspace and Gmail account How to customise Swap Google Calendar for Calendly or any other calendar trigger Replace Gmail with a Slack message to the meeting channel Swap OpenAI for Claude or any other LLM supported by n8n Adjust the AI prompt to change the number or style of questions

Finance Research Analyst for Boutique M&A Agencies This workflow acts as a junior finance research analyst for a UK boutique M&A or corporate finance team. It listens for Slack messages, classifies the request, gathers company or market data, and produces structured outputs in Google Docs, Google Slides, Google Sheets, and PostgreSQL. It supports three user intents: Research this company X Prepare pitch materials for X Industry briefing on vertical X The workflow is designed for internal team use. It is not intended to send client-facing materials automatically without human review. Why This Template This template shows how a junior research analyst LIVE job and some of the key responsibilities might be automated with help of AI. 120+ junior analyst roles are live in London right now. This template does most of what they do. What This Template Does Company Research When a user asks to research a company, the workflow: searches Companies House for the best UK entity match retrieves company profile, officers, and filing history gathers company and website context using Firecrawl retrieves public market quote data from Alpha Vantage when a ticker is available asks an LLM to synthesize the research into a structured company profile creates a Google Doc with the company profile upserts the company into PostgreSQL stores the generated research as reusable memory updates the client database in Google Sheets replies in the original Slack thread with the output link Pitch Materials When a user asks to prepare pitch materials, the workflow: loads the stored company record from PostgreSQL pulls the most recent stored research memory asks an LLM to produce compact slide-ready bullet content copies a Google Slides pitch template replaces the template placeholders with generated content creates a Google Doc press release draft updates the pitch deck URL in PostgreSQL updates the client database in Google Sheets replies in the original Slack thread with the deck and document links Industry Briefing When a user asks for a sector briefing, the workflow: gathers sector web and news context using Firecrawl retrieves ONS macro M&A context asks an LLM to generate a concise one-page industry briefing creates a Google Doc with the briefing replies in the original Slack thread with the document link Who This Is For This template is built for: boutique M&A advisory firms corporate finance teams fundraising advisors internal research analysts supporting pitch and origination work It is optimized for UK company research because it relies on Companies House as the authoritative company registry. Prerequisites Before using this template, you need: an n8n instance a Slack app configured for message triggers and posting replies a Google account with Drive, Docs, Slides, and Sheets access (Free) a PostgreSQL database (Free self hosted or use supabase) an OpenRouter credential for the LLM calls (Models used= haiku4.5, Sonnet 4.5) a Companies House API key configured as Basic Auth (Free) a Firecrawl API key configured as HTTP Header Auth (Free) API key for Alpha Vantage (free) fixed ONS URL for macro M&A context Required n8n Credentials Create or connect the following credentials in n8n before testing: Slack Trigger credential for incoming Slack events Slack credential for posting replies OpenRouter API Companies House Basic Auth Firecrawl Header Auth Google Drive OAuth2 Google Docs OAuth2 Google Slides OAuth2 Google Sheets OAuth2 Postgres Required External Assets Google Drive Root Folder The workflow creates subfolders under a given root folder: research outputs pitch outputs briefing outputs Current root folder used in the workflow: Modify this to your own folder: https://drive.google.com/drive/u/0/folders/1GH-YouAAImKugZ11IbqA6Ouw8B9U17-I Google Sheets Client Database The workflow writes to this spreadsheet: Modify this to your own google sheet: https://docs.google.com/spreadsheets/d/1yJ-UKOEUqIruCv-IBA33oN4taQTB1TA8M4a6D2iSiOU/edit?gid=0#gid=0 Required sheet name: Sheet1 Required columns: company_name sector companies_house_number market_cap last_researched profile_doc_url pitch_deck_url Best practice: make companies_house_number unique if possible keep column names exactly as shown above Google Slides Pitch Template The workflow copies this Slides template: 1zQv_cbafHzd4JNsr711Rm0558O6W_S1SODc-u6tVS0k Required placeholders in text boxes: {company_name} {sector} {profile_summary} {financials} {opportunity_summary} {comps_note} Input Examples Use messages like these in Slack: Research Monzo, fintech Prepare pitch for Wise Industry briefing UK fintech Outputs Research Intent Outputs: Google Doc company profile PostgreSQL company record update PostgreSQL research memory insert Google Sheets client DB update Slack thread reply with doc link Pitch Intent Outputs: copied and populated Google Slides deck Google Doc press release draft PostgreSQL pitch deck URL update Google Sheets client DB update Slack thread reply with deck and doc links Brief Intent Outputs: Google Doc industry briefing Slack thread reply with doc link Database Expectations This template expects PostgreSQL tables to exist for: company records research memory At minimum, your database must support the queries used by the workflow for: upserting company records loading a company record by company_name storing research memory retrieving the latest research memory for pitch generation updating pitch_deck_url Limitations UK company research is strongest because the workflow depends on Companies House. private companies will not have public market quote data public-company quote data comes from Alpha Vantage GLOBAL_QUOTE, which is not a true market-cap endpoint the workflow does not create dynamic charts in Google Slides. the workflow does not replace human judgment on valuation, comps, or client-facing strategy

Who’s it for Consultants, agencies, freelancers, and professional service firms who need to create customized proposals and contracts quickly and efficiently. How it works / What it does This n8n workflow automates the entire proposal and contract creation process: Triggers when a new client is added to Google Sheets or CRM. Normalizes client data for processing. Generates personalized proposal content using OpenAI AI models based on templates, pricing, and client info. Creates a Google Doc proposal. Converts the proposal to PDF. Sends the proposal via Gmail or Outlook. Optionally routes the proposal to DocuSign or PandaDoc for e-signature collection. Logs the proposal and client info in Google Sheets for tracking. Sends Slack notifications to internal teams. Routes high-value clients for priority follow-up via email and Slack alerts. How to set up Connect Google Sheets or your CRM for client data. Configure Gmail or Outlook credentials. Add OpenAI credentials for proposal generation. Connect Slack for notifications. Optional: Connect DocuSign/PandaDoc. Customize decision nodes for priority clients or additional workflows. Requirements n8n account with Google Sheets, Gmail/Outlook, Slack integrations. Optional DocuSign/PandaDoc accounts for signature collection. OpenAI API key for AI proposal generation. How to customize Adjust templates in OpenAI prompts for company tone/style. Modify Sheet columns for additional client info. Change decision logic to define what counts as a high-value client. Add other integrations like CRM updates or analytics dashboards. Created by Hyrum Hurst / QuarterSmart Keywords: AI proposal automation, contract automation, consulting, proposal generation, n8n workflow, QuarterSmart

This workflow automatically converts unstructured internal documentation into clear, actionable Standard Operating Procedures (SOPs). Instead of manually rewriting internal knowledge, teams can upload or update documents and let AI generate consistent, step-by-step SOPs that are easy to follow and scale across the organization. How it works When a new or updated document is detected in Google Drive, the workflow extracts the content and splits it into manageable sections. AI then analyzes the material, identifies implicit steps, and generates a structured SOP with clear actions, responsibilities, and outcomes. A second AI pass refines clarity and consistency. Completed SOPs are saved to Google Docs, logged in Google Sheets, and shared with stakeholders via Slack or email. Who it’s for Operations teams Consulting firms Agencies and service businesses Scaling startups Internal enablement teams Requirements Google Drive & Docs Google Sheets OpenAI credentials Slack or Gmail Built by QuarterSmart Created by Hyrum Hurst, AI Automation Engineer at QuarterSmart, specializing in practical, production-ready AI automation systems. For custom SOP automation or enterprise setups: [email protected]

AI Event Feedback Analyzer with Google Forms, GPT, Slack & Docs Who is this for? Event planners, webinar hosts, conference organizers, and marketers who collect attendee feedback and want instant actionable insights without manual analysis. What problem is this workflow solving? Post-event feedback analysis is slow and manual: Sorting 100s of forms takes hours Missing sentiment patterns or testimonials No real-time team alerts or historical logs This workflow automates sentiment analysis + distribution across Slack and Google Docs. What this workflow does Trigger**: Google Forms → Sheets webhook (works with Typeform too) AI Analysis**: GPT-4o extracts: Sentiment score, key likes/improvements, golden quotes Slack Alert**: "#eventfeedback: 4.2/5 'Loved networking' → Action: More breaks" Google Docs Log**: Appends "{{Event}} Feedback Summary" with bullets + NPS trends Bonus**: 50+ responses → "Avg NPS 4.2 | Top 3 fixes ranked" Setup (3 minutes) Google Forms** → Sheets (native integration) Slack channel + OpenAI API key** (GPT-4o-mini recommended) Google Docs ID** (env var DOCS_ID) Fully configurable—no code changes needed. How to customize to your needs Forms**: Swap Google Forms for Typeform/Webhook AI**: Adjust sentiment thresholds or add custom categories Channels**: Add Teams/Email + multiple Slack rooms Metrics**: Track NPS, CSAT, or custom scores Scale**: Aggregate by event/date for multi-conference orgs ROI: 30% faster feedback loops** 15% NPS uplift** (proven 500+ runs) Zero manual analysis** Need help customizing?: Contact me for consulting and support: LinkedIn / Message Keywords: event management, sentiment analysis, post-event feedback, conference feedback

📊 Description Streamline and standardize your entire client onboarding process with a single end-to-end automation. 🚀📋 This workflow captures detailed client intake data via webhook, automatically creates a fully structured Asana onboarding project, generates a personalized service contract from a Google Docs template, emails the agreement to the client, and logs all information in Google Sheets. It also creates a dedicated Slack channel for internal collaboration, ensuring every new client is onboarded consistently, professionally, and without manual effort. Perfect for service businesses scaling operations while maintaining quality and clarity. ✨📄🤝 🔁 What This Template Does 1️⃣ Receives detailed client intake form data via webhook. 📥 2️⃣ Parses and normalizes 70+ client, business, and technical fields. 🧾 3️⃣ Creates a new client-specific onboarding project in Asana. 📋 4️⃣ Copies sections and tasks from a predefined Asana template project. 🔄 5️⃣ Assigns all tasks into the new project with proper structure. ✅ 6️⃣ Retrieves a Google Docs contract template. 📄 7️⃣ Replaces placeholders with client-specific details (name, fees, dates). ✍️ 8️⃣ Downloads the personalized contract as a PDF. 📑 9️⃣ Sends a welcome email to the client with the contract attached. 📧 🔟 Resets the contract template for the next onboarding. 🔁 1️⃣1️⃣ Logs all client data into Google Sheets for tracking and reporting. 📊 1️⃣2️⃣ Creates a dedicated Slack channel for internal client communication. 💬 ⭐ Key Benefits ✅ Eliminates manual onboarding setup and repetitive admin work ✅ Ensures consistent project structure for every client ✅ Generates error-free, personalized contracts automatically ✅ Improves client experience with instant, professional communication ✅ Centralizes client data for operations and reporting ✅ Scales onboarding without adding operational overhead 🧩 Features Webhook-based client intake form processing Advanced data parsing for large intake payloads Asana project creation with template-based sections and tasks Google Docs dynamic contract generation Automated PDF download and email delivery Google Sheets client tracking with append/update logic Automatic Slack channel creation for internal teams Clean reset logic for reusable document templates 🔐 Requirements Asana OAuth2 credentials Google Docs OAuth2 credentials Google Drive OAuth2 credentials Google Sheets OAuth2 credentials Gmail OAuth2 credentials Slack API credentials Asana template project ID Google Docs contract template ID Google Sheets tracking document ID 🎯 Target Audience Service-based businesses onboarding new clients Agencies managing multi-step client engagements Operations and delivery teams SaaS or healthcare service providers with complex intake forms Automation teams building scalable onboarding systems

🎥 AI Content Generator: Transcript to Video & Image Transform meeting transcripts into engaging multi-format content with AI-powered automation Perfect for educators, consultants, and content creators who record sessions and want to repurpose them into social media posts, videos, and images without manual work. How it works Chat interface triggers the AI orchestrator when you request content creation Fetches your most recent meeting transcript from Fathom AI analyzes the transcript and extracts key insights and breakthrough moments Generates written post content and creates a Google Doc automatically Creates detailed video generation prompts and sends to video API (Luma/Runway) Generates image prompts and creates social media graphics via DALL-E Returns all assets: written content, video URL, and image file ready to use How to use Connect your Fathom account to retrieve meeting transcripts Set up the three required subworkflows: Text to Video, Text to Image, and Transcript to Content Configure your OpenAI credentials for AI processing Simply chat: "Create content from my latest session - video and image" Review and customize the generated content as needed Requirements Fathom account with recorded meetings or sessions OpenAI API account (GPT-4 recommended for best results) Google Docs access for content storage Video generation API (Luma AI or Runway ML) for video creation Three subworkflows must be created separately (see setup notes) Good to know Video generation typically costs $0.50-$2.00 per video depending on your provider The workflow processes the most recent 7 days of Fathom transcripts automatically AI agents use ~5,000-10,000 tokens per complete content generation Subworkflows need to be set up once before using this main workflow Videos take 2-5 minutes to generate after the prompt is created Need Help? Join the Discord or ask in the Forum! Happy Creating! 🚀

This n8n template transforms Upwork job postings into personalized Loom video outreach assets in under 60 seconds. Paste a job description and get a complete outreach package: video script, before/after comparison, automation flow diagram, and proposal snippet. Use cases include: AI/Automation agencies doing Upwork cold outreach, freelancers who personalize proposals with Loom videos, or anyone wanting to scale video prospecting with AI-generated scripts. Good to know Each job processed costs approximately $0.02-0.04 USD in Claude API fees (two API calls per job) Processing time is ~45-60 seconds per job The workflow uses Claude Sonnet for optimal cost/quality balance Generated scripts are starting points - review and personalize before recording How it works Submit an Upwork job via the built-in form (title, description, optional client name and URL) Claude AI analyzes the job to extract: industry classification, pain points, tools mentioned, budget/urgency signals, and competition level A second Claude call generates the complete outreach package based on the analysis All assets are saved to a Google Doc named by prospect Lead data is logged to Google Sheets for tracking Slack notification delivers the doc link and key insights What you get for each job: 90-120 second Loom video script (hook, credibility, walkthrough, CTA) Before/After process comparison with ROI calculations Automation flow diagram structure Upwork proposal opening snippet Visual prompts for Whimsical/Figma diagrams Quick reference card with pricing guidance How to use The form trigger creates a URL at your-n8n-instance/form/upwork-loom-generator Paste the full job description for best results - more context = better analysis Add the client name if visible for personalized script openings After generation, review the Google Doc and customize the script to your voice Use the visual prompts to create diagrams before recording your Loom Requirements Anthropic account** for Claude API access Google account** with Docs and Sheets enabled Slack workspace** for notifications Set up steps Anthropic credential - Create HTTP Header Auth credential with your API key (header name: x-api-key) Google credentials - Connect Google Docs and Google Sheets OAuth2 credentials Slack credential - Add Slack API credential with chat:write scope Update placeholders in nodes: Create Google Doc → Set your Google Drive folder ID Log to Google Sheets → Set your spreadsheet ID Both Slack nodes → Set your channel ID Create tracking sheet with columns: Timestamp, Prospect Name, Industry, Business Function, Pain Point, Tokens Used, Google Doc Link, Version Customising this workflow Edit the "MY BACKGROUND" section in the Claude - Generate Loom Assets node to match your experience and services Adjust industry-specific hourly rates and time savings in the prompt to match your market Modify the Loom script CTA to your preferred next step (calendar link, reply, etc.) Add additional integrations: Notion database, CRM, or calendar booking Swap Slack for Discord, Teams, or email notifications

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Accelerate your research analysis with this Automated Research Intelligence System! This workflow uses AI and web scraping to analyze research papers and articles, extracting key insights, validating content quality, and generating comprehensive research documents. Perfect for research teams, academics, and AI enthusiasts staying current with the latest developments in artificial intelligence and machine learning. What This Template Does Triggers via form submission for on-demand research URL analysis. Validates URL accessibility and prepares for processing. Uses Decodo scraper to extract research content from target URLs. Analyzes research papers with AI for comprehensive understanding. Validates summaries for accuracy, completeness, and relevance. Generates key insights and actionable takeaways from research. Creates professional Google Docs with formatted research summaries. Evaluates research quality with AI-powered rating system. Saves all research to Google Sheets for historical tracking. Sends Slack alerts for high-quality research findings (9+ rating). Key Benefits Automated research analysis saves hours of manual reading time AI-powered insights extraction from complex research papers Quality validation ensures accurate and relevant summaries Centralized research database for team collaboration Real-time alerts for breakthrough research findings Professional documentation automatically generated Features Form-based trigger for easy research submission URL validation and accessibility checking AI-powered research analysis and summarization Decodo web scraping for reliable content extraction Multi-stage validation for accuracy and relevance Automated Google Docs report generation Quality assessment with structured rating system Google Sheets integration for research tracking Slack notifications for premium research findings Quality threshold filtering for optimal results Requirements Decodo API credentials for research scraping OpenAI API credentials for AI analysis Google Docs OAuth2 credentials for document creation Google Sheets OAuth2 credentials with edit access Slack Bot Token with chat:write permission Environment variables for configuration settings Target Audience AI research teams and data scientists Academic researchers and university labs Machine learning engineers and developers Technology innovation teams Research and development departments Content creators in AI/ML space Step-by-Step Setup Instructions Connect Decodo API credentials for research scraping functionality Set up OpenAI credentials for AI analysis and quality assessment Configure Google Docs for automated research document generation Add Google Sheets credentials for research tracking and history Set up Slack credentials for high-quality research alerts Customize quality thresholds for research rating (default: 6+ for processing, 9+ for alerts) Test with sample research URLs to verify analysis and formatting Deploy the form for team access to research analysis requests Monitor research database for trends and insights Pro Tip: Get a free Web Scraping API subscription - https://decodo.com/scraping/web This workflow transforms complex research into actionable intelligence with automated analysis, quality validation, and professional documentation!

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. AI-Powered Content Analysis System Elevate your content quality with this AI-powered Content Analysis System! This workflow automatically evaluates website content using advanced scraping and AI analysis, providing comprehensive SEO insights, readability scores, and actionable improvement recommendations. Perfect for content teams ensuring optimal performance and engagement across digital properties. What This Template Does Triggers via form submission for on-demand content analysis requests. Checks previous analyses to prevent duplicate processing. Scrapes target URLs using Decodo for comprehensive content extraction. Uses AI to evaluate content quality, SEO effectiveness, and readability. Saves analysis results to Google Sheets for historical tracking. Generates professional Google Docs reports with actionable insights. Sends email notifications with formatted analysis summaries. Alerts teams via Slack for both normal and urgent findings. Creates remediation plans and Trello tasks for low-quality content. Key Benefits Automated content quality assessment with AI-powered insights Prevents duplicate analyses to optimize resource usage Comprehensive SEO and readability scoring for data-driven decisions Professional reporting with Google Docs and email integration Immediate team alerts for urgent content improvements Historical tracking and trend analysis capabilities Features Form-based trigger for easy content analysis requests Duplicate detection and prevention system AI-powered content evaluation using GPT-4o Real-time web scraping with Decodo integration Automated Google Docs report generation Multi-channel notifications (Slack, Gmail) Quality threshold monitoring and alerting Remediation plan generation for low-quality content Trello integration for task management Historical analysis database in Google Sheets Requirements OpenAI API credentials for AI analysis Decodo API credentials for web scraping Google Sheets OAuth2 credentials with edit access Google Docs OAuth2 credentials for report generation Gmail OAuth2 credentials for email notifications Slack Bot Token with chat:write permission Trello credentials (optional for task management) Environment variables for configuration settings Target Audience Content marketing and strategy teams SEO specialists and digital marketers Content quality assurance teams Digital agencies managing multiple clients Website owners and publishers Content operations managers Step-by-Step Setup Instructions Connect OpenAI credentials for AI content analysis capabilities Set up Decodo API credentials for web scraping functionality Configure Google Sheets with required analysis headers Add Google Docs credentials for automated report generation Set up Gmail and Slack credentials for notifications Optional: Configure Trello integration for task management Customize the analysis form with your industry and focus areas Test with sample URLs to verify all integrations and data flow Deploy for ongoing content quality monitoring and optimization Pro Tip: Get a free Web Scraping API subscription - https://decodo.com/scraping/web This workflow ensures your content maintains high quality standards with automated analysis, professional reporting, and immediate improvement alerts!

Who is it for This template is perfect for content creators, space enthusiasts, educators, and organizations who want to automatically generate and distribute engaging weekly space newsletters. It's especially useful for those who want to stay updated on space events without manual content creation. How it works This workflow automatically generates a comprehensive space newsletter every week by: Fetching the latest data from multiple NASA APIs (APOD, DONKI, NeoWS) Using AI to create an engaging newsletter from the raw data Creating a formatted document with the content Converting it to PDF format Distributing via email and archiving to your preferred platform Sending success notifications to your team Setup steps Get NASA API Key: Register at https://api.nasa.gov to get your API key (free) Configure OpenAI: Add your OpenAI credentials for content generation Set up Google Workspace: Connect Google Docs, Drive, and Gmail accounts Optional integrations: Configure Notion for archiving and Slack for notifications Customize schedule: Adjust the weekly trigger time to your preference Requirements NASA API key (free at api.nasa.gov) OpenAI API access Google Workspace account (Docs, Drive, Gmail) Optional: Notion and Slack accounts How to customize Modify the AI prompt to change the newsletter style and tone Adjust the date range for fetching space data Add or remove NASA API endpoints based on your interests Customize email recipients and notification channels Enable/disable the Notion archiving feature as needed

Title Japanese Document Translation Quality Checker with DeepL & Google Drive to Slack Who’s it for Localization teams, QA reviewers, and operations leads who need a fast, objective signal on Japanese document translation quality without manual checks. What it does / How it works This workflow watches a Google Drive folder for new Japanese documents, exports the text, translates JA→EN with DeepL, then back-translates EN→JA. It compares the original and back-translation to estimate a quality score and summarizes differences. A Google Docs report is generated, and a Slack message posts the score, difference count, and report link—so teams can triage quickly. How to set up Connect credentials for Google Drive, DeepL, and Slack. Point the Google Drive Trigger to your “incoming JP docs” folder. In the Workflow Configuration (Set) node, fill targetFolder (report destination) and slackChannel. Run once, then activate and drop a test doc. Requirements n8n (Cloud or self-hosted), Google Drive, DeepL, and Slack credentials; two Drive folders (incoming, reports). How to customize the workflow Tune the diff logic (character → token/line level, normalization rules), adjust score thresholds and Slack formatting, or add reviewer routing/Jira creation for low-score cases. Always avoid hardcoded secrets; keep user-editable variables in the Set node.

[Workflow Overview] ⚠️ Self-Hosted Only: This workflow uses the gotoHuman community node and requires a self-hosted n8n instance. Who's It For Content teams, bloggers, news websites, and marketing agencies who want to automate content creation from RSS feeds while maintaining editorial quality control. Perfect for anyone who needs to transform news articles into detailed blog posts at scale. What It Does This workflow automatically converts RSS feed articles into comprehensive, SEO-optimized blog posts using AI. It fetches articles from your RSS source, generates detailed content with GPT-4, sends drafts for human review via gotoHuman, and publishes approved articles to Google Docs with automatic Slack notifications to your team. How It Works Schedule Trigger runs every 6 hours to check for new RSS articles RSS Read node fetches the latest articles from your feed Format RSS Data extracts key information (title, keywords, description) Generate Article with AI creates a structured blog post using OpenAI GPT-4 Structure Article Data formats the content with metadata Request Human Review sends the article for approval via gotoHuman Check Approval Status routes the workflow based on review decision Create Google Doc and Add Article Content publish approved articles Send Slack Notification alerts your team with article details Requirements OpenAI API key** with GPT-4 access Google account** for Google Docs integration gotoHuman account** for human-in-the-loop approval workflow Slack workspace** for team notifications RSS feed URL** from your preferred source How to Set Up Configure RSS Feed: In the "RSS Read" node, replace the example URL with your RSS feed source Connect OpenAI: Add your OpenAI API credentials to the "OpenAI Chat Model" node Set Up Google Docs: Connect your Google account and optionally specify a folder ID for organized storage Configure gotoHuman: Add your gotoHuman credentials and create a review template for article approval Connect Slack: Authenticate with Slack and select the channel for notifications Customize Content: Modify the AI prompt in "Generate Article with AI" to match your brand voice and article structure Adjust Schedule: Change the trigger frequency in "Schedule Trigger" based on your content needs How to Customize Article Style**: Edit the AI prompt to change tone, length, or structure Keywords & SEO**: Modify the "Format RSS Data" node to adjust keyword extraction logic Publishing Destination**: Change from Google Docs to other platforms (WordPress, Notion, etc.) Approval Workflow**: Customize the gotoHuman template to include specific review criteria Notification Format**: Adjust the Slack message template to include additional metadata Processing Volume**: Modify the Code node to process multiple RSS articles instead of just one

Description Save hours of manual reporting with this end-to-end automation. This workflow pulls campaign performance data (demo or live), generates a clear AI-powered executive summary, and compiles everything into a polished weekly report. The report is formatted in Markdown, automatically stored in Google Docs, and instantly shared with your team via Slack — no spreadsheets, no copy-paste, no delays. What it does ⏰ Runs on a schedule (e.g. every Monday morning) 📊 Collects performance metrics (Google Ads, Meta, TikTok, YouTube – demo data included) 🤖 Uses AI to summarize wins, issues, and recommendations 📝 Builds a structured Markdown report (totals, channel performance, top campaigns) 📄 Creates and updates a Google Doc with the report 💬 Notifies your team in Slack with topline numbers + direct report link 📧 Optionally email the report to stakeholders or clients Why it’s valuable Saves time** – no manual data aggregation Standardizes reporting** – same format and quality every week Adds insights** – AI highlights what matters most Improves transparency** – instant access via Docs, Slack, or Email Scales easily** – adapt to multiple clients or campaigns Professional delivery** – branded, polished reports on autopilot 💡 Extra recommendation: Connect to a Google Docs template to give your reports a professional, branded look.

📄 AI-Powered Document Summarizer & Notifier This workflow monitors a Google Drive folder for new files (Google Docs or PDFs), extracts text, summarizes content with OpenAI, and sends results to Slack or Email. 🔧 How It Works Monitors a Google Drive folder for new files. Detects file type → Google Doc vs PDF. Extracts text (via Google Docs API or PDF extractor). Summarizes & analyzes content using OpenAI. Sends results to Slack and/or Email. 👤 Who Is This For? Business teams → Quick digests of reports, proposals, contracts. Educators / researchers → Summaries of long study materials. Founders / managers → Daily summaries without opening every file. Operations teams → Compliance and documentation tracking. 💡 Use Case / Problem Solved Reading long documents is time-consuming. Sharing key points across teams requires manual effort. Important context (sentiment, action items) is often missed. 👉 This workflow solves it by auto-summarizing documents and notifying teams instantly. ⚙️ What This Workflow Does Monitors Google Drive for new Google Docs or PDFs. Extracts text automatically. Uses OpenAI to generate: Title Summary Key Points Suggested Action Items Language detection Sentiment (positive, neutral, negative) Pushes output to Slack channel and/or Email inbox. 🛠️ Setup Instructions Prerequisites Google Drive (OAuth2) Google Docs (OAuth2) OpenAI API Key Slack (OAuth2) or Gmail (OAuth2) Steps to Configure Connect Google Drive Choose the folder you want to monitor. Set up file type routing Use an IF node to split Docs vs PDFs. For Google Docs Use Google Docs Get → extract text. For PDFs Use Google Drive Download → Extract PDF. Send text to OpenAI Connect to your OpenAI model. Customize the system prompt to generate title, summary, sentiment, etc. Notify Send output to Slack channel or Gmail. Save & activate your workflow. 📌 Notes Adjust OpenAI prompt to suit your context. For large PDFs, consider splitting into smaller chunks.

⚙ Automated Contract Employee Placement & Management System: Setup Guide This guide will walk you through setting up your n8n workflow. By the end, you'll have a fully automated system for managing your contract employee placements, from generating documents to sending renewal reminders. How It Works This workflow is structured in three logical phases to automate the entire contract management lifecycle: Phase 1: Placement Trigger & Data Retrieval: The workflow begins when a new placement record is created in your CRM or database. It automatically retrieves all necessary employee and client data to prepare for contract generation. Phase 2: Contract Generation & Delivery: The system uses a pre-made Google Docs template to generate a professional contract. It then automatically sends this document for e-signature via DocuSign to both the employee and the client. Phase 3: Post-Placement Management & Reminders: Once the contract is signed, the workflow updates your database, notifies your team, and adds the start date to your calendar. A separate scheduled automation runs weekly to proactively check for expiring contracts and send renewal reminders. Step-by-Step Setup Guide Follow these steps to configure the workflow in your n8n instance. Step 1: Prerequisites & Database Setup Before you begin, ensure you have the following accounts and a workspace set up: n8n Instance:** Your self-hosted or cloud-based n8n instance. Airtable:** Your main database for managing placements. Google Docs:** A contract template saved in your Google Drive. DocuSign:** For handling electronic signatures. Slack:** For internal team notifications. Google Calendar:** For adding start dates to a shared team calendar. Airtable Database Preparation: Create an Airtable base with a Placements table. This table must include the following columns: Candidate Name Candidate Email Client Name Client Contact Email Start Date End Date Status Google Docs Template Preparation: Create a contract template in Google Docs with placeholders in the format {{placeholder}} (e.g., {{candidateName}}, {{clientName}}). Step 2: Workflow Import & Credential Configuration Import the workflow's .json file into your n8n instance. All the necessary nodes will appear on your canvas. Click on any node with a red "!" icon (e.g., the Airtable or DocuSign node). Click "Create new credential" and follow the instructions to connect your accounts. Repeat this for all nodes that require credentials. Step 3: Node-Specific Configuration Configure the following key nodes to match your specific setup: Webhooks Trigger: Click on the Webhooks Trigger node and copy the Webhook URL. Configure your CRM or Airtable to send a POST request to this URL whenever a new placement is created. Airtable Nodes: For every Airtable node in the workflow, enter the correct Base ID and Table Name (Placements) that you created in Step 1. Google Docs Node: In the Template File ID field, enter the file ID of your Google Docs contract template. Map the placeholders you created in your template to the dynamic data from your database (e.g., {{candidateName}} should be mapped to ={{ $json.candidate_name }}). DocuSign Node: Enter your Account ID in the credentials settings. Map the Signer Name and Signer Email fields to the data from your database. Ensure your DocuSign envelope template is configured with anchor text (e.g., /signature/) that matches the anchor tags in the DocuSign node. Cron Trigger: The Cron Trigger node is set up to check for expiring contracts. You can adjust the Interval parameter (e.g., Every Week) to match your desired schedule. Step 4: Activation Once all credentials and node configurations are complete, click "Save" at the top of the canvas. Toggle the workflow to "Active" in the top-right corner. The workflow is now live! It will automatically handle contract generation, signatures, and reminders for every new placement.

Who's it for Content creators, trainers, and educators who need to convert lengthy documents into digestible micro-learning experiences. How it works This workflow takes your source content (PDFs, articles, handbooks) and uses GPT-4 to intelligently break it into 2-3 minute learning modules. Each module includes a key concept, explanation, practical example, and knowledge check question. How to set up Configure OpenAI credentials with GPT-4 access Connect Slack workspace (optional) Set up Google Docs integration Optionally, Send content via webhook or paste directly Requirements OpenAI API key with GPT-4 access Google Docs account (for document creation) Slack workspace (optional, for notifications) How to customize the workflow Adjust module count and length in AI prompts Modify output formats (email, mobile, Slack) Change document structure and styling Add custom delivery channels Perfect for converting employee handbooks, training materials, and documentation into engaging micro-learning courses that people actually complete.

Who's it for Marketing agencies, digital agencies, and freelancers who need to streamline their client onboarding process and create consistent, professional documentation for new clients. Perfect for teams handling multiple client intakes who want to save hours of manual setup work while maintaining quality standards. What it does This workflow automates the entire client onboarding journey from the moment a prospect fills out your Typeform intake questionnaire. It instantly creates a complete Google Drive folder structure with 6 main folders and 15+ subfolders tailored for marketing projects, sends the intake information to your team via Slack, generates an AI-powered marketing research brief using OpenAI, implements an approval workflow with revision capabilities, and delivers a professional welcome email to the client. The system ensures nothing falls through the cracks while maintaining consistent quality across all client projects. How it works Intake Trigger: When a client submits your Typeform intake form, the workflow automatically initiates Folder Creation: Creates a branded client folder in Google Drive with organized subfolders for ads, raw footage, product images, research, drafts, and archives Team Notification: Posts detailed intake responses to your designated Slack channel for immediate team visibility AI Brief Generation: Uses OpenAI to analyze intake responses and generate a comprehensive marketing research document including customer personas, pain points, positioning strategies, and marketing angles Approval Process: Sends the brief for team review with built-in approve/revise functionality Document Creation: Upon approval, creates a Google Doc with the finalized research brief Client Communication: Sends a personalized welcome email to the client confirming their onboarding How to set up Configure the workflow: Start by filling in all values in the "⚙️ Configuration" node: Your Typeform ID from your intake form Google Drive parent folder ID where client folders will be created Slack channel IDs for new client notifications and internal reviews OpenAI model preference (GPT-4 recommended) Welcome email template with your agency branding Connect your accounts: Typeform: Create credentials and connect your account Google: Authenticate with Drive, Docs, and Gmail permissions Slack: Add the n8n bot to your workspace and relevant channels OpenAI: Add your API key for AI content generation Test the workflow: Submit a test entry through your Typeform Verify folder creation in Google Drive Check Slack notifications are posting correctly Confirm the approval process works as expected Requirements Typeform** account with a client intake form created Google Workspace** account with Drive, Docs, and Gmail access Slack** workspace with appropriate channels created OpenAI API** key with credits for content generation n8n** instance (self-hosted or cloud) version 1.0+ How to customize the workflow Folder Structure**: Modify the subfolder nodes to match your agency's project organization needs Intake Fields**: Update the Slack message blocks and AI prompt to match your specific Typeform fields Research Brief Template**: Customize the OpenAI prompt to generate briefs aligned with your agency's format Approval Logic**: Add additional approval stages or skip approval for certain client types Welcome Email**: Personalize the email template with your branding, links, and next steps Notification Channels**: Route different types of notifications to specific Slack channels based on client tier or project type

✍️ Ultimate AI Blog Content Creator with Slack + Pinecone + Perplexity Description Turn your marketing team’s blog ideas into full, research-backed, brand-aligned articles with one Slack mention. This workflow connects Slack, Pinecone, and Perplexity to deliver high-impact blog posts that match your company’s voice and leverage the latest research — all written directly into Google Docs for immediate publishing. 👉 Watch step-by-step build of this workflow on: www.youtube.com/@automatewithmarc How It Works Slack Trigger – Marketing team members @mention the bot with a blog idea. Perplexity Tool – Gathers the most up-to-date insights and research on the topic. Pinecone Vector DB – Injects your brand guidelines, tone, and style from stored vectors. AI Blogpost Agent – Powered by Anthropic/OpenAI, it blends research + style to create a polished, structured blog post. Simple Memory – Keeps context across requests for more consistent content. Google Docs – Creates and updates a document with the generated article, ready for review or publishing. Why Content Teams Will Love It ⚡ Faster turnaround — go from idea to publish-ready blog in minutes. 📝 On-brand every time — uses your Pinecone-stored brand guidelines. 🌍 Research-driven — Perplexity ensures content is current and credible. 🤝 Team-friendly — triggered right inside Slack for effortless collaboration. Requirements Slack App (with app_mentions:read, chat:write) Pinecone account with embedded brand guideline vectors Perplexity API key Anthropic/OpenAI API key Google Docs account

📝 Auto-Generate Meeting Notes & Summaries (Zoom → Google Docs + Slack) This workflow automatically captures Zoom meeting data when a meeting ends, generates AI-powered notes, saves them to Google Docs, and instantly posts a summary with a link in Slack. ⚙️ How It Works Zoom Webhook → Triggers on meeting.ended or recording.completed. Normalize Data → Extracts meeting details (topic, host, duration, transcript). AI Notes (GPT-4) → Summarizes transcript into key decisions, action items, and next steps. Google Docs → Saves formatted meeting notes + transcript archive. Slack Post → Shares summary + link to notes in #team-meetings. 🛠️ Setup Steps Zoom App Go to Zoom Developer Console → create App. Enable event meeting.ended. Paste workflow webhook URL. Google Docs Connect Google OAuth in n8n. Docs auto-saved in your Google Drive. Slack Connect Slack OAuth. Replace channel #team-meetings. OpenAI Add your OpenAI API key. Uses GPT-4 for accurate summaries. 📊 Example Output Slack Message: 📝 Auto-Generate Meeting Notes & Summaries (Zoom → Google Docs + Slack) This workflow automatically captures Zoom meeting data when a meeting ends, generates AI-powered notes, saves them to Google Docs, and instantly posts a summary with a link in Slack. ⚙️ How It Works Zoom Webhook → Triggers on meeting.ended or recording.completed. Normalize Data → Extracts meeting details (topic, host, duration, transcript). AI Notes (GPT-4) → Summarizes transcript into key decisions, action items, and next steps. Google Docs → Saves formatted meeting notes + transcript archive. Slack Post → Shares summary + link to notes in #team-meetings. 🛠️ Setup Steps Zoom App Go to Zoom Developer Console → create App. Enable event meeting.ended. Paste workflow webhook URL. Google Docs Connect Google OAuth in n8n. Docs auto-saved in your Google Drive. Slack Connect Slack OAuth. Replace channel #team-meetings. OpenAI Add your OpenAI API key. Uses GPT-4 for accurate summaries. 📊 Example Output Slack Message: 📝 New Meeting Notes Available Topic: Marketing Sync Host: [email protected] Duration: 45 mins 👉 Read full notes here: https://docs.google.com/document/d/xxxx Google Doc: Executive Summary Key Decisions Action Items w/ Owners Next Steps Full Transcript ⚡ With this workflow, your team never scrambles for meeting notes again.

How It Works ⚙️ Imagine a dedicated financial expert tirelessly working behind the scenes, sifting through every transaction, every investment move, and every accounting entry. That's exactly what this automated system does for you, turning raw financial chaos into crystal-clear insights. Automated Data Gathering (The Collector): What happens: The system automatically connects to your bank accounts, investment platforms, and accounting software (like QuickBooks or Xero) on a schedule you define (e.g., daily, weekly). It pulls in all your latest financial data – every transaction, income, expense, and investment update. Data In: Transaction descriptions, amounts, dates, investment details, income/expense categories (if available). AI-Powered Data Cleaning & Categorization (The Organizer & Detective): What happens: Once collected, the data is sent to our first two AI brains. AI Agent 1 (The Categorizer): Reads through every transaction description and intelligently assigns it to a standard financial category (e.g., "Dining," "Groceries," "Utilities," "Software Subscriptions"). No more manual tagging! AI Agent 2 (The Anomaly Detector): Scans the categorized data for anything unusual – a transaction amount that's too high, a potential duplicate entry, or any suspicious activity. It flags these items immediately. Data Out: Clean, categorized transactions, flagged anomalies with reasons. Deep Financial Analysis & Insight Generation (The Strategist): What happens: With clean data in hand, specialized AI agents get to work on the strategic analysis: AI Agent 3 (Spending Pattern Analyst): Identifies your key spending trends over time. Are you spending more on certain categories? Where can you save? AI Agent 4 (Investment Performance Insight): Reviews your investment gains and losses and gives you a clear picture of your portfolio's health. AI Agent 5 (Overall Financial Health Assessor & Recommender): This top-tier AI synthesizes ALL the insights. It provides a concise summary of your overall financial health and, critically, gives you 3-5 clear, actionable recommendations on how to improve your finances or capitalize on opportunities. Data Out: Analysis summaries, spending insights, investment performance notes, overall financial health assessment, and precise recommendations. Automated Reporting & Smart Alerts (The Communicator): What happens: All the AI-generated insights are automatically compiled into a professional financial report. This report populates a pre-designed Google Docs template, making it look polished and ready for review. Immediate Alerts: If AI Agent 2 flagged any anomalies, you get an instant notification (e.g., via Slack) so you can investigate immediately. Report Delivery: The full report is automatically sent to your email inbox, and a summary notification is sent to your team's Slack channel. Outcome: You receive regular, detailed, and actionable financial reports without lifting a finger, always staying informed and ahead. Setup Steps 🛠️ Building this powerful system is simpler than you might think. Here’s your step-by-step guide: Prepare Your Digital Foundation: Financial Data Access: Figure out how you'll get your raw data. For APIs (Recommended): If your bank, investment platform, or accounting software has an API (like Plaid, QuickBooks, Xero), get your API keys and understand their basic HTTP Request structure. For CSVs: If you download CSV statements, ensure they have consistent formats (Date, Description, Amount at minimum). You'll use CSV Read nodes instead of HTTP Request. Google Sheets Database: Create two separate Google Sheets in your Google Drive: "Raw Financial Data" Sheet: This sheet will store all the untouched data collected from your sources. Set up columns like Date, Description, Amount, Source, Transaction Type, Asset, etc. "Categorized Financial Data" Sheet: This sheet will store the data after it's been cleaned and categorized by the AI. Add columns for Category, Is Flagged, Flag Reason, alongside the raw data columns. Financial Report Template (Google Docs): Create a new Google Doc that will be your professional report template. Design it how you want your final report to look. Insert clear placeholders like {{ report_title }}, {{ executive_summary }}, {{ spending_analysis }}, {{ overall_assessment_recommendations }}, etc., where the AI content will go. Crucially, copy the Document ID from the URL of this template. Get Your API Keys & Credentials: OpenAI API Key: This is essential for all the AI brains. Get it from your OpenAI account. Google Sheets Credentials: You'll need to create an OAuth2 credential in n8n to link to your Google Sheets. Gmail Credentials: For sending the final reports. Set up an OAuth2 credential. Slack Credentials: If you want alerts and notifications. Get a Bot Token from your Slack app settings. (Optional) Other API Keys: If you're using specific financial APIs (e.g., Plaid, QuickBooks), gather their respective API keys and authentication details. Import the n8n Workflow: We've provided the detailed node structure in previous responses. You'll translate that into an n8n workflow by adding each node manually and connecting them as described. This gives you full control and understanding! Connect Your Tools (N8n Credentialing & Linking): Go to each node in your n8n workflow that requires a credential (e.g., OpenAI, Google Sheets, Gmail, Slack, HTTP Request). Select the credential you created in Step 2. This links n8n to your external services. Customize Your Workflow Nodes (The Smart Part!): Cron Node (Node 1): Set your desired Schedule (e.g., "Every 1 Day" for daily reports, or "Every 1 Week" for weekly). HTTP Request Nodes (Nodes 2, 3, 4): Paste the exact URLs for your financial APIs. Configure the Method (GET/POST) and Authentication type (e.g., "Header Auth," "OAuth2") specific to each API. If using CSVs: Replace these nodes with CSV Read nodes and point them to your CSV file paths. Google Sheets Nodes (Nodes 7, 8, 13, 14): Paste the Spreadsheet IDs for your "Raw Financial Data" and "Categorized Financial Data" sheets. Ensure the Sheet Name is correct (e.g., "Sheet1" or "Transactions"). Crucially, map the Values correctly so that the data goes into the right columns in your sheets. OpenAI Nodes (Nodes 10, 11, 16, 17, 18): This is the most powerful part! Carefully review and refine the Prompts within these nodes. Tailor the categories for AI Agent 1, specify what counts as an "anomaly" for AI Agent 2, and ensure the tone and focus of recommendations from AI Agent 5 match your needs. Test these prompts extensively! Google Docs Node (Node 20): Paste your Template Document ID from Step 1. Map the Values from your consolidated AI insights ({{ $json.report_title }}, etc.) to the placeholders you created in your Google Doc template. Slack Nodes (Nodes 22, 24): Enter the specific Chat IDs (channel IDs) for where you want anomaly alerts and general report notifications to appear. Test & Activate! Run Manual Tests: Before activating, manually trigger the workflow a few times. Check each node's output to ensure data is flowing correctly and AI agents are generating the expected results. Activate: Once you're confident everything is working, click the "Inactive" toggle in the top-right corner of your workflow to set it live. Congratulations! You've just built a sophisticated, AI-powered financial analysis and reporting system that will bring unprecedented clarity and control to your finances.

This n8n template demonstrates how to build a complete AI-powered content pipeline that pulls fresh news from RSS feeds, transforms it into engaging Medium articles. Categories Content Creation AI Automation Publishing Social Media Share Yes, this n8n workflow is straight FIRE for content creators who want to automate their entire publishing game! 🔥 This template creates a complete content pipeline that pulls fresh tech news from RSS feeds, transforms it into engaging Medium articles using AI, generates matching cover images, and handles the entire approval-to-publishing process through Slack integration. Good to know Uses multiple AI models (Groq, Google Gemini) for content generation Integrates with Medium publishing API for automated posting Includes smart duplicate checking via Google Sheets Generates professional cover images using Pollinations AI Full Slack approval workflow with human oversight Automatic storage and organization in Google Drive How it works RSS Content Fetching Pulls fresh content from The Verge, TechCrunch, and Ars Technica RSS feeds on a 6-hour schedule Smart filtering ensures only new, unposted articles are processed AI Content Generation Groq and Google Gemini models transform RSS content into engaging Medium-style articles Automatic image prompt generation creates relevant cover visuals Pollinations AI generates professional marketing-style images Smart Review & Approval Creates Google Doc with formatted article for easy review Sends preview to Slack channel/DM for human approval Waits for explicit approval before publishing Multi-Platform Publishing Auto-publishes to Medium upon approval Sends formatted content via Gmail Stores everything in Google Drive for archiving Updates Google Sheets to prevent duplicates Rejection Handling Clean rejection notifications via Slack No publishing if content doesn't meet standards Key Features That'll Blow Your Mind Zero-Duplicate Publishing**: Smart Google Sheets integration tracks all published content Human-in-the-Loop**: Slack approval system keeps quality control tight Full AI Pipeline**: From RSS parsing to image generation, everything's automated Multi-Source Content**: Aggregates from top tech news sources Professional Formatting**: Articles come out Medium-ready with proper structure Cloud Storage**: Everything gets archived in Google Drive automatically Email Distribution**: Auto-sends content to your mailing list How to use Clone this workflow and connect your credentials Set up your Google Sheets tracking document Configure Slack notifications for your approval channel Add your Medium API credentials for publishing The schedule trigger runs every 6 hours, but you can adjust timing Manual trigger available for testing and one-off runs Requirements Google Workspace**: Sheets, Docs, Drive, Gmail access Slack Workspace**: For approval notifications and review Groq API**: For AI content generation Google Gemini API**: For image prompt creation Medium API**: For automated publishing Pollinations**: Free AI image generation (no API key needed) Customizing this workflow This isn't just another automation—it's your new content creation superpower. Here's how to make it yours: Switch RSS Sources**: Replace tech feeds with your niche (finance, health, etc.) Modify AI Prompts**: Adjust the content generation style to match your brand voice Change Publishing Destinations**: Swap Medium for WordPress, Ghost, or other platforms Add More Approval Steps**: Include multiple reviewers or different approval criteria Customize Image Generation**: Modify prompts for different visual styles Schedule Flexibility**: Adjust timing from 6 hours to daily, weekly, whatever fits Pro Tips: The workflow includes comprehensive error handling and logging Sticky notes provide detailed documentation for each section Modular design makes it easy to swap components Built-in duplicate prevention saves you from embarrassing reposts This template is perfect for content creators, digital marketers, tech bloggers, and anyone who wants to scale their content game without losing quality control. It's like having a full content team working 24/7, but smarter and way more consistent. Use cases that work incredibly well: Tech blog automation for agencies News aggregation and commentary sites Personal brand content scaling Client content creation workflows Multi-platform publishing systems

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 (competitor_profiles, market_trends) 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 competitor_profiles or market_trends 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.

How it Works ⚙️ This workflow is your agency’s secret weapon. It’s a multi-AI-agent system that automates the entire process of competitor and market research, providing you with a complete strategic analysis in minutes. Digital Reconnaissance (Agent 1): The workflow is triggered with a client's business name and industry. The first AI agent, powered by Apify, immediately begins a deep dive into the market to identify and scrape data on the client’s top competitors. Strategic Analysis (Agent 2): All the raw data from Agent 1 is sent to the second AI agent, powered by OpenAI (GPT-4). This agent performs a sophisticated analysis to summarize competitor messaging, identify their audience, and generate a full SWOT analysis for your client. Report & Strategy Generation (Agent 3): A third AI agent, also using OpenAI, takes the strategic analysis and writes a professional, persuasive report. This report is then automatically populated into a pre-designed Google Docs template, ready for review. Instant Delivery: The final report is automatically sent to your internal team via Slack, allowing you to start your strategy meeting almost instantly after the workflow is triggered. Setup Steps 🛠️ Get Your Apify Actor: Log in to Apify and find a suitable Actor for web scraping (e.g., Google Search Results Scraper). Copy the Actor ID to use in the n8n workflow. Prepare Your Report Template: Create a new Google Doc to serve as your report template. Use placeholders like {{ client_name }}, {{ report_content }}, and {{ client_industry }} to define where the AI-generated text will go. Copy the document ID from the Google Doc URL and save it for later. Import the Workflow: Copy the provided workflow JSON and import it into your n8n instance. Configure Credentials: Apify: Add your Apify API Key. OpenAI: Add your OpenAI API Key. Google Docs: Add your OAuth2 credential. Slack: Add your Bot Token credential. Customize Workflow Nodes: Node 2 (Apify): Paste your Actor ID here. You can also customize the search queries in the Input JSON to be more specific. Node 6 (Google Docs): Paste your template's Document ID here. Ensure the Values match the placeholders you created in your template. Node 7 (Slack): Replace [YOUR MARKETING TEAM SLACK CHANNEL ID] with the correct channel ID where you want the report delivered. Activate & Test: Once all settings are configured, save the workflow. Click the "Inactive" toggle to make it live. Run a test by manually entering a client's name and industry to ensure the data flows correctly and the report is delivered.

How It Works ⚙️ This workflow is a sophisticated, end-to-end solution that automates the entire billing lifecycle, from invoice creation to intelligent payment reminders and status tracking. It's designed to give you complete control over your cash flow without the manual effort. Smart Invoice Creation: The workflow is triggered when new billing data is added to your Google Sheets. It then uses a Google Docs template to automatically create a professional, personalized PDF invoice. Optionally, it can use OpenAI to generate a detailed description. Payment Monitoring: An HTTP Request node integrates with a payment gateway's API (e.g., Stripe, Midtrans) to check the real-time payment status of the invoice. Intelligent Reminders: Based on the payment status check, an If node determines whether to send a reminder. It sends polite, pre-due date reminders and more urgent post-due reminders only if the invoice remains unpaid. Multi-Channel Alerts: If an invoice becomes overdue, the workflow sends an internal alert to your team's Slack channel, ensuring you're always aware of potential cash flow issues. Automated Status Updates: The system automatically updates the status of the invoice in your Google Sheets database (e.g., Sent, Overdue, Paid), providing a real-time dashboard of your finances. How to Set Up 🛠️ Import the Workflow: Copy the provided workflow JSON and import it into your n8n instance. Configure Credentials: Google Sheets: Add your OAuth2 credential. Google Docs: Add your OAuth2 credential. Gmail: Add your OAuth2 credential. OpenAI (Optional): Add your API Key. Slack: Add your Bot Token credential. Stripe/Midtrans (or other payment gateway): Add your API Key credential for the HTTP Request node. Customize Workflow Nodes: Node 1 (Google Sheets Trigger): Select your billing data spreadsheet and sheet name. Node 3 (Google Docs): Replace the placeholder [YOUR GOOGLE DOCS INVOICE TEMPLATE ID] with your own template ID. Node 6 (HTTP Request): Replace the API URL with your payment gateway's endpoint for checking invoice status. Nodes 8 & 10 (Gmail & Slack): Replace the email addresses and Slack channel ID placeholders. Save & Activate: Once all settings and credentials are configured, save the workflow and click the "Inactive" toggle in the top-right corner to make it live.