Render custom text over images
This workflow gets triggered every Friday at 6 PM with the help of a Cron node. It pulls in data about a random cocktail via the HTTP Request Node and sends the data to a Bannerbear node to create an image based on a template. The image is then finally shared on a specified Rocket.Chat channel.
n8n Workflow: Render Custom Text Over Images with Bannerbear
This n8n workflow demonstrates how to automate the creation of custom images by rendering text over a base image using Bannerbear. It's triggered on a schedule, makes an HTTP request (though not fully configured in the provided JSON), and then uses Bannerbear to generate an image before potentially posting a message to RocketChat.
What it does
This workflow simplifies the process of dynamically generating images with custom text overlays.
- Scheduled Trigger: The workflow is initiated on a recurring schedule (configured via the Cron node).
- HTTP Request (Placeholder): It includes an HTTP Request node, which is currently unconfigured. This node could be used to fetch data (e.g., text content, image URLs) from an external API or database.
- Generate Image with Bannerbear: It utilizes the Bannerbear node to create an image. This node is designed to take a template and dynamic text/image inputs to render a new image.
- Post to RocketChat (Placeholder): The workflow includes a RocketChat node, currently unconfigured. This node could be used to post the newly generated image or a link to it to a RocketChat channel.
Prerequisites/Requirements
- n8n Instance: A running n8n instance.
- Bannerbear Account: An active Bannerbear account with an API Key and at least one image template configured.
- RocketChat Account (Optional): If you intend to use the RocketChat integration, you'll need a RocketChat account and appropriate credentials.
Setup/Usage
-
Import the Workflow:
- Copy the provided JSON code.
- In your n8n instance, go to "Workflows" and click "New".
- Click the three dots in the top right corner and select "Import from JSON".
- Paste the JSON code and click "Import".
-
Configure Credentials:
- Bannerbear: Click on the "Bannerbear" node. You will need to set up a Bannerbear API credential.
- In the Bannerbear node settings, select "Create New Credential".
- Enter your Bannerbear API Key.
- RocketChat (Optional): If you plan to use the RocketChat node, click on it and configure your RocketChat API credentials (e.g., API Key, User ID, Host).
- Bannerbear: Click on the "Bannerbear" node. You will need to set up a Bannerbear API credential.
-
Configure Nodes:
- Cron: Adjust the schedule in the "Cron" node to your desired frequency.
- HTTP Request: If you have an external data source, configure the "HTTP Request" node to fetch the necessary text or image data.
- Bannerbear:
- Select the "Operation" (e.g., "Create Image").
- Choose your Bannerbear "Template ID".
- Map the data from previous nodes (or provide static values) to the "Modifications" section to customize the text and images on your Bannerbear template.
- RocketChat: If using, configure the "RocketChat" node to post the generated image URL or a message to your desired channel.
-
Activate the Workflow: Once configured, enable the workflow by toggling the "Active" switch in the top right corner of the workflow editor.
Related Templates
Synchronizing WooCommerce inventory and creating products with Google Gemini AI and BrowserAct
Synchronize WooCommerce Inventory & Create Products with Gemini AI & BrowserAct This sophisticated n8n template automates WooCommerce inventory management by scraping supplier data, updating existing products, and intelligently creating new ones with AI-formatted descriptions. This workflow is essential for e-commerce operators, dropshippers, and inventory managers who need to ensure their product pricing and stock levels are synchronized with multiple third-party suppliers, minimizing overselling and maximizing profit. --- Self-Hosted Only This Workflow uses a community contribution and is designed and tested for self-hosted n8n instances only. --- How it works The workflow is typically run by a Schedule Trigger (though a Manual Trigger is also shown) to check stock automatically. It reads a list of suppliers and their inventory page URLs from a central Google Sheet. The workflow loops through each supplier: A BrowserAct node scrapes the current stock and price data from the supplier's inventory page. A Code node parses this bulk data into individual product items. It then loops through each individual product found. The workflow checks WooCommerce to see if the product already exists based on its name. If the product exists: It proceeds to update the existing product's price and stock quantity. If the product DOES NOT exist: An If node checks if the missing product's category matches a predefined type (optional filtering). If it passes the filter, a second BrowserAct workflow scrapes detailed product attributes from a dedicated product page (e.g., DigiKey). An AI Agent (Gemini) transforms these attributes into a specific, styled HTML table for the product description. Finally, the product is created in WooCommerce with all scraped details and the AI-generated description. Error Handling: Multiple Slack nodes are configured to alert your team immediately if any scraping task fails or if the product update/creation process encounters an issue. Note: This workflow does not support image uploads for new products. To enable this functionality, you must modify both the n8n and BrowserAct workflows. --- Requirements BrowserAct API account for web scraping BrowserAct n8n Community Node -> (n8n Nodes BrowserAct) BrowserAct templates named โWooCommerce Inventory & Stock Synchronizationโ and โWooCommerce Product Data Reconciliationโ Google Sheets credentials for the supplier list WooCommerce credentials for product management Google Gemini account for the AI Agent Slack credentials for error alerts --- Need Help? How to Find Your BrowseAct API Key & Workflow ID How to Connect n8n to Browseract How to Use & Customize BrowserAct Templates How to Use the BrowserAct N8N Community Node --- Workflow Guidance and Showcase STOP Overselling! Auto-Sync WooCommerce Inventory from ANY Supplier
Dynamic Hubspot lead routing with GPT-4 and Airtable sales team distribution
AI Agent for Dynamic Lead Distribution (HubSpot + Airtable) ๐ง AI-Powered Lead Routing and Sales Team Distribution This intelligent n8n workflow automates end-to-end lead qualification and allocation by integrating HubSpot, Airtable, OpenAI, Gmail, and Slack. The system ensures that every new lead is instantly analyzed, scored, and routed to the best-fit sales representative โ all powered by AI logic, sir. --- ๐ก Key Advantages โก Real-Time Lead Routing Automatically assigns new leads from HubSpot to the most relevant sales rep based on region, capacity, and expertise. ๐ง AI Qualification Engine An OpenAI-powered Agent evaluates the leadโs industry, region, and needs to generate a persona summary and routing rationale. ๐ Centralized Tracking in Airtable Every lead is logged and updated in Airtable with AI insights, rep details, and allocation status for full transparency. ๐ฌ Instant Notifications Slack and Gmail integrations alert the assigned rep immediately with full lead details and AI-generated notes. ๐ Seamless CRM Sync Updates the original HubSpot record with lead persona, routing info, and timeline notes for audit-ready history, sir. --- โ๏ธ How It Works HubSpot Trigger โ Captures a new lead as soon as itโs created in HubSpot. Fetch Contact Data โ Retrieves all relevant fields like name, company, and industry. Clean & Format Data โ A Code node standardizes and structures the data for consistency. Airtable Record Creation โ Logs the lead data into the โLeadsโ table for centralized tracking. AI Agent Qualification โ The AI analyzes the lead using the TeamDatabase (Airtable) to find the ideal rep. Record Update โ Updates the same Airtable record with the assigned team and AI persona summary. Slack Notification โ Sends a real-time message tagging the rep with lead info. Gmail Notification โ Sends a personalized handoff email with context and follow-up actions. HubSpot Sync โ Updates the original contact in HubSpot with the assignment details and AI rationale, sir. --- ๐ ๏ธ Setup Steps Trigger Node: HubSpot โ Detect new leads. HubSpot Node: Retrieve complete lead details. Code Node: Clean and normalize data. Airtable Node: Log lead info in the โLeadsโ table. AI Agent Node: Process lead and match with sales team. Slack Node: Notify the designated representative. Gmail Node: Email the rep with details. HubSpot Node: Update CRM with AI summary and allocation status, sir. --- ๐ Credentials Required HubSpot OAuth2 API โ To fetch and update leads. Airtable Personal Access Token โ To store and update lead data. OpenAI API โ To power the AI qualification and matching logic. Slack OAuth2 โ For sending team notifications. Gmail OAuth2 โ For automatic email alerts to assigned reps, sir. --- ๐ค Ideal For Sales Operations and RevOps teams managing multiple regions B2B SaaS and enterprise teams handling large lead volumes Marketing teams requiring AI-driven, bias-free lead assignment Organizations optimizing CRM efficiency with automation, sir --- ๐ฌ Bonus Tip You can easily extend this workflow by adding lead scoring logic, language translation for follow-ups, or Salesforce integration. The entire system is modular โ perfect for scaling across global sales teams, sir.
Tax deadline management & compliance alerts with GPT-4, Google Sheets & Slack
AI-Driven Tax Compliance & Deadline Management System Description Automate tax deadline monitoring with AI-powered insights. This workflow checks your tax calendar daily at 8 AM, uses GPT-4 to analyze upcoming deadlines across multiple jurisdictions, detects overdue and critical items, and sends intelligent alerts via email and Slack only when immediate action is required. Perfect for finance teams and accounting firms who need proactive compliance management without manual tracking. ๐๏ธ๐ค๐ Good to Know AI-Powered: GPT-4 provides risk assessment and strategic recommendations Multi-Jurisdiction: Handles Federal, State, and Local tax requirements automatically Smart Alerts: Only notifies executives when deadlines are overdue or critical (โค3 days) Priority Classification: Categorizes deadlines as Overdue, Critical, High, or Medium priority Dual Notifications: Critical alerts to leadership + daily summaries to team channel Complete Audit Trail: Logs all checks and deadlines to Google Sheets for compliance records How It Works Daily Trigger - Runs at 8:00 AM every morning Fetch Data - Pulls tax calendar and company configuration from Google Sheets Analyze Deadlines - Calculates days remaining, filters by jurisdiction/entity type, categorizes by priority AI Analysis - GPT-4 provides strategic insights and risk assessment on upcoming deadlines Smart Routing - Only sends alerts if overdue or critical deadlines exist Critical Alerts - HTML email to executives + Slack alert for urgent items Team Updates - Slack summary to finance channel with all upcoming deadlines Logging - Records compliance check results to Google Sheets for audit trail Requirements Google Sheets Structure Sheet 1: TaxCalendar DeadlineID | DeadlineName | DeadlineDate | Jurisdiction | Category | AssignedTo | IsActive FED-Q1 | Form 1120 Q1 | 2025-04-15 | Federal | Income | John Doe | TRUE Sheet 2: CompanyConfig (single row) Jurisdictions | EntityType | FiscalYearEnd Federal, California | Corporation | 12-31 Sheet 3: ComplianceLog (auto-populated) Date | AlertLevel | TotalUpcoming | CriticalCount | OverdueCount 2025-01-15 | HIGH | 12 | 3 | 1 Credentials Needed Google Sheets - Service Account OAuth2 OpenAI - API Key (GPT-4 access required) SMTP - Email account for sending alerts Slack - Bot Token with chat:write permission Setup Steps Import workflow JSON into n8n Add all 4 credentials Replace these placeholders: YOURTAXCALENDAR_ID - Tax calendar sheet ID YOURCONFIGID - Company config sheet ID YOURLOGID - Compliance log sheet ID C12345678 - Slack channel ID tax@company.com - Sender email cfo@company.com - Recipient email Share all sheets with Google service account email Invite Slack bot to channels Test workflow manually Activate the trigger Customizing This Workflow Change Alert Thresholds: Edit "Analyze Deadlines" node: Critical: Change <= 3 to <= 5 for 5-day warning High: Change <= 7 to <= 14 for 2-week notice Medium: Change <= 30 to <= 60 for 2-month lookout Adjust Schedule: Edit "Daily Tax Check" trigger: Change hour/minute for different run time Add multiple trigger times for tax season (8 AM, 2 PM, 6 PM) Add More Recipients: Edit "Send Email" node: To: cfo@company.com, director@company.com CC: accounting@company.com BCC: archive@company.com Customize Email Design: Edit "Format Email" node to change colors, add logo, or modify layout Add SMS Alerts: Insert Twilio node after "Is Critical" for emergency notifications Integrate Task Management: Add HTTP Request node to create tasks in Asana/Jira for critical deadlines Troubleshooting | Issue | Solution | |-------|----------| | No deadlines found | Check date format (YYYY-MM-DD) and IsActive = TRUE | | AI analysis failed | Verify OpenAI API key and account credits | | Email not sending | Test SMTP credentials and check if critical condition met | | Slack not posting | Invite bot to channel and verify channel ID format | | Permission denied | Share Google Sheets with service account email | ๐ Professional Services Need help with implementation or customization? Our team offers: ๐ฏ Custom workflow development ๐ข Enterprise deployment support ๐ Team training sessions ๐ง Ongoing maintenance ๐ Custom reporting & dashboards ๐ Additional API integrations Discover more workflows โ Get in touch with us