Parse PDF with LlamaParse and save to Airtable
Video Guide I prepared a comprehensive guide detailing how to automate the parsing of invoices using n8n and LlamaParse, seamlessly capturing and storing vital billing information. [](https://youtu.be/E4I0nru-fa8) Youtube Link Who is this for? This workflow is ideal for finance teams, accountants, and business operations managers who need to streamline invoice processing. It is particularly helpful for organizations seeking to reduce manual entry errors and improve efficiency in managing billing information. What problem does this workflow solve? Manually processing invoices can be time-consuming and error-prone. This automation eliminates the need for manual data entry by capturing invoice details directly from uploaded documents and storing structured data efficiently. This enhances productivity and accuracy across financial operations. What this workflow does The workflow leverages n8n and LlamaParse to automatically detect new invoices in a designated Google Drive folder, parse essential billing details, and store the extracted data in a structured format. The key functionalities include: Real-time detection of new invoices via Google Drive triggers. Automated HTTP requests to initiate parsing through Lama Cloud. Structured storage of invoice details and line items in a database for future reference. Google Drive Integration: Monitors a specific folder in Google Drive for new invoice uploads. Parsing with LlamaParse: Automatically sends invoices for parsing and processes results through webhooks. Data Storage in Airtable: Creates records for invoices and their associated line items, allowing for detailed tracking. Setup N8N Workflow Google Drive Trigger: Set up a trigger to detect new files in a specified folder dedicated to invoices. File Upload to LlamaParse: Create an HTTP request that sends the invoice file to LlamaParse for parsing, including relevant header settings and webhook URL. Webhook Processing: Establish a webhook node to handle parsed results from LlamaParse, extracting needed invoice details effectively. Invoice Record Creation: Create initial records for invoices in your database using the parsed details received from the webhook. Line Item Processing: Transform string data into structured line item arrays and create individual records for each item linked to the main invoice.
By Mark ShcherbakovHigh-level service page SEO blueprint report generator
Introduction The "High-Level Service Page SEO Blueprint Report" workflow is a powerful, AI-driven solution designed to generate comprehensive SEO content strategies for service-based businesses. By analyzing competitor websites and user intent, this workflow creates a detailed blueprint that outlines the optimal structure, content, and conversion elements for a service page. The workflow leverages the JINA Reader API to extract content from competitor websites and uses Google Gemini AI to perform deep analysis across multiple dimensions: competitor content structure, user intent, strategic opportunities, and conversion optimization. The final output is a professionally formatted Markdown document that provides actionable guidance for creating a high-performing service page that satisfies both user needs and search engine requirements. This workflow eliminates the time-consuming process of manually analyzing competitors and developing content strategies, providing a data-driven foundation for service page creation that would typically require hours of expert analysis. Who is this for? This workflow is designed for digital marketers, SEO specialists, content strategists, and web developers who need to create or optimize service pages for businesses. It's particularly valuable for marketing agencies and freelancers who regularly develop content strategies for clients across various industries. Users should have a basic understanding of SEO concepts, content marketing, and website structure. While technical SEO knowledge is beneficial, the workflow is designed to provide comprehensive guidance even for those with intermediate-level expertise. The ideal user is someone who wants to streamline their content planning process and ensure their service pages are built on data-driven insights rather than guesswork. What problem is this workflow solving? Creating effective service pages that rank well in search engines while converting visitors is a complex challenge that typically requires extensive competitive research, content planning, and conversion optimization expertise. This workflow addresses several key pain points: Time-consuming competitor analysis: Manually analyzing multiple competitor websites to identify content patterns, heading structures, and meta tag strategies can take hours. Difficulty identifying content gaps: Determining what topics competitors are missing that could provide a competitive advantage requires deep analysis and industry knowledge. Balancing SEO and conversion elements: Creating content that satisfies both search engines and user needs while driving conversions is a delicate balance that many struggle to achieve. Lack of structured approach: Many content creators work without a comprehensive blueprint, leading to inconsistent results and missed opportunities. Difficulty translating analysis into actionable recommendations: Even when analysis is performed, turning those insights into a concrete content plan can be challenging. This workflow automates these processes, providing a structured, data-driven approach to service page creation that saves hours of research and planning time. What this workflow does Overview The workflow takes a list of competitor URLs and a target keyword as input, then performs a multi-stage analysis to generate a comprehensive service page blueprint. It extracts and analyzes competitor content, evaluates user intent, identifies strategic opportunities, and creates detailed recommendations for page structure, content, and conversion elements. The final output is a professionally formatted Markdown document that serves as a complete roadmap for creating an effective service page. Process Data Collection: The workflow begins with a form that collects essential information: competitor URLs, target keyword, services offered, brand name, and whether the page is a homepage. Competitor Content Extraction: The workflow processes each competitor URL, using the JINA Reader API to extract the HTML content from each site. Content Structure Analysis: For each competitor site, the workflow extracts and analyzes heading structures, meta tags, schema markup, and recurring phrases (n-grams). Competitor Analysis Report: The AI synthesizes the competitive data to identify patterns in meta titles/descriptions, common outline sections, key heading concepts, and structural elements. User Intent Analysis: The workflow analyzes the target keyword to determine primary and secondary user intents, user personas, and their position in the buyer's journey. Gap Analysis: The AI identifies content overlaps ("table stakes"), content gaps (opportunities), SEO keyword priorities, and potential UX/conversion advantages. Page Outline Generation: Based on the previous analyses, the workflow creates an optimal page structure with H1, H2s, H3s, and potentially H4s, with justifications for each section. UX & Conversion Recommendations: The workflow adds detailed recommendations for calls-to-action, trust signals, copywriting tone, visual elements, and risk reversal strategies. Final Blueprint Creation: All analyses and recommendations are compiled into a comprehensive, well-structured Markdown document that serves as a complete service page blueprint. Setup Download or import the "High-Level Service Page SEO Blueprint Report" workflow JSON file into your n8n instance. Create a JINA Reader API key by visiting https://jina.ai/api-dashboard/key-manager. You can claim a free API key that allows up to 1 million tokens. Set up Google Gemini (PaLM) credentials by following the guide at https://docs.n8n.io/integrations/builtin/credentials/googleai/using-geminipalm-api-key. Update the "Edit Fields" node with: Your JINA Reader API Key Adjust the "Waiting Time" to 20 seconds if using the free Google Gemini API tier (which limits to 5 requests per minute) Optionally change the Gemini model if needed Activate the workflow and start the form trigger. Complete the form with: Competitors (up to 5 direct competitor URLs) Target Keyword (the query related to your service) Services Offered (details of your complete service offerings) Brand Name (your company name) Whether the page is a homepage After processing, download the generated .txt file, which contains the blueprint in Markdown format. How to customize this workflow to your needs Adjust AI parameters: Modify the temperature settings in the Google Gemini Chat Model nodes to control creativity vs. precision in the AI outputs. Customize extraction logic: Edit the "Extract HTML Elements" code node to focus on specific HTML elements that are most relevant to your industry or content type. Modify analysis prompts: Customize the prompts in the various analysis nodes to focus on specific aspects of SEO or content strategy that are most important for your use case. Add industry-specific guidance: Enhance the prompts with industry-specific instructions or examples to make the output more relevant to particular sectors. Integrate with content management systems: Extend the workflow to automatically send the blueprint to content management systems, project management tools, or document storage platforms. Add competitor scoring: Implement a scoring system to evaluate and rank competitors based on specific criteria relevant to your strategy. Expand the analysis: Add additional analysis nodes to evaluate other aspects of competitor websites, such as page speed, mobile-friendliness, or backlink profiles.
By Custom Workflows AIAi data extraction with dynamic prompts and Baserow
This n8n template introduces the Dynamic Prompts AI workflow pattern which are incredible for certain types of data extraction tasks where attributes are unknown or need to remain flexible. The general idea behind this pattern is that the prompts for requested attributes to be extracted live outside the template and so can be changed at any time - without needing to edit the template. This seriously cuts down on maintainance requirements and is reusable for any number of tables at little cost. Check out the n8n Studio Episode here: https://www.youtube.com/watch?v=_fNAD1u8BZw Community post here: https://community.n8n.io/t/dynamic-prompts-with-n8n-baserow-and-airtable/72052 Looking for the Airtable Version? https://n8n.io/workflows/2771-ai-data-extraction-with-dynamic-prompts-and-airtable/ How it works Given we have an "input" field for context and a number of fields for the data we want to extract, this template will run in the background to react to any changes to either the "input" or fields and automatically update the rows accordingly. The key is that Baserow fields have a special property called the "field description". In this pattern, we use this property to allow the user to store a simple prompt describing the data that should exist in the column. Our n8n template reads these column descriptions aka "prompts" to use as instructions to perform tasks on the "input". In this template, the "input" is a PDF of a resume/CV and the columns are attributes a HR person would want to extract from it - such as full name, address, last position, years of experience etc. How to use First publish this template and ensure it's accessible via webhook URL. You then have to complete the "create Baserow webhooks" steps to configure your baserow to send change events to the n8n template. Baserow webhooks are created in the Baserow web interface. Check the template for more instructions. Requirements Baserow for Tables/Database OpenAI for LLM and extraction. Feel free to choose another LLM if preferred. Customising this workflow If you're not using files, you can replace the "input" field with anything you like. For example, the "input" could be single line text.
By JimleukGenerate videos from images with Telegram, GPT-4.1 & Seedance/Veo3 integration
🎥 Telegram Image-to-Video Generator Agent (Veo3 / Seedance Integration) ⚠️ This template uses [community nodes] and some credential-based HTTP API calls (e.g. Seedance/Wavespeed). Ensure proper credentials are configured before running. 🛠️ In the accompanying video tutorial, this logic is built as two separate workflows: Telegram → Image Upload + Prompt Agent Prompt Output → Video Generation via API Watch Full Video Tutorial: https://youtu.be/iaZHef5bZAc&list=PL05w1TE8X3baEGOktlXtRxsztOjeOb8Vg&index=1 ✨ What This Workflow Does This powerful automation allows you to generate short-form videos from a Telegram image input and user prompt — perfect for repurposing content into engaging reels. From the moment a user sends a photo with a caption to your Telegram bot, this n8n workflow: 📸 Captures the image and saves it to Google Drive 🧠 Uses an AI Agent (via LangChain + OpenAI) to craft a Seedance/Veo3-compatible video prompt 📑 Logs the interaction to a Google Sheet 🎞️ Sends the prompt + image to the Seedance (Wavespeed) API to generate a video 🚀 Sends the resulting video back to the user on Telegram — fully automated 🔗 How It Works (Step-by-Step) Telegram Bot Trigger Listens for incoming images and captions Conditional Logic Filters out invalid inputs AI Agent (LangChain) Uses OpenAI GPT to: Generate a video prompt Attach the most recent image URL (from Google Sheet) Google Drive Upload Saves the Telegram image and logs the share link Google Sheets Logging Appends a new row with date + file link Wavespeed (Seedance/Veo3) API Calls the /bytedance/seedance-v1-pro-i2v-480p endpoint with image and prompt Video Polling & Output Waits for generation completion Sends back final video file to Telegram user 🛠️ Tools & APIs Used Telegram Bot (Trigger + Video Reply) LangChain Agent Node OpenAI GPT-4.1-mini for Prompt Generation Simple Memory & Tools (Google Sheets) Google Drive (Image upload) Google Sheets (Log prompts + image URLs) Wavespeed / Seedance API (Image-to-video generation) 🧩 Requirements Before running this workflow: ✅ Set up a Telegram Bot and configure credentials ✅ Connect your Google Drive and Google Sheets credentials ✅ Sign up for Wavespeed / Seedance and generate an API key ✅ Replace placeholder values in: HTTP Request nodes Google Drive folder ID Google Sheet document ID 📦 Suggested Use Cases Generate short-form videos from image ideas Reformat static images into dynamic reels Repurpose visual content for TikTok/Instagram
By Automate With MarcTrack n8n community topics with keywords and save to Google Sheets
This template is designed for community managers, developers, and enthusiasts who want to monitor and capture discussions on the n8n community forum by specific keywords. By tracking new topics that match your provided keyword, the workflow automatically logs them into a Google Sheet, helping you keep a pulse on trending discussions and manage community insights effortlessly. How it Works Keyword Monitoring: The workflow continuously monitors the n8n community forum for new topics containing your specified keyword. Data Extraction: When a matching topic is found, relevant details such as id, title, URL, and posting time are extracted. Google Sheets Integration: The extracted information is automatically appended as a new row in your Google Sheet, providing an organized log of community discussions. Alert Option: Optionally, you can add notifications (e.g., Slack messages or emails) to alert you when a new topic is captured, ensuring you never miss an important update. Set Up Steps Import the Workflow: Download and import the workflow into your n8n instance. Configure Keyword Monitoring: In the HTTP Request node, set your desired keyword to filter the n8n community topics. Set Up Google Sheets: Connect your Google Sheets account and specify the target sheet where the new topics should be logged. Customize Data Fields: Adjust the data extraction node parameters if you wish to capture additional details from each topic. Deploy and Test: Deploy the workflow and perform a test run to confirm that new topics matching the keyword are correctly added to your Google Sheet. Set Up Messaging Channels (Optional): Connect to Slack, Email or other providers to get instant messages when new topics are added into your Google Sheet. This template streamlines the process of tracking community discussions, ensuring you have timely and organized insights to enhance your community engagement and strategic decision-making. Enjoy seamless monitoring and easy data management with this ready-to-use n8n workflow template!
By HostingerConvert Gumroad sales to Beehiiv subscribers with Sheets & Telegram alerts
Turn Gumroad buyers into newsletter subscribers on Beehiiv, log to Google Sheets and get notified on Telegram Requirements Gumroad account Gumroad application + API key Product listed on Gumroad Beehiiv account Publication created on Beehiiv Beehiiv API key Google Sheets access (with API credentials) Telegram Bot created + Bot Token Telegram Channel created and Bot added as admin --- Set Up Trigger on a New Gumroad Sale Create a new application in Gumroad (Settings > Advanced). Copy your API key (access token). Paste it into the Gumroad Sale Trigger node. Connect to Beehiiv Newsletter Create a publication inside Beehiiv. Generate and copy your Beehiiv API key. Use it to list publications and post a new subscription. Load Into CRM (Google Sheets) Set up your Google Sheets API credentials Append the subscriber's data into your CRM Send a Telegram Message Create a Telegram Bot and get your Bot Token. Add the Bot to your Telegram Channel and make it an admin. In the Telegram Send Message node: Use your Bot Token. Set your Channel Username or Chat ID. Customize the message content (e.g., "New Sale from {{customerEmail}} 🎉"). --- Further Optimizations Add more data to Beehiiv: Include optional fields like first name, last name, custom tags, etc., when posting the subscription. Customize your Telegram message: Personalize the message with product name, sale amount, or customer name. Enhance CRM data: Add additional sale details into Google Sheets, like product ID, purchase timestamp, or affiliate code if available. Error Handling: Add an error workflow to retry failed Beehiiv or Google Sheets updates automatically or log the error messages in your team chat in Slack or Microsoft Teams. --- ✅ That's it! Every time a new sale happens, the customer is added to your Beehiiv newsletter, saved in your CRM, and you receive an instant notification on Telegram! Get in touch with us Feel free to contact us at 1 Node. Get instant access to a library of free resources we created.
By Aitor | 1NodeAutomated finance tracker with Gmail, Google Sheets & GPT-4o monthly reports
🚀 What This Workflow Does This automation helps small business owners track income and expenses effortlessly, turning scattered emails and WhatsApp messages into structured financial data — all without manual entry. Every month, it: Pulls receipts and invoices from your Gmail and WhatsApp Uses AI to extract key details (date, vendor, amount, category) Logs everything into Google Sheets Generates a monthly cash flow forecast with visual insights Sends you a clear, concise email report with AI-powered recommendations No more spreadsheet stress. No more missing receipts. Just financial peace of mind — delivered every month. 💡 Why It Matters As a small business owner, your time is too valuable to spend manually logging transactions. This workflow automates the entire finance tracking loop — from receipt capture to insight delivery — so you can: Know exactly where your money is going Spot trends and plan ahead Make smarter decisions with real-time data Start each month with confidence It's soft tech at its best: simple, elegant, and deeply useful. 🛠️ How It Works Triggers monthly on the 1st at 9 AM (customizable) Scans your inbox for new receipts/invoices via Gmail Uses GPT-4o to parse text and extract financial data Avoids duplicates by checking existing entries Saves to Google Sheets with clean formatting Generates a monthly summary with: Total income & expenses Net profit/loss Expense breakdown (pie chart via QuickChart) AI-written insights and action steps Delivers a beautiful email report with visuals and next steps 🧩 Tools Used Gmail (IMAP) WhatsApp (via Twilio) Google Sheets OpenAI (GPT-4o) Cron (scheduled trigger) Email (SMTP) ✅ Built With Soft Tech Principles Zero-code design Human-first UX Scalable for any small business Privacy-respecting (no sensitive data stored) Easy to customize and extend 📌 Perfect For Solopreneurs Coaches & consultants E-commerce sellers Service-based businesses Anyone tired of manual bookkeeping "I used to dread my monthly financial review. Now I get a clear, friendly report that tells me what’s working — and what to fix. This one workflow saved me 4 hours a month." — Sarah L., Online Coach
By Shelly-Ann DavyAutomatic invoice generation and email with Airtable and CustomJS PDF generator
> ⚠️ Notice: > This workflow uses the CustomJS Invoice Generator node from customjs.space, which requires a self-hosted n8n instance and a CustomJS API key. --- Google Spreadsheet → Invoice Generation → Email Workflow This workflow demonstrates how to: Pull invoices ready to be sent from Airtable. Retrieve client details and invoice items from Airtable. Generate a professional invoice PDF using CustomJS Invoice Generator. Send the completed invoice via email to the client. Update the invoice status in Airtable automatically. Public Airtable Example --- Workflow Overview Trigger Workflow Node: When clicking ‘Execute workflow’ (Manual Trigger) Starts the workflow when executed manually in n8n. Get Ready Invoices Node: Get Ready Invoices (Airtable) Retrieves all invoices from Airtable where Status = 'Ready'. Loop Over Items Node: Loop Over Items (Split In Batches) Processes each invoice individually. Get Clients Node: Get Clients (Airtable) Fetches client details for the current invoice: Name Address Tax ID Get Invoice Items Node: Get Invoice Items (Airtable) Retrieves all items associated with the invoice and passes them for aggregation. Map Fields Node: Map Fields (Set) Maps the invoice items into a structured format for the invoice generator: Description Quantity / Hours Unit Price Invoice ID Aggregate Node: Aggregate Aggregates all invoice items into a single JSON array for the invoice. Set Company Details Node: Set Company Details (Set) Defines issuer and payment information: Company Name Address Tax ID Email & Phone Bank Details Generate Invoice Node: Generate Invoice (CustomJS Invoice Generator) Generates a PDF invoice using all collected data: Issuer / Company information Recipient / Client information Invoice items Billing information (Invoice number, date, currency, tax, notes) Send Email With Attachment Node: Send Email With Attachment (Email Send) Sends the generated invoice PDF to the client: From: {{ $json.InvoiceEmail }} To: info@yourcomp.org Subject: Your Invoice for Last Month Body Text: Hello, Please find attached your invoice for the last month. Thank you very much for your cooperation. Best regards, Henrik Uses SMTP credentials for sending emails. Update Record Node: Update record (Airtable) Marks the invoice as Sent in Airtable. --- Requirements Self-hosted n8n instance CustomJS API key SMTP credentials Airtable API key and base access ---
By CustomJSEnd-to-end B2B real estate lead enrichment & outreach with Apify, Relevance, OpenAI & Sheets
This advanced n8n workflow automates the full lead enrichment, qualification, and personalized outreach process tailored specifically for the B2B real estate sector. Integrating top platforms like Apify, Relevance, OpenAI, and Google Sheets, it empowers sales and marketing teams to streamline prospect data enrichment, lead scoring, and engagement without manual data handling. Features: Form-Driven Lead Capture: Automated intake via Fillout form submissions capturing comprehensive lead and project details. Email Verification:Ensures email validity with Apify, allowing outreach only to verified contacts. Company & Profile Enrichment:Deep crawls of company websites paired with detailed LinkedIn profile scraping using Relevance. Project Documentation Processing:Downloads and extracts text from submitted PDF project briefs or investor decks, enhancing semantic search capabilities. Unified Lead Profiles: Merges all data sources—email validation, website content, LinkedIn insights, and project documents—to build enriched, actionable lead records. AI-Driven Summaries & Scoring: Uses OpenAI to generate readable profile/company/project summaries and assigns lead quality scores to prioritize efforts. Instant Hot Lead Alerts: Routes urgent prospects to Slack channels for rapid internal response. Personalized Outreach Automation: Creates unique icebreaker messages based on AI insights and automates email sending via Gmail. Robust Data & Report Management: Maintains lead data and automated PDF summaries in fresh copies of Google Sheets for organized tracking and collaboration. Manual Controls & Semantic Indexing: Supports manual workflow triggers and inserts project document embeddings into Pinecone vector stores for enhanced document intelligence. Who’s This For Commercial Real Estate Brokers & Agents: Automate lead qualification, enrich prospect data, and accelerate personalized outreach to close deals faster. Real Estate Investors & Developer Teams: Efficiently gather and analyze investment project data, verify contacts, and monitor promising leads with AI-enhanced scoring and notifications. B2B Real Estate Marketing & Sales Teams: Streamline lead intake from web forms and optimize campaign engagement with AI-driven profiling and tailored messaging. Property Management Firms: Centralize client and project data enrichment, validation, outreach, and reporting in an automated, scalable workflow. Business Development Managers in Real Estate Sector: Gain actionable insights from multiple data sources (LinkedIn, websites, project decks) to prioritize outreach and close high-value clients. Anyone looking for scalable, AI-powered B2B lead enrichment and outreach automation in the real estate industry. Setup Instructions Ensure you have an n8n instance and API/OAuth credentials for Apify, Relevance, OpenAI, Google Sheets, Gmail, and Slack. Import the workflow JSON into n8n, then configure all credentials in the Credentials manager. Link the Fillout trigger node to your form webhook. Prepare a Google Sheets master template; the workflow copies it fresh each run for clean data. Add your OpenAI and Slack API keys, configure Gmail OAuth for email sending, then test end-to-end before activating.
By Mirza AjmalE-commerce bestseller video generator (Algolia + Google VEO 3)
E-commerce Weekly Bestseller Video Generator (Algolia + Google VEO 3) This workflow automatically identifies your weekly bestselling product from your Algolia-powered e-commerce store and generates a cinematic product video using Google VEO 3.0 AI, helping marketing teams create engaging video content without manual editing or expensive production tools. Who's it for E-commerce stores using Algolia for search. Ideal for marketing teams who want to automate video content creation for top-performing products and maximize conversion potential with engaging visual content. What it does (and doesn't do) ✅ It DOES: Identify your weekly bestseller automatically via Algolia custom ranking Validate product images before video generation Generate 6-second cinematic product videos using Google VEO 3.0 Store videos in Supabase for easy frontend integration Update Algolia records with video URLs automatically Send email alerts if products lack images ❌ It DOESN'T: Generate videos for all products at once Edit or customize videos after generation Create multi-product compilation videos Replace manual video editing for complex productions Work without Google Cloud Storage (VEO 3.0 requirement) Think of it as: An automated video production assistant that doubles down on your bestsellers with engaging content, not a full video editing suite. How it works Weekly trigger - Runs every Monday at 9:00 PM (or manually for testing) Bestseller fetch - Queries Algolia index with empty search to get top-ranked product Video check - Skips products that already have videos Image validation - Ensures product has a valid, accessible image URL Video generation - Converts image to base64 and sends to Google VEO 3.0 with cinematic prompt Polling loop - Waits and checks generation status until video is ready Storage transfer - Downloads MP4 from Google Cloud Storage and uploads to Supabase Index update - Marks product as having video and adds public URL to Algolia Set up steps Setup time: ~20 minutes Connect your Algolia credentials (Search API key + Application ID) Replace placeholders: ALGOLIAAPPID with your Algolia Application ID YOURINDEXNAME with your product index name PROJECT-ID-GOOGLE-CLOUD with your Google Cloud Project ID GOOGLESTORAGEBUCKET_NAME with your GCS bucket name YOURSUPABASEPROJECT with your Supabase project ID YOURBUCKETNAME with your Supabase bucket name admin@example.com with your email address Configure Algolia custom ranking (inStock + popularity recommended) Ensure your products have hasVideo, images[], name, description attributes Set up Google Vertex AI with VEO 3.0 API access Create Google Cloud Storage bucket for VEO 3.0 outputs Create Supabase storage bucket for final video hosting Requirements Algolia account with product index (free tier works) Algolia index with products containing image URLs Google Vertex AI account with VEO 3.0 API access Google Cloud Storage bucket (mandatory for VEO 3.0) Supabase account with storage bucket (free tier works) Gmail account for error notifications Products with attributes: hasVideo, images[], name, description, objectID Why both Google Cloud Storage AND Supabase? VEO 3.0 can only output videos as base64 strings or MP4 files in Google Cloud Storage. Base64 strings are too large for n8n to process (even with code nodes), making Google Cloud Storage mandatory. The workflow then downloads the MP4 and uploads it to Supabase because: Supabase is where your other product assets already live Supabase offers generous free tier and simpler pricing Easier to serve videos to your frontend from a single storage provider Think of Google Cloud Storage as a temporary staging area required by VEO 3.0's limitations, and Supabase as your actual production storage. Cost breakdown For a typical 6-second product video: Google VEO 3.0 generation: ~$0.15-0.30 per video Google Cloud Storage: ~$0.002 (temporary staging) Supabase storage: Free tier covers hundreds of videos 💰 Bottom line: About $0.15-0.30 per video. Running weekly for a year = $8-16 in video generation costs. 💡 Pro tips Customize the video prompt: The default prompt creates a cinematic studio dolly shot. Edit the jsonBody in "Generate video with Google VEO 3" to match your brand style (fast-paced, minimalist, lifestyle, etc.). Adjust bestseller logic: Modify the Algolia query to add filters like category:electronics or brand:Nike to focus on specific product segments. Use manual execution during setup: Don't wait until Monday! Run the workflow manually to catch configuration issues like broken image URLs or missing credentials immediately. Monitor your email alerts: If you frequently get "no image" or "broken image" alerts, audit your product data quality in Algolia. Missing images = lost video opportunities. Start with test products: Before going live, manually trigger the workflow on a product you know has good images. Verify the video appears correctly in your Supabase bucket and Algolia record. Check your GCS bucket occasionally: Videos accumulate in Google Cloud Storage after each run. Set up a lifecycle policy to auto-delete files older than 7 days to avoid unnecessary storage costs. Adjust the schedule: If Monday 9PM doesn't work for your team's workflow, change the trigger to run on a different day or time that aligns with your content calendar. How it identifies the bestseller This workflow leverages Algolia's custom ranking feature. When you send an empty search query to Algolia, the first result returned follows your custom ranking criteria. This is an Algolia best practice that ensures your most relevant products appear first even without search terms. In the example configuration, custom ranking uses: inStock attribute - Prioritizes available products popularity attribute - A computed metric based on sales volume, views, and other signals You'll need to configure your own custom ranking in your Algolia index settings to match your business criteria. The workflow assumes your index is already configured to return your bestselling product first when queried with no search terms.
By Emir BelkahiaTeam morale monitoring from Teams/Slack messages with Gemini AI
AI Team Morale Monitor Who’s it for For team leads, HR, and managers who want to monitor the emotional tone and morale of their teams based on message sentiment. How it works Trigger: Runs every Monday at 9 AM. Config: Defines your Teams and Slack channels. Fetch: Gathers messages for the week. AI Analysis: Evaluates tone and stress levels. Aggregate: Computes team sentiment averages. Report: Creates a readable morale summary. Slack Post: Sends report to your workspace. How to set up Connect Microsoft Teams and Slack credentials. Enter your Team and Channel IDs in the Workflow Configuration node. Adjust the schedule if desired. Requirements Microsoft Teams and Slack access. Gemini (or OpenAI) API credentials set in AI nodes. How to customize Modify the AI prompts for different insight depth. Replace Gemini with other LLMs if preferred. Change posting platform or format. Note: This workflow uses only linguistic data — no personal identifiers or private metadata.
By higashiyama Create verified user profiles with email validation, PDF generation & Gmail delivery
Verified User Profile Creation - Automated Email Validation & PDF Generation --- Overview This comprehensive automation workflow streamlines the user onboarding process by validating email addresses, generating professional profile PDFs, and delivering them seamlessly to verified users. 🎯 What This Workflow Does: Receives User Data - Webhook trigger accepts user signup information (name, email, city, profession, bio) Validates Email Addresses - Uses VerifiEmail API to ensure only legitimate email addresses proceed Conditional Branching - Smart logic splits workflow based on email verification results Generates HTML Profile - Creates beautifully styled HTML templates with user information Converts to PDF - Transforms HTML into professional, downloadable PDF documents Email Delivery - Sends personalized welcome emails with PDF attachments to verified users Data Logging - Records all verified users in Google Sheets for analytics and tracking Rejection Handling - Notifies users with invalid emails and provides guidance ✨ Key Features: ✅ Email Verification - Prevents fake registrations and maintains data quality 📄 Professional PDF Generation - Beautiful, branded profile documents 📧 Automated Email Delivery - Personalized welcome messages with attachments 📊 Google Sheets Logging - Complete audit trail of all verified users 🔀 Smart Branching - Separate paths for valid and invalid emails 🎨 Modern Design - Clean, responsive HTML/CSS templates 🔒 Secure Webhook - POST endpoint for seamless form integration 🎯 Perfect Use Cases: User registration systems Community membership verification Professional certification programs Event registration with verified attendees Customer onboarding processes Newsletter signup verification Educational platform enrollments Membership card generation 📦 What's Included: Complete workflow with 12 informative sticky notes Pre-configured webhook endpoint Email verification integration PDF generation setup Gmail sending configuration Google Sheets logging Error handling guidelines Rejection email template 🛠️ Required Integrations: VerifiEmail - For email validation (https://verifi.email) HTMLcsstoPDF - For PDF generation (https://htmlcsstopdf.com) Gmail OAuth2 - For email delivery Google Sheets OAuth2 - For data logging ⚡ Quick Setup Time: 15-20 minutes 🎓 Skill Level: Beginner to Intermediate --- Benefits: ✅ Reduces manual verification work by 100% ✅ Prevents spam and fake registrations ✅ Delivers professional branded documents automatically ✅ Maintains complete audit trail ✅ Scales effortlessly with user growth ✅ Provides excellent user experience ✅ Easy integration with any form or application --- Technical Details: Trigger Type: Webhook (POST) Total Nodes: 11 (including 12 documentation sticky notes) Execution Time: ~3-5 seconds per user API Calls: 3 external (VerifiEmail, HTMLcsstoPDF, Google Sheets) Email Format: HTML with binary PDF attachment Data Storage: Google Sheets (optional) --- License: MIT (Free to use and modify) --- 🎁 BONUS FEATURES: Comprehensive sticky notes explaining each step Beautiful, mobile-responsive email template Professional PDF styling with modern design Easily customizable for your branding Ready-to-use webhook endpoint Error handling guidelines included --- Perfect for: Developers, No-code enthusiasts, Business owners, SaaS platforms, Community managers, Event organizers Start automating your user verification process today! 🚀
By Jitesh Dugar