Workflow Templates

📊 Log BTC/ETH Prices and USD Exchange Rates to Notion (Hourly) 📌 Overview This workflow automatically logs live crypto prices (Bitcoin & Ethereum) and fiat exchange rates (USD→EUR / USD→NGN) into a Notion database every hour. Each entry becomes a new row in your Notion dashboard, letting you visualize currency and crypto trends side by side. It’s perfect for traders, analysts, and anyone who wants a single source of truth in Notion without needing multiple apps open. With hourly updates, you’ll have a clean data history for building rollups, trend graphs, or financial dashboards. ⚙️ How it works Schedule Trigger — runs every hour (adjustable via cron). HTTP Request (ExchangeRate-API) — fetches USD-base FX rates (no API key required). HTTP Request (CoinGecko) — fetches BTC & ETH prices + 24h % change (no API key required). Merge — combines both payloads. Code (v2) — formats a Notion-ready JSON payload with the correct fields. Notion Node — creates a new page in your database with mapped properties. Example Row in Notion: Title: Crypto+FX — 2025-09-08 09:00 BTC: 112,417 | BTC_24h: +1.22% ETH: 4,334.57 | ETH_24h: +1.33% USD→EUR: 0.854 | USD→NGN: ₦1,524.54 🛠 Setup Guide 1) Create the Notion database In Notion, create a new database (Table view). Add these columns with matching property types: | Column | Property Type | |------------|---------------| | Title | Title | | BTC | Number | | BTC_24h | Number | | ETH | Number | | ETH_24h | Number | | USD_EUR | Number | | USD_NGN | Number | 2) Connect Notion in n8n In the Notion “Create Page” node, connect with your Notion OAuth2 credentials. On first use, you’ll be redirected to authorize n8n with your Notion workspace. Copy your Database ID (from the Notion URL) and paste it into the node. 3) Map the Code output The Code node outputs JSON fields: BTC, BTC_24h, ETH, ETH_24h, USD_EUR, USD_NGN. In the Notion node, map each property: BTC → {{$json.BTC}} BTC_24h → {{$json.BTC_24h}} ETH → {{$json.ETH}} ETH_24h → {{$json.ETH_24h}} USD_EUR → {{$json.USD_EUR}} USD_NGN → {{$json.USD_NGN}} 4) Test Run the workflow once. Confirm that a new page is added to your Notion database with all values filled. 🎛 Customization Cadence:** change the schedule to 10 minutes, 4 hours, or daily depending on your needs. Extra coins:** add more IDs (e.g., solana, bnb) in the CoinGecko call and update the Code node. Extra FX pairs:** expand from ExchangeRate-API (e.g., USD→GBP, USD→ZAR). Notion dashboards:** use rollups, charts, and linked databases for trend visualization. Formatting:** add emojis, colors, or sections in your Notion view for clarity. 🧩 Troubleshooting Page not created:** verify Database ID and ensure the Notion API integration has access. Empty fields:** check that property names in Notion exactly match those used in the Code node. Wrong data type:* make sure properties are set as *Number**, not Text. Rate limits:** CoinGecko and ExchangeRate-API are free but may rate-limit if called too often; keep cadence reasonable (hourly recommended).

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 1. Prepare BigQuery Create a table (e.g., quickbooks.accounts) with columns matching the final SQL insert step. 2. Add Credentials Connect QuickBooks Online and BigQuery credentials in n8n. 3. 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. 4. 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. 5. 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.

Automatic Clean Up Expired AWS ACM Certificates with Human Approval > Automate the cleanup of expired AWS ACM certificates with Slack-based approval. This workflow helps maintain a secure and tidy AWS environment by detecting expired SSL certs, sending detailed Slack notifications to admins, and deleting them upon approval, ensuring full visibility and control over certificate lifecycle management. 🧑‍💼 Who’s it for This workflow is designed for: AWS administrators** who want to keep their environment clean and secure DevOps teams** managing SSL lifecycle in AWS ACM IT Admins** needing visibility and control over expired cert removal Teams that use Slack for collaboration and approvals ⚙️ How it works / What it does This automated workflow performs the following tasks on a daily schedule: Fetch all ACM certificates in your AWS account. Filter out the expired ones by comparing expiration date and status. Send a Slack approval message with certificate details to the admin team. Wait for approval response directly in Slack (✅ to approve deletion). If approved, it deletes the expired certificate using AWS ACM. Finally, it notifies the IT admin about the action taken. 🔧 How to set up Create the Workflow Add the nodes as shown: Schedule Trigger AWS - ACM: listCertificates AWS - ACM: describeCertificate (loop per cert) IF Node to filter expired certs Slack - Send & Wait for Reaction AWS - ACM: deleteCertificate Slack - Post Message to notify Configure Slack Create a Slack Bot Token with: chat:write reactions:read channels:read Connect it in your Slack nodes. Configure AWS Credentials Use IAM User or Role with: acm:ListCertificates acm:DescribeCertificate acm:DeleteCertificate Set schedule Daily, Weekly, or custom cron expression. 📋 Requirements | Component | Description | |------------------|--------------------------------------| | AWS ACM Access | IAM permissions for ACM actions | | Slack Bot Token | With chat:write & reactions:read | | n8n Environment | Self-hosted or n8n Cloud | | Slack Channel | Where approval messages will be sent | 🛠️ How to customize the workflow 🕒 Change waiting time Adjust the wait time before checking Slack reactions in the sendAndWait node (default 1 hour). 👥 Change Slack target Change the Slack channel or tag specific people (<@U123456>). 📓 Add logging Add Google Sheets, Notion, or DynamoDB to log certificate details and approval decisions. 🧪 Add dry-run/test mode Use an IF node before deletion to simulate removal when ENV === dry-run.

CHRO Agent with HR Team Description Complete AI-powered HR department with a Chief Human Resources Officer (CHRO) agent orchestrating specialized HR team members for comprehensive people operations. Overview This n8n workflow creates a comprehensive human resources department using AI agents. The CHRO agent analyzes HR requests and delegates tasks to specialized agents for recruitment, policy development, training, performance management, employee engagement, and compensation analysis. Features Strategic CHRO agent using OpenAI O3 for complex HR decision-making Six specialized HR agents powered by GPT-4.1-mini for efficient execution Complete HR lifecycle coverage from hiring to retention Automated policy creation and compliance documentation Performance review and goal-setting systems Employee engagement and culture initiatives Compensation analysis and benchmarking Team Structure CHRO Agent**: Strategic HR oversight and task delegation (O3 model) Recruiter Agent**: Job descriptions, candidate screening, interview questions HR Policy Writer**: Employee handbooks, policies, compliance documentation Training & Development Specialist**: Onboarding programs, learning materials Performance Review Specialist**: Reviews, feedback templates, goal setting Employee Engagement Specialist**: Culture initiatives, team building, communications Compensation & Benefits Analyst**: Salary benchmarking, benefits packages How to Use Import the workflow into your n8n instance Configure OpenAI API credentials for all chat models Deploy the webhook for chat interactions Send HR requests via chat (e.g., "Create a complete onboarding program for software engineers") The CHRO will analyze and delegate to appropriate specialists Receive comprehensive HR deliverables Use Cases Complete Hiring Process**: Job postings → Screening → Interviews → Offers Policy Development**: Employee handbooks, compliance documentation Onboarding Programs**: 30-60-90 day plans with training materials Performance Management**: Review cycles, feedback systems, development plans Culture & Engagement**: Surveys, team building activities, recognition programs Compensation Strategy**: Market analysis, pay equity reviews, benefits design Requirements n8n instance with LangChain nodes OpenAI API access (O3 for CHRO, GPT-4.1-mini for specialists) Webhook capability for chat interactions Optional: Integration with HRIS systems Cost Optimization O3 model used only for strategic CHRO decisions GPT-4.1-mini provides 90% cost reduction for specialist tasks Parallel processing enables simultaneous agent execution Template library reduces redundant content generation Integration Options Connect to HRIS systems (Workday, BambooHR, etc.) Integrate with applicant tracking systems Link to performance management platforms Export to document management systems Contact & Resources Website**: nofluff.online YouTube**: @YaronBeen LinkedIn**: Yaron Been Tags #HRTech #PeopleOperations #TalentAcquisition #EmployeeExperience #HRAutomation #AIRecruitment #PerformanceManagement #CompensationBenefits #OnboardingAutomation #CultureTech #n8n #OpenAI #MultiAgentSystem #FutureOfWork #HRTransformation

This n8n template generates a dynamic weekly sales report from Airtable and sends it to Slack. It calculates key sales metrics like total pipeline value, weighted pipeline (based on deal stage), top deal, closed revenue, and win rate.. all formatted in a clean Slack message. How it works A schedule trigger starts the workflow (e.g., every Monday). It fetches deal data from Airtable, splits open vs closed deals, calculates all metrics with JavaScript, and formats the output. The message is then sent to Slack using Markdown for readability. How to use Update the Airtable credentials and select your base and table with fields: Deal Name, Value, Status, etc. Set the Slack channel in the final node to your preferred sales or ops channel. Requirements Airtable base with relevant deal data (see field structure) Slack webhook or token for sending messages Customising this workflow You can adapt the logic to other CRMs like Salesforce or HubSpot, add charts, or tweak stage weights. You can also change the schedule or add filters (e.g., by rep or region).

Pre‑Built AI Customer Service System for Businesses | n8n, Gemini & Notion 💥 What It Does Revolutionize your client interactions with this Done‑For‑You AI Customer Service & Lead Routing System. This advanced n8n workflow, powered by Google Gemini and integrated with Notion, is pre-configured and ready to deploy, instantly transforming how you handle inquiries. Stop losing valuable time to manual support and inefficient lead qualification; this system intelligently routes messages, retrieves information from your Notion database, and provides personalized assistance from day one. It's the ultimate shortcut to professional, scalable customer engagement and lead conversion, delivered as a fully set up automation. ⚙️ Key Features ⚡ Instant AI Lead Routing:* Automatically classifies incoming messages (customer service, questions, booking) and directs them to the right AI agent for a seamless user experience. 🧠 Multi-Agent AI System:* Includes specialized AI agents for comprehensive customer support, product/service inquiries, and automated consultation booking. 💡 Notion-Powered Knowledge Base:* Leverages your existing Notion databases to pull accurate, contextual information for personalized responses and solutions. 🤝 Personalized Customer Support:* The Customer Service Agent accesses Notion CRM to provide tailored support based on customer history and previous interactions. 📈 Automated Consultation Booking:* The Booking Agent streamlines scheduling by guiding users to your intake forms, qualifying leads effortlessly. 😩 Pain Points Solved Sick of wasting countless hours on manual customer service inquiries and support? Tired of slow response times costing you valuable leads and frustrating clients? Struggling to build a complex AI chatbot system from scratch with no prior experience? Overwhelmed by disorganized customer data and scattered product information? Missing out on potential sales opportunities due to inefficient lead qualification processes? 📦 What’s Included Fully configured n8n AI Chatbot workflow for instant deployment Pre-integrated Google Gemini language models and AI agents Ready-to-connect Notion CRM and knowledge base tools Comprehensive, step-by-step deployment and launch guide Ongoing access to future updates and enhancements 🚀 Call to Action Launch your AI customer powerhouse today. No setup, no stress, just instant results. 🏷️ Optimized Tags done for you ai, n8n workflow, ai chatbot, customer service automation, lead qualification, notion integration, google gemini, pre built system, ai agent, business automation, digital product, ready to use, instant deploy

This workflow allows you to create, update, and get a person from Copper. Copper node: This node will create a new person in Copper. Copper1 node: This node will update the information of the person that we created using the previous node. Copper2 node: This node will retrieve the information of the person that we created earlier.

🧑‍💻 Description This workflow connects SerpApi with OpenAI inside n8n to automate Google News monitoring and analysis. It’s built for market researchers, analysts, communications teams, and business leaders who need to stay on top of fast-changing news without wasting time scrolling through endless headlines. Instead of manually searching, this workflow automatically fetches news, groups it into meaningful categories, and recommends the most relevant articles. Problem it solves: Reduces time spent manually monitoring news. Helps track competitors, industries, or emerging trends. Provides structured, actionable insights from unstructured headline feeds. Disclaimer: this template can only be used on self-hosted installations. 📌 Use Cases Market Intelligence**: Track industry-specific news to guide strategy. Competitor Monitoring**: Automatically surface competitor mentions in the press. Research Support**: Organize articles into categories for academic or professional projects. Executive Briefings**: Deliver a curated daily digest to stakeholders. Trend Spotting**: Detect recurring topics to understand where coverage is growing. ⚙️ Setup Instructions Preconditions You need a self-hosted n8n instance (this template doesn’t run on n8n.cloud). A valid SerpApi account + API Key. An OpenAI API Key with billing enabled. Optional: Connected Slack, Email, or Google Sheets credentials if you plan to extend output. 1️⃣ Set Up SerpApi Connection Create a free account at SerpApi Copy your API Key from the dashboard In n8n → Credentials → New → SerpApi Paste your API Key → Save In the workflow, select your SerpApi credential in the Google News Search node. 2️⃣ Set Up OpenAI Connection Go to OpenAI Platform Navigate to Billing and ensure your account has credits/funding Copy your API Key into the OpenAI credentials in n8n 🧠 Workflow Breakdown Chat Trigger → A user enters a search query (e.g., “EV market 2025”). Google News Search (SerpApi) → Fetches the latest headlines for that query. Split Out Links → Separates articles into individual items. Aggregate Node → Merges article titles and links into a structured list. OpenAI Agent → Summarizes, categorizes, and selects the most relevant article per category. Response Output → Returns a clean, categorized digest with clickable links. 🎛️ Customization Guidance Adjust Categories**: Change the OpenAI system prompt to return 3, 5, or 10 categories depending on the depth you want. Regional Focus**: Use SerpApi’s filters (gl=us, hl=en) to restrict results by geography or language. Delivery Methods**: Add Slack, Email, or Google Sheets nodes to automatically share the digest with your team. Automation Frequency: Add a **Schedule Trigger to run daily, weekly, or at custom intervals. Extended Analysis**: Modify the prompt to include sentiment analysis, top keywords, or executive summaries. Multi-Query Runs**: Duplicate the SerpApi node to monitor multiple industries or competitors in one workflow. 💬 Example Q&A Question: “What’s happening in renewable energy today?” Response: Policy**: “US expands solar subsidies” – [link] Innovation**: “New battery breakthrough announced” – [link] Market Moves**: “Wind energy stocks surge” – [link] Competition**: “Shell invests in offshore projects” – [link] Sustainability**: “Community solar initiatives expand” – [link] 📬 Contact Need help customizing this template (e.g., tracking multiple industries, adding auto-delivery, or integrating dashboards)? 📧 robert@ynteractive.com 🔗 Robert Breen 🌐 ynteractive.com

Who's it for Digital marketing agencies and Meta Ads managers who need to generate comprehensive performance reports across multiple client accounts automatically. Perfect for agencies handling 5+ Meta Ads accounts who want to save hours on manual reporting while delivering AI-powered insights to their teams. What it does Pulls performance data from multiple Meta Ads accounts for a specified time period (last 7, 14, or 30 days) Uses Claude AI with Pipeboard's Meta Ads MCP to analyze campaign performance, identify trends, and generate actionable insights Generates professional reports with AI-driven recommendations for optimization Automatically delivers formatted reports to your Slack channels Runs on a schedule (weekly/daily) or triggered manually How to set up Set up Claude AI integration (requires Anthropic API key) Configure Pipeboard's Meta Ads MCP connection Connect Slack to n8n via OAuth2 Create a list of client account IDs in the workflow configuration Customize your reporting template and Slack delivery settings Requirements n8n version 1.109.2 or newer. Claude AI API access (Anthropic) Pipeboard account Slack workspace access How to customize the workflow Adjust the date range and metrics to track Modify the AI prompts for different types of insights Configure multiple Slack channels for different clients Set up custom scheduling intervals Add email delivery as an additional output channel

Keep your Google Sheets contacts in sync with SeaTable Update or Insert records in SeaTable How it works Use a Google Sheet as your central contact list. For each contact in the sheet: Check if the record already exists in SeaTable (based on email). If it exists → update the record. If it doesn’t → insert the new contact. How to use Copy the Google Sheet Template Link. Get the Google Sheet ID (the string between d/ and /edit). In the workflow, set the Sheet ID in the settings node. In SeaTable, create or update a base with a Table1 containing these fields: email firstname lastname company Configure your Google Sheets and SeaTable credentials in n8n. Add your own contacts to the Google Sheet & run the workflow Requirements Google credentials (for Sheets access) SeaTable account (Cloud) n8n (tested on version 1.105.2, Ubuntu) Example use cases Maintain a central CRM-like database in SeaTable. Ensure consistent contact data when collecting leads in Google Sheets. Automate record deduplication (prevent duplicate entries). Need Help? Join the discussion here or contact me directly on LinkedIn. Ask the community in the n8n Forum.

.toLowerCase(). .toUpperCase(). .replace - .replace('Un León', 'Una Jirafa'). Junta las salidas. Junta las salidas

This still needs to be reconfigured to grab the information from the second Matrix node. Have an issue with the