π Learn n8n expressions with an interactive step-by-step tutorial for beginners
How it works This template is an interactive, step-by-step tutorial designed to teach you the most important skill in n8n: using expressions to access and manipulate data. If you know what JSON is but aren't sure how to pull a specific piece of information from one node and use it in another, this workflow is for you. It starts with a single "Source Data" node that acts as our filing cabinet, and then walks you through a series of lessons, each demonstrating a new technique for retrieving and transforming that data. You will learn how to: Access a simple value from a previous node. Use n8n's built-in selectors like .last() and .first(). Get a specific item from a list (Array). Drill down into nested data (Objects). Combine these techniques to access data in an array of objects. Go beyond simple retrieval by using JavaScript functions to do math or change text. Inspect data with utility functions like Object.keys() and JSON.stringify(). Summarize data from multiple items using .all() and arrow functions. Set up steps Setup time: 0 minutes! This workflow is a self-contained tutorial and requires no setup or external credentials. Click "Execute Workflow" to run the entire tutorial. Follow the flow from the "Source Data" node to the "Final Exam" node. For each lesson, click on the node to see how its expressions are configured in the parameters panel. Read the detailed sticky note next to each lessonβit breaks down exactly how the expression works and why. By the end, you'll have the foundational knowledge to connect data and build powerful, dynamic workflows in n8n.
By Lucas PeyrinExtract and organize receipt data for expense tracking with VLM Run and Google
Transform your expense tracking with automated AI receipt processing that extracts data and organizes it instantly. What this workflow does Monitors Google Drive for new receipt uploads (images/PDFs) Downloads and processes files automatically Extracts key data using verified VLM Run node (merchant, amount, currency, date) Saves structured data to Google Sheets for easy tracking Setup Prerequisites: Google Drive/Sheets accounts, VLM Run API credentials, n8n instance. Install the verified VLM Run node by searching for VLM Run in the node list, then click Install. Once installed, you can start using it in your workflows. Quick Setup: Configure Google Drive OAuth2 and create receipt upload folder Add VLM Run API credentials Create Google Sheets with columns: Customer, Merchant, Amount, Currency, Date Update folder/sheet IDs in workflow nodes Test and activate How to customize this workflow to your needs Extend functionality by: Adding expense categories and approval workflows Connecting to accounting software (QuickBooks, Xero) Including Slack notifications for processed receipts Adding data validation and duplicate detection This workflow transforms manual receipt processing into an automated system that saves hours while improving accuracy.
By ShahrearEnd-to-end YouTube video automation with HeyGen, GPT-4 & Avatar videos
π₯ End-to-End YouTube Video Automation Workflow with n8n, HeyGen & AI Automate the entire YouTube content creation pipeline β from video idea to AI-generated avatar video, upload, metadata generation, and publishing β with zero manual intervention! --- Who is this for? This template is perfect for: Affiliate marketers (e.g., PartnerStack, SaaS products) YouTube creators scaling video production Agencies managing client content Educators and coaches delivering automated video lessons Entrepreneurs running faceless YouTube channels --- π§ What problem does it solve? Publishing consistent, high-quality video content is essential for audience growth and monetization. But manually creating each video β researching, writing, recording, uploading, and optimizing β is slow, repetitive, and unsustainable at scale. This workflow solves that by automating: β Content sourcing from Google Sheets β Script generation with AI β Avatar video creation via HeyGen β YouTube upload and metadata β Final publishing and status update All done without touching a single button. Schedule it weekly and watch videos go live while you sleep. --- βοΈ What this workflow does π₯ Reads video ideas from a Google Sheet (e.g., PartnerStack affiliate product) π Fetches product details from the web using HTTP Request π§ Generates a promotional video transcript using an AI agent π Converts the script to an avatar video using HeyGen API β³ Waits for the video to render and fetches download URL β¬οΈ Uploads the video to YouTube via API π§ Generates title, description, tags, and hashtags using AI π Updates video metadata and changes visibility to Public π Logs publication details back to Google Sheets π€ Optional human-in-the-loop step before publishing --- π Setup π Connect the following integrations: Google Sheets (or Airtable) HeyGen API YouTube Data API (OAuth 2.0) OpenAI / Gemini / Ollama π§Ύ Add your video ideas to Google Sheets: Include product name, link, and "To Do" status π Import the n8n template and configure API credentials π§ Customize your AI prompt for tone, format, and industry π Schedule it to run weekly (1 video per week) --- βοΈ How to customize this workflow Swap Google Sheets with Airtable, Notion, or API feeds Modify AI prompts for different use cases: reviews, explainers, tutorials Use D-ID, Synthesia, or your preferred avatar platform Add analytics, thumbnails, or comment automation Localize content for multi-language channels Integrate with Slack, Discord, or Telegram for notifications --- π Sticky Notes Included π Get Partner Idea: Pulls one item from the Google Sheet π Fetch Content: Extracts product details via HTTP request π§ AI Script: Generates video transcript using GPT or Gemini π₯ Video Generation: Sends script to HeyGen, waits for rendering β¬οΈ Upload to YouTube: Uploads video file π§ Metadata Generator: Creates optimized title, tags, description π Metadata Update: Updates YouTube metadata and sets video to Public π Sheet Update: Marks video as published in the Google Sheet π§ Human Approval (Optional): Pause & resume on manual review --- π Useful Links π§ Mastering n8n on Udemy π n8n Learning Guidebook π Sign Up for n8n Cloud (Use Code: AMJID10) π§ SyncBricks Automation Blog πΊ YouTube Channel β SyncBricks --- π Why this workflow? This advanced automation setup is ideal for users exploring: YouTube automation via n8n and API AI-powered content pipelines with OpenAI/Gemini Avatar video generation (HeyGen / D-ID / Synthesia) Workflow automation for affiliate marketing Full-stack video publishing using no-code tools Enterprise-grade publishing for brands and creators Built with modularity, customization, and full control in mind β whether youβre using n8n Cloud or a self-hosted instance.
By Amjid AliAutomated marketing performance email reports with Google Sheets & Outlook
This n8n workflow template automatically pulls marketing data from Google Sheets, calculates key performance metrics, and sends beautifully formatted HTML email reports. Perfect for marketing teams, agencies, or businesses that need regular performance reporting without manual data processing. What This Workflow Does This automated workflow: Retrieves marketing campaign data from Google Sheets Calculates 5 key performance metrics (customers, campaigns, clicks, conversions, spend) Merges all statistics into a single data object Sends a professional HTML email report with modern styling Can be run manually or scheduled for regular reporting The workflow processes data including Customer ID, Campaign names, Clicks, Conversions, and Spend amounts to generate comprehensive performance summaries. Tools & Services Used N8N - Workflow automation platform Google Sheets - Marketing data source and storage Microsoft Outlook - Email delivery system HTML/CSS - Professional report formatting Step-by-Step Implementation Step 1: Set Up Your Google Sheets Data Source Copy the Sample Data Template: Access the template: Marketing Performance Data Template Click "File" β "Make a copy" to create your own version Rename it (e.g., "My Marketing Performance Data") Set Up Your Data Structure: Your Google Sheet should have a "Data" tab with these columns: Customer ID - Unique identifier for each customer Campaign - Name of the marketing campaign Clicks - Number of clicks generated Conversions - Number of conversions achieved Spend ($) - Amount spent on the campaign Configure Google Sheets API Access: Go to Google Cloud Console Create a project or select existing one Enable "Google Sheets API" Create OAuth2 credentials or use service account Share your sheet with the service account email (if using service account) Step 2: Import and Configure the N8N Workflow Import the Workflow: Copy the workflow JSON from the template In your N8N instance, go to Workflows β Import from JSON Paste the JSON and import the workflow Step 3: Configure Each Node Node 1: "When clicking 'Execute workflow'" (Manual Trigger) Purpose: Starts the workflow manually for testing Configuration: No setup required Note: You can replace this with a Schedule Trigger for automated reports Node 2: "Get Google Sheets Data" Purpose: Retrieves all marketing data from your Google Sheet Setup Required: Click on the node Set up Google Sheets OAuth2 credentials: Click "Create New Credential" Follow OAuth2 setup process Authorize access to your Google account Select your spreadsheet from the dropdown Choose the "Data" sheet Test the connection to ensure data loads Node 3-7: Data Analysis Nodes "Count Unique Customers" Purpose: Counts how many unique customers were reached Configuration: Pre-configured to count unique "Customer ID" values No setup required "Count Unique Campaigns" Purpose: Counts total number of campaigns run Configuration: Pre-configured to count unique "Campaign" values No setup required "Sum Total Clicks" Purpose: Adds up all clicks across campaigns Configuration: Pre-configured to sum "Clicks" column No setup required "Sum Total Conversions" Purpose: Totals all conversions achieved Configuration: Pre-configured to sum "Conversions" column No setup required "Sum Total Spend" Purpose: Calculates total marketing spend Configuration: Pre-configured to sum "Spend ($)" column No setup required Node 8: "Merge" Purpose: Combines all calculated metrics into one data object Configuration: Pre-configured to merge by position No setup required Node 9: "Send Email Report" (Microsoft Outlook) Purpose: Sends the formatted HTML email report Setup Required: Click on the node Set up Microsoft Outlook OAuth2 credentials: Click "Create New Credential" Follow OAuth2 setup for your Microsoft account Grant necessary email permissions Configure Email Settings: To Recipients: Change from "rbreen@ynteractive.com" to your recipient email(s) Subject: Modify "Daily Marketing Performance" as needed Body Content: Pre-configured with professional HTML template Email Template Features: Modern glassmorphic design Responsive layout for mobile devices Animated gradient accents Hover effects on metric cards Professional typography For professional setup, customization, or troubleshooting of this workflow, contact: Robert - Ynteractive Solutions Email: robert@ynteractive.com Website: www.ynteractive.com LinkedIn: linkedin.com/in/robert-breen-29429625/ Specializing in AI-powered workflow automation, business process optimization, and custom integration solutions.
By Robert BreenDeploy Docker MinIO, API backend for WHMCS/WISECP
Setting up n8n workflow Overview The Docker MinIO WHMCS module uses a specially designed workflow for n8n to automate deployment processes. The workflow provides an API interface for the module, receives specific commands, and connects via SSH to a server with Docker installed to perform predefined actions. Prerequisites You must have your own n8n server. Alternatively, you can use the official n8n cloud installations available at: n8n Official Site Installation Steps Install the Required Workflow on n8n You have two options: Option 1: Use the Latest Version from the n8n Marketplace The latest workflow templates for our modules are available on the official n8n marketplace. Visit our profile to access all available templates: PUQcloud on n8n Option 2: Manual Installation Each module version comes with a workflow template file. [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741974273723.png) You need to manually import this template into your n8n server. [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741284912356.png) n8n Workflow API Backend Setup for WHMCS/WISECP Configure API Webhook and SSH Access Create a Basic Auth Credential for the Webhook API Block in n8n. [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741974396480.png) [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741974500641.png) [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741285036996.png) Create an SSH Credential for accessing a server with Docker installed. [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741285118412.png) [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741285147192.png) [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741285198822.png) Modify Template Parameters In the Parameters block of the template, update the following settings: [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741974559641.png) [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741285412110.png) server_domain β Must match the domain of the WHMCS/WISECP Docker server. clients_dir β Directory where user data related to Docker and disks will be stored. mount_dir β Default mount point for the container disk (recommended not to change). Do not modify the following technical parameters: screen_left screen_right Deploy-docker-compose In the Deploy-docker-compose element, you have the ability to modify the Docker Compose configuration, which will be generated in the following scenarios: When the service is created When the service is unlocked When the service is updated [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741875704524.png) [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741974602887.png) nginx In the nginx element, you can modify the configuration parameters of the web interface proxy server. The main section allows you to add custom parameters to the server block in the proxy server configuration file. The main\_location section contains settings that will be added to the location / block of the proxy server configuration. Here, you can define custom headers and other parameters specific to the root location. [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741875960357.png) [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741974633761.png) Bash Scripts Management of Docker containers and all related procedures on the server is carried out by executing Bash scripts generated in n8n. These scripts return either a JSON response or a string. All scripts are located in elements directly connected to the SSH element. You have full control over any script and can modify or execute it as needed. [](https://doc.puq.info/uploads/images/gallery/2025-03/image-1741876353319.png)
By PUQcloudAutomated plagiarism detection with email reports using RapidAPI & Google Sheets
π 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.
By Sk developer