Loading page
Quick overview This workflow runs hourly to collect campaign spend, clicks, and impressions from Meta (Facebook), Google Ads, TikTok Ads, and Taboola, then upserts the metrics into Airtable and creates a time-stamped snapshot record for Me…
Download this n8n workflow template and start using it instantly.
This workflow runs hourly to collect campaign spend, clicks, and impressions from Meta (Facebook), Google Ads, TikTok Ads, and Taboola, then upserts the metrics into Airtable and creates a time-stamped snapshot record for Meta campaigns. Get Implementation help via https://nocode.expert
Format Date for Campaigns (Code): Runs custom JavaScript to transform or manipulate the data flowing through the workflow.
Fetch FB Spend Data (HTTP Request): Makes an external API call (HTTP request) to send or retrieve data from a third-party service.
Compile Ad Spend Data (Code): Runs custom JavaScript to transform or manipulate the data flowing through the workflow.
Fetch Airtable Campaign Records (Airtable): Reads or writes records in an Airtable base.
Prepare Airtable Data (Airtable): Reads or writes records in an Airtable base.
Fetch FB Campaigns Account 2 (HTTP Request): Makes an external API call (HTTP request) to send or retrieve data from a third-party service.
Fetch FB Campaigns Account 1 (HTTP Request): Makes an external API call (HTTP request) to send or retrieve data from a third-party service.
Fetch FB Campaigns Account 3 (HTTP Request): Makes an external API call (HTTP request) to send or retrieve data from a third-party service.
Store to Airtable (Airtable): Reads or writes records in an Airtable base.
Fetch Taboola Ads Data (HTTP Request): Makes an external API call (HTTP request) to send or retrieve data from a third-party service.
Fetch Google Ads Data (HTTP Request): Makes an external API call (HTTP request) to send or retrieve data from a third-party service.
Extract FB Campaign Information (Code): Runs custom JavaScript to transform or manipulate the data flowing through the workflow.
Process Airtable Records (Airtable): Reads or writes records in an Airtable base.
Extract Google & Taboola Data (Code): Runs custom JavaScript to transform or manipulate the data flowing through the workflow.
Loop Over Google & Taboola Data (Split In Batches): Loops over items in batches, processing each one in turn (used for iteration).
Loop Over FB Campaigns Data (Split In Batches): Loops over items in batches, processing each one in turn (used for iteration).
Check Campaign ID Exists (If): Branches the workflow based on a true/false condition.
Filter Campaign Data (Filter): Keeps only the items that match a condition and discards the rest.
Retrieve Taboola Access Token (HTTP Request): Makes an external API call (HTTP request) to send or retrieve data from a third-party service.
Fetch FB Campaigns Account 4 (HTTP Request): Makes an external API call (HTTP request) to send or retrieve data from a third-party service.
Verify FB Campaign Batch (If): Branches the workflow based on a true/false condition.
Fetch Tiktok Ads Data (HTTP Request): Makes an external API call (HTTP request) to send or retrieve data from a third-party service.
Every Hour Schedule Trigger (Schedule Trigger): Starts the workflow automatically on a schedule (cron / fixed interval).
Who’s it for This template is built for WooCommerce store owners, eCommerce managers, and automation agencies who want to manage store operations directly from Telegram using an AI assistant. It’s ideal for users looking to save time, automate support, and access store data conversationally. How it works When a user sends a message via Telegram, the workflow triggers an AI agent that understands the request using a chat model with memory. Based on the intent, the agent executes the appropriate action such as retrieving orders, fetching product data, updating product information, logging data into Google Sheets, or sending email notifications. How to set up 1. Connect your Telegram bot credentials 2. Add your WooCommerce API keys 3. Connect Google Sheets for data storage 4. Connect your Gmail account 5. Configure your OpenRouter or OpenAI API key 6. Test the workflow via Telegram commands Requirements WooCommerce store with API access Telegram bot token Google Sheets account Gmail credentials OpenRouter or OpenAI API key How to customize You can expand this agent by adding tools like order creation, refund processing, CRM integrations, shipping updates, or advanced reporting. The AI prompt can also be modified to match your store operations.
by Nid AcademyHow it works This template launches your very first AI Agent —an AI-powered chatbot that can do more than just talk— it can take action using tools. Think of an AI Agent as a smart assistant, and the tools are the apps on its phone. By connecting it to other nodes, you give your agent the ability to interact with real-world data and services, like checking the weather, fetching news, or even sending emails on your behalf. This workflow is designed to be the perfect starting point: The Chat Interface: A Chat Trigger node provides a simple, clean interface for you to talk to your agent. The Brains: The AI Agent node receives your messages, intelligently decides which tool to use (if any), and formulates a helpful response. Its personality and instructions are fully customizable in the "System Message". The Language Model: It uses Google Gemini to power its reasoning and conversation skills. The Tools: It comes pre-equipped with two tools to demonstrate its capabilities: 1. Get Weather: Fetches real-time weather forecasts. 2. Get News: Reads any RSS feed to get the latest headlines. The Memory: A Conversation Memory node allows the agent to remember the last few messages, enabling natural, follow-up conversations. Set up steps Setup time: ~2 minutes You only need one thing to get started: a free Google AI API key. 1. Get Your Google AI API Key: Visit Google AI Studio at aistudio.google.com/app/apikey. Click "Create API key in new project" and copy the key that appears. 2. Add Your Credential in n8n: On the workflow canvas, go to the Connect your model (Google Gemini) node. Click the Credential dropdown and select + Create New Credential. Paste your API key into the API Key field and click Save. 3. Start Chatting! Go to the Example Chat node. Click the "Open Chat" button in its parameter panel. Try asking it one of the example questions, like: "What's the weather in Paris?" or "Get me the latest tech news."* That's it! You now have a fully functional AI Agent. Try adding more tools (like Gmail or Google Calendar) to make it even more powerful.
by Lucas PeyrinGenerate AI videos with Seedance & Blotato, upload to TikTok, YouTube & Instagram Who is this for? This template is ideal for creators, content marketers, social media managers, and AI enthusiasts who want to automate the production of short-form, visually captivating videos for platforms like TikTok, YouTube Shorts, and Instagram Reels — all without manual editing or publishing. What problem is this workflow solving? Creating engaging videos requires: Generating creative ideas Writing detailed scene prompts Producing realistic video clips and sound effects Editing and stitching the final video Publishing across multiple platforms This workflow automates the entire process, saving hours of manual work and ensuring consistent, AI-driven content output ready for social distribution. What this workflow does This end-to-end AI video automation workflow: 1. Generates a creative idea using OpenAI and LangChain 2. Creates detailed video prompts with Seedance AI 3. Generates video clips via Wavespeed AI 4. Generates sound effects with Fal AI 5. Stitches the final video using Fal AI’s ffmpeg API 6. Logs metadata and video links to Google Sheets 7. Uploads the video to Blotato 8. Auto-publishes to TikTok, YouTube, Instagram, and other platforms Setup 1. Add your OpenAI API key in the LLM nodes 2. Set up Seedance and Wavespeed AI credentials for video prompt and clip generation 3. Add your Fal AI API key for sound and stitching steps 4. Connect your Google Sheets account for tracking ideas and outputs 5. Set your Blotato API key and fill in the platform account IDs in the Assign Social Media IDs node 6. Adjust the Schedule Trigger to control when the automation runs How to customize this workflow to your needs Change the AI prompts to target your niche (e.g., ASMR, product videos, humor) Add a Telegram or Slack step for video preview before publishing Tweak scene structure or video duration to match your style Disable platforms you don’t want by turning off specific HTTP Request nodes Edit the sound generation prompts for different moods or effects Documentation: Notion Guide --- Need help customizing? Contact me for consulting and support : Linkedin / Youtube
by Dr. FirasThis workflow allows users to generate AI videos using Google Veo3, save them to Google Drive, generate optimized YouTube titles with GPT-4o, and automatically upload them to YouTube with Upload-Post. The entire process is triggered from a Google Sheet that acts as the central interface for input and output. IT automates video creation, uploading, and tracking, ensuring seamless integration between Google Sheets, Google Drive, Google Veo3, and YouTube. --- Benefits of this Workflow No Code Interface: Trigger and control the video production pipeline from a simple Google Sheet. Full Automation: Once set up, the entire video generation and publishing process runs hands-free. AI-Powered Creativity: Generates engaging YouTube titles using GPT-4o. Leverages advanced generative video AI from Google Veo3. Cloud Storage & Backup: Stores all generated videos on Google Drive for safekeeping. YouTube Ready: Automatically uploads to YouTube with correct metadata, saving time and boosting visibility. Scalable: Designed to process multiple video prompts by looping through new entries in Google Sheets. API-First: Utilizes secure API-based communication for all services. --- How It Works 1. Trigger: The workflow can be started manually ("When clicking ‘Test workflow’") or scheduled ("Schedule Trigger") to run at regular intervals (e.g., every 5 minutes). 2. Fetch Data: The "Get new video" node retrieves unfilled video requests from a Google Sheet (rows where the "VIDEO" column is empty). 3. Video Creation: The "Set data" node formats the prompt and duration from the Google Sheet. The "Create Video" node sends a request to the Fal.run API (Google Veo3) to generate a video based on the prompt. 4. Status Check: The "Wait 60 sec." node pauses execution for 60 seconds. The "Get status" node checks the video generation status. If the status is "COMPLETED," the workflow proceeds; otherwise, it waits again. 5. Video Processing: The "Get Url Video" node fetches the video URL. The "Generate title" node uses OpenAI (GPT-4.1) to create an SEO-optimized YouTube title. The "Get File Video" node downloads the video file. 6. Upload & Update: The "Upload Video" node saves the video to Google Drive. The "HTTP Request" node uploads the video to YouTube via the Upload-Post API. The "Update Youtube URL" and "Update result" nodes update the Google Sheet with the video URL and YouTube link. --- Set Up Steps 1. Google Sheet Setup: Create a Google Sheet with columns: PROMPT, DURATION, VIDEO, and YOUTUBE_URL. Share the Sheet link in the "Get new video" node. 2. API Keys: Obtain a Fal.run API key (for Veo3) and set it in the "Create Video" node (Header: Authorization: Key YOURAPIKEY). Get an Upload-Post API key (for YouTube uploads) and configure the "HTTP Request" node (Header: Authorization: Apikey YOUR_API_KEY). 3. YouTube Upload Configuration: Replace YOUR_USERNAME in the "HTTP Request" node with your Upload-Post profile name. 4. Schedule Trigger: Configure the "Schedule Trigger" node to run periodically (e.g., every 5 minutes). --- Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.
by Davide Boizza