Workflow Templates

This workflow automates invoice creation using Google Sheets for structured input and Google Docs for templated output — all built inside n8n. 🛠️ Step-by-Step Instructions ### Step 1: Manual Trigger Start the workflow manually for testing or development purposes. ### Step 2: Google Sheets — Load Invoice Data Pulls invoice data from a Google Sheet. 📄 Sheet URL: Copy This Sheet Expected Columns**: Company From Company To Terms Invoice Description Amount > 🔑 Credentials Required: > Connect to Google Sheets OAuth2 API in n8n. > Be sure your sheet is shared with the connected Google account. ### Step 3: Get Invoice Template — Load Google Doc Loads a static Google Docs template containing placeholder values. 🧾 Template URL: Copy This Template Required Placeholders** in the document: FromCompany# ToCompany# Terms# Invoice# Description# Amount# > 🔑 Credentials Required: > Connect to Google Docs OAuth2 API in n8n. ### Step 4: Create New Doc — Make Invoice File Creates a new Google Doc by duplicating the invoice template. Title Format**: Invoice: {{ $json.Invoice }} Destination Folder ID**: 1TnDibwPPPUm3VbmETiqWDVhtaUTLJ6mn (You can change this to your own Google Drive folder) > 🔐 Make sure your Google Docs credential has write access to this folder. ### Step 5: Merge — Combine Data Merges the loaded document and spreadsheet row together for downstream updates. ### Step 6: Insert Content into Doc (Optional) You can insert additional content here if needed. For example, a note, header, or footer pulled from your database or a custom field. ### Step 7: Input Invoice Details — Replace Fields Uses Google Docs API to replace all placeholders from the original template with the actual values. Replacements: | Placeholder | Replaced With | |----------------|------------------------------| | FromCompany# | Company From from sheet | | ToCompany# | Company To from sheet | | Terms# | Terms from sheet | | Invoice# | Invoice number | | Description# | Description of service | | Amount# | Amount of invoice | 📤 Final Output Each row from the Google Sheet results in a completed, branded Google Doc invoice stored in your Drive. 🙋 Need Help? Robert Breen Automation Consultant 🌐 ynteractive.com 📧 robert.j.breen@gmail.com 🔗 LinkedIn 🔒 Required APIs | Service | Purpose | |------------------|--------------------------| | Google Sheets API | Pull structured invoice data | | Google Docs API | Load & modify invoice documents | | n8n OAuth2 | Connect both services securely | Let me know if you'd like a follow-up step to export invoices as PDFs or auto-email them to clients!

Brief Overview This automation template helps you track the latest real estate listings from the LoopNet platform. By using Scrapeless to scrape property listings, n8n to orchestrate the workflow, and Google Sheets to store the results, you can build a real estate data pipeline that runs automatically on a weekly schedule. How It Works Trigger on a Schedule:** The workflow runs automatically every week (can be adjusted to every 6 hours, daily, etc.). Scrape Property Listings:** Scrapeless crawls the LoopNet real estate website and returns structured Markdown data. Extract & Parse Content:** JavaScript nodes use regex to parse property titles, links, sizes, year built from Markdown. Flatten Data:** Each property listing becomes a single row with structured fields. Save to Google Sheets:** Property data is appended to your Google Sheet for easy analysis, sharing, and reporting. Features No-code, automated real estate listing scraper. Scrapes and structures the latest commercial property listings (for sale or lease). Saves structured listing data directly to Google Sheets. Fully automated, scheduled scraping—no manual scraping is required. Extensible: Add filters, deduplication, Slack/Email notifications, or multi-city scraping. Requirements Scrapeless API Key:** Sign up on the Scrapeless Dashboard. Go to Settings → API Key Management → Create API Key, then copy the generated key. n8n Instance:** Self-hosted or n8n.cloud account. Google Account:** For Google Sheets API access. Target Site:** This template is configured for LoopNet real estate listings but can be adapted for other property platforms like Crexi. Installation Deploy n8n on your preferred platform. Install the Scrapeless node from the community marketplace. Import this workflow JSON file into your n8n workspace. Create and add your Scrapeless API Key in n8n’s credential manager. Connect your Google Sheets account in n8n. Update the target LoopNet URL and Google Sheet details. Usage This automated real estate scraper is ideal for: | Industry / Role | Use Case | | ---------------------- | ----------------------------------------------------------------- | | Real Estate Agencies | Monitor new commercial properties and streamline lead generation. | | Market Research Teams | Track market dynamics and property availability in real-time. | | BI/Data Analysts | Automate data collection for dashboards and market insights. | | Investors | Keep tabs on the latest commercial property opportunities. | | Automation Enthusiasts | Example use case for learning web scraping + automation. | Output Example

Transform blog posts, YouTube videos, or any text into LinkedIn posts, Twitter threads, email newsletters, and more with GPT-5.1 Who is this for? Content creators** who want to maximize reach from every piece of content Marketing teams** repurposing long-form content for social media Founders & executives** sharing thought leadership across platforms Agencies** creating multi-platform content packages for clients Solopreneurs** who need to be everywhere but have limited time What problem does it solve? Creating platform-specific content is time-consuming. A single blog post could become LinkedIn posts, Twitter threads, email newsletters, and video scripts-but manually adapting content for each platform takes hours. This workflow automates the entire process. Drop in a URL or paste your content, and get 7+ ready-to-use content pieces in under 2 minutes. What this workflow does Step 1: Content Input Submit via simple web form Accepts blog URLs, YouTube URLs, or raw text Optional: specify target audience and custom instructions Step 2: Smart Extraction Blog posts:** Fetches and extracts article content, removes navigation/ads YouTube videos:** Gets video metadata and description via YouTube API Raw text:** Processes directly with automatic title detection Step 3: AI Content Generation GPT-4.1/5.1 analyzes your content and generates platform-optimized variations: | Output | What You Get | |--------|-------------| | LinkedIn Posts | 3 variations (story-driven, list format, contrarian angle) | | Twitter/X Thread | 7-tweet thread + alternative hook for A/B testing | | Email Newsletter | 3 subject lines + preview text + full body | | Key Takeaways | 5 actionable bullet points | | Quote Cards | 5 shareable quotes ready for graphics | | Video Script | 60-second script (hook → problem → solution → CTA) | Step 4: Google Docs Output Everything saved to a beautifully formatted Google Doc Organized by platform Copy, customize, and publish! Outputs Generated LinkedIn Posts (3 variations): Story-driven emotional hook List/tips format for engagement Contrarian/hot take angle Each includes: hook, body, CTA, hashtags Twitter/X Thread (7 tweets): Scroll-stopping hook Logical flow through your key points Clear CTA at the end Alternative hook for A/B testing Email Newsletter: 3 subject line options (curiosity, benefit, direct) Preview text Conversational body copy Clear CTA Key Takeaways: 5 actionable insights Perfect for bullet points, carousels, or summaries Quote Cards: 5 impactful, shareable quotes Context included for each Ready for Canva/social graphics Video Script: 60-second format Hook → Problem → Solution → Proof → CTA structure Visual suggestions included Setup Instructions Required Credentials 1. OpenAI API Get your API key from platform.openai.com Add as "OpenAI API" credential in n8n Used for: Content generation (GPT-4o) 2. Google Docs Create OAuth2 credentials in Google Cloud Console Enable Google Docs API Add as "Google Docs OAuth2" credential in n8n Used for: Saving generated content Optional Credentials 3. YouTube OAuth2 (use same clientId and secret as above) Enable YouTube Data API v3 Add a new "YouTube OAuth2 API" credential: Client ID and Secret, same as above Used for: Better video metadata extraction How to Use Import the workflow into your n8n instance Configure credentials (OpenAI required, Google Docs required, YouTube optional) Activate the workflow Open the form URL (shown in Form Trigger node) Submit your content: Select content type (Blog URL, YouTube URL, or Raw Text) Paste URL or content (Optional) Add target audience (Optional) Add custom instructions Get your Google Doc link with all generated content! Customization Options Modify the AI prompt: Edit "AI Content Generator" node Adjust tone guidelines Add industry-specific instructions Change output formats Change output destination: Replace Google Docs with Notion, Airtable, or other platforms Add Slack notification with summary Email the doc link Add more platforms: Instagram captions Pinterest descriptions Podcast show notes Example Use Case Input: Blog post URL: https://example.com/10-tips-for-startup-founders Target audience: "First-time startup founders" Instructions: "Focus on practical, actionable advice" Output (in ~90 seconds): 3 LinkedIn posts with founder-focused hooks 7-tweet thread breaking down the top tips Email newsletter to subscribers 5 quotable insights for graphics 60-second video script for TikTok/Reels Estimated Costs | Service | Cost | |---------|------| | OpenAI (GPT-5.1) | ~$0.01-0.03 per generation | | YouTube API | Free (10,000 queries/day) | | Google Docs API | Free | Total per use: ~$0.02-0.04 Tips for Best Results Longer content = better output - Articles with 1000+ words generate richer variations YouTube videos need captions - Videos without captions may have limited output Specify your audience - Adding target audience improves relevance significantly Use custom instructions - Guide the AI toward your preferred tone and focus Support Questions or need customization? Contact Agentical AI

📰 Related News to Content Marketing Automation Overview This workflow automatically collects news from an RSS feed, identifies the most relevant article(s), and generates ready-to-use social media and blog content tailored for Medium, LinkedIn, and Instagram. It’s ideal for: • Marketing teams who want a steady flow of fresh content. • Social media managers looking to save time on research and writing. • Startups and creators who want consistent posting with minimal effort. Instead of manually scanning articles and drafting posts, this automation gives you AI-generated content with your preferred tone of voice — and even sends confirmation emails so you can review before posting. Prerequisites Before using this workflow, make sure you have: • ✅ An n8n account (self-hosted or cloud). • ✅ An OpenAI API key for content generation. • ✅ An RSS feed URL for your industry or niche. • ✅ A Gmail account (or another configured email service) to receive content confirmation messages. Setup Instructions Import the Workflow Download and import this workflow into your n8n instance. Configure the RSS Feed • Open the RSS Read node. • Replace the sample URL with your preferred news source(s). Connect OpenAI • Open the OpenAI Chat Model node. • Add your OpenAI API Key in the credentials. • (Optional) Adjust the prompts in the “Tone of Voice Writer” or “Instagram & LinkedIn Writer” nodes to match your brand’s style. Set Up Gmail • Open the Send Content Confirmation nodes. • Connect your Gmail (or another email service). • Add the email address where you want to receive content drafts. Run & Automate • Trigger the workflow manually with Execute Workflow to test. • Once tested, enable the Schedule Trigger node to run it automatically (e.g., daily). Customization Options • 🔄 Add more platforms: extend the workflow for Twitter, Facebook, or Slack. • ✏️ Adjust tone & length: update prompts in AI nodes (casual, professional, humorous, etc.). • ✅ Human-in-the-loop: add approval steps before publishing directly. • 🌍 Change news sources: swap RSS feeds for different industries or niches. Example Output LinkedIn Draft: “The future of marketing is AI-driven. 🚀 A new study shows that brands leveraging automation see 3x faster content turnaround. Read more here: [link] Instagram Caption: “Stay ahead of the curve 🌟 Today’s top story in digital marketing: AI tools are reshaping how we create content. What do you think — game-changer or hype? 🤔 #AI #Marketing” Limitations • AI may produce errors → Always review generated content before posting. • Gmail integration only sends drafts for confirmation — direct posting is not included. • RSS feeds vary in quality — results depend on your chosen source. How It Works (Workflow Overview) Collecting the news → Fetch articles via RSS feed. Best Article Finder → Selects the most relevant item. AI Writing → Generates content tailored for Medium, LinkedIn, and Instagram. Email Confirmation → Sends drafts to your inbox for review

Different Articles Summarizer & Social Media Auto-Poster This n8n template demonstrates how to extract full-text articles from different news websites, summarize them with AI, and automatically generate content for social networks (Twitter, Instagram, Threads, LinkedIn, YouTube). You can use it for any news topic. Example: posting summaries of breaking news articles. Possible use cases : Automate press article summarization with GPT. Create social media posts optimized for young audiences. Publish content simultaneously across multiple platforms with Late API. How it works The workflow starts manually or with a trigger. URLs of news articles are defined in the Edit Fields node. Each URL is processed separately via Split Out. HTTP Request fetches the article HTML. Custom Code node extracts clean text (title, content, main image). OpenAI summarizes each article factually. Aggregate combines results. Another OpenAI node (Message a model) creates structured JSON summaries for young readers. A final OpenAI node (Message a model1) generates short social media posts (hook, summary, CTA, hashtags). Images are extracted via HTML1 and uploaded to Google Drive. Posts (text + image) are sent to Late API for multi-platform scheduling (Twitter, Instagram, Threads, LinkedIn, YouTube). Requirements OpenAI API key connected to n8n. Google Drive account (for storing article images). Late API credentials with platform account IDs. Valid list of article URLs.

Who’s it for This workflow is for hotel managers, travel agencies, and hospitality teams who receive booking requests via email. It eliminates the need for manual data entry by automatically parsing emails and attachments, assigning booking cases to the right teams, and tracking performance metrics. What it does This workflow goes beyond simple automation by including enterprise-grade logic and security: 🛡️ Gatekeeper:** Watches your Gmail and filters irrelevant emails before spending money on AI tokens. 🧠 AI Brain:** Uses OpenAI (GPT-5-mini) to extract structured data from unstructured email bodies and PDF attachments. ⚖️ Business Logic:** Automatically routes tasks to different teams based on urgency, room count, and VIP status. 🔒 Security:** Catches PII (like credit card numbers) and scrubs them before they hit your database. 🚨 Safety Net:** If anything breaks, a dedicated error handling path logs the issue immediately so no booking is lost. 📈 ROI Tracking:** Calculates the time saved per booking to prove the value of automation. How to set up Create your Google Sheet: Create a new sheet and rename the tabs to: Cases, Team Assignments, Error Logs, Success Metrics. Add Credentials: Go to n8n Settings → Credentials and add your Gmail (OAuth2), Google Sheets, and OpenAI API keys. Configure User Settings: Open the "Configuration: User Settings" node at the start of the workflow. Paste your specific Google Sheet ID and Admin Email there. Adjust Business Rules: Open the "Apply Business Rules" node (Code node) to adjust the logic for team assignment (e.g., defining what counts as a "VIP" booking). Customize Templates: Modify the email templates in the Gmail nodes to match your hotel's branding. Test: Send a sample booking email to yourself to verify the filters and data extraction. Setup requirements Gmail account (OAuth2 connected) Google Sheets (with the 4 tabs listed below) OpenAI API key (GPT-5-mini recommended) n8n Cloud or self-hosted instance How to customize Filter Booking Emails:** Update the trigger node keywords to match your specific email subjects (e.g., "Reservation", "Booking Request"). Apply Business Rules:** Edit the Javascript in the Code node to fit your company’s internal logic (e.g., changing priority thresholds). New Metrics:** Add new columns in the Google Sheet (e.g., “Revenue Metrics”) and map them in the "Update Sheet" node. AI Model:** Switch to GPT-5 if you need higher reasoning capabilities for complex PDF layouts. Google Sheets Structure Description This workflow uses a Google Sheets document with four main tabs to track and manage hotel booking requests. 1. Cases This is the main data log for all incoming booking requests. case_id:** Unique identifier generated by the workflow. processed_date:** Timestamp when the workflow processed the booking. travel_agency / contact_details:** Extracted from the email. number_of_rooms / check_in_date:** Booking details parsed by the AI. special_requests:** Optional notes (e.g., airport transfer). assigned_team / priority:** Automatically set based on business rules. days_until_checkin:** Dynamic field showing urgency. 2. Team Assignments Stores internal routing and assignment details. timestamp:** When the case was routed. case_id:** Link to the corresponding record in the Cases tab. assigned_team / team_email:** Which department handles this request. priority:** Auto-set based on room count or urgency. 3. Error Log A critical audit trail that captures details about any failed processing steps. error_type:** Categorization of the failure (e.g., MISSING_REQUIRED_FIELDS). error_message:** Detailed technical explanation for debugging. original_sender / snippet:** Context to help you manually process the request if needed. 4. Success Metrics Tracks the results of your automation to prove its value. processing_time_seconds:** The time savings achieved by the automation (run time vs. human time). record_updated:** Confirmation that the database was updated. 🙋 Support If you encounter any issues during setup or have questions about customization, please reach out to our dedicated support email: foivosautomationhelp@gmail.com

🤖 AI Business Automation Opportunity Finder Turn automation audits into high-ticket sales with this ROI-focused n8n workflow powered by 4 specialized AI agents that identify and quantify automation opportunities in any business. What It Does This workflow analyzes any business and delivers a comprehensive automation blueprint with concrete ROI calculations in under 60 seconds. Perfect for agencies, consultants, and automation experts looking to generate qualified leads and close high-value deals. Unlike generic automation advice, this delivers personalized, quantified opportunities ranked by return on investment - making it incredibly easy for prospects to say yes. 🤖 Four Specialized AI Agents Business Analyst - Deep analysis of business model, workflows, pain points, tech stack, and scalability challenges Process Mapper - Maps all repetitive processes, calculates time waste, identifies bottlenecks across the entire operation Automation Architect - Designs 15+ specific automation solutions with tools, complexity ratings, and implementation steps ROI Calculator - Calculates detailed ROI for each automation, ranks top 10, creates 90-day implementation roadmap ✨ Key Features Concrete Dollar Savings**: Every automation shows exact time saved, labor cost saved, and payback period Top 10 Ranked by ROI**: Opportunities prioritized by impact vs. effort with detailed financial analysis 90-Day Implementation Roadmap**: Month-by-month plan showing progressive savings milestones Comprehensive Process Mapping**: Identifies inefficiencies they didn't even mention Tool-Specific Recommendations**: Exact tools and platforms needed (n8n, Zapier, Make, etc.) Beautiful HTML Reports**: Professional, conversion-focused email with 3-tier pricing built in Multiple CTAs**: Strategically placed conversion points throughout the report 📊 What Gets Analyzed Business Analysis Business model and revenue streams Operational workflows and processes Current tech stack assessment Team capacity and resource allocation Growth stage and scalability blockers Industry-specific automation patterns Process Mapping Comprehensive workflow documentation Time waste analysis (hours per month) Bottleneck identification Process dependencies and integration opportunities Quick win vs. strategic project categorization Automation Architecture For each of 15+ automation opportunities: Clear description of what it automates Specific tools required Step-by-step implementation flow Complexity rating (Easy/Medium/Hard) Prerequisites and requirements Additional benefits beyond time savings Real-world use case examples ROI Calculations For each automation: Time saved per week/month/year Labor cost savings (calculated from team size/industry) One-time implementation cost Ongoing monthly costs Payback period in months 12-month net savings ROI percentage Priority score (0-10) 💼 Perfect For Automation Agencies**: High-value lead magnet that pre-sells your services Business Consultants**: Demonstrate ROI before engagement No-Code Developers**: Show concrete value of your expertise Digital Transformation Consultants**: Quantify the opportunity SaaS Companies**: Lead gen for automation/workflow tools Freelancers**: Land bigger clients with data-driven proposals 🚀 Why This Converts Better Than Other Lead Magnets Traditional Lead Magnets: Generic advice ("You should automate") Subjective benefits ("Save time") No clear next steps Conversion rate: 5-10% This Workflow: Specific to their business** (personalized analysis) Quantified in dollars** ($50K+ annual savings) Prioritized action plan** (top 10 ranked by ROI) Clear implementation path** (90-day roadmap) Conversion rate: 20-30%** to strategy call 40-50% of calls close** to paid engagement 📈 Expected Business Results Per 100 Form Submissions: 25-30 strategy calls booked** (25-30% conversion) 10-15 deals closed** (40-50% call-to-close rate) $12K-18K in initial revenue** (mix of Tier 1 & 2) 2-4 retainer clients** ($30K-60K annual value) Total potential: $42K-78K** from 100 leads Why It Works: Self-qualifying**: Detailed form filters serious prospects Pre-sold**: They see the value before the call ROI-focused**: Speaks CFO language (dollars, not features) Urgency**: Shows money being wasted daily Social proof**: Built-in testimonials and case studies 📋 What You Need Required n8n instance (self-hosted or cloud) Anthropic API key (Claude Sonnet 4.5) Gmail account or SMTP provider Optional Enhancements CRM integration (HubSpot, Salesforce, Pipedrive) Slack notifications for high-value leads Calendly for automatic call booking Zapier/Make for additional workflows Analytics tracking (Mixpanel, Segment) ⚙️ Technical Details AI Model**: Claude Sonnet 4.5 (4 sequential agents) Average Runtime**: 50-70 seconds Cost Per Analysis**: ~$0.20-0.30 Form Fields**: 9 (business description, industry, team size, tasks, tools, bottleneck, revenue, email, name) Output**: Comprehensive HTML email with all analyses, pricing, and CTAs 🎨 Customization Options The workflow is fully customizable and includes detailed documentation: Adjust ROI calculation parameters (labor rates by industry) Modify agent prompts for specific niches Customize pricing tiers and packages Add/remove form fields White-label the entire report Integrate with your CRM/marketing stack Segment responses by company size or revenue Add video walkthroughs or personalized messages Create industry-specific versions 📊 Form Fields Explained The 9-field form is strategically designed to gather intelligence: Business Description (textarea): Core operations and offerings Industry/Niche (text): Context for automation patterns Team Size (dropdown): Affects ROI calculations and tool recommendations Repetitive Tasks (textarea): Gold mine for automation opportunities Current Tools (textarea): Integration points and tech stack assessment Biggest Bottleneck (textarea): Primary pain point for targeting Monthly Revenue (optional dropdown): For accurate ROI estimates and lead scoring Email (required): For report delivery Name (required): For personalization 🔧 Setup Difficulty Basic - Requires basic n8n knowledge and API configuration Setup Steps Import workflow JSON to n8n Add Anthropic API credentials Configure Gmail/SMTP credentials Customize branding and pricing in email template Test with sample business scenarios Deploy form on your website Set up follow-up sequences (recommended) 📚 Included Documentation Comprehensive sticky notes** for every component Setup instructions** with prerequisites Customization guide** for different industries Pricing strategy** breakdown and alternatives Conversion optimization** tips Follow-up sequence** recommendations Sales script** suggestions for strategy calls Marketing promotion** ideas 🌟 Advanced Use Cases 1. Lead Magnet Embed on website to capture qualified automation leads continuously 2. Discovery Tool Use during sales calls to demonstrate immediate value and build credibility 3. Content Marketing Offer in LinkedIn posts, email campaigns, YouTube videos for viral growth 4. Partner Program White-label for partners/affiliates to generate leads in their networks 5. Upsell Sequence For existing clients, identify additional automation opportunities 6. Industry Templates Create versions for specific industries (real estate, e-commerce, agencies) 7. Competitive Intelligence Analyze competitor operations and position your services ⚡ Why This Workflow Stands Out Compared to Generic Automation Audits: ✅ Quantified in dollars vs. vague "save time" claims ✅ Personalized to their business vs. generic templates ✅ Prioritized by ROI vs. random feature lists ✅ Actionable roadmap vs. overwhelming possibilities ✅ Tool-specific vs. theoretical concepts Compared to Manual Analysis: ✅ 60 seconds vs. 2-3 hours of consultant time ✅ $0.25 cost vs. $300-500 in labor ✅ Consistent quality vs. variable analyst experience ✅ Scalable vs. bottlenecked by human capacity ✅ 24/7 available vs. business hours only 🤝 Support & Community 📖 Website: https://evervise.ai/ ✨ Support: mark.marin@evervise.com N8N Link 🎁 Bonus Resources Included Follow-up email sequence** (3 emails over 10 days) Sales call script** for strategy calls Objection handling** guide Pricing calculator** spreadsheet Marketing assets** (social media templates) Case study template** for testimonials Tags automation lead-generation roi-calculator business-analysis process-mapping ai-agents anthropic claude workflow-automation business-consulting no-code n8n-workflows high-ticket-sales conversion-optimization saas-tools Ready to turn automation audits into recurring revenue? Import this workflow and start attracting qualified leads who can see the exact dollar value you provide before they even talk to you. Average user results: $42K-78K revenue from first 100 form submissions.

How it works: This template demonstrates how to build a low-code, AI-powered data analysis workflow in n8n. It enables you to connect to various data sources (such as MySQL, Google Sheets, or local files), process and analyze structured data, and generate natural language insights and visualizations using external AI APIs. Key Features: Flexible data source selection (MySQL, Google Sheets, Excel/CSV, etc.) AI-driven data analysis, interpretation, and visualization via HTTP Request nodes Automated email delivery of analysis results (Gmail node) Step-by-step sticky notes for credential setup and workflow customization Step-by-step: Apply for an API Key You can easily create and manage your API Key in the ADA official website - API. To begin with, You need to register for an ADA account. Once on the homepage, click the bottom left corner to access the API management dashboard. Here, you can create new APIs and set the credit consumption limit for each API. A single account can create up to 10 APIs. After successful creation, you can copy the API Key to set credentials. You can also view the credit consumption of each API and manage your APIs. Set credentials In HTTP nodes(DataAnalysis, DataInterpretation, and DataVisualization) select Authentication → Generic Credential Type Choose Header Auth → Create new credential Name the header Authorization, which must be exactly 'Authorization', and fill in the previously applied API key Data Source: The workflow starts by extracting structured data from your chosen source (e.g., database, spreadsheet, or file). AI Skills: Data is sent to external AI APIs for analysis, interpretation, and visualization, based on your configured queries. Result Processing: The AI-generated results are converted to HTML or Markdown as needed. Output: The final report or visualization is sent via email. You can easily adapt this step to other output channels. API Keys Required: Ada API Key: For AI data analysis Gmail OAuth2: For sending emails (if using Gmail node) (Optional) Data source credentials: For MySQL, Google Sheets, etc.

This workflow automates the creation of audiobooks from structured text data using AI-powered text-to-speech and audio processing services. Click here to listen the result of my example. Key Advantages 1. ✅ Fully Automated Audiobook Production The entire pipeline—from text retrieval to final audio upload—is automated. This removes manual steps, reduces human error, and enables repeatable audiobook generation at scale. 2. ✅ Advanced Voice Customization By using voice design prompts (voice description + style instruction), the workflow produces highly expressive and context-aware narration, ideal for audiobooks, storytelling, and branded audio content. 3. ✅ Scalable and API-Safe Architecture The batch processing and looping logic respects external API limits. This makes the workflow robust even for large audiobooks with dozens or hundreds of segments. 4. ✅ Centralized Content Management Google Sheets acts as a lightweight CMS: Easy to edit scripts and voice parameters Clear tracking of processed items Temporary URLs and merge flags ensure full visibility into the workflow state 5. ✅ Asynchronous and Fault-Tolerant The use of wait nodes and status checks allows the workflow to handle long-running audio operations without blocking or failing prematurely. 6. ✅ Seamless Cloud Storage Integration Final audiobooks are automatically stored in Google Drive, making them immediately accessible for distribution, review, or further processing. 7. ✅ Modular and Extensible Design Each step (TTS generation, batching, merging, storage) is modular. This makes it easy to: Swap TTS providers Change storage destinations Add post-processing steps (e.g. metadata, chapter markers) How it Works This workflow automates the creation of audiobooks using AI-generated voice synthesis with custom voice design. The process begins by retrieving script data from a Google Sheets document containing text, speaker information, voice descriptions, and style instructions. The workflow then processes each row in batches, sending the text to the Qwen3-TTS model on Replicate with specified voice parameters to generate individual audio segments. Each generated audio URL is stored back in the spreadsheet. Concurrently, once multiple audio segments are ready, they are merged into a single audio file using an external FFmpeg API service. The system polls for merge completion, retrieves the final merged audio file, and uploads it to Google Drive as a complete audiobook with a timestamped filename. Set up Steps Data Source Configuration: Set up the Google Sheets node to connect to your spreadsheet containing the audiobook script with required columns: Text, Speaker, Voice Description, Style Instruction, Temp URL, and To Merge API Credentials Setup: Configure Replicate API credentials for Qwen3-TTS voice synthesis Set up Fal.run API credentials for FFmpeg audio merging operations Configure Google Drive OAuth2 credentials for uploading the final audiobook Voice Design Parameters: Ensure your spreadsheet contains appropriate voice descriptions and style instructions compatible with the Qwen3-TTS model's requirements Destination Settings: Verify the Google Drive folder ID in the upload node points to your desired storage location for the final audiobook Execution: Trigger the workflow manually to begin processing your script rows and generating the complete audiobook with custom voice design 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

Who is this for? This template is ideal for DevOps engineers, automation specialists, and n8n users who manage multiple workflows and want a reliable version control system for backups. It’s especially useful for teams collaborating via GitHub. What problem is this workflow solving? Manually backing up n8n workflows to GitHub can be time-consuming and error-prone. This workflow solves that by automating the backup of new and updated n8n workflows, ensuring your GitHub repository always reflects the latest changes. What this workflow does Retrieves all workflows from your local n8n instance. Decodes their content and compares it with existing GitHub files. Detects newly created or updated workflows. Creates a new Git branch and commits changes. Opens a pull request (PR) to the main branch. Sends a Slack notification when the PR is created. The system uses GitHub API, n8n, Merge, Set, and Slack nodes for full automation. Setup GitHub credentials: Add your GitHub API credentials in n8n. Slack integration: Connect your Slack Bot token if you want PR notifications. Repository details: Update github_owner, repo_name, and workflow directory path in the “Define Local Variables” node. n8n API key - Check this doc How to customize this workflow to your needs Change the workflow directory from workflows/ to a custom path. Modify the Slack message or add email notification support. Add filters to back up only specific workflows based on naming or tags. Adjust branch naming conventions or use different GitHub base branches. This workflow provides a seamless backup and versioning pipeline, minimizing manual Git interactions and supporting collaborative automation development.

🔥 Daily Web Scraper & AI Summary with Firecrawl + Email Automation Need to extract and summarize web content from a site that doesn’t have an API? This workflow runs daily to scrape a web page using Firecrawl, summarize the content with OpenAI, and send it directly to your email — fully automated. Watch Full Video Step-by-step Tutorial Here: https://www.youtube.com/@Automatewithmarc 🔧 How It Works Daily Trigger – Starts the workflow every 24 hours. Firecrawl Node – Crawls and extracts structured data from any web page you specify. OpenAI Node (Optional) – Processes and summarizes the raw content using a prompt you control. Gmail Node – Sends the final summary or content snapshot to your email inbox. ✅ Perfect For Business analysts tracking daily market or industry news Researchers and founders automating competitive intelligence Anyone who wants web data delivered without coding or scraping scripts 🪜 Setup Instructions Firecrawl API Key – Sign up and insert your key in the credentials. Update Target URL – Edit the URL in the Firecrawl node to your desired site. Customize the Prompt – Tailor the OpenAI prompt to extract the insights you want. Connect Gmail – Add your Gmail credentials and set your recipient email. 🧰 Built With Firecrawl (Web scraping without code) OpenAI (For summarizing and insight extraction) Gmail (Automated notifications) n8n (Workflow automation engine)

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Generates relevant keywords and questions from a a customer profile. Keyword data is enriched from ahref and everything is stored in a Google Sheet. This is great for market and customer research. Understanding search intent for a well defined audience and gives relevant actionable data in a fraction of time that manual research takes. How it works We'll define a customer profile in the 'Data' node We use an OpenAI LLM to fetch relevant search intent as keywords and questions We use an SEO MCP server to fetch keyword data from ahref free tooling The fetched data is stored in the Google sheet Set up steps Copy Google Sheet template and add it in all Google Sheet nodes Make sure that n8n has read & write permissions for your Google sheet. Add your list of domains in the first column in the Google sheet Add MCP credentials for seo-mcp Add OpenAI API credentials