Fahmi Fahreza
AI Automation Developer
Categories
Templates by Fahmi Fahreza
AI-powered product video generator (Foreplay + Gemini + Sora 2)
AI-Powered Product Video Generator (Foreplay + Gemini + Sora 2) Sign Up For Foreplay HERE Automatically generate personalized, cinematic-quality product videos using Foreplay’s ad data, Google Gemini AI for creative prompts, and Sora 2 for text-to-video generation. Who’s it for? Perfect for marketers, brand managers, or creators who want to produce quick, high-quality video ads without manual scripting or editing. How it works Fetch product data and related competitor videos from Foreplay. Use Gemini AI to generate creative text-to-video prompts. Send the prompt and image to Kie.ai to generate a short, cinematic product video. Save the finished video automatically to Google Drive. How to set up Connect your Foreplay, Google Drive, Gemini, and Kie.ai credentials. Set your product image folder's permission (Google Drive) as public. Add your API keys inside the Set Workflow Credentials node. Then run the workflow manually to generate your first video ad!
By Fahmi FahrezaGenerate AI videos from text prompts with Google Veo
This n8n workflow uses the Google Gemini node to generate AI videos via the Veo model. It replaces complex manual API setups with a simple, plug-and-play experience. Important Prerequisite To use the Veo model, your Google Cloud project must have billing enabled. The feature is not available on the free tier and may incur charges. Who Is This For? Marketers & Content Creators Quickly create B-roll, ad clips, or social content from text prompts. Filmmakers & Artists Prototype scenes and visualize ideas without filming. Anyone exploring AI video generation Use Google’s Veo model without any manual API work. What the Workflow Does Define Prompt Write a text prompt in the 1. Set Video Prompt node. Trigger Manually run the workflow with one click. Generate The Gemini node sends the prompt to the Veo model and generates a video. Output Returns a binary video file ready to save or share. Setup Instructions Enable Google Cloud Billing Make sure your Google Cloud project has billing activated. Add Credentials Add your Google AI (Gemini) credentials in n8n. Set the Prompt Open the 1. Set Video Prompt node and write your video idea. Activate Workflow Save and activate the workflow. Run It Click “Execute Workflow” to generate a video. Requirements n8n (Cloud or Self-Hosted) Google Cloud Project with billing enabled Google AI (Gemini) credentials linked to that project Customization Ideas Save Output Add a Google Drive, Dropbox, or S3 node to store the video. Post Automatically Connect social media nodes (YouTube Shorts, TikTok, etc.) to publish content. Generate in Bulk Replace the Set node with Google Sheets or Airtable to generate multiple videos from a list of prompts.
By Fahmi FahrezaAnalyze any video and generate text summaries with Google Gemini 2.5 Pro
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Analyze Any Video and Get a Text Summary with Google Gemini This workflow uses the NEW native Google Gemini node in n8n to analyze videos and generate detailed text summaries. Just upload a video, and Gemini will describe the scenes, objects, and actions frame by frame. Who Is This For? Content Creators & Marketers Quickly generate summaries, shot lists, or descriptions for video content. Video Editors Get a fast overview of footage without manual review. Developers & n8n Beginners Learn how to use multimodal AI in n8n with a simple setup. AI Enthusiasts Explore the new capabilities of the Gemini Pro model. How It Works Upload Triggered via a form where you upload a video file. Analyze The video is sent to the Gemini 2.5 Pro model for analysis. Describe Gemini returns a detailed text summary of what it sees in the video. Setup Instructions Add Credentials Connect your Google AI (Gemini) credentials in n8n. Activate Workflow Save and activate the workflow. Upload Video Open the Form Trigger URL, upload a video, and submit the form. Requirements An n8n instance (Cloud or Self-Hosted) A Google AI (Gemini) account Customization Ideas Translate the Summary Add another LLM node to translate the analysis. Create Social Media Posts Use the output to generate Twitter or LinkedIn content. Store the Output Save the summary to Google Sheets or Airtable. Automate with Cloud Storage Replace the Form Trigger with a Google Drive or Dropbox trigger to process videos automatically.
By Fahmi FahrezaTikTok trend analyzer with Apify + Gemini + Airtable
TikTok Trend Analyzer with Apify + Gemini + Airtable Automatically scrape trending TikTok videos, analyze their virality using Gemini AI, and store insights directly into Airtable for creative research or content planning. Who’s it for? Marketing analysts, creators, and creative agencies looking to understand why videos go viral and how to replicate successful hooks and formats. How it works A scheduled trigger runs the Apify TikTok Trends Scraper weekly. The scraper collects trending video metadata. Data is stored in Airtable (views, likes, captions, sounds, etc.). When a specific video is submitted via webhook, the workflow fetches it from Airtable. Gemini AI analyzes the video and extracts structured insights: summary, visual hook, audio, and subtitle analysis. The workflow updates the Airtable record with these AI insights. How to set up Connect Apify and Airtable credentials, link Gemini or OpenAI keys, and adjust the schedule frequency. Add your Airtable base and table IDs. You can trigger analysis manually via the webhook endpoint.
By Fahmi FahrezaAutomate CV screening and applicant scoring from Gmail to Airtable with AI
How It Works Trigger Watches for new emails with attachments in a Gmail label. Extract Data Extracts job code from the email subject (e.g., FN-001) Extracts raw text from the attached CV (PDF) AI Parsing Uses Google Gemini to parse the CV and extract: Name Email Years of experience Skills Job Lookup Uses the extracted job code to retrieve job details from Airtable. AI Scoring Compares applicant data with job requirements Scores from 1–100 Generates a brief reasoning summary (in Bahasa Indonesia) Log to Airtable Saves applicant data, score, and AI notes to the "Applications" table. Setup Instructions Prepare Airtable Base Job Posts Table Columns: Job Code, Job Title, Required Skills, Minimum Experience, Job Description Applications Table Columns: Applicant Name, Email, Score, Notes Include a linked field to the Job Posts table Add Credentials in n8n Gmail Google AI (Gemini) Airtable Configure Nodes Trigger: Set Gmail filter (e.g., label:job-applications) Extract Job Code: Verify regex format, default is ([A-Z]{2}-\d{3}) Airtable Nodes: Select your base and table in: "Find Job Post..." "Save Applicant..." Activate Workflow Save and enable the workflow New applications will be processed automatically
By Fahmi FahrezaWeekly ETL pipeline: QuickBooks financial data to Google BigQuery
This template sets up a weekly ETL (Extract, Transform, Load) pipeline that pulls financial data from QuickBooks Online into Google BigQuery. It not only transfers data, but also cleans, classifies, and enriches each transaction using your own business logic. Who It's For Data Analysts & BI Developers Need structured financial data in a warehouse to build dashboards (e.g., Looker Studio, Tableau) and run complex queries. Financial Analysts & Accountants Want to run custom SQL queries beyond QuickBooks’ native capabilities. Business Owners Need a permanent, historical archive of transactions for reporting and tracking. What the Workflow Does Extract Fetches transactions from the previous week every Monday from your QuickBooks Online account. Transform Applies custom business logic: Cleans up text fields Generates stable transaction IDs Classifies transactions (income, expense, internal transfer) Format Prepares the cleaned data as a bulk-insert-ready SQL statement. Load Inserts the structured and enriched data into a Google BigQuery table. Setup Guide Prepare BigQuery Create a dataset (e.g., quickbooks) and table (e.g., transactions) The table schema must match the SQL query in the "Load Data to BigQuery" node Add Credentials Add QuickBooks Online and Google BigQuery credentials to your n8n instance Configure Business Logic Open the Clean & Classify Transactions node Update the JavaScript arrays: internalTransferAccounts expenseCategories incomeCategories Ensure these match your QuickBooks Chart of Accounts exactly Configure BigQuery Node Open the Load Data to BigQuery node Select the correct Google Cloud project Ensure the SQL query references the correct dataset and table Activate the Workflow Save and activate it The workflow will now run weekly Requirements A running n8n instance (Cloud or Self-Hosted) A QuickBooks Online account A Google Cloud Platform project with BigQuery enabled A BigQuery table with a matching schema Customization Options Change Schedule: Modify the schedule node to run daily, monthly, or at a different time Adjust Date Range: Change the date macro in the Get Last Week's Transactions node Refine Classification Rules: Add custom logic in the Clean & Classify Transactions node to handle specific edge cases
By Fahmi FahrezaArchive trending TikTok hashtags using TikTok, Airtable, and Apify
Archive Trending TikTok Hashtags to Airtable with Apify This template uses a community node (@apify/n8n-nodes-apify). It will not work without the required node installed. Who it's for Social Media Managers & Content Creators Discover relevant hashtags and build content calendars based on real trends. Marketing & Brand Strategists Track cultural shifts and find opportunities by understanding regional audience interests. Data Analysts Create a dataset for analyzing hashtag trends, virality, and performance over time. What it does This workflow automates trend discovery and data collection from TikTok into Airtable. Schedule: Triggers automatically once a month. Scrape: Runs an Apify Actor to scrape TikTok’s top 100 trending hashtags for a specified country (default is US). Retrieve: Fetches the dataset with hashtag metrics after scraping completes. Process & Load: Splits the dataset and saves each hashtag as a new record in Airtable with relevant details. How to set it up Install the Community Node Go to Settings; Community Nodes on your n8n instance and install @apify/n8n-nodes-apify. Prepare Airtable Create a base with a table named Trending Hashtags: ID Name Country Industry Date Added Publish Count Video Views Rank Status Add Credentials Add your Apify and Airtable credentials in n8n. Configure Scraper (Optional) Open the 1. Run TikTok Hashtag Scraper node. In the Custom Body, you can adjust: country_code (e.g., "US" to "GB") top100_period (e.g., "30" to "7") Configure Airtable Node Open the 4. Save Hashtag to Airtable node. Select the correct Airtable Base and the Trending Hashtags table. Activate Workflow Save and activate the workflow. It will now run automatically every month. Requirements Installed community node: @apify/n8n-nodes-apify Apify account Airtable account with a structured base How to customize the workflow Change Schedule Modify the Start: Monthly Schedule node to run weekly or on another interval. Add Notifications Attach a Slack or Discord node after the 4. Save Hashtag to Airtable node to alert your team when new data is added. Filter Hashtags Use a Filter node after 3. Split Hashtags into Items to only save hashtags that meet specific conditions (e.g., over 1M video views).
By Fahmi FahrezaMatch resumes to jobs automatically with Gemini AI and Decodo Scraping
Match Resumes to Jobs Automatically with Gemini AI and Decodo Scraping Sign up for Decodo HERE for Discount This automation intelligently connects candidate profiles to job opportunities. It takes an intake form with a short summary, resume link, and optional LinkedIn profile, then enriches the data using Decodo and Gemini. The workflow analyzes skills, experience, and role relevance, ranks top matches, and emails a polished HTML report directly to your inbox—saving hours of manual review and matching effort. Who’s it for? This template is designed for recruiters, hiring managers, and talent operations teams who handle large candidate volumes and want faster, more accurate shortlisting. It’s also helpful for job seekers or career coaches who wish to identify high-fit openings automatically using structured AI analysis. How it works Receive an intake form containing a candidate’s resume, summary, and LinkedIn URL. Parse and summarize the resume with Gemini for core skills and experience. Enrich the data using Decodo scraping to gather extra profile details. Merge insights and rank job matches from Decodo’s job data. Generate an HTML shortlist and email it automatically through Gmail. How to set up Connect credentials for Gmail, Google Gemini, and Decodo. Update the Webhook path and test your form connection. Customize variables such as location or role preferences. Enable Send as HTML in the Gmail node for clean reports. Publish as self-hosted if community nodes are included.
By Fahmi FahrezaSync multi-bank balance data to BigQuery using Plaid
Automated Multi-Bank Balance Sync to BigQuery This workflow automatically fetches balances from multiple financial institutions (RBC, Amex, Wise, PayPal) using Plaid, maps them to QuickBooks account names, and loads structured records into Google BigQuery for analytics. Who’s it for? Finance teams, accountants, and data engineers managing consolidated bank reporting in Google BigQuery. How it works The Schedule Trigger runs weekly. Four Plaid API calls fetch balances from RBC, Amex, Wise, and PayPal. Each response splits out individual accounts and maps them to QuickBooks names. All accounts are merged into one dataset. The workflow structures the account data, generates UUIDs, and formats SQL inserts. BigQuery node uploads the finalized records. How to set up Add Plaid and Google BigQuery credentials, replace client IDs and secrets with variables, test each connection, and schedule the trigger for your reporting cadence.
By Fahmi FahrezaWeekly SEO watchlist audit to Google Sheets with Gemini and Decodo
Weekly SEO Watchlist Audit to Google Sheets (Gemini + Decodo) Sign up for Decodo HERE for Discount Automatically fetches page content, generates a compact SEO audit (score, issues, fixes), and writes both a per-URL summary and a normalized “All Issues” table to Google Sheets—great for weekly monitoring and prioritization. Who’s it for? Content/SEO teams that want lightweight, scheduled audits of key pages with actionable next steps and spreadsheet reporting. How it works Weekly trigger loads the Google Sheet of URLs. Split in Batches processes each URL. Decodo fetches page content (markdown + status). Gemini produces a strict JSON audit via the AI Chain + Output Parser. Code nodes flatten data for two tabs. Google Sheets nodes append Summary and All Issues rows. Split in Batches continues to the next URL. How to set up Add credentials for Google Sheets, Decodo, and Gemini. Set sheet_id and Sheet GIDs in the Set node. Ensure input sheet has a URL column. Configure your Google Sheets tabs with proper headers matching each field being appended (e.g., URL, Decodo Score, Priority, etc.). Adjust schedule as needed. Activate the workflow.
By Fahmi FahrezaSync QuickBooks chart of accounts to Google BigQuery
Sync QuickBooks Chart of Accounts to Google BigQuery Keep a historical, structured copy of your QuickBooks Chart of Accounts in BigQuery. This n8n workflow runs weekly, syncing new or updated accounts for better reporting and long-term tracking. Who Is This For? Data Analysts & BI Developers Build a robust financial model and analyze changes over time. Financial Analysts & Accountants Track structural changes in your Chart of Accounts historically. Business Owners Maintain a permanent archive of your financial structure for future reference. What the Workflow Does Extract Every Monday, fetch accounts created or updated in the past 7 days from QuickBooks. Transform Clean the API response, manage currencies, create stable IDs, and format the data. Format Convert cleaned data into an SQL insert-ready structure. Load Insert or update account records into BigQuery. Setup Steps Prepare BigQuery Create a table (e.g., quickbooks.accounts) with columns matching the final SQL insert step. Add Credentials Connect QuickBooks Online and BigQuery credentials in n8n. Configure the HTTP Node Open 1. Get Updated Accounts from QuickBooks. Replace the Company ID {COMPANY_ID} with your real Company ID. Press Ctrl + Alt + ? in QuickBooks to find it. Configure the BigQuery Node Open 4. Load Accounts to BigQuery. Select the correct project. Make sure your dataset and table name are correctly referenced in the SQL. Activate Save and activate the workflow. It will now run every week. Requirements QuickBooks Online account QuickBooks Company ID Google Cloud project with BigQuery and a matching table Customization Options Change Sync Frequency Adjust the schedule node to run daily, weekly, etc. Initial Backfill Temporarily update the API query to select * from Account for a full pull. Add Fields Modify 2. Structure Account Data to include or transform fields as needed.
By Fahmi FahrezaCoinGecko crypto price forecasting pipeline with Gemini AI, Decodo, and Gmail
Automated Crypto Forecast Pipeline using Decodo and Gmail Sign Up for Decodo HERE for discount This template scrapes CoinGecko pages for selected coins, converts metrics into clean JSON, stores them in an n8n Data Table, generates 24-hour direction forecasts with Gemini, and emails a concise report. Who’s it for? Crypto watchers who want automated snapshots, forecasts, and a daily email—without managing a full data stack. How it works 30-min schedule loops coins, scrapes CoinGecko (Decodo), parses metrics, and upserts to Data Table. 18:00 schedule loads last 48h data. Gemini estimates next-24h direction windows. Email is rendered (HTML + plain text) and sent. How to set up Add Decodo, Gmail, and Gemini credentials. Open Configure Coins to edit tickers. Set Data Table ID. Replace recipient email. (Self-host only) Community node Decodo required. @decodo/n8n-nodes-decodo (community)
By Fahmi Fahreza