Workflow Templates

This automated n8n workflow reads patient data from Google Sheets daily at 8 AM, sends email and WhatsApp reports to doctors, alerts staff for critical patients, and logs activities back to sheets. Good to Know Runs daily at 8 AM via cron trigger. Filters active patients only. Requires Google service account, Gmail app password, and WhatsApp API token. Logs all sent reports in a dedicated sheet. How It Works Cron Trigger** - Schedules daily run at 8 AM. Google Sheets (Read)** - Fetches patient data from "Patients" sheet. Filter Node** - Selects active patients. Code Node** - Processes data, creates report content, checks for critical conditions. Email Send Node** - Sends reports to doctors via Gmail. HTTP Request Node** - Sends WhatsApp messages. Filter Critical** - Identifies critical patients. Critical Alert Email** - Notifies hospital staff. Google Sheets (Write)** - Logs reports to "Reports_Log" sheet. Google Sheet Structure Sheet 1: A: Patient ID | B: Patient Name | C: Age | D: Current Condition E: Temperature | F: Blood Pressure | G: Heart Rate | H: Current Medication I: Doctor Email | J: Doctor WhatsApp | K: Priority | L: Status | M: Last Updated Sample Data: P001 | John Doe | 45 | Stable | 98.6 | 120/80 | 72 | Aspirin | dr@hospital.com | +1234567890 | Normal | Active | 2024-01-15 P002 | Jane Smith | 32 | Fever | 101.8 | 130/85 | 88 | Tylenol | dr2@hospital.com | +1987654321 | Critical | Active | 2024-01-15 Sheet 2: A: Report Date | B: Patient ID | C: Patient Name | D: Status | E: Sent How to Use Import workflow JSON into n8n. Configure nodes with Google credentials, sheet ID, Gmail app password, WhatsApp token. Add patients to Google Sheet with "Active" status. Test manually, then activate for daily runs. Requirements Google Sheet with specified structure. Google Cloud service account JSON. Gmail with 2FA and app password. WhatsApp Business API token. n8n instance. Customizing This Workflow Adjust cron expression for different schedule. Modify Code Node for custom report formats or critical thresholds. Update email/WhatsApp nodes for additional recipients or templates. Extend filters for more patient statuses.

✨ About this Template This n8n template automates the process of writing SEO guest post content using OpenAI, based on rules and topics provided in a Google Sheet. The generated articles are saved into a separate sheet for outreach or publishing. Use cases include: SEO guest post generation Content marketing automation for agencies Outreach planning and editorial automation 💡 Good to Know OpenAI API usage costs apply based on the selected model (e.g., GPT-4). This automation uses Google Sheets and OpenAI; credentials are required to connect your accounts. Status filtering ensures only content marked as “Start” is processed — making it safe to use in multi-user workflows. ⚙️ How It Works Trigger the workflow manually (can be changed to schedule/cron or webhook). Reads from a Google Sheet with guest post planning data. Merges the writing prompt, brand guidelines, and posting rules. Sends the merged data to OpenAI (via the AI Agent node) to generate a guest post in German. Saves the result into another Google Sheet. Updates the original row's status from “Start” to “Finished” to prevent duplicates. ▶️ How to Use You must connect your Google Sheets and OpenAI accounts. Customize the AI prompt, tone, or language by editing the input structure. You can modify the filter to run only on certain months or categories. The Gmail node is optional and only used to notify when no action was taken. 🧰 Requirements OpenAI account (API key for GPT-4 or GPT-3.5) Google account with access to the configured Sheets Basic knowledge of how n8n expressions work (optional) 🛠️ Customising This Workflow This guest post writer workflow can easily be adapted to other use cases: Write social media content from a spreadsheet Generate product descriptions from catalog data Automatically translate or rewrite articles in different tones/languages Create personalized outreach emails using AI 🎁 The workflow includes built-in explanations (sticky notes) to guide you through each part of the process.

Overview Transform competitor Instagram content into optimized scripts for your own channel with this fully automated AI-powered content intelligence system. This workflow monitors Instagram profiles in your niche (AI/automation/tech), downloads their videos, transcribes the content, analyzes it for valuable tools and technologies, enriches it with web research, and rewrites it into polished, engagement-optimized scripts ready for your content team. It's like having a 24/7 content research team that never sleeps, turning competitor content into fresh opportunities for your channel. Key Benefits 🎯 Automated Competitive Intelligence - Monitor unlimited Instagram profiles and automatically capture their latest content the moment they post, ensuring you never miss trending topics in your niche. 🤖 AI-Powered Content Analysis - GPT-4O intelligently filters videos to identify only those discussing relevant tools, technologies, or AI solutions, saving hours of manual review time. ✍️ Professional Script Rewriting - Automatically transforms competitor scripts into unique, high-quality content optimized for your brand voice with engagement-focused CTAs that drive comments and DMs. 🔍 Deep Research Integration - Enriches every script with fresh facts from Perplexity AI's web search, adding unique insights and credibility that sets your content apart from simple reposts. 📊 Comprehensive Data Tracking - Stores all video metadata (views, likes, comments, duration) alongside original and rewritten scripts for performance analysis and content strategy optimization. ⚡ Scalable Batch Processing - Process multiple Instagram profiles in a single execution with built-in error handling, ensuring the workflow continues even if individual videos fail to process. 💰 Revenue-Generating Lead Magnet - Built-in CTA system ("comment [keyword] for the link") creates engagement and captures leads directly into your DMs for monetization opportunities. 🔄 100% Repurposable Output - Every processed video becomes a ready-to-use script with step-by-step guides, tool information, and engagement hooks perfect for reels, shorts, or TikToks. How It Works Phase 1: Content Discovery & Extraction The workflow begins by reading your curated list of Instagram profiles from a Google Sheet. These should be competitors or influencers in your niche (AI, automation, tech tools, etc.). For each profile, the system uses the Scrape Creators API to fetch their most recent post, specifically targeting video content. It extracts multiple video quality URLs and prepares them for download. Phase 2: Video Processing & Transcription Once a video is identified, the workflow downloads it directly from Instagram's servers using the highest quality version available. The video file is then passed to OpenAI's Whisper transcription model, which converts the audio into accurate text transcripts. This happens automatically even for videos with background music, multiple speakers, or accents. Phase 3: Intelligent Content Filtering The raw transcript is analyzed by GPT-4O using a sophisticated prompt that determines if the content is relevant to your niche. The AI identifies: Whether the video discusses tools, technologies, or AI solutions (verdict: true/false) Specific tool names mentioned Step-by-step instructions for using the tools A search query for additional research Suggestions for making the content more engaging for an AI/automation audience If the content isn't relevant, the workflow skips it and moves to the next profile, saving API costs and processing time. Phase 4: Deep Research & Fact-Finding For relevant content, the system automatically queries Perplexity AI using the generated search prompt. Perplexity searches the web in real-time to find three interesting, peculiar, or unique facts about the tool or technology. This adds depth and credibility to your final script that the original content likely didn't have. Phase 5: Professional Script Rewriting The final AI step combines everything: the original transcript, the step-by-step guide, the Perplexity research, and the improvement suggestions. GPT-4O rewrites the entire script in your brand voice (casual, spartan, straightforward) at approximately 100 words. The new script: Opens with a strong hook Presents the tool/technology clearly Includes the researched facts naturally Provides value-driven instructions Ends with a specific CTA (e.g., "Comment 'AI' and I'll send the link") Phase 6: Data Storage & Loop Execution All data is written back to your Google Sheet including video metadata (ID, timestamp, caption, engagement metrics), the original transcript, and the rewritten script. The workflow then loops back to process the next Instagram profile in your list, continuing until all profiles have been processed. Required Setup Google Sheets Database Create a Google Sheet with two tabs: "profiles" tab - Column: "Instagram Handles" (without @ symbol, e.g., "aiautomationhub") "phantom output" tab - Columns: id, timeStamp, caption, commentcount, videoUrl, likesCount, videoViewsCount, Username, Duration, original Script, rewritten Script, style, Updated API Credentials Required Scrape Creators API** - For Instagram data extraction (handles, posts, videos) OpenAI API Key** - For Whisper transcription and GPT-4O script analysis/rewriting Perplexity API Key** - For real-time web research and fact-finding Google Sheets OAuth** - For reading profiles and writing processed data Software Requirements n8n instance (cloud or self-hosted) Internet connection for API calls Sufficient OpenAI credits (approximately $0.05-0.15 per video processed) Business Use Cases Content Creation Agencies - Offer content repurposing services to clients, turning competitor research into ready-to-post scripts at scale. Social Media Managers - Monitor competitor content and generate fresh ideas for your own channels without manual research. Course Creators - Identify trending tools in your niche and create educational content around them before competitors do. Affiliate Marketers - Discover new tools to promote, complete with ready-made scripts and CTAs for lead generation. SaaS Companies - Track how competitors explain similar products and optimize your own messaging based on what works. Newsletter Operators - Find trending topics and tools to feature, with scripts easily adaptable to written content. Revenue Potential Direct Sales: Sell this workflow template for $97-$297 depending on setup complexity and included support. Subscription Service: Offer managed content intelligence as a service at $197-$497/month, processing unlimited profiles for clients. Agency Upsell: Use this as a lead generation tool (the CTA system) to build an email/DM list, then sell content creation services at $500-$2,000 per client/month. Course Integration: Include as a bonus tool in a content creation course priced at $497-$997, increasing perceived value. White-Label Licensing: License to agencies for $997-$2,997 with white-label rights for their client base. Time Savings ROI: If a content team spends 2 hours per video on research and scripting at $50/hour, this workflow saves $100 per video. Processing 20 videos weekly = $104,000 annual savings. Difficulty Level & Build Time Difficulty: Intermediate-Advanced Requires understanding of API authentication Needs basic JSON knowledge for data mapping Involves prompt engineering for optimal AI outputs Build Time: 3-4 hours for experienced n8n users, 6-8 hours for beginners Setup and API credential configuration: 1 hour Node connection and data flow: 1-2 hours Prompt optimization and testing: 1-2 hours Google Sheets schema creation: 30 minutes End-to-end testing with real profiles: 1-2 hours Maintenance: Low - Occasional prompt tweaks as AI models evolve Detailed Setup Steps Create Google Sheets Database Create new Google Sheet named "Instagram Content Intelligence" Add tab "profiles" with column "Instagram Handles" Add tab "phantom output" with all required columns (see schema above) Populate profiles tab with 5-10 Instagram handles in your niche Obtain API Credentials Sign up for Scrape Creators (https://scrapecreators.com) and get API key Create OpenAI account and generate API key with GPT-4O and Whisper access Sign up for Perplexity AI API (https://perplexity.ai) and get API key Connect Google Sheets via OAuth in n8n Import Workflow to n8n Copy the JSON workflow provided In n8n, click "Import from File" or paste JSON All nodes will appear but show credential errors Configure Credentials Click each node with a red error icon Add your respective API credentials (Scrape Creators, OpenAI, Perplexity, Google Sheets) Test each connection to ensure validity Map Google Sheets In "Get row(s) in sheet1" node, select your Google Sheet and "profiles" tab In "Update Entries2" node, select your Google Sheet and "phantom output" tab Verify column mappings match your sheet structure Customize AI Prompts Review "Filter & Generate Suggestions" prompt - adjust for your specific niche Review "Write New Script" prompt - modify tone, length, and CTA format to match your brand Test with sample transcripts to optimize output quality Test with Single Profile Add one Instagram handle to your profiles sheet Click "Execute workflow" manually Monitor each node's output to verify data flow Check that final script appears in Google Sheet Scale to Multiple Profiles Add 10-20 Instagram profiles to your sheet Run full workflow and monitor for errors Review output quality across different content types Adjust batch size if rate limits are hit Set Up Scheduling (Optional) Replace Manual Trigger with Schedule Trigger Set to run daily at optimal times (e.g., 6 AM when fresh posts exist) Enable error notifications to catch failures Implement DM Automation (Advanced) Connect Instagram API or tools like ManyChat Monitor comments for keywords from your CTA Auto-send tool links via DM to engaged users Advanced Customization Options Multi-Language Support: Add language detection node and conditional branches for different script formats per language. Engagement Scoring: Implement scoring algorithm based on likes, comments, views to prioritize which videos to repurpose first. Content Categorization: Add classification layer to tag scripts by category (productivity tools, AI models, automation platforms) for better organization. Thumbnail Analysis: Integrate vision AI to analyze which thumbnail styles perform best and suggest designs for your repurposed content. Sentiment Analysis: Add sentiment detection to understand emotional tone and adjust rewritten scripts to match or improve engagement potential. A/B Script Variants: Generate 2-3 script variations per video with different hooks/CTAs for split testing performance. Competitor Trend Dashboard: Build a connected dashboard showing trending tools, engagement patterns, and content gaps in your niche. Auto-Publishing Integration: Connect to Instagram API or scheduling tools to automatically post rewritten content with approval workflows. Voice Cloning Integration: Add ElevenLabs API to generate audio using your voice profile, making videos fully production-ready. Multi-Platform Expansion: Extend to TikTok, YouTube Shorts, LinkedIn by adjusting script length and platform-specific CTAs.

Who is this for? This workflow is ideal for: Business analysts* and *data professionals** who need to quickly analyze spreadsheet data through natural conversation Small to medium businesses** seeking AI-powered insights from their Google Sheets without complex dashboard setups Sales teams* and *marketing professionals** who want instant access to customer, product, and order analytics What problem is this workflow solving? Traditional data analysis requires technical skills and time-consuming manual work. This AI data analyst chatbot solves that by: Eliminating the need for complex formulas or pivot tables** - just ask questions in plain text Providing real-time insights** from live Google Sheets data whenever you need them Making data analysis accessible** to non-technical team members across the organization Maintaining conversation context** so you can ask follow-up questions and dive deeper into insights Combining multiple data sources** for comprehensive business intelligence What this workflow does This workflow creates an intelligent chatbot that can analyze data from Google Sheets in real time, providing AI-powered business intelligence and data insights through a conversational interface. Step by step: Chat Trigger receives incoming chat messages with session ID tracking for conversation context Parallel Data Retrieval fetches live data from multiple Google Sheets simultaneously Data Aggregation combines data from each sheet into structured objects for analysis AI Analysis processes user queries using OpenAI's language model with the combined data context Intelligent Response delivers analytical insights, summaries, or answers back to the chat interface How to set up Connect your Google Sheets account to all Google Sheets nodes for data access View & Copy the example Google Sheet template here: 👉 Smart AI Data Analyst Chatbot – Google Sheet Template Update Google Sheets document ID in all Google Sheets nodes to point to your specific spreadsheet Configure sheet names to match your Google Sheets structure Add your OpenAI API key to the OpenAI Chat Model node for AI-powered analysis Customize the AI Agent system message to reflect your specific data schema and analysis requirements Configure the chat trigger webhook for your specific chat interface implementation Test the workflow by sending sample queries about your data through the chat interface Monitor responses to ensure the AI is correctly interpreting and analyzing your Google Sheets data How to customize this workflow to your needs Replace with your own Google Sheets**: update the Google Sheets nodes to connect to your specific spreadsheets based on your use case. Replace with different data sources**: swap Google Sheets nodes with other data connectors like Airtable, databases (PostgreSQL, MySQL), or APIs to analyze data from your preferred platforms Modify AI instructions**: customize the Data Analyst AI Agent system message to focus on specific business metrics or analysis types Change AI model**: Switch to different LLM models such as Gemini, Claude, and others based on your complexity and cost requirements. Need help customizing? Contact me for consulting and support: 📧 billychartanto@gmail.com

Overview This template benefits anyone who wants to: automate web research on a prospect company compile that research into an easily readable note and save the note into CentralStationCRM Tools in this workflow CentralStationCRM, the easy and intuitive CRM Software for small teams. Here is our API Documentation if you want to customize the workflow. ChatGPT, the well-known ai chatbot Tavily, a web search service for large language models Disclaimer Tavily Web Search is (as of yet) a community node. You have to activate the use of community nodes inside your n8n account to use this workflow. Workflow Screenshot Workflow Description The workflow consists of: a webhook trigger an ai agent node an http request node The Webhook Trigger The Webhook is set up in CentralStationCRM to trigger when a new company is created inside the CRM. The Webhook Trigger Node in n8n then fetches the company data from the CRM. The AI Agent Node The node uses ChatGPT as ai chat model and two Tavily Web Search operations ('search for information' and 'extract URLs') as tools. Additionally, it uses a simple prompt as tool, telling the ai model to re-iterate on the research data if applicable. The AI Agent Node takes the Company Name and prompts ChatGPT to "do a deep research" on this company on the web. "The research shall help sales people get a good overview about the company and allow to identify potential opportunities." The AI Agent then formats the results into markdown format and passes them to the next node. The CentralStationCRM protocol node This is an HTTP Request to the CentralStationCRM API. It creates a 'protocol' (the API's name for notes in the CRM) with the markdown data it received from the previous node. This protocol is saved in CentralStationCRM, where it can easily be accessed as a note when clicking on the new company entry. Customization ideas Even though this workflow is pretty simple, it poses interesting possibilities for customization. For example, you can alter the Webhook trigger (in CentralstationCRM and n8n) to fire when a person is created. You have to alter the AI prompt as well and make sure the third node adds the research note to the person, not a company, via the CentralStationCRM API. You could also swap the AI model used here for another one, comparing the resulting research data and get a deeper understanding of ai chat models. Then of course there is the prompt itself. You can definitely double down on the information you are most interested in and refine your prompt to make the ai bot focus on these areas of search. Start experimenting a bit! Preconditions For this workflow to work, you need a CentralStationCRM account with API Access an n8n account with API Access an Open AI account with API Access Have fun with our workflow!

This workflow provides a mechanism for using AI transcribed voice notes using Voicenotes AI and then running them into an AI agent as prompts. On the "collection" end of the workflow, we gather the output (with the recorded prompt) and do two things: 1) It is saved into NocoDB as a new row on a database table recording AI outputs and prompts. 2) The prompt gets sent to an AI agent and the output gets returned to the user's email Who Is It For? If you like using voice AI tools to write detailed prompts for AI, then this workflow helps to remove the points of friction in getting from A to B! How Does It Work? Simply tag your voice note in Voicenotes with your preferred tag (I'm using 'prompt'). Then, provide the N8N webhook as the URL for a webhook that will trigger whenever a new note is created with this tag (and this tag only). Now, whenever you wish to use a voice note as a prompt, just add the 'tag.' This will trigger the webhook which, in turn, will trigger this workflow - sending the prompt to an AI agent of your choosing (configure within the workflow) and then saving the output into a database and returning it by email. Note: The AI agent system prompt is written to define a structured output to provide Gmail-safe HTML. This is thin injected into a template. You can use a Google Group to gather together the output runs or just receive them at your main address (if you don't use Gmail, just swap out for any other email node or your preferred delivery channel). How To Set It Up You'll need a Voicenotes account in order to use the service! Once you have one, you'll next want to create the tag and the webhook. In N8N, create your webhook node and then provide that to Voicenotes: Create a note. Then assign it a new tag: "Prompts" (or as you prefer). The webhook is matched to the tag. Requirements Voicenotes AI account Customisation The delivery mechanism can be customized to your preferences. If you're not a Google user, substitute the template and sending mechanism for your preferred delivery provider You could for example collect the outputs to a Slack channel or Telegram bot. You may omit the collector in NocoDB or substitute it for another wiki or knowledge management platform such as Notion or Nuclino.

🚀 Automated Plagiarism Checker Using Rapid API & Google Sheet logging 📄 Description This powerful no-code workflow automates plagiarism detection using Plagiarism Checker AI Powered. Users submit text through Google Sheets. The system checks for duplication using the API, sends a detailed HTML report via email, and logs the results — all without human intervention. 🔧 How the Workflow Works | Node Name | Purpose | | -------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------- | | Trigger - New Row in Google Sheet | Watches for new rows added to a connected Google Sheet. | | Send Content to Plagiarism API | Sends the user-submitted content to the Plagiarism Checker AI Powered API via POST. | | Check API Response Success | Verifies if the API responded successfully and returned results. | | Extract Plagiarism Results | Extracts matched results (if any) from the API response. | | Generate HTML Plagiarism Report | Creates a styled HTML report with similarity scores, links, and matched content. | | Send Report to User via Email | Sends the plagiarism report to the user using SMTP. | | Mark Status: Success in Google Sheet | Updates the Google Sheet with a "Success" status once the email is sent. | | Send Failure Alert to IT | If the API check fails, sends an alert email to IT for investigation. | | Mark Status: Failed in Google Sheet | Updates the Google Sheet with a "Failed" status if the process doesn’t complete successfully. | 🧾 Google Sheet Configuration ✅ Required Columns: | Column Name | Description | | ----------- | -------------------------------------- | | Content | The text to be checked for plagiarism | | Status | Workflow result (Success / Failed) | Make sure these column headers exist in Row 1 of your Google Sheet. 📊 How to Connect Google Sheets to n8n Create a new Google Sheet. In n8n, use the Google Sheets Trigger node: Set your document ID (from the sheet’s URL). Specify the sheet name (e.g., Sheet1 or use gid=0). Use Google Sheets (service account) credential type for writing updates. 🔑 How to Get a RapidAPI Key for Plagiarism Checker AI Powered Go to Plagiarism Checker AI Powered API. Sign up or log in to RapidAPI. Subscribe to the free or paid plan. Copy your x-rapidapi-key and paste it into the Send Content to Plagiarism API node's header. 🧠 Use Cases Educators verifying student submissions Content marketers validating blog originality Academic institutions enforcing anti-plagiarism policies Editors reviewing freelance work ✅ Benefits ⚙️ 100% Automated: Set once, run forever 📨 Instant Reports: Plagiarism reports delivered via email 📋 Easy Tracking: Status updates in Google Sheet 🛡️ Alerts Built-in: Automatic error notification to IT 🔗 Uses Plagiarism Checker AI Powered API to ensure accuracy and scalability 📘 Bonus Tips Ensure you handle Google API scopes properly (Editor or Owner access). Always test with small content first before scaling up. Plagiarism Checker AI Powered API supports sentence-level matching and source URLs.

📌 Overview Description: This powerful workflow automates your sales quotation process by connecting Pipedrive with DottedSign. When a deal is moved to a specific stage in Pipedrive, this template automatically generates a professional PDF quotation, uploads it back to the deal, and sends it out for e-signature via DottedSign service, saving your sales team valuable time and eliminating manual work. What it does When a Pipedrive deal moves to a designated stage (e.g., "Quotation Stage"), this workflow triggers and performs the following actions: Gathers Data: It collects all relevant information, including deal details, client contacts, organization info, and associated products from Pipedrive. Generates PDF Quote: It populates a customizable HTML template with the collected data and uses a PDF generation service (Gotenberg) to create a polished PDF document. Uploads to Pipedrive: The generated PDF quote is automatically uploaded to the "Files" section of the corresponding Pipedrive deal for record-keeping. Sends for E-Signature: It creates a new signing task in DottedSign, sending the quotation to the client for their electronic signature. Requirements A Pipedrive account with admin permissions. A DottedSign developer account to obtain API credentials. A self-hosted instance of Gotenberg for HTML to PDF conversion. How to set up Pipedrive Trigger Stage: In the If node, change the stage ID 7 to the ID of the pipeline stage you want to use as the trigger. PDF Conversion Service: In the Gotenberg to PDF (HTTP Request) node, replace the placeholder URL with the endpoint of your running Gotenberg instance. DottedSign Credentials: In the Get DottedSign Access Token node, enter your client_id and client_secret in the request body. DottedSign Signature Field: In the Create DottedSign Task node, you must adjust the page and coord values under field_settings to match the desired signature location on your PDF template. How to customize the workflow Quotation Template:** Edit the Generate Quotation HTML node to modify the quote's appearance, text, company logo, and terms. The {{ ... }} expressions are placeholders that are filled with Pipedrive data. Trigger:** Replace the Pipedrive Trigger with another trigger, such as a webhook or a form submission, to adapt the workflow to different needs. Notifications:** Add a Slack or email node at the end of the workflow to notify the sales team once the quotation has been sent.

Create Stunning CGI Videos with Sora 2 API and Google Drive Integration The Sora 2 API allows seamless generation of CGI ads, turning text prompts into stunning videos. This workflow automates the entire process from video generation to upload, notification, and file sharing via Google Drive. Node-by-Node Explanation On form submission: Triggers the workflow when a form with a prompt is submitted. Sora API Processor: The prompt is sent to the Sora 2 API's txttovideo.php endpoint to initiate video generation. (This step calls the API where the magic of turning text into video happens.) Wait for API Response: Pauses for 60 seconds before checking the API response. API Request: Check Task Status: Sends an HTTP request to check the status of the CGI ad generation task. Condition: Task Output Status: Validates the task status (success, processing, failed). Wait for Task to Complete: Waits for another 60 seconds to recheck the task completion status. Send Email: API Error - Task ID Missing: Sends an email if the prediction ID is missing in the response. Upload File to Google Drive: Uploads the CGI ad video to Google Drive. Set Google Drive Permissions: Configures file permissions for sharing. Send an email: Video Link: Notifies the user with a link to the uploaded video. Sticky Notes: Annotates and documents each step in the process for clarity. How to Obtain API Key Go to Sora 2 API on RapidAPI. Sign up or log in to RapidAPI. Subscribe to the API plan that suits your needs. Copy the API key from the dashboard under "Endpoints" or "Security" sections. How to Configure Google Drive Go to the Google Developer Console. Create a new project or select an existing one. Enable the Google Drive API for the project. Set up OAuth 2.0 credentials. Authorize the app in n8n by connecting your Google account with the credentials. Use Case This workflow is perfect for businesses looking to automate CGI ad generation, reducing the time and effort required to create videos from textual prompts. It is ideal for digital marketers, content creators, or any business that needs video content quickly and efficiently. Benefits Automates video generation**: Streamlines the creation of CGI ads. Efficient content sharing**: Automatically uploads to Google Drive and configures permissions. Error handling**: Sends notifications if anything goes wrong. Time-saving**: Reduces manual effort with automated API interactions. Easy to use**: Simple form submission to generate high-quality videos. Who is this for? Digital Marketers**: Automates video content creation for ads and campaigns. Content Creators**: Quickly generates high-quality CGI ads for social media or websites. Businesses**: Small to medium businesses looking for cost-effective video creation solutions. Developers**: Looking for an automated workflow to integrate CGI video generation into their applications or services.

AI Voice Appointment Booking with Vapi and Google Calendar Build an intelligent appointment booking system that lets customers schedule appointments through natural voice conversations. This workflow connects Vapi AI assistant with Google Calendar to check availability, create appointments, and send professional confirmation emails automatically. Who's It For Healthcare providers, consultants, service businesses, coaches, salons, or any business that schedules appointments and wants to automate booking through voice calls. What It Does This workflow creates two powerful tools for your Vapi voice assistant: Availability Checker: When customers ask about available time slots, the assistant calls this workflow which fetches busy times from Google Calendar, processes them through an AI agent, and returns open slots in natural language. Appointment Creator: Once the customer confirms their preferred time, the assistant triggers this workflow to create the calendar event and send a branded confirmation email with all appointment details. The entire booking process happens conversationally without requiring customers to navigate websites or apps. How It Works Availability Flow: Customer asks Vapi assistant to check availability for a specific date Vapi calls the first webhook with the requested date Workflow queries Google Calendar for busy slots that day JavaScript code formats the busy times into readable text AI agent analyzes the schedule and identifies available time windows Available slots are returned to Vapi in natural language Assistant presents options to the customer Booking Flow: Customer confirms their chosen appointment time and provides details Vapi calls the second webhook with name, email, date/time, and appointment type Workflow creates the calendar event in Google Calendar Professional HTML confirmation email is sent via Gmail Success confirmation is returned to Vapi Assistant confirms the booking to the customer Requirements Vapi account** with a configured voice assistant Google Calendar** for appointment management Gmail account** for sending confirmation emails Google Gemini API key** for availability analysis How to Set Up 1. Activate the Workflow Import this template and activate it to generate the two webhook URLs. 2. Configure Google Calendar In both calendar nodes, select your appointment calendar and set your timezone. 3. Connect Gmail Add your Gmail credentials to the email node and customize the confirmation email template with your branding. 4. Set Business Hours In the Availability Checker AI agent node, update the system message to reflect your operating hours. 5. Create Vapi Tools In your Vapi assistant dashboard, add two server tools: Tool 1: availability_checker Function name: availability_checker Description: "Checks available appointment slots for a specific date" Server URL: Your first webhook URL Parameters: date (string, required, ISO 8601 format) Tool 2: Creating_the_appointment_and_sending_the_confirmation_email Function name: Creating_the_appointment_and_sending_the_confirmation_email Description: "Creates appointment and sends confirmation email" Server URL: Your second webhook URL Parameters: Name, Email, date and time, Appointment type (all strings, all required) 6. Update Assistant Prompt Ensure your Vapi assistant knows when to call each tool based on customer requests. Vapi Configuration Download the complete Vapi assistant configuration: vapi-config.json 7. Test End-to-End Call your Vapi assistant and test the complete booking flow. How to Customize Appointment Duration: Change the 30-minute default in the "Create an event" node by modifying the .plus(30, 'mins') expression. Email Template: Edit the HTML in the "Send confirmation email" node to match your brand colors, logo, and messaging. Business Hours: Update the system message in the "Availability checker" AI agent node to reflect when you accept appointments. Timezone: Ensure both Google Calendar nodes use your correct timezone for accurate scheduling. Calendar Selection: Point both calendar nodes to the same Google Calendar to avoid double-bookings. Appointment Types: Customize the event description format in the "Create an event" node to include relevant details for your business. This workflow transforms appointment scheduling from a manual back-and-forth into an automated, professional experience that runs 24/7 through voice conversations.

📘 Workflow Documentation – Stock Market Daily Digest 👋 Introduction Wake up to a clean, analyst-style stock digest in your inbox—top gainers/losers, a readable performance table, 3–5 insights, and upcoming events—no spreadsheets, no manual scraping, no copy-paste. This article explains, step by step, how to build a robust, daily, end-to-end automation that collects market data (Bright Data), waits until scraping is done, aggregates results, asks an AI model (OpenAI) to draft a styled HTML email, logs everything to Airtable, and finally sends the report via Gmail. You’ll find a friendly but technical tour of every single node, so you can rebuild or adapt the same pipeline with confidence. 🎯 Who is this workflow for? Investors & traders** who want a quick, readable daily summary. Finance/Product teams** building data-driven alerts/digests. Consultants & agencies** sending recurring client updates. Automation builders** prototyping finance ops quickly. 🧰 Tools you’ll need Bright Data** — dataset triggers & snapshots for reliable web data. OpenAI (GPT)** — to generate a professional HTML digest. Airtable** — store daily rows for history, filters, dashboards. Example Airtable Table: Daily Stocks | Ticker | Company | Price | Change % | Sentiment | Date | |--------|--------------------------|---------|----------|-----------|---------------------| | AAPL | Apple Inc. | 225.80 | +1.4% | 🟢 Positive | 2025-09-18 09:00 | | MSFT | Microsoft Corporation | 415.20 | -0.7% | 🔴 Negative | 2025-09-18 09:00 | | NVDA | NVIDIA Corporation | 124.55 | +2.1% | 🟢 Positive | 2025-09-18 09:00 | | TSLA | Tesla Inc. | 260.00 | -3.0% | 🔴 Negative | 2025-09-18 09:00 | | META | Meta Platforms Inc. | 310.45 | +0.5% | 🟡 Neutral | 2025-09-18 09:00 | Gmail** — deliver the final HTML email to stakeholders. n8n** — the automation engine that orchestrates every step. > Keep API keys in n8n Credentials (never hard-code secrets). 🗺️ Architecture at a glance Schedule fires daily Seed list of tickers Split into one item per stock Prepare keyword for scraping Launch Bright Data job Poll progress with a wait-loop Fetch snapshot data Aggregate for the AI Generate HTML summary (GPT) Save rows to Airtable Send email via Gmail ⚙️ Step-by-step — Every node explained ⏰ Daily Run Trigger (Schedule Trigger) Purpose Start the automation at a precise time each day so nobody needs to push a button. Parameters (English) Trigger Type**: Time Interval or Cron Every X**: 1 Day (or your preferred cadence) Timezone**: UTC (or your own) Start Time**: optional (e.g., 09:00) 📝 Set Stock List (Set Node – SAMPLE DATA) Purpose Define the universe of stocks to monitor. This acts as the seed data for scraping. Parameters Values to Set**: Fixed JSON (array of objects) Keep Only Set**: true Fields per item**: ticker, name, market_cap (you may add sector, isin, etc.) 🔀 Split Stocks (Split Out) Purpose Turn the array into individual items so each ticker is processed independently (scraping, polling, results). Parameters Operation**: Split Out Items Field to Split**: the array defined in the previous Set node 🏷 Prepare Stock Keyword (Set Node) Purpose Create a keyword field (typically equal to ticker) for Bright Data discovery. Parameters Values to Set**: Add Field Field Name**: keyword Value**: use an expression referencing the current item’s ticker (e.g., ` {{ $json.ticker }} `) 🕸 Bright Data Scraper (HTTP Request) Purpose Trigger the Bright Data dataset to start collecting information for the keyword. Returns a snapshot_id to poll later. Parameters Method**: POST Endpoint**: https://api.brightdata.com/datasets/v1/trigger Authentication**: Authorization: Bearer <token> (header) Body Fields**: dataset_id: your Bright Data dataset ID discover_by: usually keyword keyword: the value prepared above > Add a retry/backoff policy on 429/5xx in node options. 🔄 Check Scraper Progress (HTTP Request) Purpose Poll Bright Data to see whether the snapshot is running or ready. Parameters Method**: GET Endpoint**: https://api.brightdata.com/datasets/v1/snapshots/{snapshot_id} Authentication**: Authorization: Bearer <token> Expected Output**: a status field (running, ready) ⏳ Wait for Data (Wait Node) Purpose Pause between progress checks to avoid rate limits and give Bright Data time to finish. Parameters Mode**: Wait a fixed amount of time Time**: e.g., 30 seconds (tune to your dataset size) 🔀 Scraper Status Switch (Switch Node) Purpose Route logic based on the polled status. Parameters Value to Check**: status Rules**: Equals running → go to Wait for Data (then re-check) Equals ready → proceed to Fetch Scraper Results > Loop pattern: Check → Wait → Check, until ready. 📥 Fetch Scraper Results (HTTP Request) Purpose Download the completed snapshot data once Bright Data marks it ready. Parameters Method**: GET Endpoint**: https://api.brightdata.com/datasets/v1/snapshots/{snapshot_id}/data Authentication**: Authorization: Bearer <token> Query**: format=json Output**: array of rows per ticker (price, change %, any fields your dataset yields) > Normalize fields with a Set/Code node if needed. 📊 Aggregate Stock Data (Aggregate Node) Purpose Combine all individual items into one consolidated object so the AI can analyze the entire market snapshot. Parameters Mode**: Aggregate (merge to a single item) Fields to Include**: ticker, name, price, change, sentiment (plus any extra fields captured) Output**: one JSON item containing an array/map of the day’s stocks 🤖 Generate Daily Summary (AI Node – OpenAI) Purpose Ask the model to convert raw data into a styled HTML email: headline, top movers, table, insights, and (optional) upcoming events. Parameters Model**: gpt-4.1 Input**: the aggregated JSON from the previous node Prompt guidelines**: Output HTML only with inline styles (email-safe) Include a table (Ticker, Company, % Change with ↑/↓ & color, Market Cap, Sentiment icon) Highlight top 2 gainers & 2 losers with short reasoning if present Provide 3–5 insights (sector rotation, volatility, outliers) Add upcoming events when available (earnings, launches, macro) Footer: “Generated automatically by your AI-powered stock monitor” Output field**: confirm the exact property that contains the HTML (e.g., output, message, text) 🗂 Save to Airtable (Airtable – Create Record) Purpose Log each item (or the roll-up) to Airtable for history, filtering, and dashboards. Parameters Operation**: Create Record Base ID**: from your Airtable URL Table**: e.g., Daily Stocks Field Mapping**: Ticker ← ` {{ $json.ticker }} ` Company ← ` {{ $json.name }} ` Price ← ` {{ $json.price }} ` Change % ← ` {{ $json.change }} ` Sentiment ← ` {{ $json.sentiment }} ` Date ← ` {{ $now.toISO() }} ` > Use a Single-Select for Sentiment (🟢 / 🟡 / 🔴) to build clean Airtable views. 📧 Send Report via Gmail (Gmail Node) Purpose Deliver the AI-generated HTML digest to your recipients. Parameters Operation**: Send Email Send To**: one or more recipients (e.g., investor@domain.com) Subject**: Daily Stock Market Digest – {{ $now.format("yyyy-MM-dd") }} Message (HTML)**: reference the AI node’s HTML property (e.g., ` {{ $('Generate Daily Summary').first().json.output }} `) Options: set **Append Attribution to false (keep the email clean) > Test in Gmail, Outlook, and mobile to validate inline CSS. 🧪 Error handling & reliability tips Backoff on Bright Data* — If scraping many tickers, increase *Wait** or batch requests. Guard against empty results** — If a snapshot returns 0 rows, branch to a fallback email (“No data today”). AI guardrails** — Enforce “HTML-only” and skip missing sections gracefully. Airtable normalization** — Strip %, cast numbers to float before insert. Observability* — Add a final Slack/Email *On Fail** node with run ID and error message. 🧩 Customization ideas Sector deep-dives**: add sector fields and a second AI paragraph on sector rotation. CSV attachment**: generate & attach a CSV for power users. Multiple lists**: run parallel branches for Tech, Healthcare, or regions. Other asset classes**: Crypto, ETFs, Indices, FX. Audience targeting**: different “To” lists and slightly different prompts per audience. ✅ Why this workflow is powerful Hands-off** — the report simply shows up every day. Analyst-grade** — clean HTML, top movers, tidy table, actionable insights. Auditable** — rows archived in Airtable for history and dashboards. Composable** — swap scrapers, LLMs, storage, or email service. Scalable** — start with 10 tickers, grow to many lists using the same loop. For advanced no-code & AI projects, see 0vni – Agence automatisation.

Who This Workflow Is For This workflow is ideal for YouTube creators, automation builders, and marketers who want to produce short AI-generated videos automatically. It’s especially useful for channels that publish frequent Shorts-style content or want to automate the entire video creation and posting process without manual scripting, editing, or uploading. What This Workflow Does This automation creates short AI videos by combining Gemini-generated scripts with KIE AI’s text-to-video rendering. It generates a title, description, and video prompt, sends the prompt to KIE AI to create the video, and then automatically uploads the finished result to your YouTube channel using Blotato. Each run generates a new video concept selected from a predefined set of templates, providing ongoing variety and fresh content. The workflow handles idea generation, video rendering, polling, media upload, and publishing from start to finish. How It Works Schedule Trigger starts the workflow based on your chosen frequency. Randomizer selects one creative template from several predefined options. Gemini Prompter generates a title, description, and structured video prompt. KIE AI renders the video using the Sora-style text-to-video model. Polling + Wait retrieves the completed video once rendering finishes. Blotato uploads and publishes the final video to your connected YouTube channel. How to Set Up Add your Google Gemini, KIE AI, and Blotato API credentials. Connect your YouTube channel inside Blotato. Adjust the schedule (e.g., every 6–12 hours). Edit or expand prompt templates inside the Prompter node. Activate the workflow to allow fully automated video generation and publishing. Customization Ideas Add logging to Google Sheets or Notion. Add Telegram, email, or Discord notifications when a new video is posted. Change video length, aspect ratio, or watermark settings in the Create video node. Expand your creative template list to increase content variety.