Generate personalized email icebreakers with GPT-4.1 and Instantly.ai integration
AI-Powered Personalized Cold Email Icebreaker Generator
Overview
This intelligent automation system transforms generic cold outreach into highly personalized email campaigns by automatically scraping prospect websites, analyzing their content with AI, and generating unique, conversational icebreakers that reference specific, non-obvious details about each business. The workflow integrates seamlessly with Instantly.ai to deliver campaigns that achieve significantly higher response rates compared to traditional cold email approaches.
The system processes leads from your n8n data table, validates contact information, scrapes multiple pages from each prospect's website, uses GPT-4.1 to synthesize insights, and crafts personalized openers that make recipients believe you've done deep research on their businessβall without manual intervention.
Key Benefits
π― Hyper-Personalization at Scale: Generate unique icebreakers for 30+ leads per execution that reference specific details about each prospect's business, creating the impression of manual research while automating 100% of the process.
π° Dramatically Higher Response Rates: Personalized cold emails using this system typically achieve 4-5% response rates for campaigns, directly translating to more booked meetings and closed deals.
β±οΈ Massive Time Savings: What would take 10-15 minutes of manual research per prospect (website review, note-taking, icebreaker writing) now happens in 30-45 seconds automatically, freeing your team to focus on conversations instead of research.
π§ AI-Powered Intelligence: Dual GPT model approach uses GPT-4.1-mini for efficient content summarization and GPT-4.1 for creative icebreaker generation, ensuring both cost efficiency and high-quality output with a distinctive "spartan" tone that converts.
π Built-In Error Handling: Comprehensive retry logic (5 attempts with 5-second delays) and graceful failure management ensure the workflow continues processing even when websites are down or inaccessible, automatically removing problem records from your queue.
ποΈ Clean Data Management: Automatically removes processed leads from your database after successful campaign addition, preventing duplicate outreach and maintaining organized lead lists for future campaigns.
π Batch Processing Control: Processes leads in configurable batches (default 30) to manage API costs and rate limits while maintaining efficiency, with easy scaling for larger lists.
π Instantly.ai Integration: Direct API integration pushes leads with custom variables into your campaigns automatically, supporting skip_if_in_campaign logic to prevent duplicate additions and maintain clean campaign lists.
How It Works
Stage 1: Lead Acquisition & Validation The workflow begins with a manual trigger, allowing you to control when processing starts. It queries your n8n data table and retrieves up to 30 records filtered by Email_Status. The Limit node caps this at 30 items to control processing costs and API usage. Records then pass through the "Only Websites & Emails" filter, which uses strict validation to ensure both organization_website_url and email fields exist and contain dataβeliminating invalid records before expensive AI processing occurs.
Stage 2: Intelligent Web Scraping Valid leads enter the Loop Over Items batch processor, which handles them sequentially to manage API rate limits. For each lead, the workflow fetches their website homepage using the HTTP Request node with retry logic (5 attempts, 5-second waits) and "always output data" enabled to capture even failed requests. The If node checks response names for error indicators, if errors are detected, the problematic record is immediately deleted from the database via Delete row(s) to prevent future processing waste. Successfully scraped HTML content passes through the Markdown converter, which transforms it into clean markdown format that AI models can analyze more effectively.
Stage 3: AI Content Analysis The markdown content flows into the first AI node, "Summarize Website Page," which uses GPT-4.1-mini (cost-efficient for summarization tasks) with a specialized system prompt. The AI reads the scraped content and generates a comprehensive two-paragraph abstract similar in detail to an academic paper abstract, focusing on what the business does, their projects, services, and unique differentiators. The output is structured JSON with an "abstract" field. Multiple page summaries (if the workflow is extended to scrape additional pages) are collected by the Aggregate node, which combines all abstracts into a single array for comprehensive analysis.
Stage 4: Personalized Icebreaker Generation The aggregated summaries, along with prospect profile data (name, headline, company), flow into the "Generate Multiline Icebreaker" node powered by GPT-4.1 (higher intelligence for creative writing). This node uses an advanced system prompt with specific rules: write in a spartan/laconic tone, avoid special characters and hyphens, use the format "Really Loved {thing}, especially how you're {doing/managing/handling} {otherThing}," reference small non-obvious details (never generic compliments like "Love your website!"), shorten company names and locations naturally. The prompt includes a few-shot example teaching the AI the exact style and depth expected. Temperature is set to 0.5 for creative but consistent output.
Stage 5: Campaign Deployment & Cleanup The generated icebreaker is formatted into Instantly.ai's API structure and sent via HTTP POST to the "Sending ice breaker to instantly" node. The payload includes the lead's email, first name, last name, company name, the personalized icebreaker as the "personalization" field, website URL, and supports custom_variables for additional personalization fields. The API call uses skip_if_in_campaign: true to prevent duplicate additions. After successful campaign addition, the Delete row(s)1 node removes the processed record from your data table, maintaining a clean queue. The Loop Over Items node then processes the next lead until all 30 are complete.
Required Setup & Database Structure
n8n Data Table Requirements:
- Table Name: Configurable (default "Real estate")
- Required Columns:
id(unique identifier for each record)first_name(prospect's first name)last_name(prospect's last name)email(valid email address)organization_website_url(full URL with https://)Headline(job title/company descriptor)Email_Status(filter field for processing control)
API Credentials:
- OpenAI API Key (connected as "Sycorda" credential)
- Access to GPT-4.1-mini model
- Access to GPT-4.1 model
- Sufficient credits for batch processing (approximately $0.01-0.03 per lead)
- Instantly.ai API Key
- Campaign ID (replace the placeholder "00000000-0000-0000-0000-000000000000")
- Active campaign with proper email accounts configured
Environment Setup:
- n8n instance with @n8n/n8n-nodes-langchain package installed
- Stable internet connection for web scraping
- Adequate execution timeout limits (recommended 5+ minutes for 30 leads)
Business Use Cases
B2B Service Providers: Agencies, consultancies, and professional services firms can personalize outreach by referencing prospect's specific service offerings, client types, or operational approach to book discovery calls and consultations.
SaaS Companies: Software vendors across any vertical can use this to demonstrate product value through highly relevant cold outreach that references prospect pain points, tech stack, or business model visible on their websites.
Marketing & Creative Agencies: Agencies offering design, content creation, SEO, or digital marketing services can personalize outreach by referencing prospects' current marketing approach, website quality, or brand positioning.
E-commerce & Retail: Online retailers and D2C brands can reach potential wholesale partners, distributors, or B2B clients by mentioning their product lines, target markets, or unique value propositions.
Financial Services: Fintech companies, accounting firms, and financial advisors can personalize cold outreach by referencing prospect's business size, industry focus, or financial complexity to offer relevant solutions.
Recruitment & Staffing: Agencies can reach potential clients by mentioning their hiring needs, company growth, team structure, or industry specialization visible on career pages and about sections.
Technology & Development: Software development agencies, IT consultancies, and tech vendors can reference prospect's current technology stack, digital transformation initiatives, or technical challenges to position relevant solutions.
Education & Training: Corporate training providers, coaching services, and educational platforms can personalize outreach by mentioning company culture, team development focus, or learning initiatives referenced on websites.
Revenue Potential
Same icebreaker approach used by leading cold email experts delivers 4-5% higher reply rates compared to generic outreach templates. By investing approximately $0.11-0.18 per personalized lead (AI processing + email sending costs), businesses achieve response rates of 4-5% versus the industry standard non-personalized campaigns.
Scalability: Process 30 leads (or any much you want just replace the number 30 with your number) and in minutes with minimal manual oversight, allowing sales teams to maintain high personalization quality while reaching hundreds of prospects weekly. The automation handles the research-intensive work, letting your team focus on high-value conversations with engaged prospects.
Difficulty Level & Build Time
Difficulty: Intermediate Estimated Build Time: 2-3 hours for complete setup Technical Requirements:
- Familiarity with n8n node configuration
- Basic understanding of API integrations
- JSON data structure knowledge
- OpenAI prompt engineering basics
Setup Complexity Breakdown:
- Data table creation and population: 30 minutes
- Workflow node configuration: 45 minutes
- OpenAI credential setup and testing: 20 minutes
- Instantly.ai API integration: 25 minutes
- Prompt optimization and testing: 45 minutes
- Error handling verification: 15 minutes
Maintenance Requirements: Minimal once configured. Monthly tasks include monitoring OpenAI costs, updating prompts based on performance data, and refilling the data table with new leads.
Detailed Setup Steps
Step 1: Create Your Data Table
- In n8n, navigate to your project
- Create a new data table with a name relevant to your industry
- Add columns: id (auto), first_name (text), last_name (text), email (text), organization_website_url (text), Headline (text), Email_Status (text)
- Import your lead list via CSV or manual entry
- Set Email_Status to blank or a specific value you'll filter by
Step 2: Configure OpenAI Credentials
- Obtain an OpenAI API key from platform.openai.com
- In n8n, go to Credentials β Add Credential β OpenAI
- Name it "Sycorda" (or update all OpenAI nodes with your credential name)
- Paste your API key and test the connection
- Ensure your OpenAI account has access to GPT-4.1 models
Step 3: Import and Configure the Workflow
- Copy the provided workflow JSON
- In n8n, create a new workflow and paste the JSON
- Update the "Get row(s)" node:
- Select your data table
- Configure the Email_Status filter condition
- Adjust limit if needed (default 30)
- Verify the "Loop Over Items" node has reset: false
Step 4: Configure Website Scraping
- In "Request web page for URL1" node, verify:
- URL expression references correct field:
{{ $('Get row(s)').item.json.organization_website_url }} - Retry settings: 5 attempts, 5000ms wait
- "Always Output Data" is enabled
- URL expression references correct field:
- Test with a single lead to verify HTML retrieval
Step 5: Customize AI Prompts for Your Industry
- In "Summarize Website Page" node:
- Review the system prompt
- Adjust the abstract detail level if needed
- Keep JSON output enabled
- In "Generate Multiline Icebreaker" node:
- CRITICAL: Update the few-shot example with your target industry specifics
- Customize the tone guidance to match your brand voice
- Modify the icebreaker format template if desired
- Adjust temperature (0.5 default; lower for consistency, higher for variety)
- Update the profile format to match your industry (change "Property Manager or Real estate" references)
Step 6: Set Up Instantly.ai Integration
- Log into your Instantly.ai account
- Navigate to Settings β API Key and copy your key
- Create or select the campaign where leads will be added
- Copy the Campaign ID from the URL (format: 00000000-0000-0000-0000-000000000000)
- In the "Sending ice breaker to instantly" node:
- Update the JSON body with your api_key
- Replace the campaign_id placeholder
- Adjust skip_if_in_workspace and skip_if_in_campaign flags
- Map the lead fields correctly:
- email:
{{ $('Loop Over Items').item.json.email }} - first_name:
{{ $('Loop Over Items').item.json.first_name }} - last_name:
{{ $('Loop Over Items').item.json.last_name }} - personalization:
{{ $json.message.content.icebreaker }} - company_name: Extract from Headline or add to data table
- website:
{{ $('Loop Over Items').item.json.organization_website_url }}
- email:
Step 7: Test and Validate
- Start with 3-5 test leads in your data table
- Execute the workflow manually
- Verify each stage:
- Data retrieval from table
- Website scraping success
- AI summary generation
- Icebreaker quality and format
- Instantly.ai lead addition
- Database cleanup
- Check your Instantly.ai campaign to confirm leads appear with custom variables
- Review error handling by including one lead with an invalid website
Step 8: Scale and Monitor
- Increase batch size in the Limit node (30 β 50+ if needed)
- Add more leads to your data table
- Set up execution logs to monitor costs
- Track response rates in Instantly.ai
- A/B test prompt variations to optimize icebreaker performance
- Consider scheduling automatic execution with n8n's Schedule Trigger
Advanced Customization Options
Multi-Page Scraping: Extend the workflow to scrape additional pages (about, services, portfolio) by adding multiple HTTP Request nodes after the first scrape, then modify the Aggregate node to combine all page summaries before icebreaker generation.
Industry-Specific Prompts: Create separate workflow versions with customized prompts for different verticals or buyer personas to maximize relevance and response rates for each segment.
Dynamic Campaign Routing: Add Switch or If nodes after icebreaker generation to route leads to different Instantly.ai campaigns based on company size, location, or detected business focus from the AI analysis.
Sentiment Analysis: Insert an additional OpenAI node after summarization to analyze the prospect's website tone and adjust your icebreaker style accordingly (formal vs. casual, technical vs. conversational).
CRM Integration: Replace or supplement the data table with direct CRM integration (HubSpot, Salesforce, Pipedrive) to pull leads and push results back, creating a fully automated lead enrichment pipeline.
Competitor Mention Detection: Add a specialized prompt to the summarization phase that identifies if prospects mention competitors or specific pain points, then use this intelligence in the icebreaker for even higher relevance.
LinkedIn Profile Enrichment: Add Clay or Clearbit integration before the workflow to enrich email lists with LinkedIn profile data, then reference recent posts or career changes in the icebreaker alongside website insights.
A/B Testing Framework: Duplicate the "Generate Multiline Icebreaker" node with different prompt variations and use a randomizer to split leads between versions, then track performance in Instantly.ai to identify the highest-converting approach.
Webhook Trigger: Replace the manual trigger with a webhook that fires when new leads are added to your data table or CRM, creating a fully automated lead-to-campaign pipeline that requires zero manual intervention.
Cost Optimization: Replace GPT-4.1 models with GPT-4o-mini or Claude models for cost savings if response quality remains acceptable, or implement a tiered approach where only high-value leads get premium model processing.
Generate Personalized Email Icebreakers with GPT-4 and Instantly.ai Integration
This n8n workflow automates the generation of personalized email icebreakers using OpenAI's GPT model and prepares them for integration with Instantly.ai or similar email outreach platforms. It's designed to help sales, marketing, and outreach professionals create highly relevant and engaging opening lines for their cold emails, significantly improving response rates.
Description
This workflow streamlines the process of crafting unique and compelling email icebreakers. It takes a list of prospect details (like company name, website, and a specific value proposition) and leverages OpenAI's advanced language model to generate a custom icebreaker for each. The generated icebreakers are then formatted and prepared for bulk upload or direct integration into email outreach tools.
What it does
- Manual Trigger: Initiates the workflow upon manual execution, allowing for on-demand icebreaker generation.
- Data Table: Defines a sample dataset of prospects, including their company, website, and a relevant value proposition. This serves as the input for the icebreaker generation.
- Loop Over Items: Processes each prospect's data individually, ensuring that a unique icebreaker is generated for every entry.
- OpenAI - Generate Icebreaker: Calls the OpenAI API (likely GPT-4 or a similar model) with a carefully crafted prompt. This prompt instructs the AI to generate a highly personalized and engaging email icebreaker based on the prospect's company, website, and the provided value proposition.
- Markdown: Formats the AI-generated icebreaker into a clear, readable markdown format.
- Filter: Checks if an icebreaker was successfully generated by OpenAI. Items without a generated icebreaker are filtered out.
- HTTP Request - Instantly.ai: (Implicit based on the directory name and common use cases, though not explicitly configured in the provided JSON) This node would typically be configured to send the generated icebreakers to an email outreach platform like Instantly.ai, either via their API or by preparing a CSV for import.
- Aggregate: Collects all successfully generated icebreakers after individual processing.
- Limit: (Potentially used for testing or controlling output) Limits the number of items passed through, useful for debugging or processing a subset of data.
- If: (Not connected in the provided JSON, but typically used for conditional logic) Could be used to branch the workflow based on certain conditions, e.g., if an icebreaker meets specific length requirements or sentiment.
Prerequisites/Requirements
- n8n Instance: A running n8n instance (cloud or self-hosted).
- OpenAI API Key: An API key for OpenAI with access to the GPT model used for generation. This needs to be configured as an n8n credential.
- Instantly.ai Account (Optional but recommended): If you plan to integrate with Instantly.ai for email outreach, you'll need an account and potentially an API key or a method for CSV import.
- Basic understanding of n8n: Familiarity with how to import workflows and configure credentials.
Setup/Usage
- Import the workflow: Download the JSON definition and import it into your n8n instance.
- Configure OpenAI Credentials:
- In n8n, go to "Credentials".
- Add a new credential of type "OpenAI API".
- Enter your OpenAI API Key.
- Customize the Data Table:
- Edit the "Data table" node (
id: 1315). - Replace the sample data with your actual prospect list (company name, website, value proposition, etc.). Ensure the column names match what the OpenAI node expects.
- Edit the "Data table" node (
- Review OpenAI Prompt:
- Inspect the "OpenAI" node (
id: 1250). - Adjust the prompt to fine-tune the icebreaker generation to your specific needs and desired tone.
- Inspect the "OpenAI" node (
- Configure Instantly.ai Integration (if applicable):
- The "HTTP Request" node (
id: 19) is currently generic. You would need to configure it to interact with Instantly.ai's API or prepare the data for CSV export/import. This typically involves setting the correct URL, HTTP method (e.g., POST), headers (e.g., API key), and body payload.
- The "HTTP Request" node (
- Execute the Workflow: Click "Execute Workflow" to run it manually. You can also set up a schedule trigger if you have a recurring need.
- Review Results: Check the output of the "Aggregate" node to see the generated icebreakers. If you configured the Instantly.ai integration, verify the data has been sent correctly.
Related Templates
Automate interior design lead qualification with AI & human approval to Notion
Overview This automated workflow intelligently qualifies interior design leads, generates personalized client emails, and manages follow-up through a human-approval process. Built with n8n, Claude AI, Telegram approval, and Notion database integration. β οΈ Hosting Options This template works with both n8n Cloud and self-hosted instances. Most nodes are native to n8n, making it cloud-compatible out of the box. What This Template Does Automated Lead Management Pipeline: Captures client intake form submissions from website or n8n forms AI-powered classification into HOT/WARM/COLD categories based on budget, project scope, and commitment indicators Generates personalized outreach emails tailored to each lead type Human approval workflow via Telegram for quality control Email revision capability for rejected drafts Automated client email delivery via Gmail Centralized lead tracking in Notion database Key Features β Intelligent Lead Scoring: Analyzes 12+ data points including budget (AED), space count, project type, timeline, and style preferences β Personalized Communication: AI-generated emails reference specific client details, demonstrating genuine understanding β Quality Control: Human-in-the-loop approval via Telegram prevents errors before client contact β Smart Routing: Different workflows for qualified leads (meeting invitations) vs. unqualified leads (respectful alternatives) β Revision Loop: Rejected emails automatically route to revision agent for improvements β Database Integration: All leads stored in Notion for pipeline tracking and analytics Use Cases Interior design firms managing high-volume lead intake Architecture practices with complex qualification criteria Home renovation companies prioritizing project value Any service business requiring budget-based lead scoring Sales teams needing approval workflows before client contact Prerequisites Required Accounts & API Keys: Anthropic Claude API - For AI classification and email generation Telegram Bot Token - For approval notifications Gmail Account - For sending client emails (or any SMTP provider) Notion Account - For lead database storage n8n Account - Cloud or self-hosted instance Technical Requirements: Basic understanding of n8n workflows Ability to create Telegram bots via BotFather Gmail app password or OAuth setup Notion database with appropriate properties Setup Instructions Step 1: Clone and Import Template Copy this template to your n8n instance (cloud or self-hosted) All nodes will appear as inactive - this is normal Step 2: Configure Form Trigger Open the Client Intake Form Trigger node Choose your trigger type: For n8n forms: Configure form fields matching the template structure For webhook: Copy webhook URL and integrate with your website form Required form fields: First Name, Second Name, Email, Contact Number Project Address, Project Type, Spaces Included Budget Range, Completion Date, Style Preferences Involvement Level, Previous Experience, Inspiration Links Step 3: Set Up Claude AI Credentials Obtain API key from https://console.anthropic.com In n8n: Create new credential β Anthropic β Paste API key Apply credential to these nodes: AI Lead Scoring Engine Personalized Client Outreach Email Generator Email Revision Agent Step 4: Configure Telegram Approval Bot Create bot via Telegram's @BotFather Copy bot token Get your Telegram Chat ID (use @userinfobot) In n8n: Create Telegram credential with bot token Configure Human-in-the-Loop Email Approval node: Add your Chat ID Customize approval message format if desired Step 5: Set Up Gmail Sending Enable 2-factor authentication on Gmail account Generate app password: Google Account β Security β App Passwords In n8n: Create Gmail credential using app password Configure Client Email Delivery node with sender details Step 6: Connect Notion Database Create Notion integration at https://www.notion.so/my-integrations Copy integration token Create database with these properties: Client Name (Title), Email (Email), Contact Number (Phone) Project Address (Text), Project Type (Multi-select) Spaces Included (Text), Budget (Select), Timeline (Date) Classification (Select: HOT/WARM/COLD), Confidence (Select) Estimated Value (Number), Status (Select) Share database with your integration In n8n: Add Notion credential β Paste token Configure Notion Lead Database Manager with database ID Step 7: Customize Classification Rules (Optional) Open AI Lead Scoring Engine node Review classification criteria in the prompt: HOT: 500k+ AED, full renovations, 2+ spaces WARM: 100k+ AED, 2+ spaces COLD: <100k AED OR single space Adjust thresholds to match your business requirements Modify currency if not using AED Step 8: Personalize Email Templates Open Personalized Client Outreach Email Generator node Customize: Company name and branding Signature placeholders ([Your Name], [Title], etc.) Tone and style preferences Alternative designer recommendations for COLD leads Step 9: Test the Workflow Activate the workflow Submit a test form with sample data Monitor each node execution in n8n Check Telegram for approval message Verify email delivery and Notion database entry Step 10: Set Up Error Handling (Recommended) Add error workflow trigger Configure notifications for failed executions Set up retry logic for API failures Workflow Node Breakdown Client Intake Form Trigger Captures lead data from website forms or n8n native forms with all project details. AI Lead Scoring Engine Analyzes intake data using structured logic: budget validation, space counting, and multi-factor evaluation. Returns HOT/WARM/COLD classification with confidence scores. Lead Classification Router Routes leads into three priority workflows based on AI classification, optimizing resource allocation. Sales Team Email Notifier Sends instant alerts to sales representatives with complete lead details and AI reasoning for internal tracking. Personalized Client Outreach Email Generator AI-powered composer creating tailored responses demonstrating genuine understanding of client vision, adapted by lead type. Latest Email Version Controller Captures most recent email output ensuring only final approved version proceeds to delivery. Human-in-the-Loop Email Approval Telegram-based review checkpoint sending generated emails to team member for quality control before client delivery. Approval Decision Router Evaluates reviewer's response, routing approved emails to client delivery or rejected emails to revision agent. Email Revision Agent AI-powered editor refining rejected emails based on feedback while maintaining personalization and brand voice. Client Email Delivery Sends final approved personalized emails demonstrating understanding of project vision with clear next steps. Notion Lead Database Manager Records all potential clients with complete intake data, classification results, and tracking information for pipeline management. Customization Tips Adjust Classification Thresholds: Modify budget ranges and space requirements in the AI Lead Scoring Engine prompt to match your market and service level. Multi-Language Support: Update all AI agent prompts with instructions for your target language. Claude supports 100+ languages. Additional Routing: Add branches for special cases like urgent projects, VIP clients, or specific geographic regions. CRM Integration: Replace Notion with HubSpot, Salesforce, or Airtable using respective n8n nodes. SMS Notifications: Add Twilio node for immediate HOT lead alerts to mobile devices. Troubleshooting Issue: Telegram approval not received Verify bot token is correct Confirm chat ID matches your Telegram account Check bot is not blocked Issue: Claude API errors Verify API key validity and credits Check prompt length isn't exceeding token limits Review rate limits on your Anthropic plan Issue: Gmail not sending Confirm app password (not regular password) is used Check "Less secure app access" if using older method Verify daily sending limits not exceeded Issue: Notion database not updating Confirm integration has access to database Verify property names match exactly (case-sensitive) Check property types align with data being sent Template Metrics Execution Time: ~30-45 seconds per lead (including AI processing) API Calls: 2-3 Claude requests per lead (classification + email generation, +1 if revision) Cost Estimate: ~$0.05-0.15 per lead processed (based on Claude API pricing) Support & Community n8n Community Forum: https://community.n8n.io Template Issues: Report bugs or suggest improvements via n8n template feedback Claude Documentation: https://docs.anthropic.com Notion API Docs: https://developers.notion.com License This template is provided as-is under MIT license. Modify and adapt freely for your business needs. --- Version: 1.0 Last Updated: October 2025 Compatibility: n8n v1.0+ (Cloud & Self-Hosted), Claude API v2024-10+
Automated UGC video generator with Gemini images and SORA 2
This workflow automates the creation of user-generated-content-style product videos by combining Gemini's image generation with OpenAI's SORA 2 video generation. It accepts webhook requests with product descriptions, generates images and videos, stores them in Google Drive, and logs all outputs to Google Sheets for easy tracking. Main Use Cases Automate product video creation for e-commerce catalogs and social media. Generate UGC-style content at scale without manual design work. Create engaging video content from simple text prompts for marketing campaigns. Build a centralized library of product videos with automated tracking and storage. How it works The workflow operates as a webhook-triggered process, organized into these stages: Webhook Trigger & Input Accepts POST requests to the /create-ugc-video endpoint. Required payload includes: product prompt, video prompt, Gemini API key, and OpenAI API key. Image Generation (Gemini) Sends the product prompt to Google's Gemini 2.5 Flash Image model. Generates a product image based on the description provided. Data Extraction Code node extracts the base64 image data from Gemini's response. Preserves all prompts and API keys for subsequent steps. Video Generation (SORA 2) Sends the video prompt to OpenAI's SORA 2 API. Initiates video generation with specifications: 720x1280 resolution, 8 seconds duration. Returns a video generation job ID for polling. Video Status Polling Continuously checks video generation status via OpenAI API. If status is "completed": proceeds to download. If status is still processing: waits 1 minute and retries (polling loop). Video Download & Storage Downloads the completed video file from OpenAI. Uploads the MP4 file to Google Drive (root folder). Generates a shareable Google Drive link. Logging to Google Sheets Records all generation details in a tracking spreadsheet: Product description Video URL (Google Drive link) Generation status Timestamp Summary Flow: Webhook Request β Generate Product Image (Gemini) β Extract Image Data β Generate Video (SORA 2) β Poll Status β If Complete: Download Video β Upload to Google Drive β Log to Google Sheets β Return Response If Not Complete: Wait 1 Minute β Poll Status Again Benefits: Fully automated video creation pipeline from text to finished product. Scalable solution for generating multiple product videos on demand. Combines cutting-edge AI models (Gemini + SORA 2) for high-quality output. Centralized storage in Google Drive with automatic logging in Google Sheets. Flexible webhook interface allows integration with any application or service. Retry mechanism ensures videos are captured even with longer processing times. --- Created by Daniel Shashko
Track personal finances in Google Sheets with AI agent via Slack
Who's it for This workflow is perfect for individuals who want to maintain detailed financial records without the overhead of complex budgeting apps. If you prefer natural language over data entry forms and want an AI assistant to handle the bookkeeping, this template is for you. It's especially useful for: People who want to track cash and online transactions separately Anyone who lends money to friends/family and needs debt tracking Users comfortable with Slack as their primary interface Those who prefer conversational interactions over manual spreadsheet updates What it does This AI-powered finance tracker transforms your Slack workspace into a personal finance command center. Simply mention your bot with transactions in plain English (e.g., "βΉ500 cash food, borrowed βΉ1000 from John"), and the AI agent will: Parse transactions using natural language understanding via Google Gemini Calculate balance changes for cash and online accounts Show a preview of changes before saving anything Update Google Sheets only after you approve Track debts (who owes you, who you owe, repayments) Send daily reminders at 11 PM with current balances and active debts The workflow maintains conversational context using PostgreSQL memory, so you can say things like "yesterday's transactions" or "that payment to Sarah" and it understands the context. How it works Scheduled Daily Check-in (11 PM) Fetches current balances from Google Sheets Retrieves all active debts Formats and sends a Slack message with balance summary Prompts you to share the day's transactions AI Agent Transaction Processing When you mention the bot in Slack: Phase 1: Parse & Analyze Extracts amount, payment type (cash/online), category (food, travel, etc.) Identifies transaction type (expense, income, borrowed, lent, repaid) Stores conversation context in PostgreSQL memory Phase 2: Calculate & Preview Reads current balances from Google Sheets Calculates new balances based on transactions Shows formatted preview with projected changes Waits for your approval ("yes"/"no") Phase 3: Update Database (only after approval) Logs transactions with unique IDs and timestamps Updates debt records with person names and status Recalculates and stores new balances Handles debt lifecycle (Active β Settled) Phase 4: Confirmation Sends success message with updated balances Shows active debts summary Includes logging timestamp Requirements Essential Services: n8n instance (self-hosted or cloud) Slack workspace with admin access Google account Google Gemini API key PostgreSQL database Recommended: Claude AI model (mentioned in workflow notes as better alternative to Gemini) How to set up Google Sheets Setup Create a new Google Sheet with three tabs named exactly: Balances Tab: | Date | CashBalance | OnlineBalance | Total_Balance | |------|--------------|----------------|---------------| Transactions Tab: | TransactionID | Date | Time | Amount | PaymentType | Category | TransactionType | PersonName | Description | Added_At | |----------------|------|------|--------|--------------|----------|------------------|-------------|-------------|----------| Debts Tab: | PersonName | Amount | Type | Datecreated | Status | Notes | |-------------|--------|------|--------------|--------|-------| Add header rows and one initial balance row in the Balances tab with today's date and starting amounts. Slack App Setup Go to api.slack.com/apps and create a new app Under OAuth & Permissions, add these Bot Token Scopes: app_mentions:read chat:write channels:read Install the app to your workspace Copy the Bot User OAuth Token Create a dedicated channel (e.g., personal-finance-tracker) Invite your bot to the channel Google Gemini API Visit ai.google.dev Create an API key Save it for n8n credentials setup PostgreSQL Database Set up a PostgreSQL database (you can use Supabase free tier): Create a new project Note down connection details (host, port, database name, user, password) The workflow will auto-create the required table n8n Workflow Configuration Import the workflow and configure: A. Credentials Google Sheets OAuth2: Connect your Google account Slack API: Add your Bot User OAuth Token Google Gemini API: Add your API key PostgreSQL: Add database connection details B. Update Node Parameters All Google Sheets nodes: Select your finance spreadsheet Slack nodes: Select your finance channel Schedule Trigger: Adjust time if you prefer a different check-in hour (default: 11 PM) Postgres Chat Memory: Change sessionKey to something unique (e.g., financetrackeryour_name) Keep tableName as n8nchathistory_finance or rename consistently C. Slack Trigger Setup Activate the "Bot Mention trigger" node Copy the webhook URL from n8n In Slack App settings, go to Event Subscriptions Enable events and paste the webhook URL Subscribe to bot event: app_mention Save changes Test the Workflow Activate both workflow branches (scheduled and agent) In your Slack channel, mention the bot: @YourBot βΉ100 cash snacks Bot should respond with a preview Reply "yes" to approve Verify Google Sheets are updated How to customize Change Transaction Categories Edit the AI Agent's system message to add/remove categories. Current categories: travel, food, entertainment, utilities, shopping, health, education, other Modify Daily Check-in Time Change the Schedule Trigger's triggerAtHour value (0-23 in 24-hour format). Add Currency Support Replace βΉ with your currency symbol in: Format Daily Message code node AI Agent system prompt examples Switch AI Models The workflow uses Google Gemini, but notes recommend Claude. To switch: Replace "Google Gemini Chat Model" node Add Claude credentials Connect to AI Agent node Customize Debt Types Modify AI Agent's system prompt to change debt handling logic: Currently: IOwe and TheyOwe_Me You can add more types or change naming Add More Payment Methods Current: cash, online To add more (e.g., credit card): Update AI Agent prompt Modify Balances sheet structure Update balance calculation logic Change Approval Keywords Edit AI Agent's Phase 2 approval logic to recognize different approval phrases. Add Spending Analytics Extend the daily check-in to calculate: Weekly/monthly spending summaries Category-wise breakdowns Use additional Code nodes to process transaction history Important Notes β οΈ Never trigger with normal messages - Only use app mentions (@botname) to avoid infinite loops where the bot replies to its own messages. π‘ Context Awareness - The bot remembers conversation history, so you can reference "yesterday", "last week", or previous transactions naturally. π Data Privacy - All your financial data stays in your Google Sheets and PostgreSQL database. The AI only processes transaction text temporarily. π Backup Regularly - Export your Google Sheets periodically as backup. --- Pro Tips: Start with small test transactions to ensure everything works Use consistent person names for debt tracking The bot understands various formats: "βΉ500 cash food" = "paid 500 rupees in cash for food" You can batch transactions in one message: "βΉ100 travel, βΉ200 food, βΉ50 snacks"