# templates

name: Upload Large Files to Kommo/AmoCRM with Automatic File Chunking
author_name: yatolstoy
author_username: yatolstoy
categories: []
created_at: 2025-05-07T15:10:30.214Z
updated_at: 2025-05-07T15:10:30.214Z
url: https://n8n.io/workflows/3922
scraped_at: 2025-12-24 13:02:46
description:
  Upload files from any source to your account Kommo or AmoCRM with a simple and reusable workflow.
  Advantages of workflow
  It can split a large file into small ones and upload chunks.
  Works for Kommo and amoCRM
  There are 3 required parameters in total (drive_url, file_name and file_base64)
  Where it can be useful
  To send files in a message to clients chat in Kommo or amoCRM
  To upload the generated files to the transaction or contact fields
  To upload files to notes
  How it works
  Checking the file availability
  Opening the session to download the file
  Split the file into chunks, if necessary.
  Send parts of the file to CRM one at a time.
  Installation Steps
  Import workflow
  Configuring Oauth2 credentials in Kommo or amoCRM
  Applying credentials for specific workflow steps
  Specifying the link to the file and the disk_url address
  Launching a workflow to upload a file to a Kommo or amoCRM account

nodes_used:
  ["n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.code","n8n-nodes-base.merge","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.stopAndError","n8n-nodes-base.code","n8n-nodes-base.limit","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.splitInBatches","n8n-nodes-base.convertToFile","n8n-nodes-base.if","n8n-nodes-base.stopAndError","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.manualTrigger","n8n-nodes-base.extractFromFile","n8n-nodes-base.httpRequest","n8n-nodes-base.executeWorkflow","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.convertToFile","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE62ZS28bRxLHvwrBs9ro90O33SAOAmwSIHZ2D4EP1d3V0sDUUDscJXYMffdUU7L4alIcOhdCIJs1P9bzX60v8zscYX79Zd71qxH6hD/m+fVcuOKUR5TaclN40tJlF7KyVnKQwrkYcikQbOTexMIzvc2FNDGabG3U88ereb/MuJpf/06mq0mtSgbhLFMGItNeSxa5FMyqaEoKIRSX5/QtuEM6vVhCftstkN4ZP9/Xd3rfs7VJFmGFb27H8f5X/P8DrkY6c79cdWO37Olxkkt+xSz/QO/CQNZGHAjjCxENOA6ff+nfQreYX4/DAz4Z/y8dWH9Xv5GPV8+4IggjlEOGWUqmczYMitHM6WQyNx6w2A3uDY6/DYujsCvcgxSeE6TQLcodJPVGvyBhpjjkrBg3RKOtUcx7DAwEVzKXYJSGDVLX3z+MR4nwE6aHEf+3HD6WxfLP90N3c4PDLiSz8jxI8Ua8QALnPvCcWdRekd9AsGhCYdFGAVqDMKrs+K1G+V33F/7Y//vzSAlzjDjRn7t8mujk63SbmEqfitJRMC1DYNp5zoAynMXsndQ+CRe22H7C4eZ4/t09f7rN488DUlvuUkZhds4wlRW5ywbHoneeJRe0CRBl0GmDlAaEEd/ham1oemnYGk9rXgPcrgPPhTERDCugCZBTPIPzhZUSs1FWSaVwK+lWPwxEOLy/xf4n+HQUsSu7ZI6fGcstMpu4ly4oVrBwpo3hLHgrWErJqAzSaMU3ZD8vZ2VAnOVu9XG2uod0PLSrcXn/rz5/PwzLvYoItSDUGQWxcZ9HQR4PjF6B6SSpZkUEloslDzpZAoQN5Lv7RbcuiPfL724f+o9TqoEecF61bjxIDnRcomNKAcXWW8kCZMt8sEo4pWzEreQbcPWwON5RFt1d1+xyk/zFi84qW8N4MeQvdJF5rZHRpLEJDQdvtqbEu7FLHz/Pfl6OKE6Esx6qZ/boKhs/KIZ5WvYj9iMZmh/npGGYpIia2YDkOpmAhaLIf9KkgMH7wmOTU07mtDWumh848UzQGKU2yTFudXVoBQ30krzTVoKB4GUTVE13qODfQoqUcqFWSQqkDXRcl0qxzCBG50TyinTFC+l/lsv72S9/4DCr9TJ7pVxWtbBowsCYbtczZhvb+DNn8QtqMVxlnjIrmVuqas3rEK7VI0gPQRI2bzXF75Y9cY6zcTk7KWnS07n3y+dT26NYnDlbtkexNL6oQFIhGEpUnW1iQcTMAGVKWXOaPVsS5hZWJ+n2W3YN9Hn9Zqtnm6AsT1EyEWNhmvAoxkEzT29bm3mOOu727Brcr514art+8tqU9pM1DWMJlkkRSKRGXaedo8GCQlrkCF6XZrXYydWyHsbywlrhRVDqkZJx1DCZVkkTJ2ZGdSIdMSZU7TY5HZOTzPIXYposQUVSC6IEqhNHwia6VF8QLaLLRfAmppnMyWyVgxSlC1FpBIYcjGFYNYTWKrIoIbCsRBTWWlGcaaLqC1HtpU5NSQDtH5yReqA1IAbq6IpS1qPPyRjFVUnbpFBbD2nBrr85rmahf4DFkS2Ar/epCVWkvLQRSJlJSeuJFt7RzCnAii8mAdpihDxsj+tSpx5ZgayercbhFDF+GgdI49theddql3YqM3raVwJ1JqpyqigdkTYYqqhMH2RVrC9FbJh/wCfe6RqcKX8e2rYITw7Id04xR1VDdaRo3vDoGUlc2pqLcg7cBu63+7o9n+bb2//2FMeZztsW4yomxxMVOSLJDEHiDVB55sDXjVAp50WzfNyF5RMuLfRsaI02tvZKXwNd7yFKTVMAWgogRyP2Ap2H7g+cPZzY749He60t/GGpT7yNwJgjd+RP7rytWxglAOjIwMlkY0TSsW256ae7V1f3uktVnMpZJCtJthtetzIScORTzUQO1F1NiMXrJmmYTOq/hTMbVxT1I3Ih1ZWmcUoyyUjKWgDpSDAF5duLBp/u0nXN+0sz1mkUENHSaKrCmFMaBGcts4KDUxG1Fe3gi+lLEfOynbDnofpEfnXGUY9Ka9TEalHRKA0kXksyWrs26vS96Hniq0vdis6QONaUn0mQFhUyV3FSWIxaisK1h3QkAy5Yjew3iRPU5FgQyJJT5NtCijTSfs5i5iRaAAkJ26jT1ckTqrhUmWplpEJVmFG0tmsvHfMBJCvkYBIuIoHcqv+vs58eNK6+ZUGqaTD5rlJ42irBGVJSorJapEWEJIA0oeRacyCg7dZL9ama2q7oNH3eY6pm1sefriXpjzvoquHfv6xv2k9dvq1PXs27PuOn+TV//PDh8er5frhl52ATbH7/+cq7ZeDw8r5p4etzWiaO7swHlq42XzqyLzYf/qLgTj39FUnaNPzy41uGX7m1aBrcVfAtq4dqtGlo9/a4ZWjvynvXiniysh+Zlp1T1/rtZNxL3ZbRUze4p7LixKVq298H50+lyJHOdaxk9t3SMn3kln/f5NV5YeO7Ydvl/adytP2dlvX9W+RTkdv/r9rJH9au1RZCcz9q2H58/BsOOd90Hh0AAA==


name: Sync HubSpot Contacts with LinkedIn URLs, Detect Changes & Send Gmail Alerts
author_name: PollupAI
author_username: Pollup
categories: []
created_at: 2025-05-07T15:29:02.022Z
updated_at: 2025-05-07T15:29:02.022Z
url: https://n8n.io/workflows/3923
scraped_at: 2025-12-24 13:02:46
description:
  Automate CSV imports into HubSpot without the mess. Powered by n8n. Supercharged by Pollup AI.
  Who’s this for?
  This workflow is perfect for Ops-minded folks in Customer Success, Marketing, and Sales – especially if you’re juggling CSV lists, CRM updates, and team-wide reporting. Whether you're a CS ops lead syncing product usage, or a RevOps manager updating contact records, this will save you hours.

  🧠 Why it matters
  Manually importing CSVs into HubSpot is a headache:
   ❌ Copy-paste errors
   ❌ Mismatched fields
   ❌ Wasted time formatting every upload
  This workflow does the heavy lifting for you:
   ✅ Pulls fields dynamically from your HubSpot instance
   ✅ Preps and maps CSV data in minutes
   ✅ Syncs with Google Sheets to keep your source of truth aligned

  🔄 What the workflow actually does
  Pulls live field names from HubSpot’s API (no guesswork)
  Indexes and organizes your CSV for import
  Processes & transforms raw data (optional filters, cleanup, etc.)
  Dynamically maps CSV fields to HubSpot fields
  Executes the upload and logs results

  ⚙️ How to get started
  Prerequisites:
  HubSpot private app token
  Google Sheets API credentials
  Access to an n8n instance (cloud or self-hosted)

  Setup in 3 steps:
  Import the JSON into your n8n
  Connect your HubSpot and Sheets accounts
  Upload a CSV through the built-in form — you’re live 🎉

  ✏️ Make it yours
  Add filters** (e.g., remove duplicates, format fields)
  Add more HubSpot objects** to match your use case
  Trigger automation** via webhook, schedule, or custom input

  Works beautifully with other Pollup AI flows – so you can scale CS ops with less stress!

  About Pollup AI
  Pollup builds hands-on automations for B2B communication teams. This n8n workflow is one of many tools helping lean CS teams deliver high-touch outcomes at scale.

  Find out more at pollup.ai 

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.splitOut","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.executeWorkflow","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.executeWorkflow","n8n-nodes-base.gmail","n8n-nodes-base.httpRequest","n8n-nodes-base.noOp","n8n-nodes-base.code","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.filter","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.merge","n8n-nodes-base.splitOut","n8n-nodes-base.filter","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE7Va2W4jxxX9lQafVYPaF78Ege0EAyQew0v8YBhGrRIxVFOhKGiEwQD+jOT3/CU5TcnDJlXVbErOy0AjFW+dvts59zY/Lvp1yreLL37+uFimxRcLbqn01HISmQlEWl6I5TYRR1nywWTjGVtcLHp/nXH6p6vcd3G1jO+X/WX3+2//+SHfbrv79eZ9Wa3vf//tvzi6fbgZjva2J7u7SPC3+c217+/86ofN8vIyb3DqZn273C7XPZAQpumFpL/gl36De7Z5A4AfPz2a+hf+tzvHPl08YVY2KSYkJYpLTSS1jvisBSlMlyJDZlbmPea/5223WgLmunTr+34w3gJ5td3efJf/fYeHOoQIL81AKN/wzxiFUKUkG4m2xROZlCJWZUek5k4Lbz13rI4R7s399rYr680j3pfBVUadg1clxjQTjjCjJfAKT6x2miTYKsgDl2zZ4/1+ixR46L5ZbzNrwrvdHRrOHMWbM3pBuH7mz0Vc91s8O0wt2tGH75gKSRLlh+gXQ4k1IQFzMMzQIB23e6RvSxPfshziMnyW1/jIazl5QUNyxKmA6hFAZZ1lRBpHhWZUpDSK8tdpuW17Kx8FUc9CI97Iz2hk1NFyZojG1UQykYkNLBJmlXc6S2ktH3mmj5t8DXd33/rLPB+XogBGa8WQP+R4t83v+gg7281dnqjgokTJmgjtkW3CKlzmBMlMpaSsi9TLUbbdrJbb7t3ddiLXhiM4cQiVsXlO3AOLjjsrgichF4FiRRl4neDHwqmynBeh3B7YP/PmMnd+1W2vcgdPbpa53VwifjyE5+S8hPuMTtuoWEGuCysVkTlw4jiVJBkbo6CIeCjj1EdP6d/ntOy7u82qW952+fpm+zC7IJjlc9reuCCYzTLLoRopeok0KE4vEiXIxeQRcJRE3CNclq7P9x2ubNfFMSihZvXiMSivNBe+oC4KIitFoAivoiS6JKLiPnjBJ3txE9xTxv/0RIDPwzuD1kZAXTGGMSWIDhbZ5yOAaslJzjzJoNHw2Mh7OzL++hFB6sJD99d+jUTcdCM4s2C3WXlO7bzZV48UJkWRFaEDOwNsBjF7hio30oVElfTpyNEejp6M/6SLBTvbx56m5HmB4AnQDVIpQ2wskagsPGVZoObNCOO1X66a2C6f/jpCJDXSk+0g3edwtV6/f7sjCrhBO/ApS5RDZmlGEOJENJMq5uyoj3pxMqX3nnbOMWYFI1lTZIqSkQQlBOFZWINeRW0cN9DsN/FqpyjubpEgyJWhM8wUFsiqQTH+YQUf/gZmO9+nLq6vb3z/cKQ+0JOeXDDJEMWvbvOT+bf934bg1lgDKuVi4Vf3/uEWDf7mbvuV3/qnT+/9QUXRIUsSEAD4F8LLo1qIokVT+JeHGPb++GrdDaUCDdt0Qb9+d3P0WBKRHapiPptopzjlSRNNh5ZorCWBckdopMK7LKJ1/phNbjbrslzlH7/7xxlMwg1tubxBJdknlbhQxBSDBGJwndUJP1mfTJKxeJvGCfRYqr9OluozqSDELGU/1jDeOiMhY4iC6iRQNNBWghaSaJGKhZiLknVcj5eeh42fB05q473yAsxRwL/UYFhSBkXoQCFCMOoyr7HbNLQqw81ANqa4oqXSEa02BDQFGSBeLDNDdG1QRXoNfXrotoQq6sAWZyi/s4NZHJVRlIAQcvBBUBl6xRcSTURgTQ4ujfhsNFScPVNw/pqRAsTqXKLoodAFiCsax24m1gwKUtlQmFJ7nF9e+R6Fiv7xOKShfW2nWgnKeXvMrmzezDsOMcZc7WixJKUh+aDn4VYBdY8e41T2lPuRM7/cZL99FKUP3f1yewXtN0ll6/XlKn9/lfNO7oyhipnDr6q16aGh7/sh1QwKAQ2QM4xLLGQSTCiEWqZDSsFTdTS4b9b3cPJmfd2ldbwbppWXPIGmf9YTcBZ5CAmFpQrqLFroW5kjfuLWIEK0xPGYfMS7T719oNDhxNxFxNkETKGKSJWo/m8EzLwueuiFaODQ2FljZuJekciFwziaNBOjSfjbJ0eA5QYmhofu+vSX2R2So9IbD9gsH24Zi15LAqoDzTkhiQ+Rk8I8CCfwWLQ97JDDUHezBzq/T+6UwnmdMhnnBQqcZBWALmhBfMJkZ6UtQqZgGaWT6CZG4yq8M5nPCI2xGIOwkQO/mMxRuaBlmyGnueEq2hEt/3iThuZzWty3axZNZ2bN7jGyoqG+MW4ExofZHT50KpCIMoX0YsyEdIzx9jPIaY4+AXSGN8dIkzaRMaqJSg7eTJQSZ2kgLAhlrGfR6nIY7cGLv97tIKf5kZZ01gB/oL+SQjkgxsI4jEcF04rTBYFG/NG5pRTjOn6CtrvvhfDOTESmjFfZFmICBmOJaZk45jnBRAetkXRyRY8ppM+bIRV3C5qBAMHWH9r5+FxZS6nPVNbUCJUZF0OVQPQHULTz3pIYTeLFWZ7lSIo9iv51f4Ker4djR8jguTnIxGhstNYwY5kgLlOoa2fRYbINxBjDi4nG0zwafj/v3U7tzevbNzWrgkcqDBnnnIpEK5fhPcGJF6hf64R2PDmlqFscqIN4t9kMC8zpNXlNf5mzN1tamGA5QyVQhZrNKFyvLFhOpWgyExrDQVXL8rPFrLWvEbNo054JjlYt/LBEKhSyFpRXiuJFsKK8o1Wg4mygjL1KdjOMBpZCRyVtoWids3ApeFkyTwtaTdDZVpHK85GK1w0I0ivmFMQet8O+GoOM9TyQkCLNwUeM8q6KVJ2NVNBd9J8n5zykMjBntFYEcyBkaUFrtIPWUcFwqW30PNeR6vN96vRrkAJkCRr8Ah8OW1lehqHLkJg1daYowK4XlDkbqeT0NUhB1xa04on3GpwjS8LkxSQpkYKOgk4x1fOU0Re8HNt1ppcidV7FSB0xWZZhDeaH9Ts6qudQcCxhyA1VpPYFQAefQkqehxSn8fc+x8HM7vjbMvwL9hus/vxx94L65LuV3fGLxbJP+cPiCwqz+0/OfJn6zMQvQLt7RVeD8xqjo/dXI9O7P43fgNSubSvpigd2Fg+36jWbjWVeHfrBpuiUY45lQtPk/vqayeproaqto3eYNWPjF8BVG0cKrP6MJ2Rk1fDx/q8d3+YUMgF4tCeuB/nEyr8Zm4NRo12ZzyXrdO7/kRytHGpouarRZ1XRSvP62FS1+RzDzDZwRrq386C5K25iPaq5qgea+v2k1T+erWb25P6z6YfjjUo7u2pvQSaK4YgmJp3B5tXA4Uz78jpgzcdnf8bz1xvIRD00ZvVmRlQ2sPU2e+rLBtUbGovA2g21l3ZTMmByhVcF00rsahGc2q/Xb2h8qtVqptbfjYjVmap6wZz23aCRZm88LVQuqkJkTttr5tgcAmzv3s9MolP9Y1opVmun8U2sWRF59ly1G07t26s3nf5+Se2qwy+5tQ1Pfou01b8qLy0rN3z69D+kp9Ep5yoAAA==


name: Wix Chat Auto-Responder with OpenAI GPT and Email Fallback
author_name: Ryan McMahan
author_username: owner232
categories: []
created_at: 2025-05-07T16:06:00.304Z
updated_at: 2025-05-07T16:06:00.304Z
url: https://n8n.io/workflows/3925
scraped_at: 2025-12-24 13:02:46
description:
  Wix Chat Auto-Responder with OpenAI GPT and Email Fallback

  This template connects Wix Chat with OpenAI via n8n to automate intelligent customer responses on your website only when no human has responded recently. It uses smart throttling, checks for member vs. anonymous visitors, pulls chat history, and optionally alerts support staff via email if AI shouldn't reply.

  Perfect for solopreneurs, agencies, or customer support teams looking to auto-handle conversations while maintaining a fallback system.

  Key Features

  🔌 Connects Wix Chat API to n8n seamlessly
  🧠 Uses GPT-4 (via OpenAI) to auto-generate replies
  🧍‍♂️ Detects member vs. guest via webhook payload
  📬 Optional email alert to support staff if AI should not reply
  ⏱️ Only responds if a human hasn't answered in the past 12 hours
  ✂️ Splits long AI messages into chunks to fit Wix API constraints
  🧱 Modular & customizable—adapt for CRM, Slack, SMS, etc.

  Requirements

  Published Wix site with Wix Inbox enabled**
  Wix Developer App credentials** (Client ID, Secret, Instance ID)
  OpenAI API Key**
  Active n8n instance** (self-hosted or cloud)
  Working SMTP credentials** (for fallback email alert)

  Setup Instructions

  1. Import the Workflow

  Download and import the .json file into your n8n instance. All nodes should appear in the visual editor.

  2. Rename Key Nodes (Recommended for Clarity)

  Rename the following nodes for easier maintenance:
  If → Check Member vs Visitor
  Execute Workflow → Generate OAuth Token
  Send Email → Alert Technician via Email

  3. Configure OAuth for Wix API

  In the node HTTP Request1, replace the placeholder values:
  "client_id": "YOUR_WIX_APP_ID",
  "client_secret": "YOUR_WIX_APP_SECRET",
  "instance_id": "YOUR_WIX_INSTANCE_ID"

  💡 You may move this to a separate workflow and call it using Execute Workflow.

  4. Set Up the Webhook in Wix

  Copy the Webhook URL from the Webhook node.
  Go to your Wix dashboard:
     Navigate to: Settings &gt; Automations &gt; Create New
     Trigger: "When someone sends a message via chat"
     Action: "Send a Webhook"
  Paste the n8n Webhook URL in the configuration.

  5. Add Your OpenAI API Key

  Open both OpenAI Chat Model1 and OpenAI Chat Model2 nodes:
  Add your OpenAI credentials.
  Adjust the model (e.g., GPT-4 or GPT-4o) and temperature as needed.

  6. Customize Response Logic (Optional)

  In the Code node labeled Response Throttle, modify:
  const allowChat = true;
  const allowEmail = false;
  const humanResponseTimeWindow = 43200000; // 12 hours in ms

  Change values to:
  Disable chat or email
  Modify the delay window before AI is allowed to respond

  7. Set Up Email Fallback (Optional)

  If human support is required, the workflow sends an email:
  Add SMTP credentials in the Send Email node
  Customize the message, or replace the node with Slack, webhook, or SMS alert

  8. Test

  Open your Wix site in an incognito browser tab.
  Use the chat and monitor the bot's response.
  Check Executions in n8n to debug or verify the flow.

  How to Customize

  Trigger follow-up actions** (e.g., Zapier, CRM sync) after AI response
  Customize GPT prompt** via AI Agent nodes
  Prevent replies by channel** (e.g., don’t reply via email)
  Add filters** for keywords, lead scoring, or VIP contacts with If or Code nodes

  Includes

  ✅ 1 Workflow JSON file
  🔐 OAuth2 logic (can be modularized into a separate workflow)
  📝 Sticky notes and comments to guide usage
  ⚙️ Production-ready, extensible logic for any support stack

nodes_used:
  ["n8n-nodes-base.webhook","n8n-nodes-base.httpRequest","n8n-nodes-base.executeWorkflow","n8n-nodes-base.emailSendTool","n8n-nodes-base.if","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.noOp","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.noOp","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.splitInBatches","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.emailSendTool","n8n-nodes-base.httpRequest","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE61YbW8bNxL+K4I+mzm+v/jTJWkONXCN2ya4AFcUhyE5tIVIuzppHdcw8t87K9nRSt6VVkEsQLB2yeHD4cw8z/BxOsvTyym+/fLfxfrTb+/F7W/l9zdxejFdYAPTy8fprFo3UCW8ascly1OMPnCTfRFRZFlyBvpk4CJC5ogiOYvReeOMdFhQBG2wFAwYvCW7DS6Wc2i29qTbe/Z2hXn9AZu75duanmCDNKhZ3eHXi2kFC6QZ89m6mVU37SS4WU8v//iTXtUZ238ft5sp0iaLNjHvsmQac2A+Fs1kspajo9fQbvDJ4CeMt3X9uTX4sGwfVL5iG4sswhpf3X97v6zXs2ZWV7QSE5pfSMlp8af3m+0oEGByVkyZUpjOITOfnGFKexUt98VxaA3BitZucEWgH79uF/4P/drYll8vnvbBSy5SaUKP0TBtXGGeS8m8FdoKtD7btNvHzx8//jr5Hf9/h+tGDu7mtmmWT4P2d2Q4v/Dtfo6C06928FCjdIacm5yPtFluWaRtsqK5FxZAq8B38N79hemuwcmnevW5zOv7QYS4HdgZ10Fpn71+FKXooMxSaCV1YVkDZ1o5x2KiYEAEpSydji1mh/IDVnnybgGz+TC+9m077mNdz/fRidaJFBkHUSGsjAjSk2dA0DkCnaPNngVZKGsgEh5zMipeiW9bKiCsNkUynhM5XsvAoOjMdHEGE4QiTCcursrgVmZlH7/Uo9wrO+41NigTwLBYvCMs3DCfVWLOKVt0ytJm2x+j6vtiVNmzghQ8YvIcGCWkJnwiMQBHvs+EPIjsNcAO3+uryesbrBqxw/ZPAvePHcA5VDfpFmbVK2gHHpy/8PxCn84i8cruADoVrIqKRcJDWZQo3T0mlqNzUfsgkwn9DtTnO9DJUfi6DuQZIWNxTLhM+ZPbYpqjpUpE+IzLJoSyw/eWQAzCStuXHTzejsKzQ5PQBGm1Z0ZIxTTnlM1CRJadcUEqiyByN/TF6NgXnI/D0vGNlZCE9YFZ2RJN9oIqoLEsUXX2VP24B79Dc73EigLs7S00k18IyHxMlM0X7fjN1NkhYAo2x88qhtgSIDeaOROpcjiFLEQqJBiCz86hs7ETbP+u6+Xk+guuJldE0OtBV66X81lzVb2BJt3i+gDlyCNWu4DjWZNjgalo2mpZBAOq3cxx41ESwWpf+hPCnp8QsuVx0+vEJx66JukzvSwwX+PLLLmYwvweHtbXd83yrvkJWsW0Gbqr1RIUlXdkgFQVtYye2JzKpRROZWVSFhr308eckT/ELGcmELGdoz0rZhRQvc5IyEyxLFgkXnJUyaPraKNZlev7yZs70m+ryS+4qFcPY6J2sRm5nba1cYBb2pGxu4sL0hdJ+oiMk7AkriM+jW0UGx44WFXoqys3iMcJSzPozKq+Xh6ColhQI9TFN0ghCUiRBFowRCkatGFAFMhAUgFIEmwqeNyZP8KXxIgX4jxRpIhwcknISJ5TjiEvLIZMZRRVEICC/NyJgmdW/E5SJJdeMDHmsHesqJA0fHCkI1r1rr3ULCKpTJFsSYE7yqiBIjCcPsOsSA5kpx3YZUWiZRTZahZUK819iCxmr6jjMEVLTUnk1H5aDzPRy7Qm5hgDqFPXFXgSs5aBiK0KoxiMgtioBKptUUdlXKfjuSrD/cELWhR23Ol1eZErVaxDAsEVMJ0iia7oqD1wIkUXRSqpk6o/3y2gmqxwWVdrnNzPmttZNZnDupnc1neri8m79z8NO68njfXGeyNU2K4oBlDILTVrjlJYC5KLvpAGQ4uoi9EJpD7C43JEYhzhccnPzl9DoFSmpMAAxOOCUAfS2tRWKLAuueJix8EHPD7szKNEHvy4QNhV7FicJc7WzDhSbJQknLhPWKZAO+/JHqaBJP4OIm8ZhfUe+o8hcuN1Uh49SSfcNDokSxTFiHQguCg5RMz7GT8sR3qI3OmRabYLWkEfnxSDlMi71GtRiVSWFJOlfscDj6bTee0a2+HjP9bZavlM2N3ONkcvg4iaFdWWafqjTrQ9cIqWhA4Akjqns/UpKqWVZ5y+W3kPLKqiWBBJOiukS5s62hMxw7saDJlW+rER7W637pNw0ZBoh5zCmRLPAyWeITUlvUqJY5Syo/g/3WI1ebr4yJP4MHld1c0t5eG5lyAfV7ObG1wd3kHJcRsQHQ9DUK6UFBnPspCHW+lHyomFkpImRqN2udMPf2hm6fPD5H3dDHd1682YpyFdeK2cIsX7At401VXTyoTL6XS4JnNuUETyb6KehORe9gw89QLSKmNsDopqdi/QI+VtECk50ujvBWoNz7yNfF2I7ATxnPeFBFUpxRdDQqXbknaADpPwENBANS6ci5NGQ2pmX3bFb41Ne4W6nQrzOa5+reez9EDz758Cbv2vVb34QEtc31ebuNsGJJm8XmV6cDn9Itq1vmzX2V5+mpKs98hIElMZSqLQiflC3iVG1Zw8Y1oRQmArTK2pDYCr0n5T5Wk3+Mfj5i53+DZzM+5iSjIY/5pectpc/xR1ZMqfhLu9Gehb9mXbcGzFnuuigdVk/ybPUj5jkJwAsrme6UOyd1MyOLXfZ3tycnCu6Z07eMUwaMeOsXNqM893/r0hMHhR3Wvqm+f7bB3IgKMG+p17cCPQa6FzaU0mYPa/puXvrpWX4fE8atiWOGVMnLa2p+l+wLntV4VTdeOU3/YLxilr+gxrevAszzDSnzEHveRJK6Py5YS9w9Edi0MF+FTUv8iy/spyHjAxBtkJkz23tNs8aHu5O7jBzcMRCbE//uQycvQyZ6zSe+W0XWfx9OPUAovne6rTlsVp02KU7ZOy+VSuHk+Qr1//BnRYklH2HgAA


name: Voice-to-Email Response System with Telegram, OpenAI Whisper & Gmail
author_name: Adam Janes
author_username: adamjanes
categories: []
created_at: 2025-05-08T04:01:50.996Z
updated_at: 2025-05-08T04:01:50.996Z
url: https://n8n.io/workflows/3930
scraped_at: 2025-12-24 13:02:43
description:
  This workflow gives you the ability to reply to a long email with a voice note, rather than having to type everything out. 

  ChatGPT will format your audio response and create an email draft for you.

  How it works
  When a new email arrives in your inbox, the workflow checks if it needs a response, and it it does, it sends a message to you on Telegram via a VoiceEmailer bot.

  When you reply to that message with an audio message, the second part of this workflow is triggered. It checks if the message is in the right format, transcribes the audio, and creates a draft response that shows up in the same email thread.

  Set up steps
  Add your credentials for Gmail and OpenAI
  Create an Telegram bot following the instructions here.
  Connect your telegram credentials so the workflow will use your bot.
  Turn on the workflow, and message the bot from your telegram. Find the Chat ID from the Executions tab of your workflow, and enter it in as a variable.

nodes_used:
  ["@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.gmailTrigger","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.telegramTrigger","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.gmail","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 10076 characters]


name: Auto-Post Medium.com Articles to LinkedIn with Telegram Alerts
author_name: Krishna Kumar Eswaran
author_username: mrprogrammer
categories: []
created_at: 2025-05-08T06:38:45.420Z
updated_at: 2025-05-08T06:38:45.420Z
url: https://n8n.io/workflows/3931
scraped_at: 2025-12-24 13:02:44
description:
  🧠 Problem This Solves
  Manually sharing Medium articles to LinkedIn daily can be repetitive and time-consuming. This automation:

  Fetches the latest Medium articles based on a tag (e.g., android)

  Posts them on LinkedIn twice daily

  Uses Airtable to prevent duplicates

  Sends a confirmation to Telegram once posted

  Stay consistently active on LinkedIn without lifting a finger.

  👥 Who This Template Is For
  Developers who write or follow Medium content

  Tech creators or founders looking to grow an audience

  Community or page managers needing regular curated posts

  Busy professionals who want hands-free LinkedIn engagement

  ⚙️ Workflow Breakdown
  This automation runs at 9:00 AM and 7:00 PM daily and performs these steps:

  Fetch articles from MediumAPI.com by tag

  Check Airtable to prevent reposting the same article

  Post on LinkedIn if it’s new

  Store the article ID in Airtable

  Send a Telegram message after successful posting

  🧾 Step-by-Step Setup Instructions

  ✅ 1. Airtable Configuration
  Create a base with:

  Table Name: PostedArticles

  Column: ArticleID (Single line text – to track posted articles)

  🔗 2. MediumAPI Setup
  Go to https://mediumapi.com

  Sign up and generate your API key from the dashboard

  Use this API endpoint in an HTTP node:

  GET https://mediumapi.com/api/tag/YOUR_TAG/latest

  Headers:
    Authorization: Bearer YOUR_API_KEY
  Replace YOUR_TAG with a topic like android, ai, webdev, etc.

  💬 3. Telegram Bot Setup
  Go to @BotFather and create a new bot

  Save the bot token

  Use @userinfobot to get your Telegram chat ID

  Add a Telegram node in n8n with the token + chat ID

  🔗 4. LinkedIn Setup
  Create a LinkedIn Developer App

  Connect it via OAuth2 in n8n

  Choose to post on your profile or company page

  🧱 5. n8n Workflow Structure
  Node Type	Description
  Cron	Triggers the flow twice a day
  HTTP Request	Fetches articles from MediumAPI.com
  Airtable Search	Checks if article ID already exists
  IF Node	Skips duplicates
  LinkedIn Post	Publishes to your LinkedIn profile/page
  Airtable Create	Stores posted article ID
  Telegram Node	Sends success notification

  🛠️ Customization Tips
  Change the tag in the API URL to match your niche

  Add hashtags or personal comments to the LinkedIn message

  Schedule different posting times in the Cron node

  Filter Medium posts based on length or title keywords (optional)

nodes_used:
  ["n8n-nodes-base.airtable","n8n-nodes-base.airtable","n8n-nodes-base.code","n8n-nodes-base.filter","n8n-nodes-base.code","n8n-nodes-base.telegram","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.linkedIn","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest"]

workflow_json_compressed:
  [encoded data, 4456 characters]


name: Track Personal Finances with GPT-4 via Telegram & Google Sheets
author_name: Md. Nazmul Islam
author_username: pomegai
categories: []
created_at: 2025-05-08T07:20:03.997Z
updated_at: 2025-05-08T07:20:03.997Z
url: https://n8n.io/workflows/3932
scraped_at: 2025-12-24 13:02:44
description:
  Track your expenses, gain insights, and manage money smarter – right from Telegram.
  Who is this For
  This workflow is perfect for individuals and freelancers who want financial control without app overload. Launch it in your n8n environment and start tracking your money smarter today!

  Features
  Natural Language Expense Input: Log expenses by simply messaging “Spent $50 on groceries”.
  Income Logging: Add income sources such as salary, freelance, or passive income.
  Voice Support: Speak to the bot—Whisper API converts voice to text.
  Google Sheets Integration: All data is synced to a spreadsheet in real time.

  How It Works
  User Input (Text or Voice):
   Send messages on your telegram bot like:
  	“Spent $25 on transportation”
  	“Received $300 from freelancing”
  	Or just voice record a message
  AI Parsing & Categorization:
  	GPT-4 processes and categorizes the entry using pre-trained financial logic.
  Data Logging:
   	n8n stores data in: Google Sheets (via Google Sheets API)
  Video Demo:
  	See this youtube Video to explore "how it works".

  Set Up Steps
  Import the Workflow
  	Create a new workflow
  	Import the JSON file by clicking "three dot" (upper right corner) &gt; "import from file..." (I will provide the JSON file after buying).
  Set Up Telegram Bot 
     	Create a bot via @BotFather
     	Create a telegram credential to connect telegram with n8n.
     	Grab the token from @BotFather and paste into the Telegram credential.
     	Connect that credential with telegram nodes.
  Enable Google Sheets Integration
  	Create a google sheet credential to connect google sheet with n8n.
  	Connect that credential with Google sheets tools.
  	Create a google sheet including these columns: "chat_id", "date_and_time", "income (dollar)", "income source", "cost (dollar)", "cost category"		
  	Provide access that sheet to n8n.															
  Configure OpenAI (GPT & Whisper)
  	Create an OpenAi credential to connect openai with n8n.
  	Add your OpenAI API Key in the credentials tab
  	Connect that credential with openai nodes.
  Pre-requisites
  	Necessary credentials:
  		Telegram Account
  		OpenAi Account
  		Google Sheets Account
  	N8N version 1.92.2 or upper

  Customization Guidance
  You can customize the ai agent prompt based on your needs.
  And also you can customize the sheet's columns based on your needs.
  And you can add additional features like:
  	Monthly budgeting alert
  	Expense report generation
  	Smart Recommendations for cost cutting tips
  Ready to Automate Your Finances?
  Buy the workflow for only 30$, You will get full setup guide after buying.

nodes_used:
  ["n8n-nodes-base.telegramTrigger","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.telegram","n8n-nodes-base.set","n8n-nodes-base.telegram","n8n-nodes-base.switch","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleSheetsTool","n8n-nodes-base.googleSheetsTool","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE61XW08bVxD+K6t96QuHnvuFp1KStKmUUAWaSK2i6lzmmBX2rrW7YCjiv3fWXGzIgu02bzbM5ftmvpk5vimrVB6U/5z+9nu6PLKL7t1Edm//LPfKGfS+PLgpq7rrfR3h/WAnhGeC88yyZkwqr0VmVGohrPAqa7Da+WykyyZIr13W0boI1mptmBKGYtweZvOp7+GohdSdQH8xP2rwL9ADJujbC7jdK2s/A8z24bpYNO15njaLwdFPuvLgr6/47ybB8PHmDjwDpaVXiogoMpHBAXEGgDCVKEjDc9ahfAz6CSJUl1C8r+cXffG58sUpTGHS+tmQ43o+2NS2JsskJPgO9vt7g9O2mkygRbt501V91dQIgmhN9xiliGsB4axpzpeV0soyR4Mk2XJHJH4mDqtDtBeZc5Wcpn4I5DEucm+Rz83tHYDP+G0Zm+2z2717ksZozxXzRGBUIh1Y4mgGYrJ1hnmZg9Erkqetr7vYVgGKz00VofgAXecnUKw4/oQkf1wRnfp6Es98Ve83c6gPq6ckGXLkS44bANtHwFLCgNcR0D4RmbQmPgHWI0QWhVZGcLUCfAJ1Kg7fF5+gmzd1B8Vps31fnmGlcqwhInLJI2ckRKqINFQTa5IjFhViqbVR87y5IfyRn1PZQgiCJJkNkdR6Yjk2WHLpU6ZR8WWD7/n90UH7Q4eUrvqHXrxIq4P+KSO6t7HyYl+uSQWkFDGSYDWgVDwM0rMkKBtCTjp5H1fI3jSLetr4VNxDfKKXHUtPGH/QyXrpqQzR6cAIpQm1ay0jPuNXHYTLTEfqE92l9IFni/XFCdBaoLRMIC7j/FNGoxZG+sjFGkEMGR+rXpwOfF4s/aLq49kzUvJRTxtasEKotc3SB5x5oT2RuB6JjYwSzmKGmKMJJq0QvqvqYcMWOLXxHNricAJ1v8Wk+nu7NbCaboV1fVCNAkWlkrgvNQo54aYKwUuSopdBSSUYhRXWLx4LVLy9qrq+qifFA/Q3vvcvVnXSNJMpnJwB9N1p00yfQraoGcE3Qpb76hFy1ExxbRSJQqLCowrEK5sIDVQYoyLnca28hykVH2HxPbA6uzNW5k1EnQvCRcTyZqyxzymRwAS1InHjKVth/QVqaPE6PkzjJ5hPr4svVX9WHD/s5U2ymM6Oznx/PLLGFd0K/vqsgQJhHSiShMO1mVDJgSdBmNE22Exx2cr14zqDWUAJDwiKX1EkTXu9BWT0QsOfL3KG9ktVp+XBX5e13hK4WAF3TqNyBVEm4AhKMWxBI0kQhlGRkFVY288nfRXPr4uPTf/Kclja3JusLwiDCiYj57GMTd0PI3pQlt9AfQTKqeAgRCBRRosvhYx7zUSJYs4yJe6dkTAKlO2MVNL/A9Qxqiw2HReFHNYuaOJCDCQrKxRe0SQkGwXKdy8p1/8FKVr72OPrrjzIftrBXom3dNhTS1e4gngxJDhuE77iDspLNsS4vPNfXirltASRJNEqMRQNKseDcUSh5pXCRlE2IEUQNd4U9FoGHrsw+OcZKhu54DN1YLzpEbC03sPndoKr8oAil5Xjljf6mxBfkd5Y0jFwG47QaOzRzYrBffV3P+zOHeI/uDxPMe42RmC7J+Qoj/G1dUfkbjXtSOXe6Xmel5/l36sjr/y6GUvx6ttoNMFr9//7dv510Y+x2eJXzyinzUf3jtlwry4w3gdMtyvFp75PEdze/gtMDZX/hw8AAA==


name: Generate Lessons Learned Reports from Jira Epics with AI and Google Docs
author_name: Tarek Mustafa
author_username: tarekadam
categories: []
created_at: 2025-05-08T07:35:46.686Z
updated_at: 2025-05-08T07:35:46.686Z
url: https://n8n.io/workflows/3934
scraped_at: 2025-12-24 13:02:43
description:
  Who is this for?
  Jira users who want to automate the generation of a Lessons Learned or Retrospective report after an Epic is Done.

  What problem is this workflow solving? / use case
  Lessons Learned / Retrospective reports are often omitted in Agile teams because they take time to write. With the use of n8n and AI this process can be automated.

  What is this workflow doing
  Triggers automatically upon an Epic reaching the "Done" status in Jira.
  Collects all related tasks and comments associated with the completed Epic.
  Intelligently filters the gathered data to provide the LLM with the most relevant information.
  Utilizes an LLM with a structured System Message to generate insightful reports.
  Delivers the finalized report directly to your specified Google Docs document.

  Setup
  Create a Jira API key and follow the Credentials Setup in the Jira trigger node.
  Create credentials for Google Docs and paste your document ID into the Node.

  How to customize this workflow to your needs
  Change the System Message in the AI Agent to fit your needs.

nodes_used:
  ["n8n-nodes-base.jira","n8n-nodes-base.jira","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.set","n8n-nodes-base.summarize","n8n-nodes-base.googleDocs","n8n-nodes-base.jiraTrigger","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5196 characters]


name: AI Marketing Agent for Lead Generation: Reddit + OpenRouter + Gmail
author_name: Ari Nakos
author_username: just-aristides
categories: []
created_at: 2025-05-08T09:13:21.340Z
updated_at: 2025-05-08T09:13:21.340Z
url: https://n8n.io/workflows/3935
scraped_at: 2025-12-24 13:02:44
description:
  What it is
  This n8n workflow monitors Reddit for posts relevant to a specific business or industry, identifies potential leads, and delivers them directly to your inbox.

  Full tutorial (https://findleads.agency/blog/n8n-ai-agent-for-lead-generation-using-reddit-openai-gmail)  for those wanting to build it themselves.

  How It Works
  A user submits their website URL and email through a form
  The workflow analyzes the website to determine the industry and extract relevant keywords
  It searches Reddit for posts containing those keywords and filters them based on custom engagement metrics (i.e. upvotes &gt; 15, non-empty text content, posted within the last 90 days)
  An AI agent (using OpenRouter's GPT-4.1-mini) analyzes each post to determine relevance and summarizes the key points
  Relevant posts are stored in Google Sheets and formatted into a professional HTML email
  The email is sent to the user's provided email address with a summary of potential leads

  Setup
  To run this workflow, you need to set up credentials in n8n for:

  Reddit: Uses OAuth 2.0. Requires creating an app on Reddit to get a Client ID & Secret. (YT Tutorial for Reddit App Creation: https://youtu.be/zlGXtW4LAK8)
  OpenRouter: Uses an API Key. Generate this key directly from your OpenRouter account settings. (YT Tutorial: https://youtu.be/Cq5Y3zpEhlc)
  Google Sheets: Recommend OAuth2 (just connect by authenticating) or setup in Google Cloud Console (enable Sheets API, create OAuth Client ID with n8n redirect URI) to get a Client ID & Secret.
  Gmail: Uses OAuth 2.0. Requires setup in Google Cloud Console to enable Gmail API and create OAuth credentials.

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenRouter","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.splitOut","n8n-nodes-base.reddit","n8n-nodes-base.code","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.removeDuplicates","n8n-nodes-base.formTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.merge","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.gmail"]

workflow_json_compressed:
  H4sIAAAAAAAAE61Y227bRhD9FUIvffG6e7/4qYZTN0GaJnCMvhRBsZehTUQiVYlKagT+9w4lx6SlpSTHfZFlaTl7dubMmbP6NplB6ydn3yZVvWx9HeFNmpxNVHC+LCnEBIEZ41ikMjgBPhoOwoF2TLFYei0Mtc5SUMkJ7QM4QW2wcXIyaWE2n/oWLhaQlh+hXc0vGvwEWsAN2sUK7k8mdZNgOTn7C3fvdhU6BgxkiU2cEsl1JN5pRYKPjuFeVhrAyLWfAa7+2Fbx813xR9N2H7Z38+7D2tZkHRUfWsLpcr3mYcm8WVZt1dS4IRGc0hOl6Sf82C8wYAuLZZeG2NQt1C2Gmtxvov6J36yfYvcnD0CVY1wL5ogwQhPpSkdCoEAsROmBWlFalwUqno9U8xcABQRjnE/EWOGJlBGINzYQcM4KgESjUlmg/PlAuXhJSkuVhCkNZjNYTqQylgRuOGHGKxAiOJfKHun7OdRXzQp3KC5ufVu8Q3zTHvIviPnnHvfU1zfx1lf16XTWLe+f3mYF0/SE0d0zjOMWPpkyuJLQGB2CT5R4JgyhnHkhJHM6xR736+vrD8UV/LOCZTua4du2nT+suW6a6TZGyo/DKE/5I0ofmLfYmCQCY0SaElFijgn30SZLZZSODnmwWMV2hY1bvF+181VbfPCL5TpbhxLcrNdvlvdhtplij03z4AgUTLSRKgIKUBxiSkiQMhCZolDBOCqp6I/QaQ20VdssivPaT++G6R4F7286mj7FioygJ+4YqO4RqtGU8cBQxxhDQgOlxPGgkcs8ce9RPKTuob6Fu6/NIr0Qp2CI08pn4dShZIwKi9xNyF0lGHLX4AvlRnKQUbGhOsynVdsRYlwauhWbBU/Kbfhx0B6BSapKqoMhTGgUg1ICcTYBoUlzKKXtCt4D+w2QoM2yXY4CQwqmageWOjJjfb5K53W0CEsxpKDAzAXJDInJOicFCJbkEFYNCxyAxa8zX02L19fvfh8FGPHtdkH1GLoatXf5pr6cNl83k3QLcN8zPFApjFQkaSWwwCwRG6TEKlMtRTKWB98DPp+jLqbilW/9KNCbprmZwsdbgHW6h4CV/VHA8lT1SpVkShpKzKwDIq0PxHVdj2MLkiyZw5fsHHi5+jMtUZbYcxiBJMUpFTGjFFBXBSjsdEOJSRrnK7eUC39YV/n/JayI/cgTDIQ1cfRuyiSS8ElsNogkCCaIS9SgEePGc9uf4QpmzRcoXq2w1yOye1/TdSufLHzSfnyULyNspq4EzHciyGNMNhoj3AgCiYIxAEmdFgN7eNksZqPYSvzyelHd3OxaAPUoVl8h3DbN540h5uBMyUt0pRyTJGkgVghHMDcBcVlkbJgcOskg6cEqZw2PhLOEM0wrRazkAgcypxzQfesQJzljxn7A65qXGDPQKB6p68CosSEF2vNQGkHQjrsQVfTaDqzDB8RQXFYwTcuibYq3APNxwLAzbG0nyfwgJ8Sp7FnBIpKCcoIeBysTQGImQyRJqgg4e9HpDobtZTXtxGI9LopwV1wsKvy/Ghe8qtzmLRqNo3g7qLYEY7SKaL+St3hfEIEESBY7DrXNcu8MYz3Gd7C4gQeFGG+vWbdqO39cymOwib75S+3w1uUIYwF7SlqHpoUnnHAOL3UeFXEtMo/N3735Xt9y0cyK8zfFeWdHfnoA/JxqU34c2kG1pfK0tJhEC9iCkjtKbKkcJjZQIy1wxXarfQVT+OLrQy5hp9RojJ9b6YAXF0uTJCgJaP3w8oL5lJSw6BQwKL2kw77u5i22yV2zWhTQ2YTxwfvw7ZbcZ6SqBMa5tp6AxezIMmDrdl2rE3oUZBoIm5Oqg67ilN3jTqgZNcQOwVpC1iqLfxFdBwlv8h3mfa52vfJkUtUJ/p2c0ftPn3Dz3sLlYu2ZOdlovVPNRcvYxWyUoR3Kx9nj77IRh24FI/rq726+r9DOb+6vw+j7LjA7D25v9OSaudmp7W6SRxXo++LtoE9lKV+nZ8hDNkPboHK7ZO4h2Vi7rMlFOzwQssEz5clFH5HypyHZ9x7Y5VP2/HtEI4s1N5NzgfdRbjvwyfOO+IAkr8c5LNm7yKGmGvwUdKi99rF/f2+NEiZ3jL12KK9dY7+9bE40vAYcfaAnDx27IT+04wGF2rvpMUqxp1vHBnomo/f3/wH2TiSG4xYAAA==


name: YouTube Comment Sentiment Analysis with Google Gemini AI and Google Sheets
author_name: Davide
author_username: n3witalia
categories: []
created_at: 2025-05-08T09:43:30.770Z
updated_at: 2025-05-08T09:43:30.770Z
url: https://n8n.io/workflows/3936
scraped_at: 2025-12-24 13:02:45
description:
  This workflow automatically collects all comments from a specified YouTube video and analyzes the sentiment of each comment using an AI model (e.g., GPT, Claude or Gemini). The sentiment (Positive, Neutral, or Negative), its strength, and confidence score are extracted and saved into a connected Google Sheet for easy access, reporting, and visualization.

  Advantages:

  🧠 AI-Powered Sentiment Analysis

     Uses modern language models (LLMs) to categorize comments with high accuracy.

  📺 Ideal for YouTube Creators & Marketers

     Provides insights into audience perception of videos, campaigns, or products.

  📈 Real-Time Feedback Monitoring

     Quickly identify trends in viewer sentiment across large comment volumes.

  📊 Automatic Reporting

     Saves results in Google Sheets for easy sharing or dashboard integration.

  🔁 Handles Pagination

     Automatically fetches all comments, even from multi-page videos.

  ⚙️ No-Code Customization

     Easily adaptable to other platforms (e.g., TikTok, Instagram) or data sources.

  📥 Simple Setup

     Requires just a YouTube video ID and API key — no coding needed.

  🔁 Loop and Update Logic

     Continuously updates sheet with new results, avoiding duplicate processing.

  🧩 Modular Design

     Easy to expand (e.g., reply classification, toxic comment detection, translation).

  💬 Multi-Language Compatibility

  AI can be configured to analyze comments in different languages with minimal setup.

  How It Works  
  Trigger: The workflow starts manually ("When clicking ‘Test workflow’") or can be scheduled.  
  Fetch Comments: The "Get API Comments" node retrieves comments from a YouTube video using the YouTube API.  
  Process Comments:  
     Extracts comments and replies via the "Comments" node.  
     Splits them into individual entries ("Split comments").  
     Saves raw comments to Google Sheets ("Save comments").  
  Sentiment Analysis:  
     Uses Google Gemini AI (or another model) to classify each comment as Positive, Neutral, or Negative.  
     Captures strength and confidence metrics for deeper insights.  
  Update Results: The "Update sentiment" node writes the analysis back to Google Sheets, marking processed rows.  
  Pagination Handling: Checks for multiple pages of comments ("Multipage?") and loops until all are processed.  

  Set Up Steps  
  Prepare Google Sheet:  
     Clone the template: YouTube Comments Sheet.  
     Ensure columns exist: VIDEO_ID, COMMENTS, SENTIMENT, STRENGTH, CONFIDENCE, and DO (tracking column).  

  Configure YouTube API:  
     Obtain a YouTube API key from Google Developers Console.  
     Add it to the "Get API Comments" node under Youtube Query Auth (parameter: key).  

  Set Video ID:  
     Replace the default xxxxxxxx in the "ID Video" node with your target YouTube video ID.  

  AI Integration:  
     Ensure Google Gemini API credentials are configured in the "Google Gemini" node.  

  Run the Workflow:  
     Test manually or automate execution (e.g., hourly/daily) to analyze new comments.  

  Output: A Google Sheet with categorized sentiments, enabling trend analysis and audience engagement tracking.  

  Need help customizing?  
  Contact me for consulting and support or add me on Linkedin. 

nodes_used:
  ["n8n-nodes-base.manualTrigger","@n8n/n8n-nodes-langchain.sentimentAnalysis","n8n-nodes-base.code","n8n-nodes-base.splitOut","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.splitInBatches","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.stickyNote","n8n-nodes-base.quickChart"]

workflow_json_compressed:
  H4sIAAAAAAAAE72X227bRhCGX4XgtdbdI7nrmzZ10cBo06S1k6IogmIPszJhilSklWPXMJDHaF8vT9KhHIiUTEVqEfSOFmdnP84/J9/nVchP84vv/esfLuoX727v+Is5m+WTfAbJ5qf3edUsk208nHd2VrrojQBTKm+5ENZLBaH0hvMyaOmjwl+5EYwqrgwrbbBRCMaB0aBkwdFvgtm8tgnOFhCWF5BW87MWf4EEeEFarOBhkjd2Bnjbs8bWd3/CMvutXV2uHGS+nc2gSctstayaafbsPEttFvCoT9kSX1Td28yuUjuzqfK2ru+6G+10mZ/+/hb9tgG6x/vHr1aMMV1aS7QuIpGl9UQr7gkvlFWlV4ErnW9ofr2CJvN15a+7uz9++OsSlil73y6uY92+//jh7+6qu3ln2uiGrO8izi7hZGabla0vF9V0Cgu0mrfLKlVtgyQIQCcFpQg3twu8KMECCe8fHn29wb/Whuxh8gna2VJ77QtiDDNEWnDECmYJFRoiBMao5z30xSYq62Auq2VP+Q1iftWj1raZ+itbNSebUA7ODJg5p3Si+b9gNjpaF10giqqCyEIb4lwJJErKC8pCFDH2zGefVN4bT4+PO0gMkdhhJL5B8qXAZPaCxKh5p70iRkmBqQAMJDdFkAOki3ldpU367QVbdmYvV2kHTuij4Pp4Ye55Zo0g1irU2Jec2IiE3EkrgtPWm2IAZ2/gMNu0bac1XFwBpF09i+P45InqCTFEgTogGgrXEQZii1IRUfroED9qOyB8sapTNbdT+HovXhV3g4aKYuAOKnrSaxpMyaUyJZHRo6aYWsSWMRCuSwMmeuU066EauE2vkOmyvYZmv6Swq2YXLVEcBBMncgOGqilmNRZpBIbJpiQxNpYEa4BrIbVwRvRgz+GIVNsvJ1NdeR5uKUM5OwrJy0iccVigXjviBAYy6IBxM6hxiNuAz16dZwcL9Sql+S/wboWNcocR28cx6sqhugq8NZoSLQDVFUwQUxSWGGx5UvFAEbRnPP8ue1MFaI8Xlkl9FNNQWKBlobHxEumoJTJgP9HGcKIkd8woUUgbeqYf23aevbyBxeHIrTvJefOtTf4KdgXW8iiBxSB0uuQh4owLAllLrFZNpSeFM0wXJaU0yB7z9TzgfO4H6n9tKUeMiGEOMgMajzmiOI9dCaO+mJWEeSgxvE74ohzk4Pru7DnMqqY6YqbVs7Mrmx5PbQ5tTZACmyA9XNd9l+ZFNFHrQIx02HO4wvWB+pKI6FmMUmou6aBL40JyfZf91CbYr/ra5pPJ1pYgRzt07tsmdQqd5vl+Th2l99pIop3DXl3SglhuCwKR4U6GRSWN6jl/XiEDxmqxX/d3Q5MBJp0cET20sD5VN+g32noJkxwrMeFKtf4guAW/6ty9XATclU7zG9Z92c3j+fUOajxQiU2OMBsUkRTXCm2sJh5njgLmrAsOuTA0De6FeGrteFNx+DzDhEBcXAO7j/rMeF8bTnAFDnCbn9KHt2+RZdNZxjztb42jvgaDcczbnhE16mpraow5+1z3Gfe4VWLo0lZ/dAW1QqIX6LPejuFnNs0nB3ev2l5hBvTrt9th+AJh39F7NCXGl6q9od+6fczh2A60622ysT7yQ5606i8i/MiBoSST40Qfj/zTA2PI+0fQE6+T//FU9wWH/w3cl6CHs6nX/+n6MgLz8PAPeL9cSL8PAAA=


name: Send Personalized WhatsApp Templates Triggered by KlickTipp with Auto-Responses
author_name: KlickTipp
author_username: KlickTipp
categories: []
created_at: 2025-05-08T10:59:08.584Z
updated_at: 2025-05-08T10:59:08.584Z
url: https://n8n.io/workflows/3937
scraped_at: 2025-12-24 13:02:44
description:
  Community Node Disclaimer: This workflow uses KlickTipp community nodes.

  How It Works

  This workflow automates personalized WhatsApp message template delivery triggered by events in KlickTipp or by messages sent to the Whatsapp Business account. When a contact triggers an Outbound, the workflow uses a pre-approved WhatsApp message template to send dynamic, real-time messages through the WhatsApp Business Cloud API. When receiving messages it checks whether a cancellation should be processed or if a auto-response is sent.

  This setup is ideal for time-sensitive campaigns such as:
  Birthday greetings
  Discount or promo notifications
  Follow-ups on product or service interest

  Key Features

  KlickTipp Trigger
  Starts the workflow when a specific outbound is triggered
  Typical use case: subcriber receives activation Tag and triggers an Outbound which sends a webhook call to trigger WhatsApp messaging.

  WhatsApp Business Cloud - Message Trigger
  Listens to messages from the contact and processes answers with answering auto-responder or by tagging the contact in KlickTipp.

  WhatsApp Business Cloud - Sending Template Messages
  Sends  WhatsApp message templates using a pre-approved template.
  Template placeholders are filled with data from KlickTipp custom fields.

  Setup Instructions

  Set up the KlickTipp and Whatsapp nodes in your n8n instance.
  Authenticate your WhatsApp and KlickTipp accounts.
  Create the necessary custom fields to match the data structure
  Verify and customize field assignments in the workflow to align with your specific form and subscriber list setup.

  | Field Label                 | Field Type  |
  |-----------------------------|-------------|
  | Whatsapp \| Product/service | Single line |
  | Whatsapp \| URL             | URL         |
  | Whatsapp \| Name/company    | Single line |
  | Whatsapp \| URL ending      | Single line |

  Testing & Deployment

  Use a real test contact with all required fields filled.
  Trigger the Outbound in KlickTipp using the activation tag and answer with a message to the template.
  Run the scenario once in n8n to verify successful delivery of the whatsapp message template to your test contact as well as the reception of the auto-responder and the subscription and tagging in KlickTipp to stop further messages.

  Campaign Expansion Ideas

  Connect campaign to process keywords like "STOP" from WhatsApp messages
  Pair WhatsApp with welcome email series for onboarding.
  Use tags like product_interest_X for precise segmentation.
  A/B test templates with different CTA formats or timings.
  Monitor CTRs via dynamic URLs in WhatsApp templates.

  Benefits

  Multi-channel engagement:** Adds WhatsApp to your marketing toolkit.
  Dynamic content:** Personalizes messages using contact data.
  KlickTipp campaign control** Whatsapp contacts can for example signal with messages like "STOP" to receive the according Tag in KlickTipp in order to start/end automations.

  &gt; 💡 Pro Tip: Customize the domain link ending per campaign or product line. This allows targeted redirects, e.g., meinshop.de/ProduktA or `mein

  Ressources:
  Send WhatsApp Templates with KlickTipp
  Use KlickTipp Community Node in n8n
  Automate Workflows: KlickTipp Integration in n8n

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.whatsAppTrigger","n8n-nodes-base.switch","CUSTOM.klicktippTrigger","n8n-nodes-base.whatsApp","n8n-nodes-base.whatsApp","CUSTOM.klicktipp","n8n-nodes-base.filter","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5076 characters]


name: Jira MCP Server
author_name: Tamer
author_username: tamerelzein
categories: []
created_at: 2025-05-08T12:10:18.039Z
updated_at: 2025-05-08T12:10:18.039Z
url: https://n8n.io/workflows/3939
scraped_at: 2025-12-24 13:02:44
description:
  What it does
  This n8n workflow creates a powerful AI-powered Jira management system that allows you to use Claude or other AI assistants to create, update, and manage Jira tickets through natural language requests. The workflow exposes key Jira functions as AI tools, enabling you to interact with your Jira instance through conversational commands.
  How it works

  The workflow sets up an MCP (Model Control Protocol) server, allowing compatible AI assistants to use a suite of Jira management tools
  The AI assistant can perform various Jira operations including:

  Creating new tickets with customized fields
  Adding comments to existing tickets
  Retrieving available status transitions for tickets
  Attaching files to tickets
  Changing ticket statuses
  Retrieving detailed information about tickets
  Getting available projects and issue types


  When you make a request to your AI assistant, it determines which Jira operation to perform and executes it through this workflow

  Setup Steps

  Prerequisites:

  Active Jira Cloud account with admin access
  n8n instance with the Langchain and MCP nodes installed
  Claude Desktop App or another compatible AI assistant


  Jira Credentials Setup:

  Configure your Jira Cloud API credentials in n8n 
  Ensure your Jira account has sufficient permissions for all operations


  Workflow Configuration:

  Import this template into your n8n instance
  Set up the MCP Trigger node with your desired path (currently "test_mcp")
  Verify that all Jira tool nodes are correctly connected to the MCP Server node
  Activate the workflow


  Using Claude as an MCP Client:

  Open your Claude Desktop App
  Navigate to Settings &gt; Developer Settings
  Enable "Connect to local MCP servers"
  Add a new connection with the URL path to your n8n MCP server (e.g., "http://localhost:5678/webhook/test_mcp")
  Start a new conversation and ask Claude to perform Jira tasks



  Example Usage with Claude
  Once you've set up the connection between Claude and your MCP server, you can use natural language to manage your Jira tickets. Here are some examples:

  Creating a ticket:
  "Claude, please create a new Jira ticket in the Web Development project with bug issue type. The summary should be 'Homepage loading slowly' and the description should be 'Users are experiencing delays of 5+ seconds when loading the homepage on mobile devices.'"
  Adding a comment:
  "Claude, please add a comment to Jira ticket WEB-123 saying 'This issue has been reproduced on multiple devices and browsers. Priority should be increased.'"
  Checking status:
  "Claude, can you get the details of ticket WEB-123 and tell me its current status?"
  Changing status:
  "Claude, please move ticket WEB-123 to 'In Progress' status."

  This workflow creates a seamless bridge between your AI assistant and Jira, making project management more efficient through natural language interactions.

nodes_used:
  ["n8n-nodes-base.jiraTool","n8n-nodes-base.jiraTool","n8n-nodes-base.jiraTool","n8n-nodes-base.jiraTool","n8n-nodes-base.jiraTool","@n8n/n8n-nodes-langchain.mcpTrigger","n8n-nodes-base.jiraTool","n8n-nodes-base.httpRequestTool"]

workflow_json_compressed:
  H4sIAAAAAAAAE62V247TSBCGX8XydXro8yFXwKBFsxJaxES7Emi06kP1xDCxg92ZBUV5d8oOMBMtQQRFufGh8tdXh/69rZtUz+vn+u0/L/9oW/HCXYpXC1nP6hUUX8+3ddMOxbcRrsa4zLV2KruUHEQVQMkgnUgGqJCO25xZBIvPrASqUjY6CKAhiug0BB096hZYre98gcse0nANZbO+7PAJFMAEpd/Abla3fgWY7c+m99Wry9fVNfT30I9/9rdDPX93gyFdgvFyuy8gMUdDzolYZTWRAECstIE4FYTJlnrLTf1dGHMjQTXplyZ+gDJqf16P71rbkkmcBD/AxXuMWXTdHQasu6EpTddiVmI5nWmKHGvfo2aBHmG2u73K33g3xbHd7CufM5Qbg3w+BOTjyOct8ilKE2Mu2RjsA9+zlCrsygraUpVuz7n4LU6tT+O0TEoGVhGfGCUyakMcF5EE0MwZYVJkjzhfQvnKVZXet/u0w6mM6sReeuQAxR3JnHIig6bEUs4Id4zx5CnPThz28lkpPi4P23n1O+0U9jRUpizkmBjRwiUirUokmOwI1coHpWOKRj9ay6Vvb+HxuKvr4svm5I7yE6dOpUtehUwgeElkEp74jL0VMtKstBM0Pzo9PziWe7inSPfkgfAOq4lL37QXq7he9M3t7RR8MHppZ4RNqP9BWHbdh8lmcIwMok74SgQimYrEU2aJzpAdN1IHyupf32kalDFWEDudPSkAd1oBSV5SYFHLEPjhTl8NwwZObTo7cY2NCC4BkyRx7dGylCJOc0ki2ibHxiRBwyHW6757D7EMlW/TnrFaoPbx9ViWsn4DHzcwlP8D/wqtvOA7jPGxNPewt+dZPUApTTsa8baGTxA3o+BffcLpzut7VqPI/V5gGmb02QYXLUmZAw5TormAR382RlGn8/hDsti1LRY3GQgKP4wBb3zzbxn55+/Q78f6fraF34Jn+OlK8Kme093NDTL9wPTPJX3EB89GftQXzpXhJx+cc/bo6AKfs47jZn+eLLvdFy3NJP01CQAA


name: Document Q&A Chatbot with Gemini AI and Supabase Vector Search for Telegram
author_name: Mohammad Ghaffarifar
author_username: mohamadghaffari
categories: []
created_at: 2025-05-08T14:40:13.702Z
updated_at: 2025-05-08T14:40:13.702Z
url: https://n8n.io/workflows/3940
scraped_at: 2025-12-24 13:02:41
description:
  This template creates a Telegram AI Assistant that answers questions based on your documents, powered by Google Gemini and Supabase. Key features include Intelligent HTML Post-processing for rich formatting in Telegram and Adaptive Message Chunking to handle long text responses.
  📹 Watch the Bot in Action



  ▶️ Click the image above to watch a live demo on YouTube. 

  This video provides a live demonstration of the bot's core features and how it interacts. See a quick walkthrough of its capabilities and user flow.

  How it works:

  User uploads a PDF document to a Telegram bot.

  The workflow processes the PDF, creates embeddings using Google Gemini, and stores these embeddings in a Supabase vector table.

  Users then ask questions to the bot.

  The workflow performs a vector search in Supabase to find relevant document chunks based on the user's query.

  Google Gemini uses the retrieved relevant chunks to generate an intelligent answer.

  The bot sends the formatted answer back to the user on Telegram, utilizing HTML markup for enhanced presentation.

  Set up steps:

  Setup should take approximately 15-20 minutes.

  Import the workflow into your n8n instance.

  Configure credentials for Telegram, Google Gemini, and Supabase.

  Set up your Supabase vector table using the provided SQL script.

  Activate the workflow.

  Detailed setup instructions, including how to get API keys and configure nodes, are available in the sticky notes within the workflow itself.

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.openWeatherMapTool","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.telegramTrigger","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.toolThink","@n8n/n8n-nodes-langchain.embeddingsGoogleGemini","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter","n8n-nodes-base.extractFromFile","@n8n/n8n-nodes-langchain.toolVectorStore","@n8n/n8n-nodes-langchain.vectorStoreSupabase","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.vectorStoreSupabase","n8n-nodes-base.switch","n8n-nodes-base.telegram","n8n-nodes-base.aggregate","n8n-nodes-base.telegram","n8n-nodes-base.splitOut","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram"]

workflow_json_compressed:
  [encoded data, 14672 characters]


name: AI-Powered Restaurant Order Chatbot with GPT-4o for POS Integration
author_name: Kumar Shivam
author_username: shivam840708
categories: []
created_at: 2025-05-08T15:20:19.166Z
updated_at: 2025-05-08T15:20:19.166Z
url: https://n8n.io/workflows/3942
scraped_at: 2025-12-24 13:02:41
description:
  This workflow automates the restaurant POS (Point of Sale) data management process, facilitating seamless order handling, customer tracking, inventory management, and sales reporting. It retrieves order details, processes payment information, updates inventory, and generates real-time sales reports, all integrated into a centralized system that improves restaurant operations.

  The workflow integrates various systems, including a POS terminal to gather order data, payment gateways to process transactions, inventory management tools to update stock, and reporting tools like Google Sheets or an internal database for generating sales and performance reports.

  Who Needs Restaurant POS Automation?
  This POS automation workflow is ideal for restaurant owners, managers, and staff looking to streamline their operations:

  Restaurant Owners – Automate order processing, track sales, and monitor inventory to ensure smooth operations.

  Managers – Access real-time sales data and performance reports to make informed decisions.

  Staff – Reduce manual work, focusing on providing better customer service while the system handles orders and payments.

  Inventory Teams – Automatically update inventory levels based on orders and ingredient usage.

  If you need a reliable and automated POS solution to manage restaurant orders, payments, inventory, and reporting, this workflow minimizes human error, boosts efficiency, and saves valuable time.

  Why Use This Workflow?

  End-to-End Automation – Automates everything from order input to inventory updates and sales reporting.

  Seamless Integration – Connects POS, payment systems, inventory management, and reporting tools for smooth data flow.(if needed)

  Real-Time Data – Provides up-to-the-minute reports on sales, stock levels, and order statuses.

  Scalable & Efficient – Supports multiple locations, multiple users, and high order volumes.

  Step-by-Step: How This Workflow Manages POS Data

  Collect Orders – Retrieves order details from the POS system, including customer information, ordered items, and payment details.

  Update Inventory – Decreases inventory levels based on sold items, ensuring stock counts are always accurate.

  Generate Reports – Compiles sales, revenue, and inventory data into real-time reports and stores them in Google Sheets or an internal database.

  Track Customer Data – Keeps a log of customer details and order history for better service and marketing insights.

  Customization: Tailor to Your Needs

  Multiple POS Systems – Adapt the workflow to work with different POS systems or terminals based on your restaurant setup.

  Custom Reporting – Modify the reporting format or include specific sales metrics (e.g., daily totals, best-selling items, employee performance).

  Inventory Management – Adjust inventory updates to include alerts when stock reaches critical levels or needs reordering.

  Integration with Accounting Software – Connect with platforms like QuickBooks for automated financial tracking.

  🔑 Prerequisites

  POS System Integration – Ensure the POS system can export order data in a compatible format.

  Payment Gateway API – Set up the necessary API keys for payment processing (e.g., Stripe, PayPal).

  Inventory Management Tools – Use inventory software or databases that can automatically update stock levels.

  Reporting Tools – Use Google Sheets or an internal database to store and generate sales and inventory reports.

  🚀 Installation & Setup

  Configure Credentials

  Set up API credentials for payment gateways and inventory management tools.

  Import Workflow

  Import the workflow into your automation platform (e.g., n8n, Zapier).

  Link POS system, payment gateway, and inventory management systems.

  Test & Run

  Process a test order to ensure that data flows correctly through each step.

  Verify that inventory updates and reports are generated as expected.

  ⚠ Important

  Data Privacy – Ensure compliance with data protection regulations (e.g., GDPR, PCI DSS) when handling customer payment and order data.

  System Downtime – Monitor system performance to ensure that the workflow runs without disruptions during peak hours.

  Summary
  This restaurant POS automation workflow integrates order management, payment processing, inventory updates, and real-time reporting, enabling efficient restaurant operations. Whether you are running a single location or a chain of restaurants, this solution streamlines daily tasks, reduces errors, and provides valuable insights, saving time and improving customer satisfaction. 🚀

nodes_used:
  ["@n8n/n8n-nodes-langchain.informationExtractor","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.executeWorkflowTrigger","@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5392 characters]


name: Control your discord server with natural language via GPT4o and MCP Client
author_name: David Ashby
author_username: cfomodz
categories: []
created_at: 2025-05-08T19:32:58.874Z
updated_at: 2025-05-08T19:32:58.874Z
url: https://n8n.io/workflows/3945
scraped_at: 2025-12-24 13:02:45
description:
  What it is-
  Very simple connection to your Discord MCP Server and 4o.

  How to set it up-
  Just specify your MCP Server's url, select your OpenAI credential, and you're set!



  How to use it-
  You can now send a chat message to the production URL from anywhere and the actions will occur on discord! It really is that easy.



  Note: If you don't yet have a Discord MCP server set up, there is a template called "Discord MCP Server" to get you a jumpstart!

  Need help? Want access to more workflows and even live Q&A sessions with a top verified n8n creator.. All 100% free?

  Join the community

nodes_used:
  ["@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.mcpClientTool","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE5VWa2/bNhT9K6z6YRtgJhKppz8t6AYsWNNubbqua4qCIq8sLjKpSZQdp/B/36UsO03jvoAYkajLy3vOuQ9+CLQK5sHNC9n8fZb8edtdcpm+yoNZsAQngvmHQJveCSPh3NvlBY8gU2VSMMmKNJTAEp6HEQhWhDJSMk0hjrOMxxK4KtKcRyFPkzRNJFQyD4PtLDBiCejqF91L2yly8eQP8qQWjpwtwDg82IlFH8zfvkNLq8A/ftgFyWUY5uib5iGTNE4jSQuehLSKmZJJxYu0kMHB/9n5ncdN61d+Nrk5xR8d/dJGmIWshTYnYrJrba+dtgaPjMJwRuM4xCha0aFHB13v6bCtt/CP2+3O81/4ZdwUnRTb2RRrUSalYhGjUVFirDzkVBQ8pmWW8yqTZQIiu4v1dQ2GSE/CEvoewyEdSNArUN8Qvd932enFArr7GGiUHkCsoaytvR5FzAqWR4KFNBUV0DjKcyogz6hEgUrIeCaUj+07cEcH3JyJLEoYus1A0DhPCioET2jFWCjSQqkyVHe4n7dgUKdR/guE1XwD3Gbpzced+j5ehmjZEcmWo2d8eP++w/+uG2A2LuIxje698ivRDP510ToaW1yQQtagXkA/NO7ZLtjpG6K/z4XsQGH+aNFMRPnIzlo9Fo/n5Oy1vV2V57+9vlTd72/+cZ/g10RIaQfMwCPMsgOzpSxYGFcZDaMoxYySmP1xpmiuWJljUkkmeXC8uhr9bXWwlO3O9tLa5j63PP4MuX0PvxrVWo0nzIPauXZ+etpYKZra9m6epFl+in5PY4w9zDnQilcxhp/kFN8qWuRhHBYF+EZyis6CBxwcGABf51wkNIlTjnlb5LRMi4hWVQ6FSrG/FOyOgZdOy+sNeWYd3EG/Q12KHk760WYy+bhyRrhZ+BDuWitXB3OWh7OgBr2oETXHMgukNQ5GDh4/Js+EGzrRkKdI7eDL+dy0g7syb+xApMBSF01Dqs4uiTDW1dCRte2uq8auZ6TWjuDSrh3ARO2M2I7ACruE/3xv517p0jqiK7LBI9YCY1HE2UfkzGyImaJp9tFIu1wKo0hf26FR49mk0gYIJQ34HkSujV3vvaGp3+QsKTsQ16S3SEetzYJ4H+dkrRFMg82FYMBDq4Tz3zwEB8u2EQ4efUFUGcdlxkPMC4hKGuMYoYKlgB1Jhdg+mJRKHhU1+m5V2Vc0ZR9pmsSfauprAvUQZYPUjhPjypzvGBIdkIUdUVvSr0U7oh/bDrEDivfv0COt4hpIP6Ct89Jq90NPrJnefFbUyGfjibZNf4IYSd+CxLZC+k2PVJIWZW/dXrUSiAHsPIpUmBv+wEZ0XtzGDmp3eD/ba7iwKJOriSD/DZgc+hYmE7LSgjxvGrEU3ofZKe45GL17QNKKG4wW95banXxByjxLo4qnOQXs9dj7RUnLqqpopGJI4zBSLC2OSsm+W8rP1ufn9XvYEU9fQreC7spc1ron+Oesw8LcEIly2aW+9VqTHzf7orXGgPTCeVYEFpZ31Y8+SLnxBWsW+9R/9eLpTzNSDoeaHNkUBO9S3VgfU1kfnNcgr32ykOWGXAUXu5rDrx1RU+DTSaOOD0p6agmbNbYEuAoOpUdE/+DUYxoikUI6vHHs52MPzu8YSYUbkINn/nmn8JIxD1aRd7HabR/vFFilOS9TRsMkQu0F9mYcTAnlKc9KrkSYMD+dJg6n6Xlk/uOi0O/3sKa1t3gDNLt5/fBW98B8hldWBTfBPNy+e4dhHhmFu1N8oX3dudvNwvs+v3Bh8xcOHKZfcTya3Pe63f4PvtNN5I0LAAA=


name: Control Discord Bot with Natural Language via MCP Server
author_name: David Ashby
author_username: cfomodz
categories: []
created_at: 2025-05-08T19:55:25.245Z
updated_at: 2025-05-08T19:55:25.245Z
url: https://n8n.io/workflows/3946
scraped_at: 2025-12-24 13:02:45
description:
  What it is-
  I wanted to create a simple, easy-to-use, MCP server for your Discord bot(s).

  How to set up-
  Literally all you do is select your bot auth (or crease a new Discord Bot auth if you havn't entered your key in n8n before) and that's IT!

  How to use it-
  You can now ask your bot to do things via any MCP client, including from within N8N workflows!

  Note:
  If you need an example, you can check out my simple quickstart Discord MCP Server that uses 4o to send messages to channels on your server and users who are members of the server the bot is in.

  Need help? Want access to more workflows and even live Q&A sessions with a top verified n8n creator.. All 100% free?

  Join the community

nodes_used:
  ["n8n-nodes-base.discordTool","n8n-nodes-base.discordTool","n8n-nodes-base.discordTool","@n8n/n8n-nodes-langchain.mcpTrigger","n8n-nodes-base.discordTool","n8n-nodes-base.discordTool","n8n-nodes-base.discordTool","n8n-nodes-base.discordTool","n8n-nodes-base.discordTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE+1aC2/cxhH+K9tDASfGrbVLLsmlgAKRbaBV0TSGrThNYsNZ7g7vWN2RFz50vgr6751Z8h6WTrIsWLZTFxase+xj5ptvntT5qHCjw9Fspc0v02en0S/Hunssfh6NR3NozejwfFSUTWtKC8e0TqehhMRlURrYII2FhSAKtZBgglRY6Wwcg1JJEioLoUtjHUoRxlEcRxZyqwWe28J8MTMtPKnBNS+g7RZPKvwEWsAL2rqDi/GoNHPA254Wja1qx75/8oy9gPoMatpvJs3o8NfXuKpyQC/Pex1i0ImLZcBDIWKu8G6epYnmOkmkznUaRIkbbc5+AaVjmwugacwEWFuxJ1NTljCji1YLWljqkvubeGYaeOT6LSdVRWsWVVO0RVWiFGEsxoEWKNcSsmlVnXrAUpEhKiblNlEBVzYBbiBHyUxkVGKjXMck1MLUKFYLdUOQ26psoWxx+1/Oz9nBQxLBdG3FJ1BCjdg5ntfV/OiYV4hJXTh4eMD+3H/0zYNBmQdj9ttvY/agaeuinDz4ll1c4EWTrpg5kux89OZNPesRR2OjgnhdQbKcmVkHd7y7t9K+q9Gq1YKgIg3xTQ1N1dWWLpr3AuPVtgf//uQbrLtXQBTKIicR+MLMvB0GWz+u2qNF4X2BTPri79M6eBn+a6keh/nL33/acuqv1WKKHKWTiDwv0ZyeG8HFeNgbBkYmJgm5TqOQo6coblSa89RJa4W1IWTB9rwj59jzagbspEKKzrOe/x9GSx4IMY7iy7wEJY2OwPIwl+gsKrfcOJ2g28jECidyacUVXtYoyx2BJzX2M7JroL4/g//YXEvHz+kK77B/MGy1oEO91TzSaP3Rp+BkrDUYHWBMwt9cZRnSMbYZN7HCmJljnDfp9rznMEdte1qSqmx+d2L+n5d/RF72DPgk1JROG6lyyTXEGC4lJnctkpjLKFNKaKuRIKMbygV2UheTyS47v0OwDrYUnZlygkmnKB/N7WK7eIemyFJ+Na0roXKhQ+B5mCuuwgjLjBDQcbRQIk2ByqIrNF2YdnrbvZcxkVt3TWKBAiU8lAF6SBQrrnM0eSqDKJKQ6UBlOxhDy4as2rAqZ02PS7Zavzp++uGuqxCU4DIkSWhVCjLkgYIUPVdLnorAcRPlIcg8EiIMrkDyxZQjuySfQHs0I5VrrE7rkl7fMbj4/W/wgLUIGWIJptzIcO8eFGHADEWY8kRQ/akzzdM0sVwGmTUmNkia+F229H7/8ciCHnuVLJC52CXO8czmmHMiFfNMaccjSHQcyCBF4a6QxeT46o6mOKK9f6SSeAi+/wMUBAuJEXHEwzjLMJHHCUfmSR5LARGGwiwIrvRl3zODv34yRcvyqmY1LGaru5QY+qP1ZA3KdVLhbqoLvtbyYN2p3UNj+v7mcDdEkzWOSkcE8U7SLHAvnPT0yGuAE3jbfhJ22zBxQiWaR5kQXLlA8kzkjicQ5CZUidBgL7F7O2V4l+XP78by6OOR/Kvl1mcdPHyp1M4zLVKZRVxKhYE7CIBnEBkeKxm61ICN0vRq4EZ2/9jcqSH8eAO0LyZYf6WTvE8ytshjmUltuHYp9kHGZljZKiomkR6BlSKXlyrbdX/4Yl3MNteSdNq2i+fwewdNe5WoEgMu95OLd1nXkRVGtLU5PDgYNH5kq/mBWRQHZ1IcEA+bg+/mcOCt11yOTWieKYFm18FgQSjmRQnuyQZPHwpQcJTrKTS2LhbDYqz16gLOoGF4CqpHJTwYO2WDKOsqnr7NqpYVDcPGd9QP0i+df3jJYvdnUfVoZzyaQ5qlJuMutRp7SKl4FhrFhXQGq8jImSTZiTgI1OmK/bNq4VpDNn7NsGTXhmK/DadQTKborzF+v+O9r8r9/06mCCL2iw0zsxnhTdj2MJMVTMtW6BsbAwyo266u8dzZivBnxzktYlNzBsz0S0o2r2qgA0pWlesTx37dssCbSgBfR8yQ1lg9nJbVkmEFgfdhbd+0bFqULb1bTgu0/2D3gi4f0zp8NTcrEpw1bWdPN0I0C7BFvkI5hoyIMtRVN5n2epQGuwkzYzQ26eiBSd37yJj0Lr3yFH9m/vRTgAVr6xUGDhLVX9Yj82A7kjgrjN822c4pGJlvV8oCgekWLIOcQMGV7XAkbazJXgTSt4/IIGTpQ+bNgj+oRte01ZwdPTtmlkzUNX4vWQmtvgkJhDo53xgvb8kK6J4tRzu82kyVyN9ejRhnxwxKi2iQ/oQZ6VaxJeDpGawqKvDweBmhGe2sc9BvHeiA9GSLujrDaNv4og9PQPQ9LR6i6VYP6TxXjX1piAehxqaGMZsVSFHUYEUi4rt5gaTDpcuBZKheifuQHu2UbvnTDSMkq3WM6RzjvwgVV6mjIWuSYDMeg7ROpZHRe91MfrCfbZ+Kvetny8LRMCwkN1v7XKBu6XPQgCdJw6AgiBjle7KaaQrLhiTUT6c9bcm6CNWW1FW/hQiyXk1wLw2BSlYxbF149ccYNu3mCPA3fzs++ce3j27ANoxdlFkb8jzNsV6R2Ojq0GnukpiGfiYFbfdiG3wwtjvt7ZcALiU3789YBO4APPTy12NL3nJbdOMoi50Mgcd5mnCVKctTIxzX2H0lWRzHVsu96IZ3QHfz4GwvulGwgy7R/BboPqurCR41x/RuGc3SmXHOX+gxqmmyjuEVHZ79GwMXa5cVg7eGHo836+yCQGEMoP/7uHKwjm3bhONjwdyc+gfaQ/zy0fFn+q7qZg7DdFm0aAwySLMw8zEFbmYyNKLPEHh8O6VQiUG6D3NLg9q5QU6yn6OIWXldKC7RmNArQLuwn5k3rMNqYbYRyE7BnlJQr7p2Kw19UQNWo8zMzX9o77KqT/NZtRz0GaLoJocOzUEz7ukHb4vG54PKk3Wz+Rot6L5ibiZYUnlVfNZFmequLP0p5ZbVlIaLsmuhT1PGP1iwswJt3OcoXGAwFfvUu5FjLcFNARjCNJAyT3iiEok0Fhk3QRTyJM0khCKIw0jtpbG6W5DYV+kMNKavd5j7Q2kBIe5x2RYzQzW58wGuIUYQw7DWwNRkW597xvQNoYxEz3xVtDNQ3tnvbbuuRGl9A3CT52uVh7GNHbdpKrjSTvA0DDQPA6OE1SJMdwfZO5BFHwwZPd74rIhtqqNb4INS4kFYIq0bwKavj7zE8BZsR1r9UDs/Oj+TdMRZv9331xm4XFoV8SDIBTX5FhsqrAVMJiJtpbVg6HES6luCXbcqV5p9ms4XbygeIX6/nvuO4pZP5Nb7xqOidPB2dCguXr9GIff88cM93HJNX3gPN1334Pwerrphhn5vt13/l1T3ZLX3PKe6L0VvHt7ek67ve4L70a+9uPgvdsl4RxkoAAA=


name: AI Personal Assistant with GPT-4o, RAG & Voice for WhatsApp using Supabase
author_name: Amanda Benks
author_username: amanda
categories: []
created_at: 2025-05-08T20:10:41.254Z
updated_at: 2025-05-08T20:10:41.254Z
url: https://n8n.io/workflows/3947
scraped_at: 2025-12-24 13:02:43
description:
  🧠 Intelligent AI Assistant with RAG & Voice for WhatsApp – Built with GPT-4o & Supabase

  📌 About this workflow and its creator

  Hi! I’m Amanda, a creator of intelligent automations using n8n and Make. I’ve been building AI-powered workflows for over 2 years, always focused on usability and innovation. This one here is very special to me – a truly advanced AI assistant that reads, listens, interprets and responds like a real human 🤖✨

  This ready-to-use workflow acts as a powerful AI personal assistant capable of understanding messages via voice, text, documents, or even images. It supports full multi-channel operation (WhatsApp via Evolution API, Instagram, Facebook, and more), and includes advanced RAG capabilities using Supabase + GPT-4o. It’s designed to be highly extensible, with memory, prompt update tools, and knowledge base management.

  ⚙️ What this workflow does

  💬 Understands user input via text, document, audio or image (voice, OCR, PDF)
  🎤 Transcribes and interprets voice messages using OpenAI Whisper
  🧠 Understands prompts and user commands using GPT-4o via LangChain agent
  🗂️ Searches knowledge base using RAG + Supabase vector DB
  📄 Accepts documents and automatically indexes them for future questions
  🧾 Summarizes documents and stores metadata in Supabase
  🗃️ Offers memory support (PostgreSQL chat memory per user session)
  📧 Sends replies through WhatsApp (Evolution API), Instagram, Facebook, etc.
  📅 Manages schedules (via tool integration with Google Calendar)
  📬 Sends and searches emails (with support tools)
  🛠 Modular and expandable structure (tools for saving knowledge, deleting, updating prompt)

  🔧 Setup Instructions

  n8n Hosting  
     This workflow requires n8n self-hosted (or n8n Cloud with custom credentials + community nodes enabled).

  Create required databases  
     Use the provided SQL queries inside the setar_supabase_tabelas_vectoriais, criar_cerebro, and criar_rag_controle nodes to initialize:
     documents table for RAG
     cerebro table for prompt
     memoria_chat for session memory
     rag_controle for summaries and indexing

  Credentials needed
     OpenAI API (for chat, embeddings and Whisper transcription)
     Redis (for managing message buffer)
     Supabase (for vector store + metadata)
     Postgres (for memory and prompts)
     Evolution API (or other messaging platforms)

  Webhook
     Set the webhook path to receive messages from your Evolution or WhatsApp API provider.

  Configure ‘Set’ node
     In the config node, adjust:
     adminNumero: your personal WhatsApp or admin number
     evolutionApiKey: your private API key
     utilizacaoApenasViaAdmin: toggle if this should only respond to admin numbers

  Tool connections
     Ensure the supporting workflows are also imported and connected for:
     Emails
     Knowledge management
     Calendar events

  📎 Notes

  This workflow uses LangChain agents, OpenAI GPT-4o, Supabase, Redis, and PostgreSQL.
  It includes multiple “sticky notes” inside the workflow with explanations.
  Ideal for businesses, consultants, and developers looking to offer an intelligent and extendable AI chatbot experience.

  🛍 Want to use this on your system?
  ❤️ Buy workflows: https://iloveflows.com  
  ☁️ Use n8n Cloud with my partner link: https://n8n.partnerlinks.io/amanda

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.convertToFile","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.wait","n8n-nodes-base.redis","n8n-nodes-base.if","n8n-nodes-base.redis","n8n-nodes-base.redis","n8n-nodes-base.set","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.stickyNote","n8n-nodes-base.postgres","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.embeddingsOpenAi","@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter","n8n-nodes-base.set","n8n-nodes-base.supabase","n8n-nodes-base.extractFromFile","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.embeddingsOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.vectorStoreSupabase","@n8n/n8n-nodes-langchain.toolWorkflow","n8n-nodes-base.postgres","n8n-nodes-base.stickyNote","n8n-nodes-base.postgres","@n8n/n8n-nodes-langchain.memoryPostgresChat","n8n-nodes-base.stickyNote","n8n-nodes-base.postgres","n8n-nodes-base.convertToFile","n8n-nodes-base.set","n8n-nodes-base.switch","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.stickyNote","n8n-nodes-base.postgres","n8n-nodes-base.postgres","n8n-nodes-base.postgres","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.vectorStoreSupabase","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.toolWorkflow","n8n-nodes-base.convertToFile","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.switch","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.merge","n8n-nodes-base.switch","n8n-nodes-base.executeWorkflow","n8n-nodes-base.set","n8n-nodes-base.webhook","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.toolWorkflow","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.postgres","@n8n/n8n-nodes-langchain.memoryPostgresChat","n8n-nodes-base.postgres","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.toolVectorStore","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5864 characters]


name: Automated Facebook Comment Management with GPT-4o and LangChain
author_name: Amanda Benks
author_username: amanda
categories: []
created_at: 2025-05-08T23:37:45.563Z
updated_at: 2025-05-08T23:37:45.563Z
url: https://n8n.io/workflows/3949
scraped_at: 2025-12-24 13:02:44
description:
  🤖 Facebook AI Agent with MCP Server – Built for Smart Engagement and Automation

  Hi! I’m Amanda 🥰😘 — I build intelligent automations with n8n and Make.  
  This powerful workflow was designed to help teams automatically handle Facebook page interactions with AI. Using Meta Graph API, LangChain, MCP Server, and GPT-4o, it allows your AI agent to search for posts, read captions, fetch comments, and even reply or message followers, all through structured tools.

  🔧 What the workflow does

  Searches for recent media using Facebook Page ID and access token  
  Reads and extracts captions or media URLs  
  Fetches comments and specific replies from each post  
  Replies to comments automatically with GPT-generated responses  
  Sends direct messages to followers who commented  
  Maps user input and session to keep memory context via LangChain  
  Communicates via Server-Sent Events (SSE) using your MCP Server URL

  🧰 Nodes & Tech Used

  LangChain Agent + Chat Model with GPT-4o  
  Memory Buffer for session memory  
  toolHttpRequest to search media, comments, and send replies  
  MCP Trigger and MCP Tool (custom SSE connection)  
  Set node for input and variable assignment  
  Webhook and JSON for Facebook API structure

  ⚙️ Setup Instructions

  Create your Facebook App in Meta Developer Portal  
  Add your Facebook Page ID and Access Token in the Set node  
  Update the MCP Server Tool URL in the MCP Facebook node  
     Use your n8n server URL (e.g. https://yourdomain.com/mcp/server/facebook/sse)  
  Trigger the workflow using the included LangChain Chat Trigger  
  Interact via text to ask the agent to:
     “Get latest posts”  
     “Reply to comment X with this message”  
     “Send DM to this user about...”  

  👥 Who this is for

  Social media teams managing multiple Facebook pages  
  Brands automating engagement with followers  
  Agencies creating smart, autonomous digital assistants  
  Developers building conversational bots for Facebook

  ✅ Requirements

  Meta Graph API access  
  Facebook Page (with permissions)  
  n8n instance (Cloud or Self-hosted)  
  MCP Server configured (SSE Endpoint enabled)  
  OpenAI API Key (for GPT-4o + LangChain)

  🌐 Want to use this workflow?

  ❤️ Buy workflows: https://iloveflows.com  
  ☁️ Try n8n Cloud: https://n8n.partnerlinks.io/amanda

nodes_used:
  ["@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.mcpTrigger","@n8n/n8n-nodes-langchain.mcpClientTool","@n8n/n8n-nodes-langchain.toolHttpRequest","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.toolHttpRequest","@n8n/n8n-nodes-langchain.toolHttpRequest","@n8n/n8n-nodes-langchain.toolHttpRequest","@n8n/n8n-nodes-langchain.toolHttpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE7WXS24bRxBArzKYRVZspf8friLLcOIEig1bsB0bRtCfamlgcoYmh7ZkQUCQC2QRIFlmk0PkPLlAcoTUUB+SEiWRliJIBIaqqX71rz4uq1T2y2effpi+b2B0WB3u5O8+VWWvHELry/5xWdWT1tcRHndywbjknUoxsKAdQIhCGpp1TlaIZEAJENZFzl00TAurQwoWTOSO+cSDQ70tDEcD38LOGNLkObTT0U6D30ALeEA7nsJJr6z9EPC0f//487fikY8QmuZdsbvztNh+XGzvQ90Wf//0a/EMfOrh52hwVHxR7Pra70OByoYoMCk+Vu1B8fXTPSKb7lS/Pyn7b45Pzd1vRjWMv331/YPm9YNPu6/KiyMfDaaHTeGLF1Anj1/HMSBr2m7xf5xyRSj+6j3G+lz2mdyyQr5Gseko3S528haPaRIsgJjAhFKCEidoINIJSYJigQTPOPfSO51gDvfyAOoiHvi2GMJk0lk7hgjVB/QcWng06mS+qm39Jf6R2Ulk4Ot9fKOqt7r39sbV/j6MUXrUTKq2ampEIUzTntAU6T5COEBXz0JNOVDIlJEoo0A0aoinMRHKUxIqJ2G06RT5McK1MEarjk9OMV7g00w322InvTNTHdeGpuwJpg0lUriIVtJINFCtZKKOczY39TzQaxjmz+QWTBKS9vjMolvw3AVedEkyKTJx+EOkopZ4nxlhIUcjEgemFvCeV13KFrswbMZHazAOZ4IPpjnD+GVVp+bjMrCktCf5GsDiAliGyKXB0DBlgUgfFbHGU2KsDQZklNSFcqGUfv/5n79+mRXReUWtwx1HK3OGMU57TF7OGS0Yxf6gMZ1lItgZOPEpYaCt0zIySI6rW3PmwkLqpOHeZMKsMGghj8TnnEn2ifmsArAk5hZubtnOoMLM2WuawbJxRq4XjAtQxkGpxDgJMmAVU2DEsgBoNktUyWCEXKji5+DH8QBzJ1V+DdAW+b5p29EzeD+FyaVEd13p2jXyZg5rpZGMeU+EzpzIIBWmfEL/CplZFAxo5Av98KL7+tGoqvfnwHPW4CewNYFLaBdN5UYysSXnJRhlcCZkQpNFHsxmYrPXJIgE1qZMRVzI6Jn/ioc4parB5K5+ZIxu7MioXVbcJRKj69ynPcYf+xu1StiYYxZUX4n62Xi6My+XG/NiQ3AUS4lgXSkieeLEcuEIOGEZVdHRoOa8p2P1vnARdVNcFk2WEudP4FpjnjJFQtQRJyuuG4xnpu1iQ8Z5XTyscB62WFmz4XhnaMU3hsY2kLKNmqTO0dhEDLGaYgoz3IkyeOl4XoBuq/juqPi+aeH6uprJnIks0J233yW0MjZ128WrX5Y3tCuTQsrMkYw9mchoEvHOAXHSeatljlLBSki2MaWhd+CkAfOTK0koeg/7P04Cyxzmr9UpaushB7+Sk2/M2ZXTZ3Pi8mIEE4lwjvuMBBx9wSuF+0MMQWnc8MRC39rp9rddRBqskaCDYSf+ZAT1dnWJ2K65MfC5P7MPuLxnErpoS58CsQJbl80um8yZw31zpT/Fxv50GPfPzU7tDY73QEySGb0JOPWNlUQwHPnBBlwDVlPKz6ihDRlR2scWF+6yn/1gAr0Sx16LY3H2KhxCnHaqn4wTLkz98gPrdHw4fX+2IPEAqhtyhHuFIciAWZIAkzs7JfFKBZ53ZiBEjZ0M35opXkgZfPLVj12CTLHFnX33Bq8Tnbkr9+Yr4j280iU4LPv05O1b5FtanE71d33xdrXt6ea0rG1pu7lG283L6HWalwf+vapeHnb3qnr5pnCqenj2cJuDh+fXi5Uu/l9wr+x7qH2InegW2JnIVc6rM/leYW+4D6/Cvn6XXYF/cvIfqQYQZBsRAAA=


name: Extract Named Entities from Web Pages with Google Natural Language API
author_name: Hueston
author_username: hueston
categories: []
created_at: 2025-05-08T23:46:13.171Z
updated_at: 2025-05-08T23:46:13.171Z
url: https://n8n.io/workflows/3950
scraped_at: 2025-12-24 13:02:45
description:
  Who is this for?

  Content strategists analyzing web page semantic content
  SEO professionals conducting entity-based analysis
  Data analysts extracting structured data from web pages
  Marketers researching competitor content strategies
  Researchers organizing and categorizing web content
  Anyone needing to automatically extract entities from web pages

  What problem is this workflow solving?
  Manually identifying and categorizing entities (people, organizations, locations, etc.) on web pages is time-consuming and error-prone. This workflow solves this challenge by:

  Automating the extraction of named entities from any web page
  Leveraging Google's powerful Natural Language API for accurate entity recognition
  Processing web pages through a simple webhook interface
  Providing structured entity data that can be used for analysis or further processing
  Eliminating hours of manual content analysis and categorization

  What this workflow does
  This workflow creates an automated pipeline between a webhook and Google's Natural Language API to:

  Receive a URL through a webhook endpoint
  Fetch the HTML content from the specified URL
  Clean and prepare the HTML for processing
  Submit the HTML to Google's Natural Language API for entity analysis
  Return the structured entity data through the webhook response
  Extract entities including people, organizations, locations, and more with their salience scores

  Setup
  Prerequisites:
  An n8n instance (cloud or self-hosted)
  Google Cloud Platform account with Natural Language API enabled
  Google API key with access to the Natural Language API

  Google Cloud Setup:

  Create a project in Google Cloud Platform
  Enable the Natural Language API for your project
  Create an API key with access to the Natural Language API
  Copy your API key for use in the workflow

  n8n Setup:

  Import the workflow JSON into your n8n instance
  Replace "YOUR-GOOGLE-API-KEY" in the "Google Entities" node with your actual API key
  Activate the workflow to enable the webhook endpoint
  Copy the webhook URL from the "Webhook" node for later use

  Testing:

  Use a tool like Postman or cURL to send a POST request to your webhook URL
  Include a JSON body with the URL you want to analyze: {"url": "https://example.com"}
  Verify that you receive a response containing the entity analysis data

  How to customize this workflow to your needs
  Analyzing Specific Entity 

  Modify the "Google Entities" node parameters to include entityType filters
  Add a "Function" node after "Google Entities" to filter specific entity types
  Create conditions to extract only entities of interest (people, organizations, etc.)

  Processing Multiple URLs in Batch:

  Replace the webhook with a different trigger (HTTP Request, Google Sheets, etc.)
  Add a "Split In Batches" node to process multiple URLs
  Use a "Merge" node to combine results before sending the response

  Enhancing Entity Data:

  Add additional API calls to enrich extracted entities with more information
  Implement sentiment analysis alongside entity extraction
  Create a data transformation node to format entities by type or relevance

  Additional Notes

  This workflow respects Google's API rate limits by processing one URL at a time
  The Natural Language API may not identify all entities on a page, particularly for highly technical content
  HTML content is trimmed to 100,000 characters if longer to avoid API limitations
  Consider legal and privacy implications when analyzing and storing entity data from web pages
  You may want to adjust the HTML cleaning process for specific website structures

  ❤️ Hueston SEO Team

nodes_used:
  ["n8n-nodes-base.respondToWebhook","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.webhook","n8n-nodes-base.httpRequest","n8n-nodes-base.code"]

workflow_json_compressed:
  H4sIAAAAAAAAE51XDXPbNhL9KximM7VnRJmfEqlO78bNuY5bx/LZcjvtsTMBAVBiTAEsCUpWPPrvtwtSlizLTu4ymYQEF4u3b3cfVo9Wzq2RFSyvp9fpg1afq7vx8F8PVs+aC02t0aOVy1pTycQF2mXBYBC6fhCFsZPFbCh8McxE7HpuJHgQwyoLQ5+mQ3/IQ8a8YBiDeTzMsijMaOxb654l6VyAq3OlpoUg13QqyJnUuV6RswddUaZzJclEzMuCagFANJ3W1ug/jy3S2U/3VfbF/3zlnKd301+o9b87ZJWAB36qYZPneKHtwN9o4vkjLx75cd9x3T/BrCn5183Wf8H5iosdhNHQjTOXC9ujvrAD5gd2LDizRZBGWRz7aeiFW9Q3oi6V5EQr8rtIZ0rdY8irEr/JSNrGuZ3SWvSr1nSitoalqnMMD053vcDp2YHnAKKSVuBdi6rGDKoSTfBxvW59/wZfzC637657HW7Hhc0ZD21Ir28HYhjYaZwxOx66bhxHcRQE8Qu2DdE5hP8a6JnW5Y34uxG13sPreK/gbaoCEw0b69HJSUHltIGc9qfmRFrmdZ+p+cnCPeGKNXMhdT2ikharL2IHDbibKQzrenw7gfcdEnrW51rJnxRfwecfHx/Jd/jeB88dULJew45aSN4a6aoR7fu/G1E9W/ggKDewu6VSsDxbdb7RLTj6GzddPwtxN2Com47Te7EC8wUtGnz7Y3x3Y5+Px+eXZ/bp9YX969kfUG6AfmbO/BaH75XUwI89wdRsPdOyLHJGkZATgxHc7ldG0PeeKiNkLvPCiNpBILgd8JDa1PO4zThPA545seNG28q41Tm7X5Er1XbvwaqojU1nslMUtu9AUQydl0XBVKEqgNWzljnXM2s0gPIBKvLpDBo0iuCFtdHCae/It4lBIhP57h35fUY10bO8JktV3WeFWhKuRJ3IybM1WsC/NVmpBrtVtO4IRs2J6CqPHJVClYXoEVVNqcy/GJbrHikU2zwKzfrHJKvUnFC5IkuRkhJxNnUupx3y72tyRXVT0YJcdg1AoAj65DYH6CuCtUcoubu5RCx6JtANigIg4aXKpe6Bc95+2QSwzIuCZHD8zKybQzvSeqSsFBN1TXKkolLNdLaFIloGK8HUVJpcAYBqkTPRnlIJgCqN0xoagcHbhpMVARWl/Zbpd+QDwADATQ3cu31yIyAPTJDkULUnFiDWMyS8IkB1A2R0eX1fqIYjIQR6hhwdoorMG+jkVAAMmhaCHyfS65NTKIAFZP45MRgDQHrGI1JL6/bwDaeJ9CEDLfWoKxB4Kxh7OTCwKfnldnxFUtACwzLNJeYX7dA3ltGSSrO3k68ReUxQ/RJrBIxsBFA8UEi5MKKHKUusdSID5G6Ri6Xx1/K/pdz4q7F2EQgUnpiqCqqzR2pa5AJuc1IzVeECho5XPWZp0w5dFBeybDT5WVVzqrEXdmrsAXRO1/ssvAg7l21bZcbHKJGfPn1CwUnkYyIJORAsnABiIGyt7I6UnbgTuTYu2lJqb07I2iGELSP1Bk21sd1LRNZAR+yTZjrzzTbsQWSsaDi4GSFpncKgFNRt24HqgRZcn93A6T1yOX5/OrnAp/HN+enVxZ/dm1GCRN4+Two450aeAWSHDZpeVWYMS+THLltd6qRRFcN93ragBml6wlSjAVqRozwjdEHzAtvh2HoxCjzJ/TCmnMd0aFPOQPOZCO2IDqgdZiwdhl4URcFgZxAQmtzBjf2a1C8PDSv+4Onu776b8dKLg4BF2cB2fAYXDU0jO0ojYbPU8X3Bs2g4xIGv3Lv68Dr41r3P5gCsuo97g8KmVD5CCLC6eb3C133OtlekE7k09FJmexyIC4IstVPOYIwCynyWZhHn/h5noAHmeuou6f9jhAqjNyeo7WiDzdiHxXaweWMe3L31OaehyHxuZ47vwq3PB3bqukObudkgpnQwSAf+yznWaAAHJEzvXIuvxsaQ1mdBRc4rQX2u37cpOTkB/RdUmgYoKwFmgnyYfLxEnTHS3wlSIqHdQZdmel6QH8l3OQpaH+Rl3je0YBf9kEjwN6nyOYH+0EqRglaQlaOWJVocb7xosIGr/kPrDH32CyGnEO4/iOvgH/LPdrluUrgGoX2PnF736ZiMzLcfUC6669JoIAIZtY+EbEfQpyVCNlPuzhIxAoO6iWEnVm/7obvPR7twN1/XT3agNgrVa9K5uZv8HKG+Giv8D/5ZHyh3SAqOUAtIQ0aL2gzBGoXKZEg8CNYga+MKBlTI1MJFH4t2v+nwwPc8x6eZ7cYOaAuNYjtyeWRn0WAQedSBmsosM8pJwTZl+qQx8DgH9YYqwRm3rYav9JKx78GvWC4erJGz/gsn6P0fL4f8vvXD7LDTg0Decv21Xjl4zFc2H6Totd9qBw5Yr/8L5b0CFBMQAAA=


name: Extract and Organize Colombian Invoices with Gmail, GPT-4o & Google Workspace
author_name: Juan Sanchez
author_username: juansave
categories: []
created_at: 2025-05-09T00:09:17.630Z
updated_at: 2025-05-09T00:09:17.630Z
url: https://n8n.io/workflows/3951
scraped_at: 2025-12-24 13:02:43
description:
  🧾 Personal Invoice Processor

  This N8N workflow automates the extraction and organization of personal invoices in Colombia received via Gmail. It includes the following key steps:

  🔁 Flow Summary

  Email Trigger
     Polls Gmail every 30 minutes for emails with .zip attachments (assumed to contain invoices).
     Expects ZIP file following DIAN standards.

  ZIP File Handling
     Extracts all files.
     Filters only PDF and XML files for processing.

  Data Extraction & Processing
     Uses LangChain Agent + OpenAI (GPT-4o-mini) to extract:
       Tipo de documento (Factura / Nota Crédito)
       Número de factura
       Fecha de emisión (YYYY-MM-DD)
       NIT emisor y receptor (sin dígito de verificación)
       Razón social del emisor
       Subtotal, IVA, Total
       CUFE
       Resumen de compra (max 20 words, formatted sentence)

  Validation
     Ensures Total = Subtotal + IVA using a calculator node.

  Storage
     Uploads the original PDF to Google Drive.
     Renames the file to: YYYY-MM-DD-NUMERO_FACTURA.pdf.
     Inserts or updates invoice details in Google Sheets using a unique Key (NIT_Emisor + Numero_Factura) to prevent duplication.

  &gt; ⚙️ Designed for personal use with minimal latency tolerance and high automation reliability.

nodes_used:
  ["n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolCalculator","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.gmailTrigger","n8n-nodes-base.code","n8n-nodes-base.filter","n8n-nodes-base.compression","n8n-nodes-base.noOp","n8n-nodes-base.code","n8n-nodes-base.switch","n8n-nodes-base.extractFromFile","n8n-nodes-base.extractFromFile","n8n-nodes-base.xml","n8n-nodes-base.merge","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleDrive","n8n-nodes-base.merge","n8n-nodes-base.googleDrive","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 6844 characters]


name: 🔐 Double Opt-In Email Verification System with Google Sheets
author_name: Un tal Camilo Medina
author_username: untalcamilomedina
categories: []
created_at: 2025-05-09T05:15:20.175Z
updated_at: 2025-05-09T05:15:20.175Z
url: https://n8n.io/workflows/3953
scraped_at: 2025-12-24 13:02:45
description:
  This template implements a professional Double Opt-In email verification system using Google Sheets as a database. The workflow collects user emails, generates unique verification codes, stores them securely, and validates user access before proceeding with your main form.

  How it Works

  User submits their email through an initial form
  System generates a unique 6-digit verification code
  Code is stored in Google Sheets along with user data
  Verification email is sent to the user
  User enters the code to verify their email
  Upon successful verification, user accesses the main form

  Setup

  Follow these steps to configure the workflow:

  1. Google Sheets Configuration

  Create a Google Sheets spreadsheet with the following columns:

  | Column Name    | Data Type | Description                          |
  |----------------|-----------|--------------------------------------|
  | Start Date     | String    | Timestamp of form submission         |
  | ID             | String    | Workflow execution ID                |
  | Accepts Terms  | String    | Terms acceptance flag                |
  | Email          | String    | User's email address                 |
  | Code           | String    | 6-digit verification code            |

  2. Google Sheets Connection

  In n8n, go to Credentials
  Add new credential for Google Sheets OAuth2
  Follow the OAuth2 authorization flow
  In the workflow, update the "Store Data" node:
     Replace YOUR_GOOGLE_SHEET_ID with your spreadsheet ID
     Select the correct sheet tab

  3. SMTP Configuration

  Add SMTP credentials in n8n:
     Go to Credentials &gt; Add new &gt; SMTP
     Enter your SMTP server details
     Configure port, username, and password
  Update the "Send Email" node:
     Change sender email to your domain
     Customize subject line and message body
     Set reply-to address

  4. Form Customization

  Entry Form: Customize the title and privacy policy text
  Email Form: Update the description for your use case
  Verification Form: Modify instructions as needed
  Main Form: Add or modify fields for your requirements

  Configuration

  Email Settings

  From Email**: Replace no-reply@yourdomain.com with your sender address
  Subject**: Customize the verification email subject
  Message**: Personalize the email template with your branding
  Reply-To**: Set your support email address

  Form Messages

  Update all form descriptions to match your brand voice
  Customize button labels
  Modify error messages for better user experience

  Benefits

  GDPR Compliance**: Ensures legitimate user consent
  Spam Reduction**: Validates email ownership
  Data Quality**: Maintains clean contact lists
  User Trust**: Professional verification process

  Use Cases

  Newsletter subscriptions
  User registration flows
  Marketing campaign sign-ups
  Lead generation forms
  Event registrations

  Error Handling

  The workflow includes:
  Invalid code detection
  Second attempt opportunity
  Process restart option after multiple failures
  Clear error messaging

  Security Features

  Unique 6-digit codes for each session
  Temporary code storage
  Validation against stored data
  Multiple attempt limits

  Tags
  Double Opt-In, Email Verification, Forms, Google Sheets, GDPR, Data Protection, Email Marketing, Lead Generation

  Requirements

  n8n v1.0+
  Google Sheets account
  SMTP server access
  Basic understanding of n8n workflows

  Support

  For questions or issues with this template:
  Check the sticky notes in the workflow for detailed explanations
  Review the setup instructions above
  Ensure all credentials are properly configured
  Test with a personal email address first

  Best Practices

  Test the complete flow before going live
  Monitor Google Sheets for verification attempts
  Set up email delivery monitoring
  Consider implementing code expiration (advanced feature)
  Keep form messages clear and concise

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.form","n8n-nodes-base.code","n8n-nodes-base.emailSend","n8n-nodes-base.googleSheets","n8n-nodes-base.form","n8n-nodes-base.if","n8n-nodes-base.form","n8n-nodes-base.form","n8n-nodes-base.if","n8n-nodes-base.form","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.noOp","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE61Y205bSRb9FcvPFKr7xW8RSWdQqxspIclMWnmoyy6wAse0fRxCI/6hH+Z9fnE+YdY5RNiQYxLbI/GA5fLea9Ve+1a342kZT8bpQ7p+Jf58X5ZvTsuHyzw+GF9SG8eT2/G0WbSxyXTcnYvBJ+m9Vs5ELchko4lCLVVQJm5LctU4J4qJqUiuDffOVBWkLC5rUf347mDcxEuCqf/+599/j17OlumCRidXLTtuRq8u4/Ri9J7m0zrNsZ3OmtHbm0VLl6PraXs+ej2bneHw23OidgGEbTxbjCd/3N5TkK/E+Zv4IvL49eTd0T/fjx88vTs9+g2f8pxiS+VF2x3m0jCOP38q5USICReHXuiPOLa8Kj8+dnfwzevrj6fq6GyppvrFQrye/rXy+nIGZgzMjpvnnfOJ8YdB+h84Xx17cP7uY3NTf523R15d/uPk5teV819m88vFD93yQ8vlj91+O3b3CeZnhdbuPKisuQ6JCeWJ6ZwEC9xG5mMsMWhvai0rUCfNqALXaLFMl9PFAuHtgnhz1X3X+Ib1xlmKCzrszp3Op2dnNMeZq9li2qkBjpnWlh8wYTnQXFM6n80+98oUigA8EovcCaatCSwWq5mNMWkIVNrsO1NxDjAtzcHithPjrKXFcfPLxex6PKnxYkH3kCDCHuBEHsqH+1bGF6+LY8qLxHShwHw2xIoowfvMk45uRfdezV0knqX5lJ/Qg/ysyTYUacGKKtO+wHeqlckqjKzZZAp6F37igV3hAhmcIyNVcIMmZZY4aVxozC56GQNXK3avqaE5RDM6Ap2NBPP9l+sElecPBLePxsE4XlzHm8XJsr1ati9jV6Pa+ZIeWCDwlSvpWEZlAovqWVS+MM8pdKqUvKQVi7fUlPuys5ECdd92557y4HIwUC4670hLlhwSSRsdWQhkmRM1GG9VUa7uJsRVqGI2pSYRWJBGdyQL/kuJocz6qLiV1Yg1ku1sTqP+rjaRPOtL60NlfcRT94KUO8VLH5oH0D19qx2jyDnTSQqWCuA7W7USugZp14rFoy6wbRJJxwdjU6SIGTJn0jvJtJKcxaoSs9WQCr5kT2a/JCKlarK5MBMyPGSvWShGMJN9dRFtUsa1yBydU/78fAZN61NuSKDd82etmmlXoEUkuOYhMy0LRGQQjyR0Fj6h4CS+gvpbnG4fB+E77UBAT+JgspQBJRk0uhxR1iFJa2CEqSFnRV5qsV8cuLC1OksQbrUgRwWFU2Xcns7Gm2KFtCtyx02ezeeU2z4W29MMKAWWP2WJgh0dRynS2iiwTJHFrkMZy9EwhAzO034sk7CYCIJmmMcC09VYpFTwTGTjYhAlJZXXi12eodz1ovt5vSHzO3L7qq16r7LIXWORgCqiZ4EyxFelCrbmHJxcQX1DC2q3joOF2tz3k4EtXHMZmeQR7qPNLMSES1JZGRUFVXJ7ds6slHFIdWsUkp6sYhgFkPQp5OpcMoXsejme5s83o99hfyQ20lv0p7pDTwcE0+XUvdoeYR4jui013QzXjdkbsEpUjhSjRFsXuI1UPLCidUSBZDWE1vlIMmtY5Q5Y5V5YbaXigrYsx04pmLCYVxa93KrqXcyiRD6MVW2PVXVJvDtWXXxJOaPgQA3AWpHsEiVNGCsgiAAachir3gGr5ftgVUlk1IaCNliBFXnBkuGOcZQrR76TshnGanbAKva6VxOks8Ubht6NSooqgvDHrl85SmjzXpU6jNVuj1X6ve7VZl4wy3BoCVLVJQdM0BFlIYUoI8WUxQYNuB2war8PVm6CU8knlryDBnS2zEunmUiRhEMxyMkPY/U7YO00oHaFKrQLSQeD1BIeBZxDArUkKMLZpBQ5LCjDUMP2UEV/rfL7cffnsIagrFICg0ZNmGyKrgy9piC/ULQEEszkuKEV8O3BOmDVO3cCBFoJ8gxjCjoBYsS8KBZDIFbmWE0uijZA3aFt9RJgTu8MVsuA8RCbPUfyR4UWiyGHOYMhDyxEpbV7PYLJabOk0Yfu3ehfs+V81PfxTaib2cnV0NjzbXR9OhpsSqmgTMCoyVTshj7cIMO2UTFt8FKy9TH74djvotJ++eTbxh6nY26nX+hhpMGchas6639KXykvOxcn80JzWPgiOhtf7n9/P7nHjBXGoM1VzFFYFBQGCRtYceh7SUoi0S1xANFgnMavesOr5QEfsE93HP647V+TfiZa/S8OxtOm0NfxhN99+gRUa7vTkNGBfeU7Mwer489uAIP+1553hvxveB8ZNLU27Q6ZGnpIGrSz9poxZOeZlXrY3OrdYMjc0NvJBlhre8f/IVZDy8Gg48cxGOQw8DQyaOr7uxtU8sA+P2hu4Cl0r8gPyXc4ZkMr4IDJu7v/ATceqQoaGAAA


name: Generate Logos and Images with Consistent Visual Styles using Imagen 3.0
author_name: Jimleuk
author_username: jimleuk
categories: []
created_at: 2025-05-09T08:58:19.404Z
updated_at: 2025-05-09T08:58:19.404Z
url: https://n8n.io/workflows/3954
scraped_at: 2025-12-24 13:02:41
description:
  This n8n template allows you to use AI to generate logos or images which mimic visual styles of other logos or images. The model used to generate the images is Google's Imagen 3.0.

  With this template, users will be able to automate design and marketing tasks such as creating variants of existing designs, remixing existing assets to validate different styles and explore a range of designs which would have been otherwise too expensive and time-consming previously.

  How it works
  A form trigger is used to capture the source image to reference styles from and a prompt for the target image to generate.
  The source image is passed to Gemini 2.0 to be analysed and its visual style and tone extracted as a detailed description.
  This visual style description is then combined with the user's initial target image prompt. This final prompt is given to Imagen 3.0 to generate the images.
  A quick webpage is put together with the generated images to present back to the user.
  If the user provided an email address, a copy of this HTML page will be sent.

  How to use
  Ensure the workflow is live to share the form publicly.
  The source image must be accessible to your n8n instance - either a public image of the internet or within your network.
  For best results, select a source image which has strong visual identity as these will allow the LLM to better describe it.
  For your prompt, refer to the imagen prompt guide found here: https://ai.google.dev/gemini-api/docs/image-generation#imagen-prompt-guide

  Requirements
  Gemini for LLM and Imagen model.
  Cloudinary for image CDN.
  Gmail for email sending.

  Customising this workflow
  Feel free to swap any of these out for tools and services you prefer.
  Want to fully automate? Switch the form trigger for a webhook trigger!

nodes_used:
  ["n8n-nodes-base.splitOut","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.formTrigger","n8n-nodes-base.if","n8n-nodes-base.form","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.convertToFile","n8n-nodes-base.html","n8n-nodes-base.convertToFile","n8n-nodes-base.form","n8n-nodes-base.if","n8n-nodes-base.gmail","n8n-nodes-base.extractFromFile","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 7292 characters]


name: Boost Sales: Convert Product Photos into 360° Videos Instantly
author_name: Aayushman Sharma
author_username: ajstyle0411
categories: []
created_at: 2025-05-09T09:46:12.736Z
updated_at: 2025-05-09T09:46:12.736Z
url: https://n8n.io/workflows/3957
scraped_at: 2025-12-24 13:02:46
description:
  Transform Product Images into Stunning 360° Videos with AI (OpenAI + RunwayML Workflow)

  Turn static product photos into eye-catching 360° rotating product videos—fully automated with AI.  
  Perfect for Shopify, WooCommerce, Amazon sellers, digital marketers, and content creators looking to boost engagement, increase conversions, and stand out online.

  Why This Workflow is a Game-Changer

  With this AI-powered product video automation, you can:

  Convert simple product shots into premium, studio-quality videos**—no expensive gear or editing required.
  Speed up your product media pipeline** from hours to minutes.
  Boost click-through rates** on ads, listings, and social media posts.
  Maintain consistent brand visuals across all product media.

  How the Automation Works

  This n8n + OpenAI + RunwayML workflow takes a product image, title, and description from a form submission and delivers a ready-to-publish video—completely hands-off:

  Upload Product Photo → Saved to Google Drive for processing.
  Generate AI-Optimized Prompt → OpenAI enhances details for visual quality.
  Refine the Image → AI improves lighting, sharpness, and background for a premium look.
  Create a 360° Product Spin Video → RunwayML API generates a smooth rotating showcase.
  Deliver the Final Video → (Optional) Send via email or store in cloud storage.

  Best Use Cases

  eCommerce Product Pages** → Give customers a 360° view for higher purchase confidence.
  Social Media Marketing** → Auto-generate reels, TikToks, and carousel videos.
  Paid Ads & Campaigns** → Create thumb-stopping visuals for Facebook, Instagram, and Google Ads.
  Product Launches** → Showcase new arrivals without manual editing.

  Quick Setup Guide

  Prerequisites
  Active n8n instance (self-hosted or cloud)
  API credentials for:
    Google Drive OAuth2 / Service Account
    OpenAI API Key
    RunwayML API Key
    (Optional) SMTP / Email service for notifications

  Installation Steps
  Import the Workflow → Upload the provided JSON file into n8n.
  Connect API Credentials:
     Google Drive for storage.
     OpenAI for prompt generation.
     RunwayML for video rendering.
  Update Placeholders:
     {{GDRIVE_FOLDER_ID}}
     Email address: admin@example.com
  Deploy & Test → Trigger via form submission or webhook.

  Customization Possibilities

  Style Tweaks** → Change backgrounds, lighting, and colors.
  Video Settings** → Adjust rotation speed, duration, and aspect ratio (1:1, 4:5, 16:9).
  Brand Elements** → Add logos, watermarks, or custom overlays.
  Delivery Channels** → Save to Google Drive, Dropbox, or auto-post to social media.
  Notification Emails** → Use branded templates for delivery.

  Workflow Highlights

  End-to-End Automation** → From upload to final video, all handled by AI.
  No Technical Skills Needed** → Plug-and-play with minimal setup.
  Scalable** → Works for a single product or thousands.
  Secure** → Credentials stored safely—no hardcoding.

  Keywords for SEO Targeting

  360° product video automation  
  AI product video generator  
  eCommerce product videography workflow  
  Shopify product video automation  
  RunwayML product showcase  
  OpenAI product image enhancement  
  n8n eCommerce automation

  Ready to make your product listings impossible to scroll past?  
  Deploy this AI-powered workflow today and start generating professional 360° videos—on autopilot.

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.googleDrive","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.convertToFile","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.googleDrive","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.emailSend","n8n-nodes-base.emailSend","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.switch","n8n-nodes-base.wait"]

workflow_json_compressed:
  H4sIAAAAAAAAE72Y3U4jyRWAX6Xli1xRk/r/4SqE3Y0mmt0Zwcwk0WgUnao6Ba3F3cTdHnaEeKc8Q54sp20WN7gNGJTcoLZdnPrO/zl9Pavz7HD2y6e/fvjHu8/fj+fv5j8eHf19djCbYw+zw+tZ3XQ9NAnfDuckJK9jEUVrDhy9CwA2B2GtBRA2aqGsMOCCyiA1aOHA8YySS62SjkBye5xfXkCPxwvM3Sn2y8vjlr7BHumCfrHEm4NZA3Ok2z4uoOlKu5hXHxZtXqa++nDe9m1X1U3fVsry//y7+lxnpG+u6v68en+JzdHb6g/VybK5gu8/vxuug7NudvjlKwltMw6P12uVRUihgLKMF5WY1ikyiEkw5aBwb4WIws7uUN431QqkW8Z53XV12wyyv18OvzW+YSvhLEKHb4ZzHxf12Rku6Mxl29X9cPzwCz/ghHGF8bxtf12Z0+tks1eZBRU902RPFoLTzOdoVLQl5xgGGbAgih4XhH99s773M31aiZVv5M3BrU5JgHbaIgNRLMmT9MRBsmTRWZNkJl9sdPp0edFCrt4Ta93Axdq4O9U6a9uzC/xhUX/D+2pJuVbsUUp1xyiU5s6KwlQRmWljE/OoCkslBoXcoBBpw0juPDrDpt9g/Ym4/rhhu4DmLJ1D3byB23MjNIrSp9HEG38HF8FKmQsyG4SjoJCZgS+ZWQmGq6SU1mUUFOt4Oz6HvvqZaC6eQXkxH46v/rPehhXyGbgjfysyIlIMxyFyic2zGHhixcgYTfISIWxwj9vmGy76inLnp/oCd3o6rc99bG9PjRiF4vzAPoNR3DECKK6iSAy50ExHq1mURTMB6IEL64MeMf4FG1xQdVjn9U7E876/PMF/LbF76HHiU08D6pERAWKxHg1T2immi8ks6hwZ98bqEoqEYMeA/UvZnN2bzSaKSMsDU5TaTCcsVBtsYSYC9zF6l4vZsP0N6r5SvOow7aS7ojP3sYz/HWtcmhwV7JIcZWjMVEoElccoNWcBpUiJKn4uT5amcRhIYY31UbFoLWUWZGCRQ2E5qgQlcQc4svIP7VWzKk6PBurOkuT5XiXJugSeqiPLYlBYcc0gUC0WPqE0kVM/iKM0WuAQoCdY6gZz9XZOhWf/YBDcPieTxsFADUE5DdSnEMglOlAmccVZUdLHIouAFO4H6qeTdy8g2z9Mg7dFJKNYEmXopUYyMGaoSJSPUJSXIW/ITvs6/fq9+qXtd9utW525PTKCY1Qkmd+Cm1HN6ofyfzibbUXhHabhGimqDUvBGvJzpMJZHDDHC3XI7DT120lMsTen8K/gBKNdiYYzSJE4JRHTGMWZIMs6mbjhQU9yyr05h3r5Yk6vrfM4eHyA1ZLGDZ+o/YD2wvFQdCg4yan25nSv8XsRHEWkTOE5kz2Dp1qmdGSUNYnmDxXsOHFGnHpvzvAqvwcBUgVqPaCHBE9UIxMAS1w6DM7EJN0kp9k/PsnvcjvJn8fpBBqaiASLxiGNmcIOT4ZRTzAoaQKxGiY57d6cNCy+gtNCRG4jyzTOMU07Co3XQxiEIWyllgmm49Ptb88h4f329PY8UFqrcvHOshKQZiSa6RhkCUw6aj8FjQhZTIL6l4G+2KKGSqhRnpKdZ5qVQiTQQFOBVbz4GCDSSrUBXc1J1e1IR5Kqn6C+WC6w+nFODzvRcfj1FJv8gFwOjUk/HFREdGm1QyXNCzkZacSQSZIVuaGWqIrT7ukdaqOi1RyppkVaTQz9Uc6zYBUNX7TWaknDoh33si0VT5cpYdetVVyvpeszj/XixzS2/H+tcURabowwTApaILTXinlPM5BXylLVpJYep9tieFn0Gf3C6AvGoAmeFPe0QGgZLKPBg3Zmnp2hVccquaN/8xcMGq+p5CJbLJA4o1yh0CE6BipqArfZUEI7Wu83pCftkgbKozRc3VV/JqxcDaHUQ7/sqrJo59VWnH1s290Z1FHcpfMHnYliSW7rszUVj8Y6iSEnHzMLXlP9dD5QnU/00foUYna0IY3K0mr7MNXpXsuHoJ3iIMiHIU5epdGWQlL7QB2GvMyCoIrDU+BRFEmrY3rO9kFigcxK+8FhgYsOD2Yd9n3dnK1cib9hWg4g7xcZF3TtNzH49NtawnoNIrMJijSG0VBuUNdjEZVnyQodI7HIVW5QUDS49t8g+PfZmx4pswc9v1yv3j89suGuDh7M6ibjb7NDfvP1K6Hcvf6YkrRjSZoUtFlbpyS9PgAnLx1FxLQltlbp3WJu19rXyLlvrylJj692Owx7z51TUifX8klhD9/Q7NL2Xi+ZlLT9aopkQf3P4UXUkrS6/W4kd/tN29bxrUu2X4pOET/xnnHaElOemHTZrpdak2KnUabkbptjUuCLM2fqzufOS1skB4/IeN5A8pjIqcL+fz//9ebm5r8LsZjXrRgAAA==


name: Automate New Customer Onboarding with HubSpot, Google Calendar, and AI-Powered Gmail
author_name: PollupAI
author_username: Pollup
categories: []
created_at: 2025-05-09T10:11:20.532Z
updated_at: 2025-05-09T10:11:20.532Z
url: https://n8n.io/workflows/3958
scraped_at: 2025-12-24 13:02:45
description:
  This n8n workflow streamlines the onboarding process for new customers by automating personalized email communication, calendar scheduling, and contact assignment in HubSpot. It is perfect for businesses looking to ensure a smooth and personalized onboarding experience for new clients.

  🧑‍💼 Who is this for?

  Customer success teams who need to onboard new clients efficiently.
  Sales teams who want to ensure smooth transitions from prospect to customer.
  Small businesses that want to automate customer onboarding without complex systems.

  🧩 What problem is this workflow solving?

  This workflow reduces the manual effort involved in onboarding new customers by:

  Automatically sending personalized welcome emails.
  Scheduling a welcome meeting using a calendar tool.
  Assigning the customer to a Customer Success Manager (CSM) in HubSpot.

  ⚙️ What this workflow does

  Trigger via Webhook or HubSpot:
     The workflow can be triggered either by a webhook (direct API call) or a HubSpot trigger (e.g., when a new contact is created).

  HubSpot Connection:
     Retrieves the list of HubSpot owners (users with contact access).
     Identifies the owner of the new contact.

  Calendar Management:
     Utilizes a Calendar Agent to schedule a welcome meeting with the new customer.
     The Calendar Agent can create, update, or delete events as needed.

  Personalized Email Creation:
     Uses an AI-powered Email Writer (OpenAI) to generate a personalized welcome email.
     Transforms the email text into HTML for a polished format.

  Email Sending via Gmail:
     Sends the personalized email to the customer using Gmail.
     Sets the new contact’s owner in HubSpot for further communication tracking.

  🛠️ Setup

  Webhook Setup in n8n:
  	Create a new workflow and add a Webhook node.
  	Set the Webhook URL path (e.g., /webhook-customer-onboarding).
  	Make sure the workflow is active.

   Webhook Setup in HubSpot:
  	Go to HubSpot Developer Account.
  	Navigate to Settings &gt; Integrations &gt; Webhooks.
  	Create a new webhook and set the URL as the n8n Webhook URL.
  	Choose POST as the request method.
  	Test the webhook to ensure it triggers the workflow in n8n.

   Calendar Agent Configuration:
  	The Calendar Agent can be configured to create, update, or delete events.
  	Connect it to your calendar tool (Google Calendar, Outlook, etc.).
  	Customize the calendar event details (title, description, time).

   Email Writer Setup:
  	Customize the AI prompt in the Email Writer node to match your brand’s voice.
  	Adjust the email text format for your specific needs.

   Gmail Integration:
  	Connect your Gmail account in n8n.
  	Set the recipient email to the new customer’s email address.

  ✏️ How to customize this workflow to your needs

  Modify the AI-Powered Email**:
    Adjust the email prompt for the AI model to create a different welcome message.
    Change the email format or add custom variables (e.g., customer name, service details).

  Customize Calendar Settings**:
    Set default time slots for welcome meetings.
    Specify which calendar to use for scheduling.

  Add Additional Steps**:
    Extend the workflow to automatically assign the customer to a specific HubSpot list.
    Add a follow-up email or survey after the welcome meeting.

  This workflow is perfect for businesses seeking an efficient and personalized onboarding process, ensuring new customers feel welcomed and supported from day one.

nodes_used:
  ["n8n-nodes-base.webhook","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.executeWorkflowTrigger","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.filter","n8n-nodes-base.stickyNote","n8n-nodes-base.hubspotTrigger","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.hubspot","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.gmail","n8n-nodes-base.hubspot","n8n-nodes-base.stickyNote","n8n-nodes-base.markdown","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 8168 characters]


name: Redesign T-Shirt Mockups to Print-Ready Files with GPT-4 Vision & Imagen 4
author_name: Thong
author_username: duythong
categories: []
created_at: 2025-05-09T11:07:57.285Z
updated_at: 2025-05-09T11:07:57.285Z
url: https://n8n.io/workflows/3959
scraped_at: 2025-12-24 13:02:42
description:
  🧠 What This Workflow Does

  This n8n workflow allows you to upload a T-shirt mockup design (even if it's rough or outdated), and automatically turns it into a refined, print-ready artwork using the power of AI.

  It starts with an image of a T-shirt design, analyzes it using OpenAI's vision model, and then generates a cleaner, upgraded prompt to be used with OpenAI’s image generation API (gpt-image-1). The final output is a new T-shirt graphic optimized for printing on solid black background, with no visible shirt or mockup framing.

  ⚙️ How It Works

  User Sends a T-shirt Mockup Image Link
  The workflow begins when the user drops an image link (T-shirt mockup) into a chat interface or input trigger.

  AI Analyzes the Image (OpenAI Vision)
  Using OpenAI’s GPT-4 vision capabilities, the workflow extracts the key design elements from the image:

  Characters, text, layout
  Graphic style, composition
  Visual tone and focus
  AI Agent Creates a Refined Prompt
  The extracted details are passed to an AI agent that:
  Preserves the original layout and message
  Enhances the visual composition and typography
  Removes mockup elements like shirt collar, sleeves, shadows.
  Locks the artwork on a pure black background only
  Outputs a clean, artistic, JSON-safe one-line prompt for generation

  Text Escaping for API Compatibility
  A JavaScript function node escapes the prompt (quotes, slashes, line breaks) to make it safe for use in downstream JSON requests.

  Image Generation via GPT-Image-1 API or IMAGEN 4 from GOOGLE
  The final prompt is sent to OpenAI’s gpt-image-1 to generate a brand-new artwork — ideal for direct printing on a black T-shirt.

  ⚠️ Cost Notice for gpt-image-1 Usage

  This workflow uses OpenAI's gpt-image-1 model to generate high-quality T-shirt artwork from refined prompts. Please note that this model is a paid service, and each image generation request may cost approximately $0.25 per design, depending on resolution and usage.

  We strongly recommend users to review their OpenAI API usage plan and be mindful of costs when running this workflow, especially if generating in bulk or integrating into larger automation flows.

  You can monitor your usage at: https://platform.openai.com/docs/models/gpt-image-1

  (Optional) You can send the result to Telegram, upload to Notion, or store it in your design system.

  ✅ Key Features
  Works from any uploaded mockup image
  Converts design concepts into print-ready artwork prompts
  Avoids outputting shirt models, collars, or product mockups
  Optimized for solid black background with no distractions
  Modular and easy to connect with file delivery or approval flows

  🚀 How to Use

  Import the .json workflow into n8n
  Configure your OpenAI credentials for both vision and image APIs
  Trigger the flow by sending an image url of a T-shirt mockup
  Let the workflow generate and return a brand-new design from that concept

nodes_used:
  ["@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.chatTrigger","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.convertToFile","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.openAi"]

workflow_json_compressed:
  [encoded data, 4224 characters]


name: Automated Financial Tracker: Telegram Invoices to Notion with Gemini AI Reports
author_name: Rizqi Pratama Ramadhani
author_username: rizqiramadhani
categories: []
created_at: 2025-05-09T11:57:48.753Z
updated_at: 2025-05-09T11:57:48.753Z
url: https://n8n.io/workflows/3960
scraped_at: 2025-12-24 13:02:42
description:
  Automated Financial Tracker: Telegram Invoices to Notion with AI Summaries & Reports

  Tired of manually logging every expense? Streamline your financial tracking with this powerful n8n workflow!

  Snap a photo of your invoice in Telegram, and let AI (powered by Google Gemini) automatically extract the details, record them in your Notion database, and even send you a quick summary. Plus, get scheduled weekly reports with charts to visualize your spending. Automate your finances, save time, and gain better insights with this easy-to-use template!

  Transform your expense tracking from a chore into an automated breeze. Try it out!

  Overview:

  This workflow revolutionizes how you track your finances by automating the entire process from invoice capture to reporting. Simply send a photo of an invoice or receipt to a designated Telegram chat, and this workflow will:

  Extract Data with AI: Utilize Google Gemini's capabilities to perform OCR on the image, understand the content, and extract key details like item name, quantity, price, total, date, and even attempt to categorize the expense.
  Store in Notion: Automatically log each extracted transaction into a structured Notion database.
  Instant Feedback: Send a summary of the processed transaction back to your Telegram chat.
  Scheduled Reporting: Generate and send a visual summary of your expenses (e.g., weekly spending by category) as a chart to your preferred Telegram chat or group.

  This workflow is perfect for individuals, freelancers, or small teams looking to effortlessly manage their expenses without manual data entry.

  Key Features & Benefits:

  Effortless Expense Logging:** Just send a picture – no more typing!
  AI-Powered Data Extraction:** Leverages Google Gemini for intelligent invoice processing.
  Centralized Data in Notion:** Keep all your financial records neatly organized in a Notion database.
  Automated Categorization:** AI helps in categorizing your expenses (e.g., Food & Beverage, Transportation).
  Instant Summaries:** Get immediate confirmation and a summary of what was recorded.
  Visual Reporting:** Receive scheduled charts (e.g., bar charts of spending by category) directly in Telegram.
  Customizable:** Easily adapt the workflow to your specific needs, categories, and reporting preferences.
  Time-Saving:** Drastically reduces the time spent on manual financial administration.

  How It Works (Workflow Breakdown):

  The workflow is divided into two main parts:

  Part 1: Real-time Invoice Processing & Logging (## Auto Notes Transaction with Telegram and Notion database)

  Telegram Trigger (Telegram Trigger | When recive photo): Activates when a new photo is sent to the configured Telegram chat.
  Get Photo Info (Get Info Photo from telegram chat): Retrieves the details of the received photo.
  Get Image Info (Get Image Info): Prepares the image data.
  AI Data Extraction (Google Gemini Chat Model & Basic LLM Chain):
      The image data is sent to the Google Gemini Chat Model.
      A specific prompt instructs the AI to extract details (date, ID, name, quantity, price, total, category, tax) in a JSON array format and provide a summary message. The categories include Food & Beverage, Transportation, Utilities, Shopping, Healthcare, Entertainment, Housing, and Education.
  Parse AI Output (Parse To your object | Table): Structures the AI's JSON output for easier handling.
  Split Transactions (Split Out | data transaction): If an invoice contains multiple items, this node splits them into individual records.
  Record to Notion (Record To Notion Database): Each transaction item is added as a new page/entry in your specified Notion database, mapping fields like Name, Quantity, Price, Total, Category, Date, and Tax.
  Send Telegram Summary (Sendback to chat and give summarize text): The summary message generated by the AI is sent back to the original Telegram chat.

  Part 2: Scheduled Financial Reporting (## Schedule report to send on chanel or private message)

  Schedule Trigger (Schedule Trigger | for send chart report): Runs at a predefined interval (e.g., every week) to generate reports.
  Get Recent Data from Notion (Get Recent Data from Notions): Fetches transaction data from the Notion database for a specific period (e.g., the past week).
  Summarize Data (Summarize Transaction Data): Aggregates the data, for example, by summing up the 'total' amount for each 'category'.
  Prepare Chart Data (Convert Data to JSON chart payload): Transforms the summarized data into a JSON format suitable for generating a chart (e.g., labels for categories, data for spending amounts).
  Generate Chart (Generate Chart): Uses the QuickChart node to create a visual chart (e.g., a bar chart) from the prepared data.
  Send Chart to Telegram (Send Chart Image to Group or Private Chat): Sends the generated chart image to a specified Telegram chat ID or group.

  Nodes Used (Key Nodes):

  Telegram Trigger & Telegram Node:** For receiving images and sending messages/images.
  Google Gemini Chat Model (Langchain):** For AI-powered OCR and data extraction from invoices.
  Basic LLM Chain (Langchain):** To interact with the language model using specific prompts.
  Output Parser Structured (Langchain):** To structure the output from the language model.
  Notion Node:** For reading from and writing to your Notion databases.
  Schedule Trigger:** To automate the reporting process.
  Summarize Node:** To aggregate data for reports.
  Code Node:** Used here to format data for the chart.
  QuickChart Node:** For generating charts.
  SplitOut Node:** To process multiple items from a single invoice.

  Setup Instructions:

  Credentials:
      Telegram: Create a Telegram bot and get its API token. You'll also need the Chat ID where you'll send invoices and where reports should be sent.
      Google Gemini (PaLM) API: You'll need an API key for Google Gemini.
      Notion: Create a Notion integration and get the API key. Create a Notion database with properties corresponding to the data you want to save (e.g., Name (Title), Quantity (Number), Price (Number), Total (Number), Category (Select), Date (Text or Date), Tax (Number)). Share this database with your Notion integration.
  Configure Telegram Trigger:
      Add your Telegram Bot API token.
      When you first activate the workflow or test the trigger, send /start to your bot in the chat you want to use for sending invoices. n8n will then capture the Chat ID.
  Configure Google Gemini Node (Google Gemini Chat Model):
      Select or add your Google Gemini API credentials.
      Review the prompt in the Basic LLM Chain node and adjust if necessary (e.g., date format, categories).
  Configure Notion Nodes:
      Record To Notion Database:
          Select or add your Notion API credentials.
          Select your target Notion Database ID.
          Map the properties from the workflow (e.g., ={{ $json.name }}) to your Notion database columns.
      Get Recent Data from Notions:
          Select or add your Notion API credentials.
          Select your target Notion Database ID.
          Adjust the filter if needed (default is "past_week").
  Configure Telegram Node for Reports (Send Chart Image to Group or Private Chat):
      Select or add your Telegram Bot API token.
      Enter the Chat ID for the group or private chat where you want to receive the reports.
  Configure Schedule Trigger (Schedule Trigger | for send chart report):
      Set your desired schedule (e.g., every Monday at 9 AM).
  Test: Send an image of an invoice to your Telegram bot and check if the data appears in Notion and if you receive a summary message. Wait for the scheduled report or manually trigger it to test the reporting functionality.

  Sticky Note Text for Your n8n Template:

  (These are suggestions. You would place these directly into the sticky notes within your n8n workflow editor.)

  Existing High-Level Sticky Notes:

  ## Auto Notes Transaction with Telegram and Notion database
  ## Schedule report to send on chanel or private message

  Specific Sticky Notes to Add:

  On Telegram Trigger | When recive photo:**
          📸 INVOICE INPUT 📸
      Bot listens here for photos of your receipts/invoices.
      Ensure your Telegram Bot API token is set in credentials.
      Near Google Gemini Chat Model & Basic LLM Chain:**
          🤖 AI MAGIC HAPPENS HERE 🧠
      Image is sent to Google Gemini for data extraction.
      Check 'Basic LLM Chain' to customize the AI prompt (e.g., categories, output format).
      Requires Google Gemini API credentials.
      On Parse To your object | Table:**
          ✨ STRUCTURING AI DATA ✨
      Converts the AI's text output into a usable JSON object.
      Check the schema if you modify the AI prompt significantly.
      On Record To Notion Database:**
          📝 SAVING TO NOTION 📝
      Extracted transaction data is saved here.
      Configure with your Notion API key & Database ID.
      Map fields correctly to your database columns!
      On Sendback to chat and give summarize text:**
          💬 TRANSACTION SUMMARY 💬
      Sends a confirmation message back to the user in Telegram
      with a summary of the recorded expense.
      On Schedule Trigger | for send chart report:**
          🗓️ REPORTING SCHEDULE 🗓️
      Set how often you want to receive your spending report (e.g., weekly, monthly).
      On Get Recent Data from Notions:**
          📊 FETCHING DATA FOR REPORT 📊
      Retrieves transactions from Notion for the report period.
      Default: "Past Week". Adjust filter as needed.
      Requires Notion API credentials & Database ID.
      On Summarize Transaction Data:**
          ➕ SUMMARIZING SPENDING ➕
      Aggregates your expenses, usually by category,
      to prepare for the chart.
      On Convert Data to JSON chart payload (Code Node):**
          🎨 PREPARING CHART DATA 🎨
      This Code node formats the summarized data
      into the JSON structure needed by QuickChart.
      On Generate Chart (QuickChart Node):**
          📈 GENERATING VISUAL REPORT 📈
      Creates the actual chart image based on your spending data.
      You can customize chart type (bar, pie, etc.) here.
      On Send Chart Image to Group or Private Chat:**
          📤 SENDING REPORT TO TELEGRAM 📤
      Delivers the generated chart to your chosen Telegram chat/group.
      Set the correct Chat ID and Bot API token.
      General Sticky Note (Place where relevant):**
          🔑 CREDENTIALS NEEDED 🔑
      Remember to set up API keys/tokens for:
      Telegram
      Google Gemini
      Notion
      General Sticky Note (Place where relevant):**
          💡 CUSTOMIZE ME! 💡
      Adjust AI prompts for better accuracy.
      Change Notion database structure.
      Modify report frequency and content.
      `

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.notion","n8n-nodes-base.summarize","n8n-nodes-base.quickChart","n8n-nodes-base.telegram","n8n-nodes-base.code","n8n-nodes-base.telegramTrigger","n8n-nodes-base.editImage","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.splitOut","n8n-nodes-base.telegram","n8n-nodes-base.notion","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.telegram"]

workflow_json_compressed:
  [encoded data, 6740 characters]


name: Convert LLM Output into Rich Telegram Messages — Auto-Media & Smart Chunking
author_name: Dmitry Mikheev
author_username: dmitry-expert
categories: []
created_at: 2025-05-09T12:51:34.675Z
updated_at: 2025-05-09T12:51:34.675Z
url: https://n8n.io/workflows/3961
scraped_at: 2025-12-24 13:02:45
description:
  Telegram Rich Output Helper Workflow

  Who is this for?  
  Builders of Telegram chat‑bots, AI assistants, or notification services who already run n8n and need to convert long, mixed‑media answers from an LLM (or any upstream source) into Telegram‑friendly messages.

  Prerequisites

  A Telegram bot created with @BotFather.  
  The bot’s HTTP API token saved as a Telegram API credential in n8n.  
  n8n ≥ 1.0 with the built‑in Telegram node still installed.  
  A parent workflow that calls this one via Execute Workflow and passes:  

     chatId — the destination chat ID (integer).  
     output — a string that can contain plain text and HTTP links to images, audio, or video.

  What the workflow does

  Extract Links – A JavaScript Code node scans output, deduplicates URLs, and classifies each by file extension.  
  Link Path  
     If no media links exist, the text path is used.  
     Otherwise, each link is routed through a Switch node that triggers the correct Telegram call (sendPhoto, sendAudio, sendVideo) so users get inline previews or players.  
  Text Path  
     An IF node checks whether the remaining text exceeds Telegram’s 1 000‑character limit.  
     When it does, a Code node slices the text at line boundaries; SplitInBatches then sends the chunks sequentially so nothing is lost.  
  All branches converge, keeping the whole exchange inside one execution.

  Customisation tips

  Adjust the character limit** – edit the first expression in “If text too long”.  
  Filter/enrich links** – extend the regex or add MIME checks before dispatch.  
  Captions & keyboards** – populate additionalFields in the three “Send back” nodes.  
  Throughput vs. order* – tweak the batch size in both *SplitInBatches** nodes.

  With this template in place, your users receive the complete message, playable media, and zero manual formatting – all within Telegram’s API limits.

nodes_used:
  ["n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.if","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.splitInBatches","n8n-nodes-base.if","n8n-nodes-base.splitOut","n8n-nodes-base.code","n8n-nodes-base.splitOut","n8n-nodes-base.splitInBatches","n8n-nodes-base.telegram","n8n-nodes-base.limit","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.switch"]

workflow_json_compressed:
  H4sIAAAAAAAAE+1aC2/byBH+KwteAUsXrbx8k84lgeu7a4PkmmuSywGN3GIfQ4kxRaokZcfnE9C/0b/XX9LZJfWmFCcXtCnQwJAVcnZ25pv3ru+sVFlnViCeXbwcZ/V3f/7hmbxir6yBNYWaW2d3VppXNc8lPNV0MQPww8SJuO2GjDNfObEMfAc440kSKBk7ApzIc4OQRyHwyAWOP9KxHaZCENZiYOV8CsjqNWQwLvn0ZSonL+b1bF7jpjUfV9bZ20ukKhTor3eNgNzxPSdSNlWuJ6nnJB6Nuc1paLsC9MY2xNaK9yvIFRFcXhGek3TKx6B53870uzzKqWFOBa9gWLdiIMGsqNI6LXLclXoRG4QOQ0FuQEyK4sqoL2QUCB4BdXgsqJd4EeVSCcp8n8nY92IPEs2II0Oooaw0gEma6X0f3d2R372rinw4LzOyWCCdnPDa8DXveic/TyAn370HOa8B5b8l53lRT6AkPxflVZIVNyf9YVrDdGjYNKsbTsUMSt7IblWo/I+Toi7wOVfKqMSz71PIlJEHpavgb1OEAIn/+PqH59YCrSJLUJDXKc8M0RKW81lqnEBL+f3tu/T5m5djxsLr+UX+zNqzJeFSFvO8Jr1XFz/2DV+N+htEwshmD+3FoOXGfCfw3ITTwLVjit9civ7kUI+BYuD4vuNGByzK5yotPtaiTvA/bdHzVucv2KKhqxJhM5/6SQKIZcSpiAOgggnfD1Toxn7QaVFynSr4aIP+b9vzTavyF2xPCG0/ieKI2kJy6oEHlHuBSxOXRbYfBF4Y7NrzNbyvP9KOtscGzp4dpS8ZFg50HhtN6Ll+RKMwdqhirvJ9oZjwoj071nr3T7RVYUrQ57b6/ayLdLOZjvG6LlMxb4BJ0M7wH7S7s7K7GyVoeB7RJOaYjwMMpBhtThNQXuDEgUjsZL3D04Ro3EldFCQr8vFB86fJTgBrywfa8NtWLGaaQH/Vyhd5g+DOK+t6KbkzsDJI6jc8m+tNtflwN/RGvdE1PqrLObTa8ixVqyBErGVtmT2mIs15XZS60ciVtb3tqgUJ3MCXoUNj0C2IwKolQsencRz4iRKRDY69CnTN624JhCiKDHi+kwW0XPioSvNxBq34+tliW6Hf4M3DDPJxPSGPic0YazyyTMeTNViLyz1PcDY8wYkCZdtSoCd4mAFsz6URd0LqesJPPLA9O3bWnvBBEQ+6BjSLlnSvUcgxlDvuEmPCp6jInsPctMue5qhz4xxav8Z0rWxtSK8FmE8F7qA1bSkayLoQ2cyJigs7EUzSOGSgu5aQctf1qfSiwI1BcS5gjcjzopiRF+iq5HmaX1UH9a9mWVo/zX/PazmBakdvP1omyINxsiuxu5KX2wmWZUycIrBRXhv7Lc5kSH0GWDzDCFgcbMVyjlF8VNa9MPadA3b5UgPZdR3lJJHuUzyPeioSlGO5ocwVisfSjcNAdQcyL0t+uxPGMJ3Vt/eNYxOcut2oPiEahcLRC3ygscewtwmSmPIwSNAsnsKmBzA5yY16rH2K4GRFMAbv438vzAS2admIfdDzBtg8YWF7Xbxasjgz7VRl7UXRSo8IEwfOawEFCQxjyGYYTdKhkRNznCpDL2TBrh4ZL8fQFBpMLHIyP6aO1LV1r8mgdocq76qLphCjo1Q1SXUK0U0MeXTfpJukZVX3+ltdxK+/kpE1sh6O8oYtRhRa/NGafYN4D4lG+cjqI+Eoz6BuFUPKt5cP2yfzssTqf6Ff4POW7ShPipL01txJkTS79MndKCfk9JRcTACb6zQhugnJx8YNDOlNMc8UgfcSUCn91FQHzJAll4gLEk3TWjPBtb3elgAPGg4PyFLy7RLTbm62/3FeTZbSN3ppfogfMRHT0OkdNjfotwgMZ7h6680Qo3za62uo2g1e1bysSQ43LfebtF5vqMVsKHcA3JbfcFsQwFZrQ/RzpRq6utjWoIPjg26Wo3yhrbTEQaOcYGrK1khoP4J//eOfFSlhytNcmwjtWSPnUf5JuJjtXkI9L3MCXE7avXiFE1YF2u9rILpHGOVlQ3VHGoc9a7lP+azXLHr0mPTuWgYL0u8vHu4F9EZiYhFELAop9o0+9TCAMaEq7NhlLHD0s+0wDA8lpovjodydmdzgQDh/IDMta/zB1BR7gtm+YpTbIsSRx3YxNbmc+tzxE4gi6bC4q7yblHEfVQ4Uef8eCh0u8r6dOH6MQ68X45zk2S4WBsEYdSM3ECH3HVB+x6DWCPyR45quCa2kn3Vea0cn42//n8EsFQrOeZJQHtuIZxQq3XFyqhxIvDjymSfcDUfUGfugIbP27WZpd7ubysOR4Sehg6NgRJkTJhgZERrYdWJqczQuSyII5EaMf/e+1sXkA23Hfp2moXegmVwVasxxSQlATS9gCuqyytZt3TYPO+vykyfrAnr6NZmCSjkWwlr3mMiCjMtiPmvcS0tMvj5d8n76wx90VT55NxufDPAT9K9Zrj/HaYKfYjrDTwwJ/as2j/AzOblcNQHnP31rWExnrqbk1/g59Th+JhmX+KsYa3a8+Y6JfmPtm6fLtZ5eVZi1V9fNjlO96jrVjxq5pijk5VLJAotTCWN4j+mW16giF1gQ8ttW+59ePic93fTzX27J3+ccnRzzZjkgVWHy880EZ1czEpC0Ilcwq/sbsJSAYp32JnU9q56cjUan+PP2r6NRNbJOvnl8+WA0GvaefIMIP357Tv/C6S/Y6l3eOQN/0e/39IInG9Rf95+cjlMjd8O9Aox53EDX+FeAxlzh0bTQbZu01QxNdSekPQGLGSba8yzrldBvG5OGRJ/uPSLTt/blw2WXo3caTnjVw3dIrOtwms/hIVn9Q7dTQBW6h15j6DGxGHojwpJ544O96dD4UjXU/8d28ATTU108L26gvEDX7y0X6RbPuNojcmLy2clKJnS5YZrLbI7x0kM2KNeK1NxpNKSmd9H06F+79Etyc2C+Q44udYjcHMeetBIaqJu+405DN2jIFloD0+O0vcTbO6JD7QybinbAIYvLY12D54Nnc2bTINLHTCLwaBS5jALzYzuwMdvFm11DncqrW/Knoj58l1MZmpZka0TF8up1VFdZZHq+87GWpaqeWGcBEloT0FOZdabvgKy2JcPNvvqKmNJpxuNRvv5u2kQdW9hprfqsKVQV2qgio9w0plhdymJWpvqdAbBnbDhoLjMGzRF4/0hrIgSIINBXJVxXWJb4VEDoU4hjYNJ3vcCBTrjsj8YL9aZdc18LV7CCK2YbcLmsEy5uTgWXeGjcWoQ2H6+HOkxNiugDcp19piZ74Tv8dQQaT4kkDmREE4H+40kHZ8lExlRi7ylFHMWuDDqhcT4Fmq42rcXD3cRDXzh14lFNChxcVoB8C1mqe8idF6SnIOHzDJMddjfHPAO7VAhciKnr6jMePxIUVXaxSMsAO3PdCvK1+s1YqAszea1VP4gAuq2c7N+5YFTsqV/O9cS/ffDWlNxncIusl1ewX9AhkM1Aer4bUeFLiaAFDo19j9NEelzxyAtUGHUfAumtzDH31ilQrqqfMc6tg6c+TdbcO/RpoFlc4jqc6RDT9i68PULaxnF58fkF4aiTD4AfUOFENvUU5vPYjgOKyQqnEQFx4O2eireOiFUC/We4fDME7D6yjWaxG+eG6GNRboC7J8rL28gvCGUcKpQtcZ5iEodTT6kAJ7wY41xGQQwOC+Nw98jyv4ByA9whlPXjY+MsTj+YWHBqMMiZ0WtgVVBjJzY2sDe3BEj8olSg8bq2tYitNcywaMfMlgEXFCIl9J8SAI1s7C4CpcI4CJWjVNRAnINc2bMZn/CLPodB0PW1QTNsHL7cMqQDK80VvLfO2OJSq7d5fv4b2Q3Wq46e5HbKsT1+HZBk/6S/k9duvejiduzvbY5qduSvOu65bvdvBzp12L2H6dJhZ4Y+tv3BEtq5+e55S+fmx0+SDjnbtjN1WuYep+cfRHr7Vv+wklsWOa7mfby4wzs+M9PGVT8D044I/dxcW5/4XN7TvWaDe6cX7B4ZHpG70+cOu+ih8+DOHT5809y10YFDqY4dFot/Az1KRSAYKQAA


name: Automate Cal.com Meeting Attendee Management with Google Sheets, Beehiiv & Telegram
author_name: Aitor | 1Node
author_username: aitoralonso
categories: []
created_at: 2025-05-09T14:09:48.256Z
updated_at: 2025-05-09T14:09:48.256Z
url: https://n8n.io/workflows/3962
scraped_at: 2025-12-24 13:02:44
description:
  This n8n workflow template automates the process of managing meeting guests booked through Cal.com. It captures attendee information, logs it in a Google Sheet, and subscribes new guests to your Beehiiv newsletter, while also notifying you in Telegram.

  How it Works
  This workflow is designed to streamline your post-booking process. When a new meeting is booked via Cal.com, the workflow automatically triggers. It extracts the attendee details, adds a new row with the guest's information to a designated Google Sheet, and then adds the guest as a subscriber to your Beehiiv newsletter. Finally, it sends a notification to a specified Telegram channel, keeping you informed of new subscribers.

  Features
  Automated Data Entry:** Automatically log meeting guest details into Google Sheets.
  Newsletter Growth:** Effortlessly add new meeting guests to your Beehiiv subscriber list.
  Real-time Notifications:** Get instant alerts in Telegram for new subscribers.
  Seamless Integration:** Connects Cal.com, Google Sheets, Beehiiv, and Telegram.

  Set Up
  To use this workflow, you will need the following:

  Cal.com:** Set up a Cal.com account and configure a webhook to trigger the workflow on new bookings. You will need the webhook URL provided by the first node in this workflow.
  Google Cloud:** A Google Cloud account with access to Google Sheets. You will need to specify the Sheet and the range where data should be added.
  Beehiiv:** A Beehiiv account. You will need your Beehiiv API key and the publication ID of your newsletter.
  Telegram Account:** A Telegram account and a channel where you want to receive notifications. You will need your Telegram Bot Token and the chat ID of the channel.
  Configure each node** in the workflow with your respective API keys, IDs, and sheet details as required. The "Define your parameters" box in the workflow provides guidance on finding your Telegram chat ID and Beehiiv API key/publication ID.

  Additional Enhancements
  This workflow can be extended and customized further:

  Conditional Logic:** Add filters to only subscribe guests based on certain criteria (e.g., specific meeting types).
  Data Enrichment:** Integrate with other services to enrich guest data before adding to Google Sheets or Beehiiv.
  CRM Integration:** Connect to a CRM to create or update contact records for new guests.
  Custom Notifications:** Customize the content and format of the Telegram notification.

  Need Help?
  If you need assistance setting up this workflow, encounter any issues, or would like to explore setting up similar automation workflows tailored to your company's specific needs, please contact us at 1 Node.

nodes_used:
  ["n8n-nodes-base.splitOut","n8n-nodes-base.googleSheets","n8n-nodes-base.calTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.telegram","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE71Z/W7TShZ/FW9Y6YLUSf39UQldtaVA76UUaLhwodXVeOY4GXBs43GSlqp/7hPsA+wr7iPsmbEdO2lCC8uuhErsnDnfH78zuR4IPtgbXEIk379+y4Krd+GrUEwHO4MpVHSwdz0QmaxoxuBY0UW2FUHMgiDyYqCh7yeBSanDoyDgnutaQcIT02euFbluDJEHtsmS2DeTKLJ5bEXIt4JpkdIKDkvg8gyqWXGY4xuoAAVU5QxudgYZnQJKOwGoRDY24jz/DNwgRpUbGSwkEldQGjTjxuGbE8WTjuVg7+N1bYznPX02+QT0kH06eEun/mDJ0MpyDvjISkAN+H6F72zT9ojpEsccmeGe5exZ/tAN3Q9INiv43WQ3O41YE+hzSJ1P7+RYzr+OemJbk+8lObif5KAn2XGuZnN+6eavTW/0IX/SSe68tVE2/rM103DPdYaWG26WvYHs5gJloDN7bg8sL4mYGRMvpD5x/TgiceDYxHFcxuwkdqhvdpqdFamojH1ULeOAbDCIV4VWOcyI5kxiKmEoFd3prEKCIpeiEnmGIpG9uUMs10Q1CloiSzRRqnTNC0WiPmIeJQJSPsrPWh57A7oUeFNL/APPaZ7W0p1WYAH3LCC+HQQoiTskMp2AhLEd2Dajps97huxzbsykkr7NhHGej1M4m2A2y1UzbHOLFSxPZ1NtxWBO0xmoD5WoUsX98fW18feHv+SZ8RIWxgHWBtbIL4+GAtNs+Enm2RDmkFUjRW7c3KDEFLJxNbnX0Zq0PlaJKXzIs6VMTdC+rEn6KXU38yV1fbiNxcvakZ0M5dmaZFp3gLOKlvcTIRXlSLTnWxFHUyrSFRmg3igizAPJJvjYZXJn1TKksipRFD5zgRlJr+pWtTMoYZrPVedKaCr185eZKHsvGvrGxj5nDgmdpdUJrdhkSc5odgBvJWDWNl/ULbHRrM6Bn61Vy/VHNFqJ0M9WbI35j+i3kmQ/W7815v+NfnWG/q8UbLn/WM41beDnp92S8Y/o1XS1n63Vku336IQNfEqLAuWfKISxpw6LDA4gzReqjSlS/PKwbesfL+reNC2qUX6YZ3PAroVmyE5Q/fKpmmASR1htXP0ttqyVMZcXUNJ6pAxQC4w4ypRq3tQ2XQ/++qtMW39Maw1TIVVNNeNlMBb8sZpqjGIz5G9Aoulv1aHBpKoKube7y3Mmm1k2ZPl0VxbYzLgWI3f5rnX2Wy6T/IS8+3AkpgevR1+t6cz3LsXV7EsUPz8+No/H3JqOD9kXcxe4qB5sEtkEQQ9LS/VmlDqb4jhT8PM+dnyPGv9Xc3+dyeIxL8UcJP+82epDisnHaakBL4YbQcqNnrEcHSAw8soFfTRxuj+rJvZ+ITRQ18W6+MBfPJXHzudR9qUqnnU45Zk+Z9QHDcpYPssqLWAFBrlDr8OVsW3z0HJJAqFJXObFBJ8S4oLt+z6LfEadTsDqVN6KhhhNR6UYjzUk7UM6P1yCoQXEE2SjVw4z9hiLo4iEzKTEDcAlNApQHdMB3wxYGIFK91X8pBGQqrPBwenp78cvn/11+OZof3T0ZHCxUju33Yvq9f3p/DY7tcv42fvfz96bf7yIOnMxWNu9aHdbgW1CkDCPBElgE9dB94U0dInlxVYQ2E5gub1NQYFJOYslK0WsHbTZhypH32AbA7mGi117C6Cc6dx+3CY3LcQwBpgIMdfJPbd3i1mcCqbbiNytcZaEysBdgK4grB7dMUcAtdvo2zhVL46TXJn+6vRsNFhrVRIT/CDny+asnp9jXWk161cxfv1qRfm+KYjRGl9BM9Paym/A4dpisQqMl6DvAnWZaLn3EaXKLC/F17rJ9kQeAC1xE/2Guxov7786buTeLrguWRzPDzA7EgKh6xJcLxNcoRKHBDzxaGgmLrV5b4WCzs7t+xOsr07bUmQlTlRKMc6mdRVdrz4uFz4zYbYDMYm82MPUjinuST7uSTx0XO66ph+6vVV0MwBbid4K+l96xaY08CKXk8RPOHFdXMVoEJuEcgdsJ8b6snp1CVuA1G1BvRWgtYjaCbY8ius2WMT1zIDEluMRK+EJZ5zTIEh6a/12YHRbWH9v2pAFztBdaoE5EAeMhsQGhs3WjbHjYWETQI+aJjcjGvT9mlciuTJEZrAJzTJIt6ZCBSmMMeKr+eC7G9tugLUROsBwm0+w7cauQyh1MNZOHJs8ouh0+1bbreBSr2n//tc//6GHwXTlBuc8O8+OVGc2lO57TdksF+iVuqma9fU80+jfeIJ707dP9JcFPGi8HR2eZy/vFNTH8Fqexsr3O3PUZNB5hpCwNFSMja8Y5LtMW1mhJ1SDm7Z/bewimuhJs9NyrmNH0xoc6vrUqA+bAc6NWR3YGineHnBtFvSn3PG4zKrRpcyfFJOJFX3tsmvUUG8fdVavf1lYj0HoJcSiDlYqNxlWKreIBTHzbTPiHgs73q2l39O73J/WvKKAe0Fgkdh2cS4HiUeoyXzCmUMtbMExDuhO1dr/3yj0q3xWHtaR7LzBHNuJICR+AigipBz7Y+hgc+GWGdLIo8A6Ed2guEMMUnyGq05MyCKXYjViaap7t5ADIgw7wEfmATfBD6Fnycr4vkPSQa3Sq5UjdzQvlvg+JIlNGMWO7YJnk9gNfGL7juPS0LYDr9dCzyrBPl8ZL/PqGxNM0zQk/WRwHEwG17+dDAvB1XWXjYASh7wYT7ApueoBlyosXNWiHjwwnugVzVCGGt3584wYT0XG6/dtsajeWhmCqxvoMaatbroCuGq71CgQ1WN7ahuw8TDOK2M6k5URg4HlinQUITefiuyR4n+ob4EMmrVVZSB2/th4++LhI32zrcRoHRCrGRhwdfBZ+64XRaVVUubT+ove9fhiItjEWIg0VWqghbLWt5qAcb6GNM8HBiJEA3tIkQtV5VsvRxlzcOSzkPDIx2xjFg7jGCONU8JHS72QOcHG+FrfH2DLUre8Trg1wq7Zi7Dnrkf4eb4wEAsu8vIzxnU0EVJ/TnApN2iKf6VymoopBskAXMiWA2ussDV6C79bWZx2FKkiUP27RD5JXtYn6xMqcqiDVOA8q9Krlhzxo4R6Fih567HCMDbhH6ohiborcDcrDFlBIdWrbVmDa4hC8BcPW2hfQgKl2rI0sNe/eKwknRJrNJP+/hy0YQqsI4NKGao3LGWKSqe3b17g/1ghag5horVplohSqmLhMDT+RE/rZFSJrVmo3l8fU1FgaFihzuWGGgzqeKmo8kR/bgM31AWKTu/qpdV7sVj0l5pf54I+1toTKh5pGVp+BrCsY8V5Uy2p962Xi3Qm6xd1IfZMSVSjqEOLh+tqbU6hDSqR5LDtMxtE5W0xtpMQy1Dpu4PqoXYTVcSimtSMR2utaMcQSWOUnOhfxmogqIglpMnm1rSYQNbkQFf9hpB1m9LJd5R9yq+MeCZSlbl/U6/2RZWX59lHCyuZQ+dx7d0hendDw1A3XKwSc1heabUuadbsFHevHN2Bu+Cgja58it4/w0I/XWR6/4WyzMt3zbdI+OXp6Z8nzvF+9PpDkJxcKSwLl8A05jktcZ1Dmrm+OJrXqmho5btW6FKHEUQhCszGFqEQOYQHsc/VHYdHFZjFws2AtUCiwyf4GYGeaklqJayvnTYvX5psZ4BpAZeDPfPmQu2Z3S9EmxhtW/k3slqRuo3b2q9RW3XqSd3E6huLxUaWa/c/G5227Ue/zcauUW/ieBtDbmB1c/MfaaHaBeceAAA=


name: 📊 AI Token Tracker for WhatsApp & Telegram – Save AI Usage to Google Sheets
author_name: Amanda Benks
author_username: amanda
categories: []
created_at: 2025-05-09T14:30:39.809Z
updated_at: 2025-05-09T14:30:39.809Z
url: https://n8n.io/workflows/3963
scraped_at: 2025-12-24 13:02:45
description:
  💸 GPT-4o Token Tracker – Measure AI Usage and Cost via WhatsApp or Telegram

  Hi! I'm Amanda — I create smart, useful AI automations for n8n and Make.  
  This workflow helps you monitor how many tokens are consumed per conversation with AI Agent Tokens, and logs that usage into Google Sheets — so you can track expenses and make smarter decisions about your AI usage.

  You can connect it to Telegram or WhatsApp (via Evolution API), and it will automatically capture:
  Prompt and completion tokens
  Total tokens
  Time of interaction
  The user/channel
  (Optional) Cost estimate in USD

  📊 What this workflow does

  Logs token usage from LangChain agents  
  Calculates token totals for each request  
  Appends the data to a structured Google Sheet  
  Works with WhatsApp (Evolution API) or Telegram bots  
  Ideal for tracking AI Agent Tokens usage over time and controlling costs

  🧪 Free Spreadsheet Template

  You can duplicate and use this template for logging token usage:  
  👉 Google Sheets Template

  Includes columns like:
  Date
  Input
  Output
  Tokens (Prompt / Completion / Total)
  Tool name or use case
  Estimated cost

  🛠️ Setup Instructions

  Import the workflow to your n8n (Cloud or self-hosted)
  Connect your Google Sheets account  
  Choose your trigger:
     WhatsApp (Evolution API webhook)  
     Telegram (Bot webhook or message input)  
  Fill out:
     AI Agent model used (e.g. gpt-4o)  
     Cost per 1K tokens (optional, for USD estimation)  
  Update spreadsheet ID and tab name in the Google Sheets node  
  (Optional) Connect as a sub-tool to an AI agent for automatic logging

  🧰 Tech Used

  OpenRouter
  LangChain  
  Google Sheets  
  Telegram or WhatsApp webhook (Evolution API)  
  Nodes: HTTP Request, Set, If, Google Sheets, Merge

  ✅ Who This Is For

  Developers or agencies that want to monitor AI Agent Tokens usage  
  Freelancers managing AI bots for clients  
  Teams that need billing visibility and cost control  
  Anyone who wants transparency in AI token spending

  ✅ Requirements

  OpenAI GPT-4o access  
  Google Sheets credential  
  Telegram Bot Token (or Evolution API access for WhatsApp)  
  n8n (Cloud or self-hosted)

  🌐 Want this template?

  ❤️ Buy more workflows at: https://iloveflows.com  
  ☁️ Try n8n Cloud: https://n8n.partnerlinks.io/amanda

nodes_used:
  ["n8n-nodes-base.gmailTool","n8n-nodes-base.airtableTool","n8n-nodes-base.googleSheets","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.telegram","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.webhook","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.convertToFile","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.telegramTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.filter","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatOpenRouter","n8n-nodes-base.switch","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.switch"]

workflow_json_compressed:
  H4sIAAAAAAAAE6VZy24byRX9FYKLrFRKvR9aRTAcw4NMnLE1CZLBwKjHLYkxxWbIlmzHEJB1tvMB+bd8QT4hpymN2CKbIiUBA3hEFm+f+zr33Opv40kZn4wj/fXi8yv/7uv7N5O/T87S+Gh8SW0cn3wbT2bLNs4yve3OJRdKDKbkJJINRCkr7Xi1tXiliiOjSPmQpQzZCau8TSV5clkGEYtMYXxzNJ7FS4Kp//3nl3+PTt+OzppPNBudLWL+RItRbRajv1zEdnk6n49+MzqjKZ0v4uXov//6ZfQhXlP3ix+X8ZxGbTN60zTnUxp9uCBql4DcxvPl+OSnb7c+XV58Md9/d/rpn0ouvjunH8b3j55Mm2uq0+bz8jg3l/g8Lyi2VE5bfCm5NIzjv3Am9In0J0ocGx7+hmNX87L/2M3PeE5TqIckpZptiZLZHALTgTuWtK0sKllqUNxHqmt0H2hWRq8v42TaufR13n028zO2MspSXNLxefftWdN0J8pkGdOU8Jx2cUVH43mznLSTZobHW8uPpOcA9JnSRdN8WuVQeIopisiEl4LpxD1LVirmdLAxcF91UbA7j4g7tbSAI99ubpH8GX+tTMtjcXN0550izSVpy6qp8E7JyhKRYCG5jE98lkmvvXtD7ehVM2tjvk3ZoH9xsmg7p/a76O5dPByvLT6RTMzBXaY7qElLQjhM8dYZI8mv8f6hOd+dhlX93ZdfD5YQwLUXlT4296iM9pyT8Uwp7YEqokZElayqpBTXGv1T1qherQp29PqaZu0eeK/iFAUVF/tj6Q+LpThW96gzaSGNI6YM6lknF1kKiGXg0VkbQQNkeqinFGejH+c7EWf870YguTwgkPIeUAyiRBM0MzpnAEqReRWJlaSjKibaGO0a0OvFolnsLsM9+T0gVv0MayWid44zHm1iuljFYtGcyURcS2EplbwBbfSelvNmtqSdENs7gtyA5+RQ5yNXIeWsWYxaMq25Zj5XzYJTQktZHXm7r/PF8TrYyeqQs49Me6GZdoqzKPAnFRU1zy44LtYevcSXTU/ICSlVEcx7z5mOvLLgk2DFJc6lcj4Y/RRP4HgyxRQwOmga3ByYl2hBUXNUgbL3mXoM3U7yp6+jPzbtbmeWqzN3R3ruMOv5ERNyq3TGGazYtfPJeLwFdV1E0rkUku+qBuRNaLjoAzHS2krvOHelDgIVT0aq7UuAGs2LQ2KAjMBn0haWVKjMGKMq5EKRXA0Clc8CKrZ78TCc1deSAY/VABrTxQgWayVMQw3mtR6lbAZxqifjtPoFOEVKxgVNqMtaO5yBRRjsiE3WwrWyXA/i1E/GGV5UoUIloy1orpqMxCPXLDmoA15V9BCIXBQ5CNQ8C+izA6oxCng0yLRAWWoSBjwIGWR55BJU7GX2G6Pr49NH1yHaZM1C2peUhGSlgNq0D+A3nSQzsaZKBrJN+sHQ2SeHTij5kiST08ogzSylDP4tIbNAQjCpqkfgQMLOrZFCs5+eP1AqvwPM366hTuPsPF/Eyew43p1rZqsB2EkM4JnMrmj197urdn7VPnTFdOW67cg23Yd7+NzlKqAGmKsaufcSYqsqxWrUhTKmSfJpMND+6XyPQfWiSCP3JUIrhCLQTtkk5o30jDKGVEgWhNXj0dfXzfSqe/Lo9E9vd2K9m6Sbgwk4tyQD98mrzDHYk4ZocUahJLtWUcJ6Gzj0ndu7LNw7Y5UgZQ0mbCgKY7uzBgKGFEkxJlOzrr24v3l9NvqeyiTudOSibefv6R9XtNyoCSYPqgndkwDeRJK1m/kuAhH2IBZy8IyrHC357G89HZis4elFofiLRECE9kH7schFR11UkI9uHRUxFK8tREIYnq38GXrlJUiVCIaENixiSCOoiTOsBwCesGlWy4l0bxicXpVJM4LsPaMv7egDdQ9cwdgFelI3066ftC04RZlbwHMcMhiKRQIZSSY0ZmvJIuXaU1NYW69p0XY3D7+fTHdLv3x77qy5O9Wn3cPqUvTWVezj2ShQ7Url6ortMHXSlHNvVYHmNiVthvBsEWfLvJjMH0ZvJ+s2c5qdTh5ClfZAqHa9DyiFfcIl1i06wGst80lCAkLrGYeRKmpvhz1by/3H94GzxeT8nBYDdAWMG3xVco2y2gD1UZDRqtAaEqtpEbpaUmRC3Xu50V8MFC/WKmxLFjyMfTLDJS6IJSguEyTXlYYnhXy64GYv0bEOmsV2XEopls5xD6CYE0ZimjmL72xvu0RltquIDiOsv369UQ8H3bT020tFF9Fe0Ki+Cx62Ko7dV9jIvdOBfD94q6b/Ps7nk9nuK5clDTD9AbDUsb6HFSwJ9L2D5C8G4sWB6VWKrKJWU0BGs+0te68uImABwfSARppedsffoZ3eN1dbITRgfTD/3pZaX6+AMDPHRg2eB9IMBRDBACwHxUl1t4rUa6i3M2ij0YfmapEf2Us/T9p8sSkG9UG9rnq5DRZDRkOritLVW6yyu850DLmoIRePjbp30YK0PiGl2t8pkYNTaoVGa2OBw0KMQMkAZUpY5YpKwUJscF79AzSPdOcgnFumORgPlvPignUYLAnR4QqqrWBWO+zAOkRypV/5v154P13nCNOx9CH3UOvMZZsTyh3KxhrECvMD/YlN0lhVZXZVFrLb2Ead/n4mQLm/5vsAo3KmFG+ZCLK7w8urC2pweJBRuGwLz8MbpHveGvRszk3FJeNDwCzu1E2u2Mmdw6T2NqM3vBVSD7fnI+W3qz8PqkDZvX2IuZ1cw3SN0yUdjVHQWKDOV27RF8qr/eDdolC3XV2Lzr/rWwu3E1QpB22hWJYOGh2SnXlF3f5RhdO+uxfpVCQCNKPcmVoZ7q7J8c8lSBCAf/q2egWyk5NWx47Gk1mhL+MTfvPzzwDRccSQif2qcJc5MWhveM4M2ri7H97nmNhj5m7aDjq3tRoPWrg/NmRj+1p9y8bRxumPj57unnhvdOiJD16K7P75xx0/37x2H7RwLw+HLDxk8MHfr7fHwZjt0vLD3qw1AIzFycdu4l/Fc7r77NGEbh3ftN574Xdrve1e1ew12t6+0NlA2n8x9GJrD17WvdjaAy4YSsr2HHyskLffJ+yoo167Dz11UwsPM8GDi5UdJbnHxkPKeCwAG8P2sSjsek80XMcbVb+bbndskMPkNPCLFxLvTs4fsjtwT/RYxA6GcXPzf3J92VkeIQAA


name: Build an On-Premises AI Kaggle Competition Assistant with Qdrant RAG and Ollama
author_name: JHH
author_username: jac2325057
categories: []
created_at: 2025-05-10T05:03:59.199Z
updated_at: 2025-05-10T05:03:59.199Z
url: https://n8n.io/workflows/3967
scraped_at: 2025-12-24 13:02:43
description:
  LLM/RAG Kaggle Development Assistant

  An on-premises, domain-specific AI assistant for Kaggle (tested on binary disaster-tweet classification), combining LLM, an n8n workflow engine, and Qdrant-backed Retrieval-Augmented Generation (RAG).
  Deploy via containerized starter kit.
  Needs high end GPU support or patience.
  Initial chat should contain guidelines on what to to produce and the challenge guidelines.
  Features

  Coding Assistance**  
    • "Real"-time Python code recommendations, debugging help, and data-science best practices  
    • Multi-turn conversational context
  Workflow Automation**  
    • n8n orchestration for LLM calls, document ingestion, and external API integrations  
  Retrieval-Augmented Generation (RAG)**  
    • Qdrant vector-database for competition-specific document lookup  
    • On-demand retrieval of Kaggle competition guidelines, tutorials, and notebooks after convertion to HTML and ingestion into RAG
  entirly On-Premises for Privacy**  
    • Locally hosted LLM (via Ollama) – no external code or data transfer  

  ALIENTELLIGENCE/contentsummarizer:latest for summarizing
  qwen3:8b for chat and coding
  mxbai-embed-large:latest for embedding
    
    • GPU acceleration required

  Based on:
  https://n8n.io/workflows/2339 breakdown documents into study notes using templating mistralai and qdrant/

nodes_used:
  ["n8n-nodes-base.localFileTrigger","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter","n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.switch","n8n-nodes-base.readWriteFile","n8n-nodes-base.extractFromFile","@n8n/n8n-nodes-langchain.chainSummarization","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.vectorStoreQdrant","n8n-nodes-base.markdown","@n8n/n8n-nodes-langchain.embeddingsOllama","@n8n/n8n-nodes-langchain.lmOllama","@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.toolVectorStore","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.vectorStoreQdrant","@n8n/n8n-nodes-langchain.lmChatOllama","@n8n/n8n-nodes-langchain.embeddingsOllama","@n8n/n8n-nodes-langchain.lmChatOllama"]

workflow_json_compressed:
  [encoded data, 4384 characters]


name: AI Email Triage & Alert System with GPT-4 and Telegram Notifications
author_name: Peter Joslyn
author_username: pjawz
categories: []
created_at: 2025-05-10T05:49:57.648Z
updated_at: 2025-05-10T05:49:57.648Z
url: https://n8n.io/workflows/3968
scraped_at: 2025-12-24 13:02:45
description:
  Fully Automated AI Email System for n8n: Triage, Summarize & Alert—Never Check Your Inbox Again!





  Fully Automated Email Intelligence: Triage, Summarize, Escalate & Alert—Never Check Your Inbox Again

  🚀 Overview

  Turn every minute you waste in your inbox into revenue‑generating focus time.
  This is more than a workflow—it’s a profit engine disguised as an email assistant.





  ⚙️ Eliminate 90 % of inbox noise with AI triage and smart labeling.



  🚨 Instantly surface high‑value leads & crises via Telegram push alerts—before they cost you.



  📰 Digest newsletters in 60 seconds with bite‑size AI briefs that keep you ahead of the curve.



  🤖 Hand off replies, snoozes, and archiving to a tireless autonomous agent that never slips.

  Set‑up takes 10 minutes. The payoff starts within the first hour—hours reclaimed, opportunities captured, and the calm certainty your inbox is handled perfectly, 24/7.



  🎯 Who's It For?





  Startup Founders & CEOs – Stop wasting hours on inbox cleanup. Automatically surface leads, triage support, and escalate ops issues while you focus on growth.



  Agencies & Consultants – Instantly prioritize high-value client messages, flag urgent ops threads, and never drop the ball on critical communication.



  Busy Professionals & Teams – Reclaim 5–10 hours weekly by letting AI handle noise, flag what matters, and summarize newsletters into actionable insights.



  No-Code Builders & AI Engineers – Plug in, customize, and ship production-ready inbox automation in minutes—no training required.



  Remote Operators & Virtual Assistants – Delegate inbox management confidently with a system that flags what’s important and handles the rest.



  📌 High‑Impact Results

  What You’re Dealing With → What This System Solves Instantly





  Inbox Clutter & Constant Noise → 90% Noise Reduction
  Trivial, low-value messages are automatically triaged and labeled—only high-value threads stay in your spotlight.



  Missing Critical Emails → Real-Time Telegram Alerts
  Get instantly notified the moment a client, lead, or ops-critical email lands. Zero lag. Zero drop.



  Manual Reply Fatigue → AI-Generated Drafts in Seconds
  Fully contextual, brand-aligned replies ready at a click—cut response time from minutes to seconds.



  Newsletter Overload → Actionable 60-Second Summaries
  Dense newsletters converted into digestible, decision-ready highlights. Save hours while staying sharp.



  Information Chaos → Fully Structured Inbox Intelligence
  From raw email to labeled insights to escalated alerts—your inbox becomes an automated decision support system.

  This system doesn’t just "help"—it replaces hours of work per week, prevents costly misses, and ensures you never drown in emails again.



  ⚙️ Powerful Features





  📥 AI Email Triage – Classifies and sorts emails using GPT/Gemini, labeling by intent and urgency.



  📰 Newsletter Summarizer – Extracts concise, actionable insights from newsletters into structured summaries.



  🚨 Real-Time Priority Alerts – Instantly escalates mission-critical emails via Telegram.



  🤖 Autonomous Inbox Agent – Proactively manages email actions: replies, drafts, archives, and thread labeling.



  🧠 Persistent Context Memory – Remembers senders, conversation history, and adjusts responses accordingly.



  🏅 Why Choose This Solution?





  Fully Self-Hosted & Secure – Keep full control of your data and privacy. No external storage, no SaaS lock-in—just your infrastructure, your rules.



  Production-Grade Reliability – Built by a Lead Software Engineer. Tested, trusted, and optimized for uptime by myself.



  AI-Native Workflow Engine – Smart, adaptive, and deeply embedded in your processes. Automates with context, learns with use, and gets smarter over time.



  💰 Pricing

  Limited Time Launch Price: $29 (One-time payment)

  🎯 Lifetime access—pay once, save time forever.

  ⏱️ Designed to reclaim 5–10 hours per week per inbox.

  🚨 One missed priority email could cost more—this system prevents that.

  ⚡ Launch offer pricing will increase SOON!—lock in early.


  📦 What's Included?

  ✅ Fully documented and annotated n8n workflow (ready-to-import JSON)

  📂 Gmail labeling system (production-ready taxonomy)


  📲 Telegram integration and alert configuration



  🛠 Customizable AI prompt templates for Gemini/GPT



  🧠 Custom prompt templates for GPT & Gemini



  ⚙️ Autonomous email categorization & filtering



  📰 Newsletter summarizer with structured JSON output



  🤖 Optional AI agent for full inbox management tasks



  🚀 Quick Start Setup





  Import the full workflow into your self-hosted n8n environment.



  Connect your Gmail, Telegram, and preferred LLMs (OpenAI or Gemini).



  Deploy Gmail labels using the included taxonomy—ensures proper triage and filtering.



  Trigger test alerts from real email data to verify AI classification and Telegram escalation.



  Go live—start receiving summarized insights, escalations, and triaged inbox updates within minutes.



  ❓ FAQ

  Q: What kind of ROI can I expect?
  A: On average, users reclaim 5–10 hours per week per inbox by eliminating low-priority noise, surfacing urgent emails instantly, and automating replies and summaries. For a business leader or agency, that’s hundreds of dollars in time savings weekly—and zero dropped balls.

  Q: Can it scale for my team?
  A: Absolutely. It’s architected with modular nodes and reusable components so you can rapidly duplicate, extend, or adapt it across teams, departments, and workflows. Whether you’re a solo founder or managing 20+ inboxes, this system grows with you—without code rewrites.

  Q: Is my data secure?
  A: Absolutely!. This system runs entirely in your self-hosted n8n environment, so your data never leaves your control. External LLMs (like OpenAI or Gemini) are only used when needed and receive minimal, context-limited input. You control all API keys and endpoints. No data is stored externally unless you configure it.



  Made with ❤️ by Bluegrass Digital Advantage

nodes_used:
  ["n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.telegramTrigger","n8n-nodes-base.telegram","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.aggregate","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.noOp","n8n-nodes-base.stopAndError","n8n-nodes-base.telegram","n8n-nodes-base.stopAndError","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.gmailTrigger","n8n-nodes-base.set","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.outputParserAutofixing","n8n-nodes-base.switch","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.if","n8n-nodes-base.gmail","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.textClassifier","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.noOp","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.webhook","n8n-nodes-base.set","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.set","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.memoryPostgresChat","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.airtable","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.toolWorkflow","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 10464 characters]


name: Summarise Slack Channel Activity for Weekly Reports with AI
author_name: Jimleuk
author_username: jimleuk
categories: []
created_at: 2025-05-10T08:37:45.163Z
updated_at: 2025-05-10T08:37:45.163Z
url: https://n8n.io/workflows/3969
scraped_at: 2025-12-24 13:02:41
description:
  This n8n template lets you summarize team member activity on Slack for the past week and generates a report.

  For remote teams, chat is a crucial communication tool to ensure work gets done but with so many conversations happening at once and in multiple threads, ideas, information and decisions usually live in the moment and get lost just as quickly - and all together forgotten by the weekend!

  Using this template, this doesn't have to be the case. Have AI crawl through last week's activity, summarize all threads and generate a casual and snappy report to bring the team back into focus for the current week. A project manager's dream!

  How it works
  A scheduled trigger is set to run every Monday at 6am to gather all team channel messages within the last week.
  Each message thread are grouped by user and data mined for replies.
  Combined, an AI analyses the raw messages to pull out interesting observations and highlights.
  The summarized threads of the user are then combined together and passed to another AI agent to generate a higher level overview of their week. These are referred to as the individual reports.
  Next, all individual reports are summarized together into a team weekly report. This allows understanding of group and similar activities.
  Finally, the team weekly report is posted back to the channel. The timing is important as it should be the first message of the week and ready for the team to glance over coffee.

  How to use
  Ideally works best per project and where most of the comms happens on a single channel. Avoid combining channels and instead duplicate this workflow for more channels.
  You may need to filter for specific team members if you want specific team updates.
  Customise the report to suit your organisation, team or the channel. You may prefer to be more formal if clients or external stakeholders are also present.

  Requirements
  Slack for chat platform
  Gemini for LLM (or switch for other models)

  Customising this workflow
  If the slack channel is busy enough already, consider posting the final report to email.
  Pull in project metrics to include in your report. As extra context, it may be interesting to tie the messages to production performance.
  Use an AI Agent to query for knowledgebase or tickets relevant to the messages. This may be useful for attaching links or references to add context.
  Channel not so busy or way too busy for 1 week? Play with the scheduled trigger and set an interval which works for your team. 

nodes_used:
  ["n8n-nodes-base.slack","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.splitOut","n8n-nodes-base.code","n8n-nodes-base.slack","n8n-nodes-base.aggregate","n8n-nodes-base.splitOut","n8n-nodes-base.slack","n8n-nodes-base.aggregate","n8n-nodes-base.set","n8n-nodes-base.filter","n8n-nodes-base.noOp","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.slack","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.aggregate","n8n-nodes-base.aggregate","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.aggregate","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.switch","n8n-nodes-base.executeWorkflow","n8n-nodes-base.set","n8n-nodes-base.executeWorkflow","n8n-nodes-base.if","n8n-nodes-base.code","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.slack","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.executeWorkflow","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 11380 characters]


name: Secure API Endpoint with Bearer Token Authentication and Field Validation
author_name: Audun
author_username: xqus
categories: []
created_at: 2025-05-10T10:23:31.512Z
updated_at: 2025-05-10T10:23:31.512Z
url: https://n8n.io/workflows/3970
scraped_at: 2025-12-24 13:02:45
description:
  A reusable and production-ready n8n workflow that secures public webhooks using Bearer Token authentication and dynamic request validation.

  ✨ What It Does

  Verifies Bearer Token**  
    Compares the Authorization header with a configured secret token.

  Validates Required Fields**  
    Checks that all expected fields are present in the incoming request body.

  Returns Standardized JSON Responses**  
    401 Unauthorized if token is missing or invalid  
    400 Bad Request if required fields are missing  
    200 OK with a custom success payload

  👤 Who It’s For

  Developers exposing n8n workflows as APIs
  No-code/low-code builders integrating with external forms or tools
  Anyone needing simple authentication and validation on incoming webhooks

  💡 Why Use It

  🔒 Secure: Prevents unauthorized access to your public workflows
  🧼 Clean: Centralized configuration for token and required fields
  ⚙️ Flexible: Easy to extend and customize for any use case

  🛠 Setup Instructions

  Configure Values in the Configuration Node
     Set your secret token:  
       config.bearerToken = YOUR_TOKEN
     Define required request fields by key:  
       Example:  
            config.requiredFields.message = true;
       config.requiredFields.email = true;
             ✅ Only the keys matter – values can be anything.

  Plug in Your Business Logic  
     Replace the "Add workflow nodes here" with your own logic.

  Customize the Success Response  
     Edit the Create Response node to shape your success payload.

  🧪 Use Cases

  Securing public form submissions 
  Creating internal API endpoints
  Validating data from external services

  📌 Use this as a base for building secure, API-style workflows in n8n.

  👋 Hello! I'm Audun / xqus 

  If my n8n workflows saved you time or sparked ideas, consider sending a little support my way. It helps me keep building cool stuff — and maybe grab a coffee ☕ along the way!

nodes_used:
  ["n8n-nodes-base.if","n8n-nodes-base.respondToWebhook","n8n-nodes-base.respondToWebhook","n8n-nodes-base.set","n8n-nodes-base.webhook","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.respondToWebhook","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.noOp","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 4336 characters]


name: Summarise MS Teams Channel Activity for Weekly Reports with AI
author_name: Jimleuk
author_username: jimleuk
categories: []
created_at: 2025-05-10T15:05:32.396Z
updated_at: 2025-05-10T15:05:32.396Z
url: https://n8n.io/workflows/3971
scraped_at: 2025-12-24 13:02:42
description:
  This n8n template lets you summarize individual team member activity on MS Teams for the past week and generates a report.

  For remote teams, chat is a crucial communication tool to ensure work gets done but with so many conversations happening at once and in multiple threads, ideas, information and decisions usually live in the moment and get lost just as quickly - and all together forgotten by the weekend!

  Using this template, this doesn't have to be the case. Have AI crawl through last week's activity, summarize all messages and replies and generate a casual and snappy report to bring the team back into focus for the current week. A project manager's dream!

  How it works
  A scheduled trigger is set to run every Monday at 6am to gather all team channel messages within the last week.
  Messages are grouped by user.
  AI analyses the raw messages and replies to pull out interesting observations and highlights. This is referred to as the individual reports.
  All individual reports are then combined and summarized together into what becomes the team weekly report. This allows understanding of group and similar activities.
  Finally, the team weekly report is posted back to the channel. The timing is important as it should be the first message of the week and ready for the team to glance over coffee.

  How to use
  Ideally works best per project and where most of the comms happens on a single channel. Avoid combining channels and instead duplicate this workflow for more channels.
  You may need to filter for specific team members if you want specific team updates.
  Customise the report to suit your organisation, team or the channel. You may prefer to be more formal if clients or external stakeholders are also present.

  Requirements
  MS Teams for chat platform
  OpenAI for LLM

  Customising this workflow
  If the teams channel is busy enough already, consider posting the final report to email.
  Pull in project metrics to include in your report. As extra context, it may be interesting to tie the messages to production performance.
  Use an AI Agent to query for knowledgebase or tickets relevant to the messages. This may be useful for attaching links or references to add context.

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.microsoftTeams","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.chainLlm","n8n-nodes-base.markdown","n8n-nodes-base.microsoftTeams","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.splitOut","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 6348 characters]


name: Multilingual WhatsApp Translator with OpenAI Whisper & GPT-4 and HubSpot Integration
author_name: Amanda Benks
author_username: amanda
categories: []
created_at: 2025-05-10T15:10:13.996Z
updated_at: 2025-05-10T15:10:13.996Z
url: https://n8n.io/workflows/3972
scraped_at: 2025-12-24 13:02:45
description:
  🌍 AI WhatsApp Translator + Voice Transcriber with HubSpot Integration

  Hello! I'm Amanda ❤️, a passionate automation creator and AI enthusiast.  
  With over 2 years of experience in n8n and Make.com, I design robust, intelligent agents  
  that make your operations smarter and smoother.

  This translator + transcriber assistant is perfect for multilingual communication via WhatsApp.  
  It automatically captures voice or text messages, identifies the customer's region and language,  
  transcribes audio using OpenAI Whisper, and generates friendly, culturally adapted translations  
  with GPT-4 or GPT-4o. All messages and contacts are saved in your HubSpot CRM—so no lead gets lost.

  ✅ What this Workflow Does:

  🎧 Transcribes audio messages using OpenAI Whisper (accurate + fast).
  🌐 Translates text & voice into the client’s native language or a default one.
  🇧🇷 Adapts tone, slang, emojis, and cultural expressions for natural conversation.
  💼 Saves contact info & history to HubSpot automatically (name, phone, and translation).
  📬 Replies via WhatsApp using Evolution API (also works with chatbots).
  ✨ Handles over 80+ countries and phone prefixes to detect preferred languages.

  🛠️ How to Use It:

  Clone the workflow to your n8n instance (cloud or self-hosted).
  Configure the Webhook URL in your Evolution API or WhatsApp provider.
  Set up credentials for:
     OpenAI (for transcription and GPT translation)
     HubSpot (to store leads)
  Optional: Adjust prompt logic and default languages inside the AI Agent node.
  Done! Your AI translator bot is live 💬🌎

  🧠 LLMs and Tools Used:

  OpenAI GPT-4o / GPT-4 Mini** for translation
  OpenAI Whisper** for transcription
  HubSpot CRM** integration
  Evolution API** for WhatsApp messaging
  Dynamic language detection based on phone prefix

  💡 Ideal For:

  Multinational businesses with global customers
  Customer support teams with multilingual needs
  Agencies serving clients in Latin America, Europe, or Asia
  Translating informal messages in real-time

  📁 Included:

  1x Complete n8n Workflow  
  Preconfigured translation agents  
  HubSpot contact mapper  
  Multi-country language index  
  Ready-to-use voice transcription logic

  ❤️ Support Materials and Templates:
  iloveflows.gumroad.com

  ☁️ Want to use this with n8n Cloud?  
  Use my affiliate link to get started:  
  👉 https://n8n.partnerlinks.io/amanda

  🔥 Buy a VPS server with a Super Discount: https://hostinger.com/vps

nodes_used:
  ["n8n-nodes-base.convertToFile","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.webhook","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.filter","@n8n/n8n-nodes-langchain.toolCalculator","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.convertToFile","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.httpRequest","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolCalculator","@n8n/n8n-nodes-langchain.toolThink","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.toolThink","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.convertToFile","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolCalculator","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.toolThink","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.filter","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.filter","n8n-nodes-base.filter","n8n-nodes-base.filter","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.n8n","n8n-nodes-base.stickyNote","n8n-nodes-base.n8n","n8n-nodes-base.splitInBatches","n8n-nodes-base.noOp","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.textClassifier","@n8n/n8n-nodes-langchain.textClassifier","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatGroq","n8n-nodes-base.filter","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.filter","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.hubspot","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.filter","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.filter","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.if"]

workflow_json_compressed:
  [encoded data, 7412 characters]


name: Create Secure Interactive Applications with WhatsApp Flows End-to-End Encryption
author_name: Flavio Angeleu
author_username: flavioangeleu
categories: []
created_at: 2025-05-10T16:32:23.891Z
updated_at: 2025-05-10T16:32:23.891Z
url: https://n8n.io/workflows/3973
scraped_at: 2025-12-24 13:02:45
description:
  WhatsApp Flows Encrypted Data Exchange Workflow

  Summary
  This workflow enables secure end-to-end encrypted data exchange with WhatsApp Flows for interactive applications inside Whatsapp.  It implements the WhatsApp Business Encryption protocol using RSA for key exchange and AES-GCM for payload encryption, providing a secure channel for sensitive data transmission while interfacing with WhatsApp's Business API. This follows the official WhatsApp Business Encryption specifications to establish an encrypted GraphQL-powered data exchange channel between your business and the WhatsApp consumer client.

  How It Works

  Encryption Flow
  Webhook Reception: Receives encrypted data from WhatsApp containing:
     encrypted_flow_data: The AES-encrypted payload
     encrypted_aes_key: The RSA-encrypted AES key
     initial_vector: Initialization vector for AES decryption

  Decryption Process:
     The workflow decrypts the AES key using an RSA private key
     Then uses this AES key to decrypt the payload data
     The inverted IV is used for response encryption

  Data Processing:
     The workflow parses the decrypted JSON data
     Routes requests based on the screen parameter.
   

  Response Generation:
     Generates appropriate response data based on the request type
     Encrypts the response using the same AES key and inverted IV
     Returns the base64-encoded encrypted response

  Key Components
  Webhook Endpoint**: Entry point for encrypted WhatsApp requests
  Decryption Pipeline**: RSA and AES decryption components
  Business Logic Router**: Screen-based routing for different functionality
  Encryption Pipeline**: Secure response encryption

  How to Use

  Deploy the Workflow:
     Import the workflow JSON into your n8n instance

  Set Up WhatsApp Integration:
     Configure your WhatsApp Business API to send requests to your n8n webhook URL
     Ensure your WhatsApp integration is set up to encrypt data using the public key pair of the private key used in this workflow

  Test the Flow:
     Send an encrypted test message from WhatsApp to verify connectivity
     Check if appointment data is being retrieved correctly
     Validate that seat selection is functioning as expected

  Production Use:
     Monitor the workflow performance in production
     Set up error notification if needed

  Requirements

  Authentication Keys

  RSA Private Key: Required for decrypting the AES key (included in the workflow)
  WhatsApp Business Public Key: Must be registered with the WhatsApp Business API
  PostgreSQL Credentials: For accessing appointment data from the database

  WhatsApp Business Encryption Setup
  As specified in the WhatsApp Business Encryption documentation:

  Generate a 2048-bit RSA Key Pair:

  The private key remains with your business (used in this workflow)
  The public key is shared with WhatsApp


  Register the Public Key with WhatsApp:

  Use the WhatsApp Cloud API to register your public key
  Set up the public key using the /v17.0/{WhatsApp-Business-Account-ID}/whatsapp_business_encryption endpoint


  Key Registration API Call:
  POST /v17.0/{WhatsApp-Business-Account-ID}/whatsapp_business_encryption
  {
    "business_public_key": "YOUR_PUBLIC_KEY"
  }

  Verification:

  Verify your public key is registered using a GET request to the same endpoint
  Ensure the key status is "active"

nodes_used:
  ["n8n-nodes-base.webhook","n8n-nodes-base.code","n8n-nodes-base.switch","n8n-nodes-base.respondToWebhook","n8n-nodes-base.code","n8n-nodes-base.respondToWebhook","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 7404 characters]


name: Prevent Concurrent Workflow Runs Using Redis
author_name: Hugues Stock
author_username: hpstock
categories: []
created_at: 2025-05-10T23:21:45.044Z
updated_at: 2025-05-10T23:21:45.044Z
url: https://n8n.io/workflows/3976
scraped_at: 2025-12-24 13:02:45
description:
  What does this template do?  
  This workflow sets a small "lock" value in Redis so that only one copy of a long job can run at the same time. If another trigger fires while the job is still busy, the workflow sees the lock, stops early, and throws a clear error. This protects your data and keeps you from hitting rate limits.  
  Because the workflow also stores simple progress flags ("working", "loading", "finishing"), you can poll the current status and show live progress for very long jobs.

  Use Case  
  Great when the same workflow can be called many times in parallel (for example by webhooks, cron jobs, or nested Execute Workflow calls) and you need an "only run once at a time" guarantee without building a full queue system.

  What the Workflow Does  
  ⚡ Starts through Execute Workflow Trigger called by another workflow  
  🔄 A Switch sends the run to Get, Set, or Unset actions  
  💾 Redis reads or writes a key named process_status_&lt;key&gt; with a time‑to‑live (default 600 s)  
  🚦 If nodes check the key and decide to continue or stop  
  ⏱️ Wait nodes stand in for the slow part of your job (replace these with your real work)  
  📈 Updates the key with human‑readable progress values that another workflow can fetch with action = get  
  🏁 When done, the lock is removed so the next run can start  

  Apps & Services Used  
  Redis  
  Core n8n nodes (Switch, If, Set, Wait, Stop and Error)  

  Pre‑requisites  
  A Redis server that n8n can reach  
  Redis credentials stored in n8n  
  A second workflow that calls this one and sends:  
    action set to get, set, or unset  
    key set to a unique name for the job  
    Optional timeout in seconds  

  Customization Tips  
  Increase or decrease the TTL in the Set Timeout node to match how long your job usually runs  
  Add or rename status values ("working", "loading", "finishing", and so on) to show finer progress  
  Replace Stop and Error with a Slack or email alert, or even push the extra trigger into a queue if you prefer waiting instead of failing  
  Use different Redis keys if you need separate locks for different tasks  
  Build a small "status endpoint" workflow that calls this one with action = get to display real‑time progress to users

  Additional Use Cases  

  🛑 Telegram callback spam filter  
  If a Telegram bot sends many identical callbacks in a burst, call this workflow first to place a lock. Only the first callback will proceed; the rest will exit cleanly until the lock clears. This keeps your bot from flooding downstream APIs.

  🧩 External API rate‑limit protection  
  Run heavy API syncs one after the other so parallel calls do not break vendor rate limits.

  🔔 Maintenance window lock  
  Block scheduled maintenance tasks from overlapping, making sure each window finishes before the next starts.

nodes_used:
  ["n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.switch","n8n-nodes-base.manualTrigger","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.executeWorkflow","n8n-nodes-base.executeWorkflow","n8n-nodes-base.stickyNote","n8n-nodes-base.executeWorkflow","n8n-nodes-base.stickyNote","n8n-nodes-base.redis","n8n-nodes-base.redis","n8n-nodes-base.redis","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.executeWorkflow","n8n-nodes-base.stopAndError","n8n-nodes-base.noOp","n8n-nodes-base.executeWorkflow","n8n-nodes-base.executeWorkflow","n8n-nodes-base.stickyNote","n8n-nodes-base.wait","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.executeWorkflow","n8n-nodes-base.stopAndError","n8n-nodes-base.executeWorkflow","n8n-nodes-base.stickyNote","n8n-nodes-base.wait","n8n-nodes-base.stickyNote","n8n-nodes-base.wait","n8n-nodes-base.wait","n8n-nodes-base.executeWorkflow","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.executeWorkflow","n8n-nodes-base.executeWorkflow","n8n-nodes-base.executeWorkflow","n8n-nodes-base.switch","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5228 characters]


name: Auto-Generate And Post Tweet Threads Based On Google Trends Using Gemini AI
author_name: Amjid Ali
author_username: amjid
categories: []
created_at: 2025-05-11T10:14:48.535Z
updated_at: 2025-05-11T10:14:48.535Z
url: https://n8n.io/workflows/3978
scraped_at: 2025-12-24 13:02:45
description:
  AI-Powered Twitter Automation using n8n to Check BigQuery Latest Google Trend and Publish

  Who is this for?

  This template is designed for:

  Content creators
  Tech influencers
  Educators and marketers
    who want to automatically tweet trend-based threads using AI and stay relevant without spending time on manual research and content writing.

  What problem does this workflow solve?

  Creating daily engaging Twitter threads takes time and effort. This workflow:

  Finds trending search terms in your region (via Google Trends)
  Selects the most relevant topic using AI
  Generates a thread of five value-packed tweets
  Publishes them automatically on X (Twitter)

  You get high-quality, niche-specific content on autopilot — ideal for boosting visibility, brand awareness, and engagement.

  What this workflow does

  ⏰ Runs on a scheduled basis (daily at your preferred hour)
  🌍 Uses BigQuery to fetch the top 25 trending search terms
  🎯 AI Agent selects one niche-relevant trend
  ✍️ AI generates a 5-part tweet thread using Gemini or OpenAI
  🐦 Tweets are published to X (Twitter) in sequence
  🔁 Works with any niche – simply modify the AI prompt

  Setup Instructions

  🔧 Google Cloud Setup

     Create a project in Google Cloud Console
     Enable BigQuery API
     Use the included SQL to fetch Google Trends

  🐦 Twitter Developer Setup

     Go to developer.twitter.com
     Create an app and generate OAuth 2.0 credentials

  🧠 AI Credentials

     Add either Gemini API Key or OpenAI Key in n8n

  ✨ Customize

     Modify the AI prompts to match your niche (e.g., marketing, health, finance)
     Adjust tweet tone, call to action, hashtags, or output format

  How to customize this workflow to your needs

  🌍 Change Google Trends region or country in the SQL query
  🧠 Switch to another AI model (Claude, GPT-4o, DeepSeek, etc.)
  📢 Replace Twitter with LinkedIn, Telegram, or Slack integration
  📊 Add metrics or logging for tweet performance (advanced)

  🎥 Watch How It Works



  &gt; In this tutorial, I walk you through the full automation – from pulling Google Trends to posting your AI-generated tweet thread using n8n.

  Example Use Cases

  🔍 Daily tweet series on trending tools or technologies
  💹 Market insights or productivity tips based on daily trends
  🎓 Educational content scheduled automatically
  🧠 Personal brand building using consistent, trend-aware posts

  Dependencies

  n8n (self-hosted or cloud)
  Google Cloud project with BigQuery enabled
  Twitter Developer Account (OAuth 2.0 setup)
  AI provider (Gemini or OpenAI)

  Keywords

  n8n twitter automation, tweet scheduler, X automation, auto post tweets, AI tweet writer, trending topics Twitter bot, Google Trends automation, AI content workflow, tweet generator using GPT, Twitter bot with Gemini, twitter + n8n

  Support & Credit

  Created by Amjid Ali —
  🏆 Global CIO200 | Founder of Syncbricks

  If this template saved you time, consider supporting:

  ➡️ paypal.me/pmptraining

  📚 Learn more:

  Enroll in the full n8n course
  LMS
  More automation templates
  Watch all YouTube tutorials

nodes_used:
  ["n8n-nodes-base.twitter","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.aggregate","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","n8n-nodes-base.code","n8n-nodes-base.splitInBatches","n8n-nodes-base.wait","n8n-nodes-base.googleBigQuery","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE62Y227bRhCGX0XQtTbd88FXTVwgMNA0Ldw2AQqj2MOsTEQiBYmqEwR+9w4pN6Ql0jqkN4JEDmc+zs7O/Kuv0yXUfnr1dVqUm9qXEW7S9GoqeLI0K+WF8iYoky1I47mPzCllk8sqRIjOCq8Uc8lF7oI3TOQsM+PRTGfTGparha/heg1pcwv1dnVd4RWoAQPU6y08zqZllWAzvfoLozdRgVHDWApEoWMivRHEJ/DEeoCsrbdSafRc+iWg9ccmyJdV87W0JWl9keA38Kp+KOoa1nh/VW2KuqhKjMG5pDPF6R1e9Wt0gRYY++vjzsuf+Ks15I+zJxwOOUmjgQTwkkjLLQnRRhKZdMxLarXs4dwWzdtN3sGyWn/p0H5Eth86voUv5/HeF+WrZWv4ZpszrD8UZaoenvNKTmdWHsVlr8Q3YOOEiFkEYgRzRCaliGMuEO+s4jFyq1TogN9W1RyB38KyKIvJ9b2vJ++QcXEC+2LZmO8c7J7fyzVFdn2c/Rs5zc4yrylhGXklCE0CY4I4Rb1mxgALviN/va0rkovPRTmfvN/Wq209+dWvN+2KH0OvWvudeeNn5+Y5vkZ8fULqu0qJFCi1noC0jEiTGAnUZJIAt0bO+AqZ9SoFqz/WW9wX30XfuXlOb5vk2xMKp6v07ClzEgwxJhms9ADEQ1aEZyu48jFzY3vpn8/XMMetPboBfc+iR0a4pTNzTl0wwD6UQiTJQCRS4YdrvsXEsV6ipC7FDuz9CsrXN5eUcvtkcVgFpxRxP48mamW8JyY6aBqYJN4LR5ho+qXnAlPb4f6+hjJNbmEBsa5OWX0/h7Le6xIIKU5ZbDeb+sWD/7LZldxPvun62S820FUxAzA+O6K8o7gJMyMOOz2RLDGjrDRMih79A0CN3aOEtb8YnzVN+TT+b5jSO29ZDoRxIYiMmhNrMiUeMywAENL4412O/Q9tjjGkN2c1Cq+MRXwSFH5IHRixWisccziejAiWitSxXyPP6B6Lu5t9HI0jQ9EzJhwOcKXBOiIkdlyJVUuCppKAM0alqATO9Q7n56paTd7/A+vJDQ73zSjZZrUo6pvyja/jPWz2GJ09ibEbatrrrL21hGbUAxLVB05hwDXHGhBZOcpzbwp/8EU9Cvawu9kfVEr/JwoeINxX1adW/jiwGhSXRDOeMC8C9zG12Bmpw0YfIaDmmR4t2d6yW4tZlopYHtBLNkBcCBbbmDcce4PHIj4o2bY9bCav/7gdfaF5a/mmmP+2hVZ09JutwNYgj/cv3uekUnlUCwQbPsdcM48TOKCecJ5pByqo3Gu3t7i8aduSFvN5f37tF8STYWfX52QU18CcN7A44BJZhWlkHhttkpLYxCLKB0FxSZEc+qB1ET99mfxSvTCyNq3Nk8kzPNWogcOKncaqrJuGdjWdjm/4aHjmIVnCBTWNsMHqzYkTrVSkxjIdXR4EZexi1MtIdYwhCqaIwn2PNYq6O3BUA4LmiGMgaaphmJSfT6oacXspKG5FVIuSOCpR5SqvUeBihkGxTDPQYMzw2jNxNmjT4C/lTNLqbEwgzrZiIOJm0o0kRxmAk0uA1CNLL8/npPRyULAoUB3TRLncgKJ+CcKlZvh7bTkIquUwqDofFBXV2aBojfdLlEl4oTX/2HwscUajSzw9NoEPmn97e4bn2gSfp1f08e4OPbcjdejZ0eE26KaN9P1uOiU95GtMHw66en78RHe++Hv59OMEn531vuO9JwZBx6TgIOl+inoe72ad049H3OwHHQJ7LqCG87Y/xIb8vDCRB50e2g95HThHDXo7PNbslrcRqlsU1U/X+p6PH5APnh95h8O/B44Ff6HEXo44ei7eReyffS9422ePH2zEURdHYr/wsi8GHD+WHE3v2GY7kt/Hx38Bh0BNMewTAAA=


name: Raw Materials Inventory Management with Google Sheets, Supabase and Approvals
author_name: Immanuel
author_username: spectrabit
categories: []
created_at: 2025-05-11T13:15:27.989Z
updated_at: 2025-05-11T13:15:27.989Z
url: https://n8n.io/workflows/3979
scraped_at: 2025-12-24 13:02:44
description:
  Automated Raw Materials Inventory Management with Google Sheets, Supabase, and Gmail using n8n Webhooks

  Description

  What Problem Does This Solve? 🛠️
  This workflow automates raw materials inventory management for businesses, eliminating manual stock updates, delayed material issue approvals, and missed low stock alerts. It ensures real-time stock tracking, streamlined approvals, and timely notifications. 

  Target audience: Small to medium-sized businesses, inventory managers, and n8n users familiar with Google Sheets, Supabase, and Gmail integrations.

  What Does It Do? 🌟
  Receives raw material data and issue requests via form submissions.
  Updates stock levels in Google Sheets and Supabase.
  Manages approvals for material issue requests with email notifications.
  Detects low stock levels and sends alerts via Gmail.
  Maintains data consistency across Google Sheets and Supabase.

  Key Features 
  Real-time stock updates from form submissions.
  Automated approval process for material issuance.
  Low stock detection with Gmail notifications.
  Dual storage in Google Sheets and Supabase for redundancy.
  Error handling for robust data validation.

  Setup Instructions

  Prerequisites 
  n8n Instance**: Self-hosted or cloud n8n instance.
  API Credentials**:
    Google Sheets API: Credentials from Google Cloud Console with Sheets scope, stored in n8n credentials.
    Supabase API: API key and URL from Supabase project, stored in n8n credentials (do not hardcode in nodes).
    Gmail API: Credentials from Google Cloud Console with Gmail scope.
  Forms**: A form (e.g., Google Form) to submit raw material receipts and issue requests, configured to send data to n8n webhooks.

  Installation Steps 
  Import the Workflow:
     Copy the workflow JSON from the “Template Code” section (to be provided).
     Import it into n8n via “Import from File” or “Import from URL”.
  Configure Credentials:
     Add API credentials in n8n’s Credentials section for Google Sheets, Supabase, and Gmail.
     Assign credentials to respective nodes. For example:
       In the Append Raw Materials node, use Google Sheets credentials: {{ $credentials.GoogleSheets }}.
       In the Current Stock Update node, use Supabase credentials: {{ $credentials.Supabase }}.
       In the Send Low Stock Email Alert node, use Gmail credentials.
  Set Up Nodes:
     Webhook Nodes (Receive Raw Materials Webhook, Receive Material Issue Webhook): Configure webhook URLs and link them to your form submissions.
     Approval Email (Send Approval Request): Customize the HTML email template if needed.
     Low Stock Alerts (Send Low Stock Email Alert, Send Low Stock Email After Issue): Configure recipient email addresses.
  Test the Workflow:
     Submit a test form for raw material receipt and verify stock updates in Google Sheets/Supabase.
     Submit a material issue request, approve/reject it, and confirm stock updates and notifications.

  How It Works

  High-Level Steps 
  Receive Raw Materials: Processes form submissions for raw material receipts.
  Update Stock: Updates stock levels in Google Sheets and Supabase.
  Handle Issue Requests: Processes material issue requests via forms.
  Manage Approvals: Sends approval requests and processes decisions.
  Monitor Stock Levels: Detects low stock and sends Gmail alerts.

  Detailed Descriptions
  Detailed node descriptions are available in the sticky notes within the workflow screenshot (to be provided). Below is a summary of key actions.

  Node Names and Actions

  Raw Materials Receiving and Stock Update
  Receive Raw Materials Webhook**: Receives raw material data from a form submission.
  Standardize Raw Material Data**: Maps form data into a consistent format.
  Calculate Total Price**: Computes Total Price (Quantity Received * Unit Price).
  Append Raw Materials**: Records receipt in Google Sheets.
  Check Quantity Received Validity**: Ensures Quantity Received is valid.
  Lookup Existing Stock**: Retrieves current stock for the Product ID.
  Check If Product Exists**: Branches based on Product ID existence.
  Calculate Updated Current Stock**: Adds Quantity Received to stock (True branch).
  Update Current Stock**: Updates stock in Google Sheets (True branch).
  Retrieve Updated Stock for Check**: Retrieves updated stock for low stock check.
  Detect Low Stock Level**: Flags if stock is below minimum.
  Trigger Low Stock Alert**: Triggers email if stock is low.
  Send Low Stock Email Alert**: Sends low stock alert via Gmail.
  Add New Product to Stock**: Adds new product to stock (False branch).
  Current Stock Update**: Updates Supabase Current Stock table.
  New Row Current Stock**: Inserts new product into Supabase.
  Search Current Stock**: Retrieves Supabase stock records.
  New Record Raw**: Inserts raw material record into Supabase.
  Format Response**: Removes duplicates from Supabase response.
  Combine Stock Update Branches**: Merges branches for existing/new products.

  Material Issue Request and Approval
  Receive Material Issue Webhook**: Receives issue request from a form submission.
  Standardize Data**: Normalizes request data and adds Approval Link.
  Validate Issue Request Data**: Ensures Quantity Requested is valid.
  Verify Requested Quantity**: Validates Product ID and Submission ID.
  Append Material Request**: Records request in Google Sheets.
  Check Available Stock for Issue**: Retrieves current stock for the request.
  Prepare Approval**: Checks stock sufficiency for the request.
  Send Approval Request**: Emails approver with Approve/Reject options.
  Receive Approval Response**: Captures approver’s decision via webhook.
  Format Approval Response**: Processes approval data with Approval Date.
  Verify Approval Data**: Validates the approval response.
  Retrieve Issue Request Details**: Retrieves original request from Google Sheets.
  Process Approval Decision**: Branches based on approval action.
  Get Stock for Issue Update**: Retrieves stock before update (Approved).
  Deduct Issued Stock**: Reduces stock by Approved Quantity (Approved).
  Update Stock After Issue**: Updates stock in Google Sheets (Approved).
  Retrieve Stock After Issue**: Retrieves updated stock for low stock check.
  Detect Low Stock After Issue**: Flags low stock after issuance.
  Trigger Low Stock Alert After Issue**: Triggers email if stock is low.
  Send Low Stock Email After Issue**: Sends low stock alert via Gmail.
  Update Issue Request Status**: Updates request status (Approved/Rejected).
  Combine Stock Lookup Results**: Merges stock lookup branches.
  Create Record Issue**: Inserts issue request into Supabase.
  Search Stock by Product ID**: Retrieves Supabase stock records.
  Issues Table Update**: Updates Supabase Materials Issued table.
  Update Current Stock**: Updates Supabase stock after issuance.
  Combine Issue Lookup Branches**: Merges issue lookup branches.
  Search Issue by Submission ID**: Retrieves Supabase issue records.

  Customization Tips
  Expand Storage Options **: Add nodes to store data in other databases (e.g., Airtable) alongside Google Sheets and Supabase.
  Modify Approval Email **: Update the Send Approval Request node to customize the HTML email template (e.g., adjust styling or add branding).
  Alternative Notifications **: Add nodes to send low stock alerts via other platforms (e.g., Slack or Telegram).
  Adjust Low Stock Threshold **: Modify the Detect Low Stock Level node to change the Minimum Stock Level (default: 50).!

nodes_used:
  ["n8n-nodes-base.googleSheets","n8n-nodes-base.webhook","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.webhook","n8n-nodes-base.gmail","n8n-nodes-base.code","n8n-nodes-base.supabase","n8n-nodes-base.supabase","n8n-nodes-base.supabase","n8n-nodes-base.supabase","n8n-nodes-base.merge","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.merge","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.supabase","n8n-nodes-base.supabase","n8n-nodes-base.supabase","n8n-nodes-base.itemLists","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.webhook","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.supabase","n8n-nodes-base.if","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.supabase","n8n-nodes-base.if"]

workflow_json_compressed:
  [encoded data, 18732 characters]


name: Audit & Generate JSON-LD Schema Markup for SEO with GPT-4.1-mini + Gmail
author_name: Ari Nakos
author_username: just-aristides
categories: []
created_at: 2025-05-11T13:47:31.383Z
updated_at: 2025-05-11T13:47:31.383Z
url: https://n8n.io/workflows/3980
scraped_at: 2025-12-24 13:02:45
description:
  Schema Markup Generator
  Automatically audit and optimize your site’s JSON-LD structured data and email a step-by-step implementation guide.

  What It Does

  Collects a website URL & email via form
  Extracts existing JSON-LD, identifies gaps
  Generates optimized schema markup (GPT-4.1-mini)
  Builds an HTML before/after guide with action items
  Emails the full implementation instructions

  Prerequisites

  n8n instance (self-hosted, Desktop, or Cloud)
  Gmail OAuth2 credentials
  OpenRouter API key (for GPT-4.1-mini)

  Quick Setup

  Gmail: Add OAuth2 credential → select in “Send Email” node
  OpenRouter: Store API key → link in “Schema Markup Agent” node
  Form: Configure fields websiteUrl & emailAddress in your Webhook/Form node

  Customization

  AI Prompt**: Tweak system message to focus on specific schema types or output style
  Email Template**: Modify HTML header/footer or add sections

  Troubleshooting & Limits

  Monitor OpenRouter rate limits and Gmail send quotas
  Ensure target sites allow scraping for schema extraction

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenRouter","@n8n/n8n-nodes-langchain.toolCode","n8n-nodes-base.formTrigger","n8n-nodes-base.httpRequestTool","@n8n/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatOpenRouter"]

workflow_json_compressed:
  H4sIAAAAAAAAE61W224aSRD9FTTPLm/fL37ayNJq85BNlFj7ElmrvlRjZJhhmRklVsS/bw2QAAbbYC8SQsxUnzp16nR1/6hm2IXq6kc1qdsu1Anf5+qq0tGHUhimjJFb63liKnqJIVmB0qPxXPNUgpGWOe8Y6uylCRG9ZC66VF1UHc7m09Dh9QJz+wW7fn7d0BPskBJ0ix6XF1XdZGyrq6+UfcgarXBGJgUyYAJldIagWQKkv94haswDch1mSNFfukm6fxj91XQ4pHuYDw9rV8MKFWJo8bJdxWxC5k076SZNTQmBaLILZdgtPQ4LAuxw0Q4ypKbusO4IqlquUf+mN6tVfHmxIeqYLlZkBp4zA6RMAq+KBaFE4FqSOpwdJSrPZyqkeAPTKLgqwQXIyUpQ2iP4IjIwW6ILGJTF40z5KzQ17A1MpRGGexGhxJBJ06LBKRUguBhLYqlQKTtMsc6jrhk9NP1ihLMwmT7Jd7x5uycqp/Y7NVD9hvGuae5Xtnc6BZV0BIsmkFqKU3rDQfrMo0ShRSzVo+pWNu6wfV//MW2+ra39qEhxuS2TOcOCVQaQSwSVOUIQSYMOhrYVt5y+Rxsizm+IUtQQEK81uVFRSymIZCAxsooQrbKgndbaD+9C2WGa7qgNow9hcd/PR+/GA/wvwr8T49+2rKehHqe7MKkvwyZurzde/OzNY6H3mV76X1y5YcXrJMEEbYG2Itk8CAk5MyejkjSZ8pbrxznWn5uecE+gOJ1d34Vub8n+IDHsgqbAy3S3TqdPspyDyZamhzYGHJkLrGDcSmSYd8leE58TaHZNM92E7olpT6V3KbadV64UnTkghkHNrMBLUYBL770tAbU2O2rWo9IsZqO2j7NJu0J7yqlD3M1iMh4fykhePbIhVaYxFXMGiZKYqCTAG8wQtSk0FXSIBo9syEe7b6cyL5LI2UDRnqRP2kBM3IP1ISqhoo3RbSv78+bm0+gz/ttj2z1Z013XzTcxN9SDY2Y+RX+1w1JbVqTmDkpB2nlFFvCeKzoRI8++xBwQtyzf9V0DZfJ9Uo9HH/tu3nejT2HRnmTuZhW/Dh9w1jAHHhpqEOwMiydFBuKCg6eRCcMfcLEIcEkXLoXwyeXdKbfoU9fTRWFTwJnMt+sfMx9OJC7Pc78tq5uPAR8ZcbeODvdsLRhJ50Hi0VI/js0S/vZhItypfJcUQVO8xjSsXQ311e6n3zD5ZxgGhEf3qnr18Pnp/HPBBd0BM36vrtjy9pYy7tBcww519DSyPxDoefj7K59OxF/MdILbX8y3t6//T8UOjbxG3zXrK6rZW34g3uH4paR056lPr2cVfVDMkRVHkZ+5ih0FfrroF9R6qSfP6LRc/gexKwCZ6gwAAA==


name: Auto-Update Notion CRM and Send Email from Google Form Submissions
author_name: Harsh Sharma
author_username: hksharma2004
categories: []
created_at: 2025-05-11T17:46:53.147Z
updated_at: 2025-05-11T17:46:53.147Z
url: https://n8n.io/workflows/3985
scraped_at: 2025-12-24 13:02:45
description:
  Who is this for?

  This is for marketers, educators, HR teams, startups, and freelancers who use Google Forms to collect information and want to automatically send it to Notion while emailing the respondent.

  What problem does it solve?

  Manual data entry from Google Forms into CRMs is time-consuming. This template eliminates that, ensuring leads are captured in your Notion database in real time and respondents are notified instantly — improving speed and accuracy.

  What this workflow does?

  Node 1 – Google Sheets Trigger**:
    Listens for new rows in the spreadsheet connected to your Google Form.
  Node 2 – Notion**:
    Creates a new entry in your CRM-style Notion database.
  Node 3 – Gmail**:
    Sends a confirmation email to the person who filled the form.

  🛠 Setup Guide

  1. Prepare Google Form and Sheets

  Create your Google Form.
  Connect it to a Google Sheet (Responses tab &gt; "Link to Sheets").

  2. n8n - Google Sheets Trigger Setup

  Add Google Sheets Trigger node.
  Authentication: Use OAuth2 (preferred).
  Select your spreadsheet and worksheet.
  Trigger type: On new row (not "updated").

  3. n8n - Notion Node

  Add Notion node (action: "Create Page").
  Connect your Notion integration:

    In Notion, create a new integration and copy the token.
    Share your CRM database with that integration.
  In the node, map form responses to your database properties:

    e.g., Name → Title, Email → Email, etc.
    Use {{$json["Full Name"]}} for mapped fields.
  Common error: Check Notion property types (email must be set to type: email).

  4. n8n - Gmail Node (Optional Auto Reply)

  Add Gmail node (action: "Send Email").
  Auth: OAuth2 with your Gmail account.
  To: {{$json["Email Address"]}}
  Subject: "Thanks for contacting us!"
  Body:

      Hi {{$json["Full Name"]}},
    Thanks for reaching out via the form. We’ve received your info and will follow up soon!
  🧩 How to Customize

  Replace Gmail with Outlook or SendGrid if needed.
  Map more fields into Notion like phone, tags, etc.
  Add Slack or Discord notifications for internal alerts.

  🧾 SEO Optimized Title Suggestions

  Auto-sync Google Forms with Notion CRM and send a confirmation email
  Add Google Form leads to Notion and auto-send thank-you email via Gmail

  📎 Required Permissions / Dependencies

  Google Sheets and Gmail authenticated in n8n
  Notion integration shared with your CRM database
  Enable “Impersonate User” if using Google Service Account

nodes_used:
  ["n8n-nodes-base.googleSheetsTrigger","n8n-nodes-base.notion","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE42Ty27bMBBFf8Xg2gw4fIn2sgFapEVboCmyaOEFHyNHiC0ZEuMmMPzvHUpuY+SBdkeJl5dnZi4PrElsyd59ulEfH69ueokR1Y89m7MtZs+WB9a0Q/ZtxKuiq4ypQVZukZQzUgSnjHZKLmp0oVLCAygJydUmSVFFJVPwwSTUC10Hb0RNvhm3u43PeNljGq4x3+8uO/qDGemC3N/jcc5av0W67UPXrTc4e9/122GWu9mXLjdde/ntc7Hx64Etf65I3CUsy8NUiqt0CMFUXENluTYguF8o5MZ6lGglgUf2/IrrW8Q8zL73zXqNfbF/3JXt1rV89OfBD3ixHtWT+Em764amgBGDmAsi2vme3DP2hHU4TmY39DVq4Dg/kQpfGeeBSD3UXOsKeIhywWvUIorosLbmiXQq/k209s/2GY2U/8EjL+RfIg21dSIAFxiB61oA9yIZDsZF7VV0ztZnvdv6ZvN2r067ZzxaTzy/MNx23d2YqKAhITi6UkgaV4w0Lh0MFyYoBTE4tMD+WcJTU70MNYI23EKlafzWcueEpwxIo6wKyrqzEq5zE+8eS7DwzUKGUXOSnFXDgdrLpXvRYRa7NmObyYq9nD6pfczNHqe0z9mAOTftejyJDxjvi//XPlG2lmwPxWI/HR8bpgOgrzRylyylRgbPHTjkgBQe40BqVQokhhZjsRqNT+mhFY2l0NNzKTW+HOO4P6dnn/CBLcVxtSKA15/Ja27PY/qK3fH4Gx14DNd2BAAA


name: Personalized AI Tech Newsletter Using RSS, OpenAI and Gmail
author_name: Miha
author_username: miha
categories: []
created_at: 2025-05-11T19:47:23.634Z
updated_at: 2025-05-11T19:47:23.634Z
url: https://n8n.io/workflows/3986
scraped_at: 2025-12-24 13:02:41
description:
  Combine Tech News in a Personalized Weekly Newsletter

  This n8n template automates the collection, storage, and summarization of technology news from top sites, turning it into a concise, personalized weekly newsletter.

  If you like staying informed but want to reduce daily distractions, this workflow is perfect for you. It leverages RSS feeds, vector databases, and LLMs to read and curate tech content on your behalf—so you only receive what truly matters.

  How it works

  A daily scheduled trigger fetches articles from multiple popular tech RSS feeds like Wired, TechCrunch, and The Verge.
  Fetched articles are:

    Normalized to extract titles, summaries, and publish dates.
    Converted to vector embeddings via OpenAI and stored in memory for fast semantic querying.
  A weekly scheduled trigger activates the AI summarization flow:

    The AI is provided with your interests (e.g., AI, games, gadgets) and the desired number of items (e.g., 15).
    It queries the vector store to retrieve relevant articles and summarizes the most newsworthy stories.
    The summary is converted into a clean, email-friendly format and sent to your inbox.

  How to use

  Connect your OpenAI and Gmail accounts to n8n.
  Customize the list of RSS feeds in the “Set Tech News RSS Feeds” node.
  Update your interests and number of desired news items in the “Your Topics of Interest” node.
  Activate the workflow and let the automation run on schedule.

  Requirements

  OpenAI** credentials for embeddings and summarization
  Gmail** (or another email service) for sending the newsletter

  Customizing this workflow

  Want to use different sources? Swap in your own RSS feeds, or use an API-based news aggregator.
  Replace the in-memory vector store with Pinecone, Weaviate, or another persistent vector DB for longer-term storage.
  Adjust the agent's summarization style to suit internal updates, industry-specific briefings, or even entertainment recaps.
  Prefer chat over email? Replace the email node with a Telegram bot to receive your personalized tech newsletter directly in a Telegram chat.

nodes_used:
  ["n8n-nodes-base.splitOut","@n8n/n8n-nodes-langchain.embeddingsOpenAi","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.gmail","n8n-nodes-base.markdown","n8n-nodes-base.stickyNote","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.vectorStoreInMemory","n8n-nodes-base.set","n8n-nodes-base.rssFeedRead","@n8n/n8n-nodes-langchain.vectorStoreInMemory","@n8n/n8n-nodes-langchain.embeddingsOpenAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.set"]

workflow_json_compressed:
  [encoded data, 5788 characters]


name: Send Telegram Text and Audio Messages to Notion with DeepSeek Summaries & OpenAI Transcription
author_name: Wild Nomad
author_username: rahimin3d
categories: []
created_at: 2025-05-11T19:49:53.476Z
updated_at: 2025-05-11T19:49:53.476Z
url: https://n8n.io/workflows/3987
scraped_at: 2025-12-24 13:02:44
description:
  Streamline Your Communication and Task Management with the Telegram to Notion Automation

  This powerful automation effortlessly connects your Telegram messages with your Notion workspace, transforming how you capture information and manage tasks.

  What it does:

  Automatic Capture: Instantly captures messages, voice notes, and audio files sent to your designated Telegram chat.

  Intelligent Processing:

  Text messages are automatically summarized into clear, plain-text descriptions using advanced AI (DeepSeek).

  Voice notes and audio files are transcribed into text using OpenAI's powerful transcription service.

  Organized in Notion:

  Text message summaries are added as new entries to your "Tasks Tracker" database in Notion, with the original message as the title and the summary as the description. The current date is also included.

  Transcriptions of voice notes and audio files are saved to your "Transcribes" database in Notion, making them easily searchable and reviewable.

  Saves You Time: Eliminates the manual effort of copying and pasting information, transcribing audio, and creating new entries in Notion.
  Boosts Productivity: Keeps all your important communications and tasks organized in one central location.

  This automation is perfect for anyone who uses Telegram for work or personal notes and wants to seamlessly integrate that information into their Notion workflow for better organization and productivity.

nodes_used:
  ["n8n-nodes-base.telegramTrigger","@n8n/n8n-nodes-langchain.lmChatDeepSeek","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.notion","n8n-nodes-base.switch","n8n-nodes-base.telegram","n8n-nodes-base.notion","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.telegram","n8n-nodes-base.notion","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE6VX227bRhD9FYHPWnfvFz3VcF5SoE1bu0GRwCj2MisTkUmBohMHhv49s7JjyRIlSy4gCBI5PHtmZs/Z4UNVp2pStR//etfJ+NvFP7rpGFxV4+oWel9NHqq6WfS+ifC+xIF1TmiRpDTMuOhBKSF0xq/AtQzZaOGUM+AEC1lYI0KWllOw2QfrrUfcHm7nM9/DRQdpcQn93fyixSvQAy7Qd3ewHFeNvwVc7QpmMO387egK7vvx6GNbRxj90fYwarvR+V2q21GuZzDq23K1bpvRO9/74BdQ1vHTRTX5/PCY4MXN9Opvc/9vrW/iJ00X1fMif0K3aBs/Wz076mDedn25HTtAlum8xxhOuSIUP+6Kswm3E6HOmLWfMOxunl4PW17jcm2CDUJeKkstCyQr54mkyhCbpSQAmvFAbVY+VgOV6OrpFLqS3/d5udPYhqygScn7rH8KXMfN20VdaoNLC0nHRFMk8w3CTdt+WfUUO+qAMUosN4lIxzKxAf8aFizjilKnecHxCItd6jCJh+Xj+h/x3wqaLcdPeWUaguRMkOCyJZJFSazhjMQAzroQRWCwzusdwPwS4Mvo4sb3o98xj9k6tV8xt1/W+c18M403vm7OZrcl/OezL3NkVNMxsyXJIxlryCxrk4lmORBpsiCeaU44cGEFxZ3NxZrx+fvR+RSa/gia/inuBbvnFhxmd+ae+RlnbcqGYx3BEJmkIT6mRHhO2cvgQwa25vcoBLZ3gzSr+y9ZcXYcK37G131OgomkPfEJSyfB46+yk7NQOmudfGZ0zeryW93Hm/2sFqv7L1lpehQpsUGKZ+y8irjbWOREysRJoEkTCjRZNC2pHN8V1atiGuqhkts68kYma1E93jHc+RFpeC+BuJgAQnI5gnpVRxvJAOfKZGeIotEUhwASwAt0F2mNQZdlMmz3/Q1tf0zklb6v1QJKh6ywukEXt5BBIytmSNLRYMGzYXGD1Yc5NOfvj9BKWwLrrUKrI/ltuI9g2IbgiHAM2SmNPSgUs5AGVETLNRvsLvs6fvm+OlEObM1VUInZYictsjO77KrYNn1R/qSq9jN1KksdOCU0Yk+ld5FYFhUBEbxLIYBWcZApP5kpL5b4dqbRJiMhRUIzoD8CkwQtkRGwqVwJPg+dVPsLekBVu6KyhjEWXCJaBFw8MEU8eCjmZ4LTLngaTxEVB+My5YGAk6XsCs1egCTc8oDTimBGm21R7a/4XlWdKCorMzgQkuSMliWZl8RnxYnHAcFlT61KaltU/K2qMvwofmt2iWouAtoP4xxHFcEicQoPIE+di07jhCOHt+rpmlLITex6/nEbFR0JlFeMBEMjkTrjSKUoENy+3mpl8Zw3gzzF6ZJi9H8QpYa6ZKUjkCTFEz2jS9HkiQrRly2J7i4GicqTiZoi/ZOJYrSPff0VHifycbWAvq+b6epJuId4V+A/dAknzEn1lRWIr4+Pr1SrvAlRGtQq+lgZDvDoQlMj2dDgvBbZqTIcIIcGYoFaAT8dYfjrFjcvkv98fY3AT2fIxuWH1TA9cOitAsb4ypLgvprQ5cbz/AAAfwXh5/QyhLA7ROxAjNfRu9PjoegBLx3k94y6P8XXIJ7TGILYPsUPIgyXacezDmI8v+YMQe3MkoNQQ28WiObr/4o93uFs/nTt86Hu7IS/XGa5/AHCSS6iQA8AAA==


name: Access Control for AI Agents (RBAC) using Airtable and Telegram
author_name: Mario
author_username: octionic
categories: []
created_at: 2025-05-11T20:09:38.591Z
updated_at: 2025-05-11T20:09:38.591Z
url: https://n8n.io/workflows/3988
scraped_at: 2025-12-24 13:02:44
description:
  Purpose

  This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control.

  Demo & Explanation

  How it works

  User permissions are managed in Airtable where every restricted AI tool is listed by name and connected via roles to users
  Requests to the Main Agent can be sent through a Telegram message (can be replaced by Whatsapp, IMAP or similar)
  On every request the Telegram username is used to query a list of all allowed tools which are linked in Airtable
  A LangChain Code node is used to compare that list against the connected tools
  Every tool which is not permitted to be used is being replaced by a tool, which has a status response, telling the Agent to return a message to the user, that he is not authorized to use the tool
  Otherwise allowed tools are passed through to the Agent, as if they were connected directly to the Agent
  The parameters can also be passed to a sub-agent called as a sub-workflow where permissions can be checked the same way
  Every response is sent back to the same Telegram conversation

  Setup

  Clone the workflow and select the belonging credentials. You'll need an OpenAI and Airtable Account as well as a Telegram Bot (refer to the docs for the Telegram credentials).
  Copy this Airtable Template into your workspace
  Follow the instructions given in the yellow sticky notes
  Activate the workflow

  How to use

  Try this example:

  Create a new line in Airtable under “Users” containing your Telegram username and your full name
  Set the roles “basic” and “info”
  Consider temporarily disconnecting or resetting the chat memories so they do not remember previous confirmations
  Start a new chat, asking about your permitted roles - you should get a list of those
  Ask about the current weather in your city - you should be informed, that you do not have permission to access that information
  Back in Airtable add the role “weather” to your user
  Now ask the Agent the same question again - It should give you a proper answer this time

  From here on you can add tools and create roles to your likings.

  Disclaimer

  Please note, that this workflow can only run on self-hosted n8n instances, since it requires the LangChain Code Node.

nodes_used:
  ["@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.code","n8n-nodes-base.telegramTrigger","n8n-nodes-base.set","n8n-nodes-base.airtable","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.code","@n8n/n8n-nodes-langchain.toolCode","@n8n/n8n-nodes-langchain.toolCode","@n8n/n8n-nodes-langchain.toolCalculator","@n8n/n8n-nodes-langchain.toolWikipedia","@n8n/n8n-nodes-langchain.toolHttpRequest","@n8n/n8n-nodes-langchain.toolHttpRequest","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.telegram","n8n-nodes-base.telegram","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 6824 characters]


name: Backup N8N Workflows to Github
author_name: Dat Proto
author_username: datproto
categories: []
created_at: 2025-05-12T05:05:39.188Z
updated_at: 2025-05-12T05:05:39.188Z
url: https://n8n.io/workflows/3990
scraped_at: 2025-12-24 13:02:44
description:
  Introduction
  This workflow will backup all of your existed workflows to a single Github repository.

  The Backup folders' name are based on the current backup date and have default format: "yyyy/MM/dd" (setup at "Create sub path" node).

  Throughout the backup process, the N8N will inform user via discord with clear message about Start, Success and Failure backups.

  The workflow will be 

  Tech Stack
  The following nodes / services / libraries are used in this workflow:

  Nodes:
  Discord: To send message to configured setup channel.
  N8N: To get all workflows' information.
  Github: To store backup data.
  Code: To run data comparison (Existed vs Latest workflow data).
  Wait: To avoid discord message rate limit.

  External libraries:
  Underscore.js: JavaScript library that provides lots of common Javascript functions, to help user save time when using code node.

  Guideline
  Open "Config" node and setup the following information:
      repo_owner: Your Github username.
      repo_name: The repository that you want to store workflows backup data.
  Open "Create sub path" node and change the naming and path format of backup folder(s).
  Setup custom messages in 3 discord nodes:
      Starting Message: N8N inform user at the time workflow start.
      Inform Success Flows: After each success backup, N8N will notify user.
      Inform Failed Flows: After each failure backup, N8N will notify user to have appropriate action.
      Completed Notifications: Then at the final, the workflow will give user a summary.
  Setup "Schedule Trigger" node to change default automated backup time.

  Screenshots

  Discord output

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.executeWorkflowTrigger","n8n-nodes-base.n8n","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.merge","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.noOp","n8n-nodes-base.github","n8n-nodes-base.github","n8n-nodes-base.splitInBatches","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.discord","n8n-nodes-base.discord","n8n-nodes-base.github","n8n-nodes-base.executeWorkflow","n8n-nodes-base.wait","n8n-nodes-base.github","n8n-nodes-base.wait","n8n-nodes-base.code","n8n-nodes-base.switch","n8n-nodes-base.wait","n8n-nodes-base.stickyNote","n8n-nodes-base.discord","n8n-nodes-base.discord"]

workflow_json_compressed:
  [encoded data, 6260 characters]


name: Readable Workflow Export & Deployment Pipeline for Multi-Environment CI/CD
author_name: Klaasjan te Voortwis
author_username: voortwis
categories: []
created_at: 2025-05-12T08:05:06.961Z
updated_at: 2025-05-12T08:05:06.961Z
url: https://n8n.io/workflows/3994
scraped_at: 2025-12-24 13:02:45
description:
  This n8n workflow template uses community nodes and is only compatible with the self-hosted version of n8n. 

  Export workflows with readable names, tagged for different environments

  To ensure understandable workflow exports, ease of use in delivery pipelines, and a better developer experience, this workflow helps with exporting workflows.

  Inner workings
  First, the workflow ensures that the directory structure for storing the workflows is correct.
  Exports all workflows.
  Next, it processes all workflow files and stores them with readable names.
  Based on tags, it will also export to dev and prod folders for easy commit and usage in a delivery pipeline.

  Configration
  No special setup is required for readable exporting.

  Usage
  Create a workflow and tag it with 'Auto deploy to dev'
  Run the workflow, this will create the needed folders and workflows with readable names.
  Commit these in your version control.
  Have a CICD pipeline build an n8n container
  —see the attached Dockerfile. 

  Check our Auto Starter workflow for auto-starting workflows after deployment.

  CI/CD Bonus:
  Attached are two nodes with some example configuration on building your own automated n8n deployment. 
  A Dockerfile, to get the new entrypoint and exported workflows packaged in the container.
  An updated entrypoint to build your own container, import the workflows, and run the Auto Starter.

  Set the following environment variables:

  STARTUP_WORKFLOWS_LOAD_LOCATION: to specify the folder to import from and distinguish between environments.
  STARTUP_WORKFLOW_ID: the ID of the workflow to run after starting n8n.  
    &gt; Note: The 'Instance Started' n8n trigger won't work, as all workflows are disabled upon import.

nodes_used:
  ["n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.manualTrigger","n8n-nodes-base.executeCommand","n8n-nodes-base.readWriteFile","n8n-nodes-base.extractFromFile","n8n-nodes-base.convertToFile","n8n-nodes-base.readWriteFile","n8n-nodes-base.convertToFile","n8n-nodes-base.convertToFile","n8n-nodes-base.readWriteFile","n8n-nodes-base.readWriteFile","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 4260 characters]


