# templates

name: 🤖 Build an Interactive AI Agent with Chat Interface and Multiple Tools
author_name: Lucas Peyrin
author_username: lucaspeyrin
categories: []
created_at: 2025-07-09T12:12:39.907Z
updated_at: 2025-07-09T12:12:39.907Z
url: https://n8n.io/workflows/5819
scraped_at: 2025-12-24 13:02:41
description:
  How it works

  This template is a complete, hands-on tutorial that lets you build and interact with your very first AI Agent.

  Think of an AI Agent as a standard AI chatbot with superpowers. The agent doesn't just talk; it can use tools to perform actions and find information in real-time. This workflow is designed to show you exactly how that works.

  The Chat Interface (Chat Trigger): This is your window to the agent. It's a fully styled, public-facing chat window where you can have a conversation.
  The Brain (AI Agent Node): This is the core of the operation. It takes your message, understands your intent, and intelligently decides which "superpower" (or tool) it needs to use to answer your request. The agent's personality and instructions are defined in its extensive system prompt.
  The Tools (Tool Nodes): These are the agent's superpowers. We've included a variety of useful and fun tools to showcase its capabilities:
      Get a random joke.
      Search Wikipedia for a summary of any topic.
      Calculate a future date.
      Generate a secure password.
      Calculate a monthly loan payment.
      Fetch the latest articles from the n8n blog.
  The Memory (Memory Node): This gives the agent a short-term memory, allowing it to remember the last few messages in your conversation for better context.


  When you send a message, the agent's brain analyzes it, picks the right tool for the job, executes it, and then formulates a helpful response based on the tool's output.

  Set up steps

  Setup time: ~3 minutes

  This template is nearly ready to go out of the box. You just need to provide the AI's "brain."

  Configure Credentials: This workflow requires an API key for an AI model. Make sure you have credentials set up in your n8n instance for either Google AI (Gemini) or OpenAI.
  Choose Your AI Brain (LLM):
      By default, the workflow uses the Google Gemini node. If you have Google AI credentials, you're all set!
      If you prefer to use OpenAI, simply disable the Gemini node and enable the OpenAI node. You only need one active LLM node. Make sure it is connected to the Agent parent node.
  Explore the Tools: Take a moment to look at the different tool nodes connected to the Your First AI Agent node. This is where the agent gets its abilities! You can add, remove, or modify these to create your own custom agent.
  Activate and Test!
      Activate the workflow.
      Open the public URL for the Example Chat Window node (you can copy it from the node's panel).
      Start chatting! Try asking it things like:
          "Tell me a joke."
          "What is n8n?"
          "Generate a 16-character password for me."
          "What are the latest posts on the n8n blog?"
          "What is the monthly payment for a $300,000 loan at 5% interest over 30 years?"

nodes_used:
  ["@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.httpRequestTool","n8n-nodes-base.dateTimeTool","@n8n/n8n-nodes-langchain.toolWikipedia","n8n-nodes-base.cryptoTool","@n8n/n8n-nodes-langchain.toolCode","n8n-nodes-base.rssFeedReadTool","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:
  [encoded data, 10932 characters]


name: Automatic Gmail Categorization and Labeling with AI
author_name: Matt Chong | n8n Creator
author_username: mattxchong
categories: []
created_at: 2025-07-09T12:31:25.807Z
updated_at: 2025-07-09T12:31:25.807Z
url: https://n8n.io/workflows/5820
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  Who is this for?

  If your inbox is full of unread emails, this workflow is for you.  
  Instead of reading through them one by one, let AI do the sorting.  
  It reads your emails and flags only what needs action.

  What does it solve?

  This workflow reads your unread Gmail emails and uses AI to decide what’s important — and what’s not.
  It labels emails that need your attention, identifies receipts, and trashes everything else.
  No more manual reading. Just an inbox that uses AI to take care of itself.

  How it works

  Every hour, the workflow runs automatically.
  It searches for unread emails in your Gmail inbox.
  For each email:
     It extracts the content and sends it to OpenAI.
  The AI returns one of four labels: Action, Receipt, Informational or Spam.
  Based on the label:
     Emails are marked with the appropriate label.
     Or moved to trash it is spam.
  It marks the email as read once processed.

  How to set up?

  Connect these services in your n8n credentials:
     Gmail (OAuth2)
     OpenAI (API key)
  Create the Gmail labels:
     In your Gmail account, create these labels exactly as written:  
       Action, Receipt, and Informational  
     The workflow will apply these labels based on AI classification.

  How to customize this workflow to your needs

  Change the AI prompt to detect more types of emails like Meeting or Newsletter.
  Add more branches to the Switch node to apply custom logic.
  Change the schedule to fit your workflow.
  By default, it runs every hour, but you can update this in the Schedule Trigger node.

nodes_used:
  ["n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.scheduleTrigger","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.gmail","n8n-nodes-base.switch","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.gmail"]

workflow_json_compressed:
  [encoded data, 4420 characters]


name: Build a Scalable AI Chatbot with GPT-4 and Pipedream: Calendly, Gmail Integration
author_name: Davide
author_username: n3witalia
categories: []
created_at: 2025-07-09T13:49:54.152Z
updated_at: 2025-07-09T13:49:54.152Z
url: https://n8n.io/workflows/5821
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  This n8n workflow integrates the powerful Pipedream MCP server with AI capabilities to create a smart, extensible assistant that can interact with over 2,700 APIs and 10,000+ tools — all within a secure and modular structure.



  This setup seamlessly integrates Pipedream's MCP server with n8n, enabling your AI assistant to leverage thousands of APIs and tools securely.

  Benefits

  Massive Tool Access**: Instantly connect 2,700+ APIs using Pipedream MCP tools — from productivity apps to custom APIs — with zero-code integration.
  Dynamic AI Agent**: The use of a LangChain agent allows for flexible tool execution and contextual conversations, powered by GPT.
  Easy Customization**: Simply copy your MCP tool URL into the respective sseEndpoint field to extend the agent’s capabilities.
  Scalable and Modular**: Add or remove tools (like Slack, Notion, Stripe, etc.) without altering the core logic.
  Secure and Revocable**: Credentials and API access can be managed directly via Pipedream’s MCP dashboard.

  How It Works  
  Chat Trigger: The workflow begins when a chat message is received via the When chat message received node, which acts as the entry point.  
  AI Agent Processing: The message is passed to the AI Agent node, which orchestrates the interaction using the connected tools and memory.  
  Language Model: The OpenAI Chat Model (GPT-4.1-mini) processes the user's input and generates responses or actions.  
  Memory: The Simple Memory node retains context from the conversation to enable coherent multi-turn interactions.  
  Tool Integration:  
     The Calendly and Gmail nodes (connected via Pipedream's MCP server) allow the AI to perform actions like scheduling events or sending emails. These tools use SSE (Server-Sent Events) endpoints provided by Pipedream.  
  Response: The AI Agent combines the model's output and tool responses to deliver a final reply to the user.  

  Set Up Steps  
  Sign Up for Pipedream:  
     Create an account on and set up your MCP server.  
  Configure MCP Tools:  
     Connect your accounts (e.g., Calendly, Gmail) in Pipedream and obtain the SSE endpoints for each tool (e.g., https://mcp.pipedream.net/xxx/calendly_v2).  
  Update n8n Nodes:  
     Replace the placeholder SSE endpoints in the Calendly and Gmail nodes with your Pipedream MCP URLs.  
  OpenAI Credentials:  
     Ensure the OpenAI Chat Model node has valid API credentials (configured under "OpenAi account").  
  Activate Workflow:  
     Enable the When chat message received node (currently disabled) and deploy the workflow.  

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

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

workflow_json_compressed:
  H4sIAAAAAAAAE6VWbW/bNhD+K5z6YStmOhJFvdCflnnBVmBui6ZdUbRBQJEnm4hEaRLtJAv833eUHTuJ0zRFP9iQqOPxnnueu+NNYHQwCerlSf+frv9dvvt0+kHPRDAKanAymNwExvZOWgWvvJ3kRalEDCJLlGRxLBVPQGdKMJbpnKsywVUm4ihMWCKiTGpZxnHEIAp1wlOGfh3UbSUdTDvQ/Sm4ZTttcAUc4AGuW8J6FFhZA5721rSgO5D1zz2ZTd+SHroVdN6HnPfB5PMZWjYa/OPNBofmIgctOE2TklOepCGVUZ7SQsaMJ2FaZnEZ7Px/XIAlaiEdqaHv5RxIBwrMCiPBM65bb/Obze0R/uhwEq2kneMOY8d+3/vOzOdDRG3TG2cai6FE6YimHGO7hGLRNBdD4jKhJfCEU4U5ojxiguaRyGiZiQKTprXIcu9Gdhiag673qW9a79I/rtebgP7BL8Mp0Thaj7ag8zRFeJmijElGuYwlzYWIaZZIEJDHqcqiPejjV+R4DtY9A6Lc2t0Bx3i4Rfe1UIP+ukeOZ5uMovtPzZLIDogkC6jaclkR2ffGi8oFB7jYHVw8yYo0yhBSEgmKyhNUyhxp5booI15AWaR7XG9asIht6umcIZDqGQCr2psPO80DEiM2ivghznrwjA/n51210etoWMRjKgSFXlayWvrXeesoH0e0NtYEiPM+mwrlj9k1strmz8dw3Jqh5Dz691Cu4LX8Q85O3lXR4tMDpIZIpZqldeSXk2UHLw9TGY3ZLpVKpwnLQ04lFi7lUGpaePkJlkdhKXhRJHfqYiorsLq6fkYGa9VOK4NA3jdNdT+FPAwfTWHfw4nVbWOQ/0mwcK7tJ0dH6Gjc3tb72II7urq6OlLbSM5XLDjAt0OHMhdpmTMaQYzyyFNJpX9lpVYlxEzFWuzRnRrfbsgM6qZ7FsTB8PdlWUL30VjdXD4oiSR9DOchHfFe2Rz7k+JA07wIfZvSNGe5pEVZMpGGcS5jvg/4z1qa56j5CS6Sr8j5e7iYD2F8nYWYgYhEmdMUshjbkIypiHhORVwKFoo4LOPiDgvOqItr8rpxsIe2R1XIHsb9YLM1uYOGxgkb0SzND/BcGu0WwSRlfBQswMwXCCtFfgLVWAcDyBcvyONz5Yv9Yo+1JmyUheGv5Pjtq55Iq0kUjkK/4DCrPf6T62bZEWw1uzZGyqYjZQcwJtPGWlBuY7Ot0B4PUFij1fXgr4NVcwH+I7ZIgt1K2mviTA1jH8FPn02NffPsl1sybHzZu6bDtXFBlbYDH7honKyMPNrxdB6NWzt/+cU+QVEmZMKjLKK8THOcQrmiudSMFnEIDDSLS0gepSj6bo5Ynv8ARS/IX82lz/Vl0134tFByauaWLFvSWPJ5R+A+Tfc1q5r66KXfNZPWz/WBjj3VAw9qQxXoHU9+w7RpNzS1EsfYfuPpZuOHd3+Tp8vkRrbteV8t52uCVdUQt4CNg9MTcltrxCcQPxNM5sD6yZX0TWniI3h2Rxxkd9urv3/n0Fb84T8iOjaI7hHJIe9SObxLBZMSZxxOyR6cM3Y+iACusCK8Ut50Gu9Pk2AVeR+rzf7hxqSzBGWJ4gSlS2wnKqO55gXNmEpEGqlMZioYVONZvL18bHolPkhz7gsWlYh3Q7sZ0IdXn1urEV5zNVwFk3B9doaB7CbgD3u6P2027urty7cc1rcj6r7Lw5vOxq2fBEukbLv2Le/3zR8e8sTd2F+DcN5844TB5L7X9fp/+jPXs28MAAA=


name: Generate Cold Emails & Sales Letters with OpenAI GPT & Google Docs via Chat
author_name: Yar Malik (Asfandyar)
author_username: yar
categories: []
created_at: 2025-07-09T19:57:09.683Z
updated_at: 2025-07-09T19:57:09.683Z
url: https://n8n.io/workflows/5828
scraped_at: 2025-12-24 13:02:41
description:
  How it works
  Trigger: Listens for an incoming chat message
  Copy Assistant: Feeds the message (plus memory) into an OpenAI Chat Model and exposes two “tools”

  Cold Email Writer Tool


  Sales Letter Tool• 

  Tool execution: Depending on the user’s intent, the appropriate tool generates the copy
  • Save output: Writes the generated email or sales letter into your target document via the Update a document node

  Set up steps
  • Configure your OpenAI Chat Model credentials in n8n (no hard-coded keys!)
  • Add and authenticate the Simple Memory credential (to keep context across messages)
  • Create Google Docs (or MS Word) credentials for the Update a document node
  • Ensure your Chat trigger is pointing at your incoming-message endpoint
  • Mandatory: Drop sticky-note annotations on each tool node explaining where to enter API keys and how to tweak prompts

  Once everything’s wired up, send a test chat message like “Write me a cold email for a fintech startup” and watch the workflow spin up a polished draft in your document.

  How to use

  Import the workflow JSON into n8n.

  Configure your Chat trigger (webhook or form) to receive incoming messages.

  Send a chat prompt like:

  “Write me a cold email for a B2B SaaS offering.”

  The “Copy Assistant” custom GPT picks the right tool (Cold Email or Sales Letter).

  Generated copy is written directly into your linked Google Doc or Word document.

  Requirements
  OpenAI API Key (with Chat Completions & Custom GPTs enabled)

  Custom Assistant created in your ChatGPT dashboard (Assistant ID pasted into the Chat Model node)

  n8n instance (Cloud or self-hosted) with credentials set up for:

  Simple Memory (to persist context)

  Google Docs or Microsoft Word (for document output)

  Customising this workflow
  Tweak system and user prompts inside the Copy Assistant node to fit your brand voice.

  Swap in Slack, Teams or email nodes instead of a document writer to deliver copy where you need it.

  Add or remove tools (e.g., “Follow-up Email Writer”) by duplicating the existing tool pattern.

  Use sticky-note annotations on every node to explain where to enter API keys, Assistant IDs, or prompt tweaks.

nodes_used:
  ["@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.googleDocs","@n8n/n8n-nodes-langchain.toolWorkflow","@n8n/n8n-nodes-langchain.toolWorkflow"]

workflow_json_compressed:
  H4sIAAAAAAAAE9VY23Lbxhl+lR260yYzhIQjTzOZVlZ8UGLLiilZcSNPZrFYkGuBAIJdiGY8mtFV73u46Uz7DH0nPUm/fwGSoki7SpubXkjEYfc/fd9/WHzsqKQz6oxPD55OTqevx9/rMj3rPe90OzNpeGf0saNybXgu5BGt68dB5EZDnqZuLxoE/dgT/cQPvdCPg37YD6MojN1BHAR9Nw3cYS/2ZdQPwqg3dBOvP5CQa+SszLiRh5VM9Fiaujws8EQaCQWmquV1t5PzmYS2U8lnrEjZwRE7LMrFvFJGVppk8InujH54h5VFIunyY+OHDAT3YYjjpnHghAMZOQMvihx/wHthkg5dNwg7K/nnU5kzMeWGzaTWfCJZJYVUV7AEOhYlrflDPsj38edYTU7G8wl2qHyP9p1WajKRFVaXhVZGFTlMcbyB23V8F9bNZTwtiksbuiDsS+EJ3+nFwnVC7gonTqTn9EXPTwJYJqOIBPEKxlk/EfyiJKF0eX3dmPQGb6web8+77i7d9mIv7keBE4gocULPC52BK3qkQER+GEf9mK/dpliyA60VAWse4CoiY9fdcdLzlz5+yuCOXmhg/bKJLMQ/enUlqysl5xf526JmvJKMs01b2AFpAgq6hBAVZ5KlRcVmPOcTlU8YzxNWFbWh61rLCit/qqU2mpmCmSkElmVVlJUCv5gupVA8Uz/LhImWPlYI6dAs5hovipypvKzNHlvaRGJEkZuqyPBbVInKuYERZAh2yoqbpSmJzECWim6najK9vfnzTzUUmgUjhmPDDI8qyZMFXKgupd1Ipuxd5Bf5o0fwPjfyg1kHBIpzKZAK5NCszoxCZnzSE1MUmR6RrDHPpGYvpAEOTRAv8sMiS9iTGVfZneyhxVZZpgt4jidcGDZXZgqP2KtS5ki2JiVAgsy6yZEes6JasAZRMq1CcVA5mQv/NSfMeWbDZt25yF+hYlhbmdLLsMmkyxZFDdQKOKUsaG0ImTJMZJJX2aJRKURNO3DbImvhpld1mRC6LUxttJ4VxQQyvy5E4wu9TRXZdNXkyzLiR6hmlagtSS9yWwD4BpXIrmUV6MI8RGimcpgLylC8QM8lC+nh0jxRVNhlGnIBkoOkpbYl9O2f/sLKOhfTBZuCDhkEahKuRaWahGG/ZYenB9qyLFEa/Fnsa8RDTPd1QeAznsDgN+MXbGw33ZGc1lkGomUyn8D1K5XIgmlLiMwSQjcxoUrUZcgPpNUMUjMbBfukSLuk3pq9JV5Pi8qwL7zo9uavPff25l9aii9bNTxhjQ+N5afq8pSUUJT5BHWhS2l1WsdyF0Wt9KzIJzCekoVJS1bIQd3c5YFGHi5ACsRvsrI7hvfS6E/w3eoAT4TSElsgiphqMwkIIjcFxBLy4KtmX+g6fg8YAY6iCoDfK57VknSVuEmLLCvmMLcu9Zcto04pCe8BPvoFaDfw7m+CvhvtkY0WnLLBhxk2RhZ6G9UlFP8t3KMW6y1s74P/y7Ee/XKgH4jwaAnvDkBvb/7WIspaFP4jrC2qTz5wGkpwe3vzj2MpqQo+5ULGiCpFhiJApSyXcxQaA9mams/e7c0/LeWa+oDisMELK+2czIa4AApRWmgdAd3EmpXKiCkVd5LOa1PMbHW1tX5b+n2GWAWBS9SQCEvSooQOUpiVzRP8Q8dG3NJUyp0mb8l8cQe9u4BZoY/9x6BxauZoYdvidvUmSIzISCNLmAFUG0YsgaNtWTHBUKCEbto/uLEt+pMtDgiOX50AvSNqcSXaVVu8R4z68aqj3N78HZNApSRotowRAm5L/KTgGagss3VdhynlsuITILigTskBGVUPjo4BRLqNN/gxYg9l4qTCgLsSUXKiCmWDFWOVY16oyQ5Se1UoBKCgZrdgeWGIg68lzU1EcIwqIPxUiksYkMtua7CxFbERIGicVjSyX+RfN+0ViS3pDTpsvtrSDhMYhKywVUywqxD1bGmsWXZSO1tdLXchnM0WPQXqdztwG/+ndtNx48C3EkAb4rVeV+PN6aHbAgKOCVwlqE7ZnC8QK33JVEqTA7INmjCKyNbVhMaQTFO0tFlA/aRWNFHkpHNs+IKlCG+etFMFmJbxuKAJ7oqqlCmakYuGFhD4bh1gZi75pbZDGUryDBTWna0Z3F9N4P2ED7grB07qB8IJQzd0YpcPHJEKGXhpKgaBWE/g7Zx1SOx5SXPWA4bwbEbL7U5178ARul1/xyxuJzi6+PHHKmvOVl37EGoy5Bak2DKI20lpnHDPc1CPVAdebp47BAAGHdCm2hmfbDgolT0ekvc/Hxx6l/Ps/PvX+umUu0f3PFU0zxU1Or7P3vLqdxohFZSTJImr7bh6e+vISt8LgmiIoErJnXAYe87QQ2T7CY6VwbCX9FxvrW+sqGyzl3ZgfUBUm8n2cY1KWJ2rPCnmm7HFUS4It0K7bW+wsncoPJ72vNThbgyjUzeBvWGA28jDOS0IRX+wtvesmWY5S9qcW9u8NpeOKnsTm2DIL71pYTjYfRLDXE8Qnqn1zVMls6Q5LRPloeOrjx/Zb95jJtpragu7vob0ZjVe4+wvK9O5fmcpYY8+9nkzg2Pl0uqz1y/weGpMqUf7+3iqW3v3UI32l6v2k31PHoUnyXsZHmj32ydv3z95FpTVy7PvDtUL6ZgzPc/nx2dvvnvmPxvP92WizO8Nj78ye25nm4friLw6qM3Uv8vI4Pjth7PpT9+Mz+NvD2NXryO+LlR6ScvPJXYYSH8gAtcRcR/H9kE4dHgKYIN+EAd+HPX6ae/u0XrVkM6b+ZPGwwfwkLrJeVFdptl9BvrI7qC3je+8XU0fFx6S4n80Y/HkbPg4Ojk+yY/ECV4JDEsyeS01DprHWw6sOyrF/s74Sst4Rs3PnuHQBud0jlqd0laH8h2dnYBYWU4Hb+tLayPllYZJM9583EG3LdEyXjb+JBJ9SD6WTYRs08VLGFzP8vZrEHU1tNrT4tC2FnOKqONVCsIgLk2/MU0WnBZjQyf39u02A+6UoCTy/V4quMP9qI8SlPpOHA1iJ5U9j+Ni6Ht3viptzDv/M/yh++vA//y7+n2gHr/xTrIj9/lbbzf827Paw7DfOEHbU83GUL9E//8J/HdNHbySKxFa2jnLGi0/yOYrwqsqQYKMOlceRar92nDUNIKhkGESOH7aD50wGvadod8fOgM3CEMv8N1hSCNB+xFj+dVss4FR6VY/ztqbH1C48yYen/qGt17dRfVO5IfOyL1+R/X73g6aD8C8DaGfaUZ27X2R22NMYy/xusa42z57mNmbm+6r2k6qRpWxlw/TYJpcvB+WnRX7V5L+mS/MuwD4lPgd0b++/jcv1ULFuxcAAA==


name: Qualify & Reach Out to B2B Leads with Groq AI, Apollo, Gmail & Sheets
author_name: VKAPS IT
author_username: solutions
categories: []
created_at: 2025-07-10T07:08:32.442Z
updated_at: 2025-07-10T07:08:32.442Z
url: https://n8n.io/workflows/5832
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  🎯 How it works
  This workflow captures new lead information from a web form, enriches it with Apollo.io data, qualifies the lead using AI, and—if the lead is strong—automatically sends a personalized outreach email via Gmail and logs the result in Google Sheets.

  🛠️ Key Features
  📩 Lead form capture with validation

  🔍 Enrichment via Apollo API

  🤖 Lead scoring using AI (LangChain + Groq)

  📧 Dynamic email generation & sending via Gmail

  📊 Logging leads with job title & org into Google Sheets

  ✅ Conditional email sending (score ≥ 6 only)


  🧪 Set up steps
  Estimated time: 15–20 minutes

  Add your Apollo API Key to the HTTP Header credential (never hardcode!)

  Connect your Gmail account for sending emails

  Connect your Google Sheets account and set up the correct spreadsheet & sheet name

  Enable LangChain/Groq credentials for lead scoring and AI-generated emails

  Update the form endpoint to your live webhook if needed

  📌 Sticky Notes
  Add the following mandatory sticky notes inside your workflow:

  FormTrigger Node:
  "Collects lead info via form. Ensure your form is connected to this endpoint."

  HTTP Request Node:
  "Enrich lead using Apollo.io API. Add your API key via header-based authentication."

  AI Agent (Lead Score):
  "Scores lead from 1-10 based on job title and industry match. Only leads with score ≥ 6 proceed."

  AI Agent (Email Composer):
  "Generates a concise, polite email using lead’s job title & company. Modify tone if needed."

  Google Sheets Append:
  "Logs enriched lead with job title, org, and LinkedIn URL. Customize sheet structure if needed."

  Gmail Node:
  "Sends personalized outreach email if lead passes score threshold. Uses AI-generated content."

  💸 Free or Paid?
  Free – No paid API services are required (Apollo has a free tier).

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.gmailTool","@n8n/n8n-nodes-langchain.lmChatGroq","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.lmChatGroq","n8n-nodes-base.webhook","n8n-nodes-base.googleSheetsTrigger"]

workflow_json_compressed:
  [encoded data, 4560 characters]


name: Automate Instagram Carousel Posts with Google Sheets, Drive & Cloudinary
author_name: Henry
author_username: henry
categories: []
created_at: 2025-07-10T08:29:17.367Z
updated_at: 2025-07-10T08:29:17.367Z
url: https://n8n.io/workflows/5833
scraped_at: 2025-12-24 13:02:41
description:
  Who is this for?

  This workflow is ideal for social media managers, content creators, marketers, and small businesses who want to automate Instagram Carousel posts using Google Sheets and Google Drive. It is also suitable for anyone looking to streamline repetitive Instagram publishing tasks with n8n, Cloudinary, and the Instagram Graph API.

  What problem is this workflow solving? / Use case

  Managing and publishing Instagram Carousel posts manually can be time-consuming, especially when handling multiple accounts or campaigns. This workflow solves that by automatically fetching scheduled posts from Google Sheets, uploading images from Google Drive to Cloudinary, and publishing them to Instagram, saving time and reducing the risk of errors.

  What this workflow does

  This n8n workflow checks a Google Sheet every 5 minutes for new Carousel posts marked as "ToDo." When found, it uploads images from a specified Google Drive folder to Cloudinary, prepares the media on Instagram using the Graph API, and publishes the Carousel post with the given caption.

  Setup

  Prepare a Google Sheet to track posts and image folder URLs.
   Example : https://docs.google.com/spreadsheets/d/1WEUHeQXFMYsWVAW3DykWwpANxxD3DxH-S6c0i06dW1g/edit?usp=sharing
  Upload post images to a dedicated Google Drive folder.
  Set up a Cloudinary account and gather API credentials.
  Obtain Instagram access_token and ig_business_id for API publishing.
  Configure the n8n workflow with required credentials and your custom intervals.

  How to customize this workflow to your needs

  Adjust the schedule trigger interval to fit your publishing frequency.
  Expand the Google Sheet with additional metadata as required.
  Modify the filter logic to support different content types or statuses.
  Add extra automation steps, such as sending notifications after publishing.

nodes_used:
  ["n8n-nodes-base.googleDrive","n8n-nodes-base.googleSheets","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.aggregate","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets"]

workflow_json_compressed:
  [encoded data, 4724 characters]


name: Create Low-Cost AI Videos with Veo3 Fast and Upload to YouTube & TikTok
author_name: Davide
author_username: n3witalia
categories: []
created_at: 2025-07-10T08:53:57.003Z
updated_at: 2025-07-10T08:53:57.003Z
url: https://n8n.io/workflows/5835
scraped_at: 2025-12-24 13:02:41
description:
  This workflow allows users to generate AI videos using the cheaper model Google Veo3 Fast, save them to Google Drive, generate optimized titles with GPT-4o, and automatically upload them to YouTube and TikTok with Upload-Post. The entire process is triggered from a Google Sheet that acts as the central interface for input and output.

  IT automates video creation, uploading, and tracking, ensuring seamless integration between Google Sheets, Google Drive, Google Veo3 Fast, TikTok and YouTube.

  Benefits of this Workflow

  💡 No Code Interface**: Trigger and control the video production pipeline from a simple Google Sheet.
  ⚙️ Full Automation**: Once set up, the entire video generation and publishing process runs hands-free.
  🧠 AI-Powered Creativity**:

    Generates engaging YouTube and TikTok titles using GPT-4o.
    Leverages advanced generative video AI from Google Veo3.
  📁 Cloud Storage & Backup**: Stores all generated videos on Google Drive for safekeeping.
  📈 YouTube Ready**: Automatically uploads to YouTube with correct metadata, saving time and boosting visibility.
  📈 TikTok Ready**: Automatically uploads to TikTok with correct metadata, saving time and boosting visibility.
  🧪 Scalable**: Designed to process multiple video prompts by looping through new entries in Google Sheets.
  🔒 API-First**: Utilizes secure API-based communication for all services.

  How It Works  
  Trigger: The workflow can be started manually ("When clicking ‘Test workflow’") or scheduled ("Schedule Trigger") to run at regular intervals (e.g., every 5 minutes).  
  Fetch Data: The "Get new video" node retrieves unfilled video requests from a Google Sheet (rows where the "VIDEO" column is empty).  
  Video Creation:  
     The "Set data" node formats the prompt and duration from the Google Sheet.  
     The "Create Video" node sends a request to the Fal.run API (Google Veo3 Fast) to generate a video based on the prompt.  
  Status Check:  
     The "Wait 60 sec." node pauses execution for 60 seconds.  
     The "Get status" node checks the video generation status. If the status is "COMPLETED," the workflow proceeds; otherwise, it waits again.  
  Video Processing:  
     The "Get Url Video" node fetches the video URL.  
     The "Generate title" node uses OpenAI (GPT-4.1) to create an SEO-optimized YouTube and TikTok title.  
     The "Get File Video" node downloads the video file.  
  Upload & Update:  
     The "Upload Video" node saves the video to Google Drive.  
     The "HTTP Request" node uploads the video to YouTube via the Upload-Post API.  
     The "HTTP Request" node uploads the video to TikTok via the Upload-Post API.  
     The "Update Youtube URL" and "Update result" nodes update the Google Sheet with the video URL and YouTube link.  

  Set Up Steps  
  Google Sheet Setup:  
     Create a Google Sheet with columns: PROMPT, DURATION, VIDEO, and YOUTUBE_URL.  
     Share the Sheet link in the "Get new video" node.  

  API Keys:  
     Obtain a Fal.run API key (for Veo3) and set it in the "Create Video" node (Header: Authorization: Key YOURAPIKEY).  
     Get an Upload-Post API key (for YouTube uploads) and configure the "HTTP Request" node (Header: Authorization: Apikey YOUR_API_KEY).  
     Get an Upload-Post API key (for TikTok uploads) and configure the "HTTP Request" node (Header: Authorization: Apikey YOUR_API_KEY).  

  YouTube Upload Configuration:  
     Replace YOUR_USERNAME in the "HTTP Request" node with your Upload-Post profile name.  

  Schedule Trigger:  
     Configure the "Schedule Trigger" node to run periodically (e.g., every 5 minutes).  

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

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.googleDrive","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest"]

workflow_json_compressed:
  [encoded data, 6056 characters]


name: Create AI-Summarized Email Digests from Gmail Labels with OpenAI O4-Mini
author_name: German Velibekov
author_username: germanv
categories: []
created_at: 2025-07-10T12:10:09.259Z
updated_at: 2025-07-10T12:10:09.259Z
url: https://n8n.io/workflows/5839
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  Transform email overload into actionable insights with this automated daily digest workflow that intelligently summarizes categorized emails using AI.

  Who's it for

  This workflow is perfect for busy professionals, content creators, and newsletter subscribers who need to stay informed without spending hours reading through multiple emails. Whether you're tracking industry news, monitoring competitor updates, or managing content subscriptions, this automation helps you extract key insights efficiently.

  How it works

  The workflow runs automatically each morning at 9 AM, fetching emails from a specific Gmail label received in the last 24 hours. Each email is processed through OpenAI's language model using LangChain to create concise, readable summaries that preserve important links and formatting. All summaries are then combined into a single, well-formatted digest email and sent to your inbox, replacing dozens of individual emails with one comprehensive overview.

  How to set up

  Create a Gmail label for emails you want summarized (e.g., "Tech News", "Industry Updates")
  Configure credentials for both Gmail OAuth2 and OpenAI API in their respective nodes
  Update the Gmail label ID in the "Get mails (last 24h)" node with your specific label
  Set your email address in the "Send Digested mail" node
  Adjust the schedule in the Schedule Trigger if you prefer a different time than 9 AM
  Test the workflow with a few labeled emails to ensure proper formatting

  Requirements

  Gmail account with OAuth2 authentication configured
  OpenAI API account and valid API key
  At least one Gmail label set up for email categorization
  Basic understanding of n8n workflow execution

  How to customize the workflow

  Change summarization style: Modify the prompt in the "Summarization Mails" node to adjust tone, length, or format of summaries. You can make summaries more technical, casual, or focus on specific aspects like action items.

  Adjust time range: Change the receivedAfter parameter in the Gmail node to fetch emails from different time periods (last 2 days, last week, etc.).

  Multiple labels: Duplicate the Gmail retrieval section to process multiple labels and combine them into categories within your digest.

  Add filtering: Insert additional conditions to filter emails by sender, subject keywords, or other criteria before summarization.

  Custom formatting: Modify the "Combine Subject and Body" code node to change the HTML structure, add styling, or include additional metadata like email timestamps or priority indicators.

nodes_used:
  ["n8n-nodes-base.if","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.documentDefaultDataLoader","@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter","n8n-nodes-base.noOp","n8n-nodes-base.set","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.chainSummarization","n8n-nodes-base.gmail","n8n-nodes-base.gmail","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5932 characters]


name: Automate LinkedIn Post Creation with Image using Google Gemini & DALL-E
author_name: Intuz
author_username: intuz
categories: []
created_at: 2025-07-10T12:25:46.184Z
updated_at: 2025-07-10T12:25:46.184Z
url: https://n8n.io/workflows/5840
scraped_at: 2025-12-24 13:02:41
description:
  This n8n template from Intuz delivers a complete AI-powered solution for automated LinkedIn posts, including unique content, custom images, and optimized hashtags.

  Use cases are many: Generate and schedule tailored LinkedIn content for different use-cases. By feeding the AI specific prompts, you can create specific post depending upon the topics and visuals to maintain a consistency yet and an online presence.

  How it works

  Maintaining a consistent and engaging presence on LinkedIn can be time-consuming, requiring constant ideation, content creation, and manual posting. This workflow takes that burden off your shoulders, delivering a fully automated solution for generating and publishing high-quality LinkedIn content.

  Scheduled Content Engine: Each day (or on your chosen schedule), the workflow kicks into gear, ensuring a fresh stream of content.

  Smart Topic & Content Generation: Using the power of Google Gemini, it intelligently crafts unique content topics and then expands them into full, engaging posts, ensuring your message is always fresh and relevant.

  Dynamic Image Creation: To make your posts stand out, the workflow leverages an AI image generator (like DALL-E) to produce a custom, eye-catching visual that perfectly complements your generated text.

  SEO-Optimized Hashtag Generation: Google Gemini then analyzes your newly created post and automatically generates a set of relevant, trending, and SEO-friendly hashtags, significantly boosting your content's reach and discoverability.

  Seamless LinkedIn Publishing: Finally, all these elements—your compelling text, unique image, and powerful hashtags—are merged and automatically published to your LinkedIn profile, establishing you as a thought leader with minimal effort.

  How to Use: Quick Start Guide
  This guide will get your AI LinkedIn Content Automation workflow up and running in n8n.

  Import Workflow Template:
  Download the template's JSON file and import it into your n8n instance via "File" &gt; "Import from JSON."

  Configure Credentials:
  Google Gemini: Set up and apply your API key credentials to all "Google Gemini Chat Model" nodes.
  AI Image Generation (e.g., OpenAI): Create and apply API key credentials for your chosen image generation service to the "Generate an Image" node.
  LinkedIn: Set up and apply OAuth credentials to the "Create a post" node for your LinkedIn account.

  Customize Schedule & AI Prompts:
  Schedule Trigger: Double-click "Schedule Trigger 1" to set how often your workflow runs (e.g., daily, weekly).

  AI Prompts: Review and edit the prompts within the "Content Topic Generator," "Content Creator," and "Hashtag Generator / SEO" nodes to guide the AI for your desired content style and topics.

  Test & Activate:
  Test Run: Click "Execute Workflow" to perform a test run and verify all steps are working as expected.

  Activate: Once satisfied, toggle the workflow "Active" switch to enable automated posting on your defined schedule.

  Requirements
  To use this workflow template, you will need:

  n8n Instance: A running n8n instance (cloud or self-hosted) to import and execute the workflow.

  Google Gemini Account: For content topic generation, content creation, and hashtag generation (requires Google Gemini API Key) from Google AI Studios.
   
  AI Image Generation Service Account: For creating images (e.g., OpenAI DALL-E API Key or similar service that the "Generate an Image" node uses).
   
  LinkedIn Account: For publishing the generated posts (requires LinkedIn OAuth Credentials for n8n connection).

  Connect with us

  Website: https://www.intuz.com/services
  Email: getstarted@intuz.com
  LinkedIn: https://www.linkedin.com/company/intuz
  Get Started: https://n8n.partnerlinks.io/intuz

  For Custom Worflow Automation
  Click here- Get Started

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatGoogleGemini","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.linkedIn","n8n-nodes-base.merge","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.stickyNote","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"]

workflow_json_compressed:
  [encoded data, 9196 characters]


name: Automate Social Media Posts with AI Content and Images across Twitter, LinkedIn & Facebook
author_name: Abrar Sami
author_username: abrarsami
categories: []
created_at: 2025-07-10T12:53:23.146Z
updated_at: 2025-07-10T12:53:23.146Z
url: https://n8n.io/workflows/5841
scraped_at: 2025-12-24 13:02:41
description:
  Auto-generate & post content using AI

  This workflow helps you create daily content using just a topic prompt. It writes a tweet, generates an image, and publishes across Twitter, Facebook, and LinkedIn — all on autopilot.

  How it works

  Triggers daily at 10 PM to start the flow  
  Uses OpenAI to generate a niche topic title  
  Writes a short-form post (tweet style) with hashtags  
  Generates a Japanese anime-style image for visual context  
  Saves everything in Google Sheets  
  Publishes automatically on Twitter, LinkedIn, and Facebook  

  Set up steps

  You’ll need OpenAI, Google Sheets, and social media credentials (Twitter, Facebook, LinkedIn)  
  Takes about 10–15 minutes to configure if you already have the credentials ready  
  Make sure your Sheet and API keys are properly linked before activating  

  📝 Keep detailed notes inside the workflow with sticky notes for easier handoff or collaboration.

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleSheets","n8n-nodes-base.twitter","n8n-nodes-base.linkedIn","n8n-nodes-base.facebookGraphApi"]

workflow_json_compressed:
  H4sIAAAAAAAAE9VYbVPbSBL+K1O6+4hg9C5RlbpzgBA2L1CHnezeJpUazbTsAUmjaMaAQ/m/X49kbMA2S9iqVN03S5rufrqffhvfOlI4+06UsfTz4YeTd+9UVrA/zpwdpwLDnP1bR9basJrDiT3H04QlcQx5CiJkQeb5Hi88L2MRDVI/oizljDLPA5FRLoQfhkWcQ54EQZxEaR6gXgNVUzIDBy0IfQ5m2hwofAMG0IBppzDfcWpWAVo7U9rIemyF2Fg7+39+xU9KgP152wNPPeHn1GNuTlnshkHsuRnkkUupH3k08JifZs5S4TmfgJiWQIatHI+htZpnjf1Sp7XbqXZzpmFXLw6uzjVKSyNVjabpjhdECKVhLao10GobpxaP9/HCN1es7DCaXn5g3qpp6+z7/vzrfN4b/YRynT5v15/vLNyJoshjXMQui0XihjzN3DzJU9ejoRcHwucY/pU7H0BrNgbCSIXQy5U3/0Z39lYulawe8wmT9a5qoB7Ih+74/maHOp2W9Vvn27e27MnZ6V6jiVJqg3rQ0al9HDfGDfGZMxu5/4CeluZjj/L4bIif0GvVWItW99ymV4e9s9Qp6UnlCsNXGxTD/MAsQd8iShB8yzgCI0YapE8V+N6oRnLSgk0mgU/kCtoZ0Q1wWeCHplV5CdX9AxgRolrCpkZVzGLZdXo+OOYiWpWs7PD0URo0suPT8vL25N3rzxejCz7j11FTD1YcnHZnCeNcTWtDfGcDv+mS3yLgqR8n4Ioi5W5Ihe8ylnluUjDfAz8PaE638uu9kOAopTuuF9K/xzDqNx3LyrUB7b5tYPvg7WDYMX7qvh8Mj86HP8/8q9dYgoKompgJ9Izvk9tb8s8LjZQtxHcX58l8/qX+3MouVcw1gEEpZkiO6XOp8bfUi0wR6rre/VJ/qV8D0aqcWkiYDhKVoDVWC1KxSyDSEGBaljPMHCYY5hC5lmZiX87IleIsn5asnVlFAyFQUwVkwvTEtii0pMivzika+SErssKlIsiwBdLQzXxfuNiL/ZQmDBt6sNJ9DDW0XWHVRFYYyBcmVRbSnSBd7xpYdlXzMhZX0MgFa1gN2qKUGF9tZkhDB5c4j9KpBY29lVsHen9+Zex5GsQQZszNRIyxhyhzU1vPIU4jTsNMCBavdA8aVC5sC5o2wjraqmsia6InmLbe1mE0Vmpcwrk9pNdJcL11Ejimd1WvKsz+GFoGLC9PcIDaD0HzVja9gacPY2DsnKzYahz3RpaOaJx/3fwWUuPQn911mBYqdWXnfYEMdc/fp7K992JxftFT7rQKKBh2mg/M8MnyKGdY0CNMtaFafOiXiAWi+/48A9eTOB7qegmak4cV90Icd1p+BgHmSMWaBs196Ns7CssaXkOpru22Z4/ix4O7zPlzEXWUY8bubGaoDlSNM9YMEbxe2etfvpFQCj1U571L/dfHrR8LsWWL1GJdMZy2o64UEEJXBb2Hz9o4pHhFH82gkRVyJsY0en9vTyiuF8WDaVvt6cZ29M6M3hN73pmXDi9mR0d6PILZt/H339VHfRQdl5odH1a//fGppP/9/OnHzcEoGe2BkOYfm0wuKDnvSxh9RKvTCivkuXP1Z2D8Unf/NdXNK9HKK9DicrPXg+UmhW0sx4YpyN0Y3zAC7/exUxSd+Pdb8vjs6Ej+kCN6+f5TVF5d3BtZnRzpBZedOVjvzOFuvKy0IMyiLPICF8IELwZZFLt5kXA3oTwUSZKAF9/rzItlc2j3h6192OAeYB5fBjwvxvV5wyA0cGMedNB73aNvtUyITgsr++KxNbIetYXV9YDJG63f63ffL8Tp2zeVX6+8+f0uSOshWl014iDxwgjwbpFmwg1jjgEC6ru8AEppGMaCeWsBYgRd3x6hUtaXIE7qDSHaNKa2BODhtF0CDmnhhSAokhlEuOfk1M3yVLgCr5tFGrAU76IrwG8Yh1ypS3LcsmZCBmcnW1EXi6PdSRvhdfSbNp17nW2dtTWdd6wd48XO+3g9mv0IT94fHm5H/NQGYrs53oewNJdtWIOxd+XOONwA79bb01Zgvu47V11nuurlu4u8lyH7WVC4LGO5G+JN3c0S/EUjKLyCCUoLCw2ruQZ+5+fahdPeIXBBxCjhAlD37W37paU7uoMXZAE3zj61xC5knlhKtws9d5t6rOHrV4zFGspNrvwtC2v/NTwjWH+hcj1Mm3Ru7mXb47iltLcLPFVaG3H/RRz/H5yYz/8Hzx14wioTAAA=


name: Transform Reddit Questions into SEO Blog Posts with OpenAI and Google Sheets
author_name: Abrar Sami
author_username: abrarsami
categories: []
created_at: 2025-07-10T12:56:48.385Z
updated_at: 2025-07-10T12:56:48.385Z
url: https://n8n.io/workflows/5842
scraped_at: 2025-12-24 13:02:41
description:
  Turn Reddit Questions into SEO Articles Automatically

  This workflow takes real user questions from Reddit and transforms them into fully structured blog posts — title, intro, steps, and conclusion — using AI.

  How it works

  Manually triggered when you want to run it
  Scrapes the latest posts from a specific subreddit (e.g. r/n8n)
  Filters only posts that are real questions (based on keywords like “how,” “what,” “why”)
  Logs relevant questions into a Google Sheet as raw input
  Enhances each question using AI (rephrases, creates a clean title and slug)
  Generates full-length blog content:
    ✏️ Intro paragraph
    ✅ Step-by-step guide
    🧠 Clear conclusion
  Saves the final blog content to a second Google Sheet for publishing

  Set up steps

  You’ll need access to:
    Reddit API (OAuth)
    OpenAI API
    Google Sheets
  Takes around 15–20 minutes to connect all the credentials and tweak prompts
  Customize the subreddit or topic focus by changing the Reddit node config

  Perfect for content teams who want to scale content output using real community pain points — without ever starting from a blank page.

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.reddit","n8n-nodes-base.code","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.googleSheets","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 4824 characters]


name: Build a Restaurant Voice Assistant with VAPI and PostgreSQL for Bookings & Orders
author_name: Oneclick AI Squad
author_username: oneclick-ai
categories: []
created_at: 2025-07-10T15:10:47.642Z
updated_at: 2025-07-10T15:10:47.642Z
url: https://n8n.io/workflows/5847
scraped_at: 2025-12-24 13:02:41
description:
  This n8n template demonstrates how to create a comprehensive voice-powered restaurant assistant that handles table reservations, food orders, and restaurant information requests through natural language processing. The system uses VAPI for voice interaction and PostgreSQL for data management, making it perfect for restaurants looking to automate customer service with voice AI technology.

  Good to know
  Voice processing requires active VAPI subscription with per-minute billing
  Database operations are handled in real-time with immediate confirmations
  The system can handle multiple simultaneous voice requests
  All customer data is stored securely in PostgreSQL with proper indexing

  How it works

  Table Booking & Order Handling Workflow
  Voice requests are captured through VAPI triggers when customers make booking or ordering requests
  The system processes natural language commands and extracts relevant details (party size, time, food items)
  Customer data is immediately saved to the bookings and orders tables in PostgreSQL
  Voice confirmations are sent back through VAPI with booking details and estimated wait times
  All transactions are logged with timestamps for restaurant management tracking

  Restaurant Info Provider Workflow  
  Info requests trigger when customers ask about hours, menu, location, or services
  Restaurant details are retrieved from the restaurant_info table containing current information
  Wait nodes ensure proper data loading before voice response generation
  Structured restaurant information is delivered via VAPI in natural, conversational format

  Database Schema

  Bookings Table
  booking_id (PRIMARY KEY) - Unique identifier for each reservation
  customer_name - Customer's full name
  phone_number - Contact number for confirmation
  party_size - Number of guests
  booking_date - Requested reservation date
  booking_time - Requested time slot
  special_requests - Dietary restrictions or special occasions
  status - Booking status (confirmed, pending, cancelled)
  created_at - Timestamp of booking creation

  Orders Table
  order_id (PRIMARY KEY) - Unique order identifier
  customer_name - Customer's name
  phone_number - Contact for order updates
  order_items - JSON array of food items and quantities
  total_amount - Calculated order total
  order_type - Delivery, pickup, or dine-in
  special_instructions - Cooking preferences or allergies
  status - Order status (received, preparing, ready, delivered)
  created_at - Order timestamp

  Restaurant_Info Table
  info_id (PRIMARY KEY) - Information entry identifier
  category - Type of info (hours, menu, location, contact)
  title - Information title
  description - Detailed information content
  is_active - Whether info is currently valid
  updated_at - Last modification timestamp

  How to use

  The manual trigger can be replaced with webhook triggers for integration with existing restaurant systems
  Import the workflow into your n8n instance and configure VAPI credentials
  Set up PostgreSQL database with the required tables using the schema provided above
  Configure restaurant information in the restaurant_info table
  Test voice commands such as "Book a table for 4 people at 7 PM" or "What are your opening hours?"
  Customize voice responses in VAPI nodes to match your restaurant's tone and branding
  The system can handle multiple concurrent voice requests and scales with your restaurant's needs

  Requirements

  VAPI account for voice processing and natural language understanding
  PostgreSQL database for storing booking, order, and restaurant information
  n8n instance with database and VAPI integrations enabled

  Customising this workflow

  Voice AI automation can be adapted for various restaurant types - from quick service to fine dining establishments
  Try popular use-cases such as multi-location booking management, dietary restriction handling, or integration with existing POS systems
  The workflow can be extended to include payment processing, SMS notifications, and third-party delivery platform integration

nodes_used:
  ["n8n-nodes-base.webhook","n8n-nodes-base.postgres","n8n-nodes-base.respondToWebhook","n8n-nodes-base.wait","n8n-nodes-base.wait","n8n-nodes-base.webhook","n8n-nodes-base.postgres","n8n-nodes-base.respondToWebhook","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE+VY63LbNhZ+FQy706YzhkKC4E0z+yNx1qnbSeOx3WR2I08HlwOZa4pQSEip16OZvkPfsE/SA1KyfKEce7fb/qh+EcABzuU7ON+BroJSB+Pg4OV08aqS387ky9f19DsT7AUzcCIYXwVl3TpRKzj0clqnBRhhchYxlXGhWZhmYaijkGdxoeOYFUmei9TEJo/zSPBU8DwyMVeFUiyP8FwHs3klHOw3oNsTcIv5vsUZcIAKXLOA1V5Qixmgtne2VEBetG3pTXDk159/IceA34vGD19ae1HW0z3yttHQtORLclgbS04uW9ThNYlpG4w/nOF5VoP/vOq9VSJVSVxkVPEMKDcaqAxzQVVRpEYlknEmg2srTptyOoVmTHpzjuHjAm0gz969ODr82qu5nHuxOq9pp4dK0cLoE8hztA/X57YtXWlr1E9ZuEfjPEST1utdVAuTyiJiCQ1lllAeKUbzTBQ0kmnGU5UXwMAfJBq0yKGrHpe5cOeP32vn3gS/EcN77tz8Dbhz65UfvT05RYEG2jkKwBt0AWc3w+/9cNU7+Q41d36w1d46klLKIo0Vp5FRMeVaKppzlVDQeZRHRWZULraR/GGuEXjySjhBnp0KWcEGQ/J8DeLugGIY3RTNuh1Rvo3o7fA4f7z/+PHHpuoTC3O6d64zZy9Yimrhh+gJetiqc5iJHTsqzMAbO+YLWZXK71K2Wsy6uG4Wr26c5XNvJuZz9HAdV7Fw9o2YH9bzhfNx8BdNOHWOEvubo/wu4fw9cad239ZLaNwpxgSXjKha8Fq7yYMSKt2e2hPX4P716uoO2HYOjeijFSzmLW7r7MbbB7UrcUeXTJvgjtfA8n/yj/84eP3xgF005vibf21BPFqLUoe3IFjdy41Rep0dRRZnaZalFO9+RHnMJc0LGVOIs1hzo1RoYHvwcZdyerzJieddRhAMgCmbWefC5y5dn7X61L4fun0p35Ert+K1PuN92V2vf7e4dXs7Xlp9ibN/v5rUBH8Tv7CoXDsJxuRDP+d/V9vPXsxZW+2LqjrUXnISXF2Rvz376sHK8tXXoxJzYOQtGEnUO5pB24opjDaHtR/Cs1GpyWo1CfbuauwN22rrjsHS6RZtt2Erv+o/zyb16t5Nj0bbu54pLXOF8BVYMSnPck4LmRVYNQWw1OhMQLpF870oHTmwDTleh253pUTJ20CxcLBMZiGYlElBZZRg2c51SmUKgoZxZCKhQxZl6d0yed+h6Nohk0WJCXlM0zSSWDqjnBZZikOO7JbrIk4VPOBQ9ASPujIVsbseJSxHUiwMhYRjSL1bggmGvnNtuCzQQv0Uj7hgJhcANIVEUM51gmQQY01G4BguGBMPEVtHm/8zr913DwwwFcUGyUggN6UQ0QIpliaZ1CoNORJEvIvXHrn3/8RrcSwywIJFE8ZyDCRSayGxholEGJmpPE3SG4Ekr8HdbEy6eD7bFMqnUlqX/X0w/xRK28keLVSg/jj2CIswyVWukS4Mp1wJgeyBXVrEYjAcVAxSDLDHDRxeYQtbVu3vwBpDcPzprDFwbX830rjJGmKJUey6tf+OOCBRPDZY1tJcFdgGhDGVOuNYdlOmTJGIMDFbIE9cqS4uyffW7aaMtpNZi9ysQzxHsNIBsLBPs00w5ligSu0x4ghrcA7l9NwF49gPsKlymNSo7YsvyO3u9Mu+OyXfiFpXODGpJzUlP7RA3HnZkk+2uTCV/UScJfiQwUkgy47SxfXbxYkLlO5OxShDs+xuVUvwRGKs1cT2jxjT2BlRi9bZGQ5HvaZDR1qxhJbItUF+V7eB6HWOlzUq94qxxRY+SJ2M6pun1q/MiBTqgqzFNipI/75z1WWna1Lfh3JLL6AibiTHG5lmlEuszlIKLJKhUlmowjDXbBDI3VS5E8nEV0E2gOQGv/xB/O5W46PGLkuM118MOf+SUK5cwvXToQXn0I6eUMoZ/MfWHpYXbSmef2eri/5NorBSQHNkkRJ85dqEqT1AH08QjLefamhQDn4CtfDh6O4HSi4jb8Wyt6BrAsII8gjfATSKGPYkTOBjWzKDAMeZYDrRouBBh16N7LKuqAPtI07OROlzA5/xdc9hT3tQdtv3grLW8FMwDldnZ2jqQFs3pOkp9DKo58Fma0jjo5uKh9UN/mkxpO+Bhn1Qw+fse5SO6DNKHgXwg3g94TE5YMFq9RuoGM29IRMAAA==


name: Generate Instagram Reels with Veo3 and GPT for AI-Powered Ad Creation
author_name: Automate With Marc
author_username: marconi
categories: []
created_at: 2025-07-10T16:13:26.519Z
updated_at: 2025-07-10T16:13:26.519Z
url: https://n8n.io/workflows/5849
scraped_at: 2025-12-24 13:02:42
description:
  🎬 Veo3 Instagram Reel Generator – AI-Powered Ad Creation in Minutes

  Description:
  This no-code workflow transforms your creative brief into an engaging Instagram Reel using OpenAI and Veo3 API (via Wavespeed) — fully automated in n8n. Just type a product, theme, or trend via chat, and get a short-form video plus caption delivered and logged, ready to post.

  Perfect for marketers, creators, and content teams looking to scale their ad content output without hiring editors or creative agencies.

  Watch step-by-step build video tutorial here:
  https://www.youtube.com/@Automatewithmarc

  ⚙️ How It Works:
  💬 Chat Trigger
   Start by sending a message like “Create an ad for a minimalist perfume brand using the ‘quiet luxury’ trend.”

  🧠 Prompt Engineer (ChatGPT)
   Generates a 5–8 second descriptive video prompt suitable for Veo3 based on your input — including visual tone, motion, and hook.

  📡 API Call to Veo3 via Wavespeed
   Submits the prompt to create a short video (9:16 ratio, ~8 seconds), then polls for the final video URL.

  ✍️ Caption Generator (GPT)
   Creates an Instagram-friendly caption to pair with the video, using a playful, impactful writing style.

  📄 Google Sheets Integration
   Logs each generated video prompt, final video URL, caption, and status into a Google Sheet for easy management and scheduling.

  🔌 Tools & Integrations:
  OpenAI GPT (Prompt generation & caption copywriting)

  Veo3 via Wavespeed API (Video generation)

  Google Sheets (Content tracking and publishing queue)

  Telegram / Chat UI trigger (Optional – easily swappable)

  💡 Use Cases:
  Instagram & TikTok ad generation

  Creative automation for digital agencies

  Short-form UGC testing at scale

  Trend-driven campaign ideation

nodes_used:
  ["@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.if","n8n-nodes-base.wait","n8n-nodes-base.wait","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.openAi","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"]

workflow_json_compressed:
  [encoded data, 4884 characters]


name: AI-Powered Multi-Platform Assistant with Google Suite, LinkedIn & Twitter
author_name: Jay Emp0
author_username: jay-emp0
categories: []
created_at: 2025-07-10T16:29:10.444Z
updated_at: 2025-07-10T16:29:10.444Z
url: https://n8n.io/workflows/5850
scraped_at: 2025-12-24 13:02:41
description:
  🤖 MCP Personal Assistant Workflow Description

  This workflow integrates multiple productivity tools into a single AI-powered assistant using n8n, acting as a centralized control hub to receive and execute tasks across Google Calendar, Gmail, Google Drive, LinkedIn, Twitter, and more. 

  ✅ Key Capabilities

  AI Agent + Tool Use**: Built using n8n's AI Agent and MCP system, enabling intelligent multi-step reasoning.
  Tool Integration**:
    Google Calendar: schedule, update, delete events
    Gmail: search, draft, send emails
    Google Drive: manage files and folders
    LinkedIn & Twitter: post updates, send DMs
    Utility tools: fetch date/time, search URLs
  Discord Input**: Accepts prompts via n8n_discord_trigger_bot repo link

  🛠 Setup Instructions

  Timezone Configuration:
     Go to Settings &gt; Default Timezone in n8n.
     Set to your local timezone (e.g., Asia/Jakarta).
     Ensure all Date & Time nodes explicitly use the same zone to avoid UTC-related bugs.

  Tool Authentication:
     Replace all OAuth credentials for:
       Gmail
       Google Drive
       Google Calendar
       Twitter
       LinkedIn
     Use your own accounts when copying this workflow.

  Platform Adaptability:
     While designed for Discord, you can replace the Discord trigger with any other chat or webhook service.
     Example: Telegram, Slack, WhatsApp Webhook, n8n Form Trigger, etc.

  📦 Strengths

  Great for document retrieval, email summarization, calendar scheduling, and social posting.
  Reduces the need for tab-switching across multiple platforms.
  Tested with a comprehensive checklist across categories like:
    Calendar
    Gmail
    Google Drive
    Twitter
    LinkedIn
    Utility tools
    Cross-tool actions  
    (Refer to discordGPT prompt checklist for prompt coverage.)

  ⚠️ Limitations

  ❌ Binary Uploads:
    AI agents & MCP server currently struggle with binary payloads.
    Uploading files to Gmail, Google Drive, or LinkedIn may fail due to format serialization issues.
    Binary operations (upload/post) are under development and will be fixed in future iterations.

  ❌ Date Bugs:
    If timezone settings are incorrect, event times may default to UTC, leading to misaligned calendar events.

  🔬 Testing

  Use the provided prompt checklist for full coverage of:
  ✅ Core feature flows
  ✅ Edge cases (e.g., invalid dates, nonexistent users)
  ✅ Cross-tool chains (e.g., Google Drive → Gmail → LinkedIn)

  ✅ MCP Assistant Test Prompt Checklist

  📅 Google Calendar
  [X] "Schedule a meeting with Alice tomorrow at 10am. and send an invite to alice@wonderland.com"
  [X] "Create an event called 'Project Sync' on Friday at 3pm with Bob and Charlie."
  [X] "Update the time of my call with James to next Monday at 2pm."
  [X] "Delete my meeting with Marketing next Wednesday."
  [x] "What is my schedule tommorow ? "

  📧 Gmail
  [x] "Show me unread emails from this week."
  [x] "Search for emails with subject: invoice"
  [X] "Reply to the latest email from john@company.com saying 'Thanks, noted!'"
  [X] "Draft an email to info@a16z.com with subject 'Emp0 Fundraising' and draft the body of the email with an investment opportunity in Emp0, scrape this site https://Emp0.com to get to know more about emp0.com"
  [X] "Send an email to hi@cursor.com with subject 'Feature request' and cc sales@cursor.com"
  [ ] "Send an email to recruiting@openai.com , write about how you like their product and want to apply for a job there and attach my latest CV from Google Drivce"

  🗂 Google Drive
  [ ] "Upload the PDF you just sent me to my Google Drive."
  [X] "Create a folder called 'July Reports' inside Emp0 shared drive."
  [X] "Move the file named 'Q2_Review.pdf' to 'Reports/2024/Q2'."
  [X] "Share the folder 'Investor Decks' with info@a16z.com as viewer."
  [ ] "Download the file 'Wayne_Li_CV.pdf' and attach it in Discord."
  [X] "Search for a file named 'Invoice May' in my Google Drive."

  🖼 LinkedIn
  [X] "Think of a random and inspiring quote. Post a text update on LinkedIn with the quote and end with a question so people will answer and increase engagement"
  [ ] "Post this Google Drive image to LinkedIn with the caption: 'Team offsite snapshots!'"
  [X] "Summarize the contents of this workflow and post it on linkedin with the original url https://n8n.io/workflows/5230-content-farming-ai-powered-blog-automation-for-wordpress/"

  🐦 Twitter
  [X] "Tweet: 'AI is eating operations. Fast.'"
  [X] "Send a DM to @founderguy: 'Would love to connect on what you’re building.'"
  [X] "Search Twitter for keyword: 'founder advice'"

  🌐 Utilities
  [X] "What time is it now?"
  [ ] "Download this PDF: https://ontheline.trincoll.edu/images/bookdown/sample-local-pdf.pdf"
  [X] "Search this URL and summarize important tech updates today: https://techcrunch.com/feed/"

  📎 Discord Attachments
  [ ] "Take the image I just uploaded and post it to LinkedIn."
  [ ] "Get the file from my last message and upload it to Google Drive."

  🧪 Edge Cases
  [X] "Schedule a meeting on Feb 30."
  [X] "Send a DM to @user_that_does_not_exist"
  [ ] "Download a 50MB PDF and post it to LinkedIn"
  [X] "Get the latest tweet from my timeline and email it to myself."

  🔗 Cross-tool Flows
  [ ] "Get the latest image from my Google Drive and post it on LinkedIn with the caption 'Another milestone hit!'"
  [ ] "Find the latest PDF report in Google Drive and email it to investor@vc.com."
  [ ] "Download an image from this link and upload it to my Google Drive: https://example.com/image.png"
  [ ] "Get the most recent attachment from my inbox and upload it to Google Drive."

  Run each of these in isolated test cases. For cross-tool flows, verify binary serialization integrity.

  🧠 Why Use This Workflow?

  This is an always-on personal assistant that can:
  Process natural language input
  Handle multi-step logic
  Execute commands across 6+ platforms
  Be extended with more tools and memory

  If you want to interact with all your work tools from a single prompt—this is your base to start.

  📎 Repo & Credits

  Discord bot trigger: n8n_discord_trigger_bot
  Creator: Jay (Emp₀)

nodes_used:
  ["n8n-nodes-base.webhook","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.discord","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","@n8n/n8n-nodes-langchain.mcpTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.linkedInTool","n8n-nodes-base.gmailTool","n8n-nodes-base.twitterTool","@n8n/n8n-nodes-langchain.mcpClientTool","@n8n/n8n-nodes-langchain.mcpClientTool","@n8n/n8n-nodes-langchain.mcpClientTool","@n8n/n8n-nodes-langchain.mcpClientTool","@n8n/n8n-nodes-langchain.memoryMongoDbChat","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequestTool","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.mcpTrigger","@n8n/n8n-nodes-langchain.mcpTrigger","@n8n/n8n-nodes-langchain.mcpTrigger","@n8n/n8n-nodes-langchain.mcpTrigger","@n8n/n8n-nodes-langchain.mcpClientTool","@n8n/n8n-nodes-langchain.mcpTrigger","n8n-nodes-base.googleDriveTool","n8n-nodes-base.twitterTool","@n8n/n8n-nodes-langchain.toolCode","n8n-nodes-base.twitterTool","n8n-nodes-base.twitterTool","n8n-nodes-base.linkedInTool","n8n-nodes-base.linkedInTool","@n8n/n8n-nodes-langchain.toolThink","n8n-nodes-base.stickyNote","n8n-nodes-base.googleDriveTool","n8n-nodes-base.googleDriveTool","n8n-nodes-base.googleDriveTool","n8n-nodes-base.googleDriveTool","n8n-nodes-base.googleDriveTool","n8n-nodes-base.googleDriveTool","n8n-nodes-base.googleDriveTool","n8n-nodes-base.googleDriveTool","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-nodes-base.gmailTool","n8n-nodes-base.gmailTool","@n8n/n8n-nodes-langchain.mcpClientTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.gmailTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.googleCalendarTool","n8n-nodes-base.dateTimeTool","n8n-nodes-base.dateTimeTool","n8n-nodes-base.httpRequestTool","n8n-nodes-base.discord"]

workflow_json_compressed:
  [encoded data, 9632 characters]


name: Daily Workflow Backups to GitHub with Slack Notifications
author_name: Andrew
author_username: boanse
categories: []
created_at: 2025-07-10T17:08:00.210Z
updated_at: 2025-07-10T17:08:00.210Z
url: https://n8n.io/workflows/5851
scraped_at: 2025-12-24 13:02:41
description:
  Who is this for?
  This workflow is ideal for n8n self-hosted users, DevOps engineers, and automation developers who want to automatically back up their n8n workflows to GitHub on a regular basis.

  What problem is this workflow solving
  Manually backing up n8n workflows can be time-consuming and prone to human error. This workflow automates the backup process, ensuring that all workflows are safely stored in a version-controlled GitHub repository every 24 hours.

  What this workflow does
  This automation runs daily to back up all workflows from your n8n instance to a specified GitHub repository. Each workflow is saved as a .json file using its unique ID, organized into a folder path defined by repo_path. The workflow is designed to manage memory usage efficiently by recursively calling itself. Once the backup is complete, it optionally sends a Slack notification to confirm success.

  Setup
  Configure the Config node in the subworkflow to set:
     GitHub Repo Owner
     GitHub Repo Name
     Main folder path (repo_path)
  Connect your GitHub and (optionally) Slack credentials.
  Set the workflow to run on a daily cron schedule.
  Test the workflow manually to confirm the GitHub integration works.

  Sign up for a free consultation and find out how n8n can help you.

nodes_used:
  ["n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.github","n8n-nodes-base.github","n8n-nodes-base.filter","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.switch","n8n-nodes-base.n8n","n8n-nodes-base.set","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.github","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.slack","n8n-nodes-base.slack","n8n-nodes-base.splitInBatches"]

workflow_json_compressed:
  [encoded data, 4764 characters]


name: WhatsApp Appointment Scheduling with Google Calendar
author_name: Andrew
author_username: boanse
categories: []
created_at: 2025-07-10T17:31:35.245Z
updated_at: 2025-07-10T17:31:35.245Z
url: https://n8n.io/workflows/5855
scraped_at: 2025-12-24 13:02:44
description:
  Who is this for?
  This workflow is for service-based businesses and freelancers who want to automate booking appointments via WhatsApp without relying on third-party scheduling tools. It's perfect for small teams who want full control over the reservation system and calendar integration.

  What problem is this workflow solving?
  Manually coordinating bookings through messages can be inefficient and error-prone. This workflow streamlines the entire scheduling process-from user input to calendar event creation-saving time and avoiding double-bookings. It ensures users only choose from available time slots and automatically records the meeting in your Google Calendar.

  What this workflow does
  Sends a WhatsApp message with a reservation link.
  Collects the user's name and preferred date.
  Checks availability and shows only free time slots.
  Allows the user to choose a time slot.
  Automatically creates a Google Calendar event with the selected details.
  Saves all data to a Postgres database for future reference.

  Setup
  Create Tables in Postgres DB
     Open the provided SQL script and replace "n8n" with your Postgres schema name.
     Execute the script to create the required tables.
  Add Credentials
     WhatsApp: Set up your WhatsApp Business API credentials using OAuth and API keys.
     Postgres: Connect your database where the booking data will be stored.
     Google Calendar: Authorize access to your calendar for event creation.

nodes_used:
  ["n8n-nodes-base.if","n8n-nodes-base.whatsAppTrigger","n8n-nodes-base.set","n8n-nodes-base.whatsApp","n8n-nodes-base.whatsApp","n8n-nodes-base.postgres","n8n-nodes-base.switch","n8n-nodes-base.switch","n8n-nodes-base.postgres","n8n-nodes-base.if","n8n-nodes-base.postgres","n8n-nodes-base.postgres","n8n-nodes-base.postgres","n8n-nodes-base.if","n8n-nodes-base.whatsApp","n8n-nodes-base.postgres","n8n-nodes-base.whatsApp","n8n-nodes-base.whatsApp","n8n-nodes-base.googleCalendar","n8n-nodes-base.postgres","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.googleCalendar","n8n-nodes-base.whatsApp","n8n-nodes-base.postgres","n8n-nodes-base.postgres","n8n-nodes-base.code","n8n-nodes-base.postgres","n8n-nodes-base.summarize","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"]

workflow_json_compressed:
  H4sIAAAAAAAAE7Va224bRxL9FYLPbqPvF78sFF9iI4i1ib0bLAJjUd1dLROmhgo5kmIb/vfUULI4pHqoIW2/ELw0i6eqq+qc6ubn6SxPn0z/evbv/71cPv/l/a/20/XF25fTR9MGzpE++eOEvcH5/MV8cc1+Wiw+zJqz/z+FOTYZluxKdAsXGVfTJ39+vjGFACVnoZlwTjMtimFBpcKcLSBkLpgibMy/Wk3iop2sWli2q3/R++3Hi+79xjdsbZhFWOHjWaGPLharWTtbNPRbnvNHnr+j92BJhlpcEoLPX26+/l96tV4mH8svj25h8egDmJCY9F4wjTwzehlZsNwV6awGmXtev4d2dXJxMXm7nJ2d4XIQ2PXtws26Hkrmb1FeY3xPsXvVAXEuxZwg0odgmJacngVFQUIRsggKUkzTBxwTd24BZhWBB1akSExHYxgkJRnX4LI3OlopetFuCBrMZ59gjXDIqRW2244IPSbc6rG+w4VR6aCyYilp8hJi7LIAGYCCEoviKsteuHGeFuc4+RVXKzjDB6O9jU55irOQ9yKtsFA4NTJM4JgOGFlMJTBuUhEuUrx1HB/pHBQGUI5csIFpHSWLTgAr3DphFZc2mY1Hv8KsIXeay6N84T/YF3SmOBk585bqQGcEBt45VmLyBbi2XPWy5mdsvxZpe7kadIi8aM+WuNpxyI6rVPNoCvNr+Lg6vWwvLttn0ML0Sbu8xDvQwdssgCuWOUhKqeKZL6iZEiFKGQ0lvNuAfoZl1uCkUN8azvPrWZve76Q6l+NyXdYAF5ivNohBFi61QVacVdRzomWBl0LYcwzUclRxfoP46eL8HJo8HOAqXEmlKat4l9guP542L2A2vwV234c7qM6rmIPpUBrK7iwziz4H6pZKIUoUmMN2RsAVGYY4x8lfl7ja20/qmSGs/16pUXzyqIpkWKiTakoQFoz1zNjkJERXwOQtzimLyyaPpxsRDuabaJW3KkHX4VWXrYrFQBWHCqwS1sSS4KGAHlprUlDuMnqoAMW/MV22eNokvAneEWG2PtuCFFzqPEQ2IRcWorLEOJiL5JJe6I1PJzlPTprV9R723OPGqMS4Qya01BqCYqZICjnFlugmBIbRkRTRuZSUtpFdLPFIeMqObWk98REVBPRM8UCayAjBvCCMKkbkqWABi1v5+dvXDNhkxfhslUp/QxpsUlgqhxCMZFYF4hxJD9EFoKoC7mm7nY9qg/r5crl4WCdV2E7/aOIuxRXvDXPOkPJzyFlwVInGUmvLnohb95rDfy4ytNjju8mimfx0evrLq9c/H9rgiEcHevNgpgRMAnkBRoRGJOddYj6RmKYtiCKEmAvnG7C/PdR594T9R+slQbmtPX3dZuzo2iciv6RZcop2hLgmu7jx5MWsma3eH+OH/cF+qKJRd2SSdCSt5DUxo5CGWeeTtRh89D3Z8XSJXfpAM8ErbNpBh84Wi7M5fh2kasT4cN6Ix2rD39pwAQaYRU2t2VGgfSK9nXVKkDz4XOI23dz0vkMpZq03RmDr53SRPgQTDfPRWKZt4gyk9kyQ1qDOgjbyHrY3hI24B9sZDQQnr59NXnfvHzCq2CGAD/W+/vySiE1ScpYVnalp6ExiU3kS/4kks+GYTeh17A7vAf3Z2MH+PNiMSZZR+/I0dJCcobFaSBpdqTtgskZLJwTXYjuIL5aIk7ddFN/MF+0eWbkbQqWH+WMwYNJnrbIG5rSINIjSXEGCUjAHvEglioB+mRDFvZgtV+34oJmRYrEXMWW8stR2XNGkwLLopk+wTEkjJDVST3Pcdkk8g4+T50eXreL8aNqlUn5QfYHjkftYqMSl6tQXKUqiBcajSxyd4Eb2Ivw7rlXkOgGOaau3jvzAGdSgI4Ok0bSlhOm0cSykknNOwWNWKH2vwqq0/Obtye9vJ4d2sG7Au52wjxDJG17INHHaQDO0oMFD20L4ZcnMJhSxQC6JqzH4j4JfVxWHwI/SmpBNYsW4NWFQg3OYWIqx2GIjQuTb/eSPxfLD5OXicg9nJHq6k0vyG0aSO7DGoNI+EP26TLFGEqEBCnYdMEcL3WS9NfrP6VeOJbj1qHcYwckSi5HBMknlQanQHRIJiCxolYrUpQTbV5jNrNv7/T358vwclrNPu9G0I5lDPN4Umna+dFKFRe6o0Eom+tVAiaqoL2dvUJQ8vUe/4+mC5oDD6YJ+HGwnAmyiFqYlGBYECQMZfUhSKk8iuAeqnaUPHyevF/twrdfcLukfwupuxuD30E3Tomm7Xv9kOh3uUslJb8FJRv2IdEAET0lnHOM0UKDMQkQQVZzhOKD3E28cTuEhlGgNE6LrpjSNM5psiI2Lizr6GCzU4yn4cUCZtMeGNOsMFFeG3lNFg3CM9CEF1woqY0e9P2MVqjscaf3cZhzOAMoWrWnoNYVCqnjqDklJUgsoJjqnKSWqOP1xOI+PqC7CkuwlpKKQwM5OkNT2ngwKjyL54lyob744DurB5USrIbWzK7w7iaQ20s6as/VXb4iAlp4uMy7JwpXobFzdfP/m1sTmHAMRLdhkqA4l0ZXmgdH04D3lDI+q2wwC0WC6OTsjwze6nJ6cw6wD/+fn9W1Vtc2tlzyazpqMf0+fcIK8WX1/zr63+h0Bvh1ia79XnbiqRu6OgWtmxp1O7HNl55imCuHO3RqEwcOzqqm7OA8FpaK5q4Y2E8PouOzIq31RGbqGHIJye3485NTeo9x9OGpnplUMvYXfB0RntH9nMt7qOM/u325UIfTrZF/dDpwOVG32BVfNZn1UqpraWvrt1bFdAEP+1oT3wP5tCd/DCmUyAmvvFrBmvDLV1wto+xp6KNVqd45DBdmv3u/ndy9/q/eJgy2vt2VDuzp4PFNnhZ1zxZrVobmnavDePxyqGzrwf4FBv3edqm5Fbf7ZSx7bxV6zOXjsOpjKlT42kNK7d4UHmBwsk/33O0NJXv1WNRO2zyP35fXuwXu9gw7Ta+3nB//OcaDxSdV65a8V4+1+1Urfhd7effny5R88IYkpQSUAAA==


name: Generate Personalized Cold Email Openers from LinkedIn Posts with GPT-4o
author_name: Dajeel Dulal
author_username: dajeel
categories: []
created_at: 2025-07-10T17:43:21.305Z
updated_at: 2025-07-10T17:43:21.305Z
url: https://n8n.io/workflows/5856
scraped_at: 2025-12-24 13:02:41
description:
  Turn any LinkedIn post into a personalized cold email opener that sounds like a human wrote it in seconds.

  Whether you're in sales, partnerships, or outreach, this tool reads LinkedIn posts like a human, distills the core message, and gives you a smart, conversational opener to kick off the relationship the right way.

  How It Works:

  1.) Paste the post + author info into a short form.

  2.) AI reads the post like a B2B sales expert would.

  3.) Output = personalized opener, company name, prospect’s name, and next steps.

  4.) Copy-paste into your cold email and hit send.

  The opener isn’t generic fluff — it references real details, sounds natural, and shows you actually paid attention.

  Perfect For:

  SDRs and BDRs

  Agency outreach

  Partnership prospecting

  Any cold outreach that starts with a real conversation

  Setup Steps

  Setup time: ~2-3 mins

  1.) Add your OpenAI credentials (or use n8n’s built-in credits).

  2.) Open the form and test it with the sample post.

  3.) Tweak the AI prompt if you want to target a different niche or tone.

  (Optional) Connect to Google Sheets, a CRM, or your email tool.

  You're live.

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.code","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.formTrigger","n8n-nodes-base.code"]

workflow_json_compressed:
  [encoded data, 4744 characters]


name: Multimodal Chat Assistant with GPT-4o for Text, Images, and PDFs
author_name: Cooper
author_username: cooper
categories: []
created_at: 2025-07-10T19:57:54.523Z
updated_at: 2025-07-10T19:57:54.523Z
url: https://n8n.io/workflows/5857
scraped_at: 2025-12-24 13:02:41
description:
  Chat with thing

  This n8n template lets you build a smart AI chat assistant that can handle text, images, and PDFs — using OpenAI's GPT-4o multimodal model. It supports dynamic conversations and file analysis, making it great for AI-driven support bots, personal assistants, or embedded chat widgets.

  🔍 How it Works

  The chat trigger node kicks off a session using n8n's hosted chat UI.
  Users can send text or upload images or PDFs — the workflow checks if a file was included.
  If an image is uploaded, the file is converted to base64 and analyzed using GPT-4o's vision capabilities.
  GPT-4o generates a natural language description of the image and responds to the user's question in context.
  A memory buffer keeps track of the conversation thread, so follow-up questions are handled intelligently.
  OpenAI’s chat model handles both text-only and mixed media input seamlessly.

  🧪 How to Use

  You can embed this in a website or use it with your own webhook/chat interface.
  The logic is modular — just swap out the chatTrigger node for another input (e.g. form or API).
  To use with documents, you can modify the logic to pass PDF content to GPT-4 directly.
  You can extend it with action nodes, e.g. saving results to Notion, Airtable, or sending replies via email or Slack.

  🔐 Requirements

  Your OpenAI GPT-4o API key
  Set File Upload on the chat

  🚀 Use Cases

  PDF explainer bot
  Internal knowledge chat with media support
  Personal assistant for mixed content

nodes_used:
  ["@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.chainLlm","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.if","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.memoryManager","@n8n/n8n-nodes-langchain.memoryManager","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.memoryBufferWindow","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE9VYbW8bxxH+K4tLAacAV97XexEQoI6TFELt2Kid9MUynL3dOXLj4x17t5TMCgL6I/oL+0s6e0eRlEhJTOJ+6AcJvLvdmZ1nZp6Z2avEu+Q0eXP2zd+LafOq0qtvq3Dx12SSzCGY5PQq8U0fTGPhLK5TLM2kdmVVViKFIrOQ24oXXOY6Ty3nZSoMFAwUN6AKYNIJnfPc2ELwTFmGcgPMF7UJ8LwD17+BsFw8b/ENBEAFoVvC9SRpzBxQm52ZEHeYaZ+cvnuP71sH8efVeOq0SqHMBaOVdIoqYwpa5jqlvJIiSzUrhHLJRtqrBTTPzqK81SI+/6HJm6f4RweptDbNFBX65qSNCz0uXLS9D75tUCPNczGhqWB4ioXpUGKAro/4BPgUUNpX30BvO18CCTMgtm0CNIG01fDo52YKpO3IwlXEN8Qhtr6OnxpyaXwgFX77xxL6qK0npmyXgfhwQr42PTjS4iqEgvg+bt6RPyH9cjrFbUTubI8Llj10ZG5WxPQfozPRxDp68Cr58KGrR6DH13j22vcR5wtTL+PjdBGoavGFNXYG7s/QL+vw/QjiH1+/pepVgj5qF4O2KHI0B7/O/HQWv3XQt8vOxg2D6SjLN4tleDsiX6JVqUqiDOjMiHBiGlOv/hmXlr4x3ep1F7+G1VqxM8GwKNti3KDp3tSD7tFZzxZ+iNUYFeKOyz0x1rbLJiTX16Pzf0TXDUr5SX49uQkmVXLIBFDjck1VpguaO6holmtrtFCg0nwrGR3jLXnx4iV5HmPmiKga/r+o53fiSudqQvUxcfXT1RX53c99i6LW0XV9/dN5c9780I9BF3eQqmvnY4jEiAkthpZdjjGBXlmgx+D0vBlkffkkrnny+xOPOXkySsYXZ9FTUXZ0hQl25pspHgixW6DsxY0TERvfQLIPabaBlKdCpYYbKowrqSoVpzkrLE0V8ExmMjeluZufEc9AXsZ4PQLUeh6XvzqUsKpIJ1SyfWCHXPjtmbD+disTrj97fIoNmIw5UxmpKYDKqLICwSxNSh2kwGVRarsLJgL5bIrHOAJDs163F5UPBOXf2iUxHRDTEPgU0xR/OXLp65rMoF5sKejSh1l88gO/dasxir88H7j9PLk39kYOPG82MT+HvseT9u9uP57U0ExRBSX8/cnHS9NN+530OG+SW+45LoS3mMtCCKkUo3kqLVUCiaGoREbBVUXGodDS8S3mZ9UW7S3QkexOfHUHYM5zNkGJ+xDfOi6a4vyGZ3co92Jz2ElSQxV+XEfsEKs9vIEm6rqAm/geDDS1dzd024fO2zAQajuPjBvabmDhWDF31d4UW1sYobPMUabzgipuDS1UzqiowBnhqtIV5YbSo6yrGyyiKqSQ23TftOFb9MQKX/f4tYa1BesOYNemrzZBUPkaI4C9H37EPEQfo4AOy84Wgev3e3kkdvIIeJGxSpSUG8axaeCcllWKji2lKyoGgrEdn77xsTchL2Hedqsjkmk+LPx6WVXQ/cU3rr28S0synYgDrNRjQOOSP8HqxuID9LxedOZGuzeP63hGog/tPIrYJxK5BQCkltJyWnFhkCa1pqUtc2pYyvMqZybN7AOszH8bLWt92P7/U1YWpQUnck6F5ZgVLKuwf1Al1ZJlOk0zZ3iW3GpoMUKOjqOX2BRNoTtEzsUB6ljDhR07MvLQwo8kOXwbfw9ZMmb1+gjGb1feSrYtjR5KKX7CNyA4nSJPypTK3Eqkhkpju8wsxUiSpmBWmlLugXBMHD2EQpGygyXqFn/2MX19tXq1DFhYktMK/Q8PmcK4E1hlS8rQKDQFRwrsBw21WWEZw46lKPN72OF4gx6ih9i1ZMfxw6Ei+lkYQvHMYcHTVCLhU6VSS3OlgJbOFjItdMYrnuxNaY/3v+EtMvW+J7lim1p4CeWsbT8Ow2aOgIs0YxjwDjtyx5CjuK3wF7eZMWBNppO7OC2WZe3tDYHsVExT1+3ld1g3fljUrXH9ptT4xkdeeLlJluQAONsIKYzNciOxJygY0mcKGS24yqkoskK73IKS4p4IEZ8jQvJMHFtA/mcBwkErXWDxx4lJx5LmMEsyTBVllFQ2NZnbGbzfBG8/rsj3bYB7G6R+WLNecis4cDbCjFD7Bl96F2bJqVRskmCDiS1AcooNydC9ROJCJV98MRaudReKfUacl97OcJBG/eTmKoLUEHqywp62XPraEUP6ucGeFuveMEUZxCheguA8FR8tdr0zbJTqceSajON9Pxl64NfffNeT//zr39j+ojoyls8nPRkG55bMsVR55GlTk6HinZCzgEP8YtF2eAS3QshwrkQLYoNn1tcBKDY2PGQYkfEoE5zsP0bpPpBpB2a8P3h2Rl2HLV9zI4+UbcC12HSh41Hhxgx8iethXoJz4EYbEc0ponCy7/et17kotNUlrUyK3KjyDMe5zFKhC1kUvFT5cMGz73X+K9zO2T1u33p38GOHYwKOtkvE6TJep6BvBnc8jYg9He5bEMEQhlZhRNtcQL++UMEngO2tyro83w+BA9CMlQIngDImvyxoqZmmjpUOrNTMsuogBOKXQyBjgUsfRGCc/GM0o7w47PcQbu6HNgH0gDnG5qqUyPEWmIy9MKawBkfTyulCC8iYsAfNkb/cnKFe8/Rxh0ZXmgq/jlPkwNaT6KoOcJCA6LzhTm2k7c1V2+biY2TQ84fsls5JkeEYYySPBc7gLFPajIoShz1EQGdVcdBu9SvdyB8PZD+aNcciMAQi0on7Gdl4eDuOrdHD83gjE7mqiwM2icPeoZxFbcbuDoAYGQEpY9AMn8Au4/ledQ7i1HfBo4j1TDnUXg2lULLitDAVTr65VTR3vKIud6zgKdeVKcdBsQG7qbE4AcdWM16Inb7DFrMZG9K7N6/z8cYMqxt8Sk4ZHna7dr873Fv9Pvbzsek4pGt3CD+4c32YQ3vvvdS7K2hy97hHnHYw6pDW/auagzJuT6KxofEf5uuHB6Vt1z0okt8vc8/II0WKR0XyY2TuXwyOYmPTtESqX787xpF7ux7VxR9VdhDxh7RcX/8XHUXBN3YZAAA=


name: Summarize Documents, Images & Spreadsheets with Gemma 3 on Ollama
author_name: Rish
author_username: b2brish
categories: []
created_at: 2025-07-10T20:16:42.077Z
updated_at: 2025-07-10T20:16:42.077Z
url: https://n8n.io/workflows/5858
scraped_at: 2025-12-24 13:02:42
description:
  Tutorial Video

  🚀 Overview
  Transform your file management with this intelligent workflow that automatically processes and summarizes any file dropped into a monitored folder. Using local AI powered by Ollama, this workflow provides instant insights for images, documents, and data files.
  ✨ Key Features

  🔄 Automatic Processing: Monitors a folder and processes files instantly upon detection
  🎯 Multi-Format Support: Handles images (JPG, PNG), documents (PDF), and data files (CSV, XLS)
  🤖 AI-Powered Analysis: Uses Ollama's Gemma 3 model for intelligent content understanding
  📝 Smart Summaries: Generates concise, informative summaries tailored to each file type
  💾 Organized Output: Saves all summaries as text files with descriptive naming

  🛠️ What It Does

  Image Analysis: Describes visual content and identifies key elements in photos and graphics
  Document Summarization: Extracts and summarizes text from PDF documents
  Data Insights: Analyzes spreadsheet data and provides structural insights

  📋 Prerequisites

  Ollama Installation: Download and install Ollama on your system
  Model Setup: Pull the Gemma 3 model with ollama pull gemma3:4b
  Service Running: Ensure Ollama is running with ollama serve
  Credentials: Configure Ollama API credentials in n8n

  🔧 Setup Instructions

  Clone this workflow to your n8n instance
  Update the folder path in the "Local File Trigger" node to your desired monitoring directory
  Configure Ollama credentials for all three AI model nodes
  Test the workflow by dropping a sample file into your monitored folder

  📊 Supported File Types
  TypeExtensionsProcessingImages.jpg, .pngAI vision analysis and descriptionDocuments.pdfText extraction and summarizationData Files.csv, .xlsData structure analysis and insights
  🎯 Perfect For

  Content Creators: Quickly understand and catalog image collections
  Researchers: Summarize academic papers and research documents
  Data Analysts: Get instant insights into dataset structures
  Knowledge Workers: Organize and understand file collections efficiently

  🔒 Privacy & Security

  100% Local Processing: All AI processing happens on your machine
  No Cloud Dependencies: Files never leave your system
  Private & Secure: Complete control over your data and processing

  🚦 Getting Started
  Simply drop any supported file into your monitored folder and watch as the workflow automatically:

  Detects the file type
  Processes the content appropriately
  Generates an intelligent summary
  Saves the result as a text file

  Your intelligent file assistant is ready to help you understand and organize your digital content!

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.readWriteFile","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOllama","n8n-nodes-base.localFileTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.switch","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOllama","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOllama","n8n-nodes-base.stickyNote","n8n-nodes-base.extractFromFile","n8n-nodes-base.extractFromFile","n8n-nodes-base.extractFromFile","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.convertToFile","n8n-nodes-base.readWriteFile","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE61YbW8bNwz+K4Y/W6kk6jWfVqQrUKB7wVJ0A4ZioCQqNWqfA/u6tSjy38dzssSJz96d02/xHUU+x4cPSeXbdEktTs+/TefNpsUm05syPZ+SRfQxOEwuGidNDKEWp0xVrkApISftbQbpirfFYVCBlMlRRq/AeMjT2bSl5fUCW7pYU9lcUvv5+mLFT6glDtCuP9PNbNqsCm2m539y9C5qqDlU8kmQLCRMqk6k4LPQNSdlXHWuIHtucElsfdnO86evk59XLXXhvl53D5vQiK1XkXBDZ5utzZ3J9Wozb+erhgMKBVrOwMgP/BjX7LCl9aZLQ141LTUtu5re3Hp9z2+2p9TN7A5oKUk7K1Fk7RkomSKS8k5ATrIWxc4jPAD9jbC8+H09b2nyer6gzaSuV8vJq/nm00Hcaz6yPdEdeALdM3IX9pAfRlu9DIo0CR0TCpOhchCn+C9ZKhaMqqbetKrxefVBzsypaZUuEWlphIm5g+e0CNprUauTQCo7cjtpfflm8vKq83kP8gdG+eIB6QKbq/wR580Z3tntIFWcRfP/WdT34FQygTQ6ISNqYZDBISkrQJsQFNbIMngA98tigUucXHzEdvITo1kMQLlYdua3Jx+DZaxejmAcHFVfIQqpAzOu0YhQjRHJEiZQ0jwS0ttVxsW2NCfv1vOrK1of5H3RmXaWD4a77EczsjQhgq8IILKKSRhvrQhKRVEBKSSXIJPrLU19iuQlp9GdWJvMviWnQGhXnDAGioheB+EJCPmnStXuIP1n3uaPhzH+93oXn2V4bl86TyHB2U5NmlKLCVVQrKwabzKDskp4ZTBGZIAHGiaMT581z2iY3HMgeZQCgt+2ICWiRBS+OAuWdZRq2Fe2OlHanMgxyk5GJW+57UQbWdleBRFARuEQMBkedhLNEWUPQXlU2jBG2tbGqguz7Xxgyqv0ArUyglt5IQgQyMpeys0JinFyJk6lPEWAELMU0gdu5uCsQAYnKm8LzgTOq3H7lOvTKNecxrgv7cOch2QM5uRF5KVGmMK1iN7yT2McUbWhpHqE8yEwj3EuZ4ohD2cdZU7kuN1IDawf1rXoPoD1Y4PSpdhoai/rdjTrKvRW5DDSrfKYoZuP1XI/pxBEKrwYeZd9qhUKwM6q8eOXdo25vd2Hfn31+iBWujV8zXY9C5HizmTHTB1ZcgzRhm52Zx6PRXKYDKJGrghu5bL4cgDlH28vn4EyjFE6r9eoIGtGySoyiaszaVuF5heSAijl5QGUF5fvn4GS94MxMHlXT9IwuMrLEa9UWsTApVk9IllNZFLsLU13QkPqavPUCW4xoOS7i3BVsYZM5KXIOSNAegTiSQmyX0N+vIZM78I28HIBNULocCa0LCTeMVOMioVUQ63WcJ+jB5wXq+ZvWreTdjW5o7Mfar61e7faJ503tpkbUJlnu9uQBb79KYEVmHRWN8/zzIIKLHcmPYWwM88PX4AO3zCO3ICiHIb3oURNkRmISxQV673mbh3m3CoWFnesgMr0X4DCaOZdN8/3e9Ew5nWuuSQe63KbVd7bebZXrlVArMqD8qn04ownbsNjpcTW/L6h3HnZmt8tuvzXkmceO+a7fBe+f4vb2sym86bQl+m5ZH8nmx+eHYNPPerlg0896q17pz5w0u4vpn1ZOajXo67Ud/Slv4Ovp9Z9Hgepvtf7Xr6PlZce46wrlGPOxvjqyuc5wPb/RcDecP5Xt0F+5h337tlRlHvmT4P03O3HcTX2I9Tgr1AjPqNnAR8aRo8IcyQNfVl7esvvydDNzb9CWQO6YhUAAA==


name: Dynamic AI Model Selector with GDPR Compliance via Requesty and Google Sheets
author_name: Stefan
author_username: stefan
categories: []
created_at: 2025-07-10T23:26:33.951Z
updated_at: 2025-07-10T23:26:33.951Z
url: https://n8n.io/workflows/5862
scraped_at: 2025-12-24 13:02:41
description:
  Overview
  This comprehensive n8n workflow provides a sophisticated solution for dynamically selecting and using AI models while maintaining GDPR compliance. It leverages Requesty's European-based AI routing service to ensure data privacy and automatically updates available model options based on real-time API availability.

  Choose Your Integration Approach

  Before diving into the setup, it's crucial to understand that this workflow offers two completely independent AI integration approaches:

  Approach 1: Dynamic HTTP Request Workflow (Advanced)
  Complete infrastructure with dynamic model selection

  What it includes:
  Automatic model discovery from Requesty's API
  Dynamic dropdown updates in web forms
  Model selection persistence in Google Sheets
  Complex workflow orchestration with multiple phases
  Full control over API parameters and response handling

  Best for:
  Teams needing multiple AI models for different tasks
  Organizations requiring model usage auditing
  Users who want maximum flexibility and control
  Advanced n8n users comfortable with complex workflows

  Setup complexity: High (requires multiple components and configurations)

  Approach 2: Standalone AI Agent (Simple)
  Plug-and-play solution without complexity

  What it includes:
  Direct use of n8n's native OpenAI Chat Model node
  Simple configuration: just set base URL to https://router.requesty.ai/v1
  Immediate GDPR compliance through European infrastructure
  No model discovery or selection infrastructure needed

  Best for:
  Users wanting quick GDPR-compliant AI integration
  Single-model use cases
  Simple chat interfaces
  Users preferring minimal configuration

  Setup complexity: Low (5-minute setup)

  Quick Start: Approach 2 (Simple AI Agent)

  If you want to get started quickly with GDPR-compliant AI, follow these steps:

  Step 1: Register with Requesty
  Visit https://www.requesty.ai
  Complete the registration process
  Choose "OpenAI-compatible" integration
  Note your API endpoint: https://router.requesty.ai/v1
  Create an API key (name it "n8n Integration")

  Step 2: Configure n8n
  Add a new OpenAI credential in n8n
  Set the base URL to: https://router.requesty.ai/v1
  Enter your Requesty API key
  Add an OpenAI Chat Model node to your workflow
  Select your Requesty credential

  Step 3: Test
  Your AI agent is now ready and GDPR-compliant! All requests will be routed through Requesty's European infrastructure.

  Advanced Setup: Approach 1 (Dynamic HTTP Workflow)

  For users who need dynamic model selection and advanced features, follow this comprehensive setup:

  Prerequisites
  n8n instance (self-hosted or cloud)
  Requesty API credentials
  Google Sheets integration
  Basic understanding of n8n workflows

  Phase 1: Requesty Account Setup

  1.1 Registration Process
  Navigate to https://www.requesty.ai
  Sign up with your email address
  Complete the welcome process

  1.2 Integration Configuration
  Choose Integration Type: Select "OpenAI-compatible"
  Note API Endpoint: https://router.requesty.ai/v1
  Create API Key:
     Provide a descriptive name (e.g., "n8n Dynamic Workflow")
     Click "Create API Key"
     Important: Save this key securely - you'll need it for n8n configuration

  Phase 2: Google Sheets Preparation

  2.1 Create Storage Sheet
  Create a new Google Sheet named "AI Model Selections"
  Add the following column:
     A1: "Selected Model"
  Note the Google Sheet ID from the URL

  2.2 Configure Google Sheets API
  Enable Google Sheets API in Google Cloud Console
  Create service account credentials
  Share your sheet with the service account email
  Download the credentials JSON file

  Phase 3: n8n Workflow Configuration

  3.1 Import Workflow
  Download the workflow JSON file
  Import into your n8n instance
  Review all nodes and connections

  3.2 Configure Credentials

  Requesty API Credentials:
  Go to n8n Credentials section
  Create new HTTP Request credential
  Set authentication type to "Header Auth"
  Header name: "Authorization"
  Header value: "Bearer YOUR_REQUESTY_API_KEY"

  Google Sheets Credentials:
  Create new Google Sheets credential
  Upload your service account JSON file
  Test the connection

  Google Sheets Nodes:
  Update sheet ID in all Google Sheets nodes
  Verify column mappings match your sheet structure

  Phase 4: Troubleshooting Guide

  Common Issues and Solutions

  Models Not Loading:
  Verify Requesty API credentials
  Check network connectivity and API endpoint URL

  Selection Not Persisting:
  Verify Google Sheets credentials and write permissions
  Check sheet ID configuration

  Chat Not Responding:
  Verify selected model availability
  Check API request formatting and response processing

  Debug Procedures
  Enable debug mode and detailed logging
  Check node outputs and data flow
  Validate API calls with external tools
  Review n8n execution logs

  Conclusion

  The choice between approaches depends on your specific requirements:
  Simple AI Agent**: Perfect for straightforward AI integration with minimal setup
  Dynamic HTTP Workflow**: Ideal for complex requirements with multiple models and advanced features

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.n8n","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.n8n","n8n-nodes-base.formTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.chatTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.code"]

workflow_json_compressed:
  [encoded data, 4228 characters]


name: Convert CAD & BIM (Revit, IFC, AutoCAD) in DataBase (DataFrame)
author_name: Artem Boiko
author_username: datadrivenconstruction
categories: []
created_at: 2025-07-11T05:50:35.160Z
updated_at: 2025-07-11T05:50:35.160Z
url: https://n8n.io/workflows/5867
scraped_at: 2025-12-24 13:02:45
description:
  A minimal workflow to convert a Revit/IFC/DWG project into analysis-ready XLSX (and optional DAE) with a single run. Set two variables, execute, and the converter does the rest.

  What it does
  Inputs:** path_to_converter and path_project_file (RVT/IFC/DWG).
  Runs:** RvtExporter.exe "&lt;converter&gt;" "&lt;project_file&gt;".
  Outputs:* writes &lt;ProjectName&gt;_rvt.xlsx (and _rvt.dae if enabled by your converter).

  Prerequisites
  Windows** host (local executable + filesystem).
  DDC Revit toolkit installed: C:\\DDC_Converter_Revit\\datadrivenlibs\\RvtExporter.exe.
  A local project file you can read.

  How to use
  Import this JSON into n8n.
  Open “Set path to file and converter” and set:
     path_to_converter: C:\\DDC_Converter_Revit\\datadrivenlibs\\RvtExporter.exe
     path_project_file: e.g., C:\\Sample_Projects\\your_project.rvt
  Run Manual Trigger → the command node executes the converter.

  Notes & tips
  Ensure the path points to the executable inside datadrivenlibs.
  Use ASCII-safe paths; ensure write permissions next to the project file.
  This is intentionally simple: chain it with your own Parse/Transform/Load steps as needed.

  Categories
  Data Extraction · Files & Storage · ETL · CAD/BIM

  Tags
  cad-bim, revit, ifc, dwg, converter, xlsx, dae

  Author
   DataDrivenConstruction.io 
   info@datadrivenconstruction.io

  Consulting and Training
  We work with leading construction, engineering, consulting agencies and technology firms around the world to help them implement open data principles, automate CAD/BIM processing and build robust ETL pipelines.

  If you would like to test this solution with your own data, or are interested in adapting the workflow to real project tasks, feel free to contact us.


  Docs & Issues:  
    Full Readme on GitHub

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.manualTrigger","n8n-nodes-base.set","n8n-nodes-base.executeCommand","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE91Xy3LbNhT9FRTpovUINkmAL8100dh5beI2Tpp0Qo8M4mExpggVBGVpPJ7Jrst20UXbVT+g3fd7/AP9hV5Q8ltOk7SraqEhxcuLc+8596ETXEk8xLvzBy+ef/342YIl4dH9+UM8wBPlOB6e4KppHW+EeuLtNOdpoMKwTMM0DqOcp0zLjDJJWRxqKcIsieIsL8NEJplUMqA6DwVPy1AJwcMInw5wwycKXDVZMwpHz9SscqMnD7dHOy8fjbZNM1O25a4yzaitJtNaARLHD1s8fL0Prxqp/OXJEnWQ8JznsiRCyZiwiJaEUx6SXKcsZ1xxGqb44sA9V4mjBXpqXO90MV2hIL1XUvJWbba9zcpkatrKI4ED4ygbRBEDCFNuwZ0DlD45wtTG4mE6wMeVdGM8jJNggMeqOhw7PKQB3AjTONXAHb53D539+ttff/6AnlvTlbVqx8a4qjksmicaLUyHVCNMB+YWKWuNbZHsLDxHYpkXwDJApUJtZxVyBlmllYV34GaskJor0TkOfhFwVsnlrxsbB5I7Lm01U01dle3BxgbSppbKbqIXrTeqWjTlbjwsmqI5ODhwau7gEu/sbI8ezKfGAp7Rq+WnKK47K4pX8/m50SYgKHDvo2i8bBSXyOjhe3hd78WrxfP0zTJ2PAxPByvqY0lpGgcRkUAyYYrGJGdZSDgoVEVJEGmdraU+/GDuGbBI4OsW+SvKKbtCeUijq5Sf/fEjMLBiV1cN5KOzQJ2pWzRW9VR39cbGAIHOAQFYwpueOYug5qynHsjyb1jVAzJ2gUyDXj+q3OOu3P9s7Ny0HW5tHVZu3JWbwky2LvnxvpzthA9jS3AZ+UekLzgCBUeg4MjOo6dkWk1VXTWKHIMXcik1MuN1JftaJN858/km8gL51sNpu6knqw+hRV2LoFStmSnEIUIffdV0Ckk1U7WZegGbqWpQa+rOe2tBf7YXJwCedE3lFp8UzTvIznUkaR5pQhWlhKVwBVVPiZdAEiRaJ5G8JPvlGM4SNZDpTz57+/ODvjAUOjb2SNfm+OztL3eKYMKbjtfPbXV4qOwNHWSggzC5KYN3wRbQGnlCoBkGhNFAkTwvFVFlTlUsWU7zK7D3lOvL0Be2ruqLXAIbrodyh2qVuw4zybJ1MLGZ9rlfIuZtWx02ExBp/+za7Xl3zUUpmRI5kTpihIUqIyVLOUmjgDMhy5TS8hK+hz5yZrQGMagQmIB7EFTnf9geFgW0Hgvt40swnaD7pjoyRbGj2iNnpkUBMRbFv5csmfDqv3Tke9f2eXzL0XW7IT6buautDF/IgXNQA0tSkgW6BBUnHBgUIUnSKGNpBg91cCOfUFRvlHAjr4f/YT73uJ/wo6+WUQL6KIgoslyAsivR9k9XKdi0M4dP909vVhvdZBcJzmQoIJGcgBeYCanOSakZJ3FOdRSWIZVCXyZ4RaTvEb4Vrc6B0Qn1x9Gyc8Kclb5ZTe4sv+XQVdvQyKBer1ditr5hYLEyHuIvCnxy8umb1jSvi9sVVGCIt8DoltFVWayM4OQVlF3YB7zrd/RTKlQg0zglaRL6RAUZ4QxmqdZ5qqOM0iQUa4dn9MHDM4HhSKIgu2tzYhebU5hHVzanjN3cnH7/3m9Ou029QBMjK73oaZtxW/mVx49TWIpgRJ29/QnB4LELWGyAW1W3y87fIt45MwENCl7Xi3ekJ9QsKjNYJqgINKyVZUnKKIa+nSq/9JZU35Ee+nG7RRSv08iNxdK39Yv0sORaevb6TRnBmRczbk14cAaHZWAG8DSHrAwwzA6v//7ApXrAdNfC/gFOZ6H3sarffvmXgukE+j6hMpeExVFOMp3kJEiCMku5EDGLcY+rUeJ82PzTXAML3wwgFzB3fMY+vjR7PwP4wyLVHA+D0/19COC9toF1IN53Hq859fT0b9VlVsZXDQAA


name: Validate CAD and BIM Files Against Excel Standards (Revit, IFC, AutoCAD, DGN)
author_name: Artem Boiko
author_username: datadrivenconstruction
categories: []
created_at: 2025-07-11T05:55:45.745Z
updated_at: 2025-07-11T05:55:45.745Z
url: https://n8n.io/workflows/5868
scraped_at: 2025-12-24 13:02:44
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  CAD-BIM Multi-Format Validation Pipeline

  This workflow enables automated validation of CAD and BIM files in multiple formats (Revit, IFC, DWG, DGN) for compliance with project standards and requirements.

  Key Features

  Converts Revit, IFC, DWG, and DGN models into open data tables
  Runs automated validation checks on model naming, structure, attributes, and completeness
  Generates error reports and QTO (Quantity Take-Off) tables for all processed files

  How it works

  Upload one or more project files in Revit (.rvt), IFC (.ifc), DWG, or DGN formats
  The pipeline automatically processes each file and validates against configurable rules in Excel form
  Error summaries and QTO tables are generated 
  All outputs are available for download as Excel 


  Converter Path:**  
    Make sure the converter executable (e.g. RvtExporter.exe) is placed in DDC Exporter\datadrivenlibs\.  
    Specify the full path in the workflow settings if required.



  Troubleshooting:**  
    If conversion fails, double-check the path to the executable.
    Only supported formats can be processed (see GitHub Readme).
    Review logs in /output for error details.

  Docs & Issues:**  
    Full Readme on GitHub

  Consulting and Training
  We work with leading construction, engineering, consulting agencies and technology firms around the world to help them implement open data principles, automate CAD/BIM processing and build robust ETL pipelines.

  If you would like to test this solution with your own data, or are interested in adapting the workflow to real project tasks, feel free to contact us.

  Author
   DataDrivenConstruction.io 
   info@datadrivenconstruction.io

  Docs & Issues:  
    Full Readme on GitHub

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.readBinaryFile","n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.readBinaryFile","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.writeBinaryFile","n8n-nodes-base.executeCommand","n8n-nodes-base.set","n8n-nodes-base.readBinaryFile","n8n-nodes-base.if","n8n-nodes-base.executeCommand","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.merge","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:
  [encoded data, 8396 characters]


name: Generate Interactive Quantity Reports from Revit and IFC Projects to HTML
author_name: Artem Boiko
author_username: datadrivenconstruction
categories: []
created_at: 2025-07-11T05:57:27.985Z
updated_at: 2025-07-11T05:57:27.985Z
url: https://n8n.io/workflows/5869
scraped_at: 2025-12-24 13:02:44
description:
  Revit to HTML Quantity Takeoff Generator

  Automates extraction of wall quantities from Revit models and creates a professional interactive HTML report.

  Key Features

  Automated wall quantity analysis
  Calculates volumes by wall type ("Type Name")
  Generates interactive HTML QTO report
  Includes summary statistics: total elements, total and average volumes
  Provides detailed breakdown by element type

  How it works

  Upload a Revit file as input
  Workflow extracts wall quantities and types
  Creates and saves a ready-to-share HTML dashboard with QTO data

  No API keys required
  Runs offline
  Output is a professional, ready-to-use HTML report

  Consulting and Training
  We work with leading construction, engineering, consulting agencies and technology firms around the world to help them implement open data principles, automate CAD/BIM processing and build robust ETL pipelines.

  If you would like to test this solution with your own data, or are interested in adapting the workflow to real project tasks, feel free to contact us.

  Author
   DataDrivenConstruction.io 
   info@datadrivenconstruction.io

  Docs & Issues:  
    Full Readme on GitHub

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.set","n8n-nodes-base.executeCommand","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.readBinaryFile","n8n-nodes-base.spreadsheetFile","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.function","n8n-nodes-base.function","n8n-nodes-base.writeBinaryFile","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.if","n8n-nodes-base.set"]

workflow_json_compressed:
  [encoded data, 8908 characters]


name: Generate Personalized Marketing Emails from Google Sheets with Llama AI
author_name: Oneclick AI Squad
author_username: oneclick-ai
categories: []
created_at: 2025-07-11T08:47:06.226Z
updated_at: 2025-07-11T08:47:06.226Z
url: https://n8n.io/workflows/5875
scraped_at: 2025-12-24 13:02:45
description:
  An AI-powered email marketing automation workflow that generates personalized marketing emails using data from Google Sheets and delivers them directly to clients. This workflow combines the power of AI content generation with spreadsheet-based campaign management for seamless email marketing automation.

  What's the Goal?
  Automatically pull marketing offer details from Google Sheets (Sheet 1)
  Fetch client information from Google Sheets (Sheet 2)
  Use AI to generate compelling, personalized marketing content
  Format emails with professional structure and personalization
  Send targeted marketing emails directly to clients
  Enable scalable email marketing campaigns with minimal manual effort

  By the end, you'll have a fully automated email marketing system that creates and sends personalized campaigns based on your spreadsheet data.

  Why Does It Matter?
  Manual email marketing is labor-intensive and lacks personalization at scale. Here's why this workflow is a game changer:

  Zero Manual Drafting**: AI generates unique content for each recipient
  Data-Driven Personalization**: Leverages spreadsheet data for targeted messaging
  Scalable Campaigns**: Handle hundreds of clients with a single workflow execution
  Consistent Quality**: AI ensures professional, engaging content every time
  Time Efficiency**: Transform hours of work into minutes of automation
  Cost-Effective**: Reduce marketing team workload while increasing output

  Think of it as your intelligent marketing assistant that creates personalized campaigns at enterprise scale.

  How It Works

  Here's the step-by-step process behind the automation:

  Step 1: Track Offer Updates
  Node**: Track Offer Sheet Updates (Sheet 1)
  Function**: Monitor Google Sheets for new marketing offers or updates
  Trigger**: Automatically activates when new data is added to Sheet 1

  Step 2: Generate Marketing Content
  Node**: Generate Marketing Content with AI
  Function**: Process offer details through AI model (Llama 3.2)
  Process**: Creates compelling marketing copy based on offer parameters

  Step 3: Fetch Client Information
  Node**: Fetch Client List (Sheet 2)
  Function**: Retrieve client names and email addresses from Sheet 2
  Data**: Pulls client_name and client_email for personalization

  Step 4: Content Personalization
  Node**: Format Personalized Email
  Function**: Combine AI-generated content with client-specific data
  Output**: Creates personalized email for each recipient

  Step 5: Email Delivery
  Node**: Send Marketing Email to Client
  Function**: Deliver personalized emails directly to client inboxes
  Method**: Uses Gmail integration for professional delivery

  How to Use the Workflow

  Prerequisites
  Google Sheets Setup: Create two sheets with the required column structure
  n8n Account: Access to n8n workflow platform
  Gmail API: Gmail account with API access configured
  AI Model Access: Llama 3.2 API credentials

  Importing the Workflow in n8n

  Step 1: Obtain the Workflow JSON
  Download the workflow file or copy the JSON code
  Ensure you have the complete workflow configuration

  Step 2: Access n8n Workflow Editor
  Log in to your n8n instance (Cloud or self-hosted)
  Navigate to the Workflows section
  Click "Add Workflow" to create a new workflow

  Step 3: Import the Workflow
  Option A: Import from Clipboard
  Click the three dots (⋯) in the top-right corner
  Select "Import from Clipboard"
  Paste the JSON code into the text box
  Click "Import" to load the workflow

  Option B: Import from File
  Click the three dots (⋯) in the top-right corner
  Select "Import from File"
  Choose the .json file from your computer
  Click "Open" to import the workflow

  Configuration Setup

  Google Sheets Integration
  Authenticate Google Sheets: Connect your Google account in n8n
  Configure Sheet 1: Set spreadsheet ID and range for marketing offers
  Configure Sheet 2: Set spreadsheet ID and range for client information

  AI Model Configuration
  Set API Credentials: Configure Llama 3.2 API key and endpoint
  Customize Prompts: Adjust AI prompts for your brand voice and style
  Set Content Parameters: Define content length, tone, and structure

  Gmail Integration
  Gmail API Setup: Enable Gmail API in Google Cloud Console
  OAuth Configuration: Set up OAuth credentials for email sending
  Sender Configuration: Configure sender name and email address

  Content Customization
  Email Templates: Customize email structure and branding
  Personalization Fields: Map spreadsheet columns to email variables
  Brand Guidelines: Set company colors, fonts, and messaging tone

  Workflow Execution

  Manual Execution
  Click "Execute Workflow" in the n8n interface
  Monitor execution progress through each node
  Review generated content and delivery status

  Automated Execution
  Set up triggers based on sheet updates
  Configure scheduling for regular campaign runs
  Enable webhook triggers for real-time processing

  Best Practices

  Data Management
  Keep spreadsheet data clean and formatted consistently
  Regular validation of email addresses in Sheet 2
  Update offer details promptly in Sheet 1

  Content Quality
  Review AI-generated content periodically
  Adjust prompts based on campaign performance
  Maintain consistent brand voice across campaigns

  Deliverability
  Monitor email bounce rates and engagement metrics
  Maintain clean email lists with valid addresses
  Follow email marketing best practices and regulations

  Performance Optimization
  Batch process large client lists for efficiency
  Monitor workflow execution times
  Implement error handling and retry mechanisms

  Troubleshooting

  Common Issues
  Authentication Errors**: Verify API credentials and permissions
  Sheet Access**: Ensure proper sharing permissions for Google Sheets
  Email Delivery**: Check Gmail API quotas and sending limits
  AI Processing**: Monitor API rate limits and response times

  Error Handling
  Implement retry logic for failed operations
  Set up notification systems for workflow failures
  Maintain backup data sources for critical campaigns

  Security Considerations

  Use environment variables for API keys and credentials
  Implement proper access controls for sensitive data
  Regular security audits of connected services
  Compliance with data protection regulations (GDPR, CAN-SPAM)

  Conclusion

  This Smart Email Marketing Generator transforms your marketing campaigns from manual, time-consuming tasks into automated, intelligent processes. By leveraging AI and spreadsheet data, you can create personalized, engaging campaigns that scale with your business needs while maintaining professional quality and consistency.

  The workflow represents a significant advancement in marketing automation, combining the accessibility of spreadsheet-based data management with the power of AI-driven content generation and automated delivery systems.

nodes_used:
  ["@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.gmail","@n8n/n8n-nodes-langchain.lmChatOllama","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheetsTrigger","n8n-nodes-base.googleSheets"]

workflow_json_compressed:
  H4sIAAAAAAAAE+1ZTW/cxhn+K+NNgEjqckVyuZ+108qSLLuWLceSHASx4Qw5w92R+BXOcKW1IMA59FA0TZDGPRR1G6BA0d56yCWn/hj9geYn9Jkhd0VZa0W+5NSDpF1y5v143uf9mNFJQ7DGsNHrTz95zBO53XlhU/bR/UazEXNFG8OThkikoknA7+l1jHUHPKRh33XcoOdR5trdnm0zx/Z67QFrt91Bp9+n3bAd9tt9h3pd6vWdsO0FgyBw+w7kKh5nEVV8PedM7nJVZOspnnDFoUDlBT9tNhIac2jbjWmuyGZMRUQe0PyQK5GMyBZPeE5VmpOJoGTzOOAR+QVZu0eWdsecK6JSci/x0+NlrYyOZGP46TOITBnXH09Kh3kv9LxOu2e1e5xbXsD7Vp8NqOV2uMM7jusHPm/MDalU8poV62mieKLIkVBjKNe6pple++ukn6zixzIarYgmo2BMRdKiI6zHuiyVQok0gTGW69rNvg3zMppDleK51Jgrfqwg6tYnaUFozglNCD/OOMCQNOKSBGk2PcoFlrfIbSo5I2lC1JiTLE8ngunvYchzwqiiTTKaWU8JZMiCSjHRMhnhcaotoVE0JTwZ0ZH2DDJmj0nMpYTdJATaH4+pkmtZRvC5jInCE6LXTiBdEhHHnAmtKCikSmMYQAMtqPU0eZr8+N1X/yYrKzv+AcfDCR+urDxNNpMgLXKtIStywCQhxoctcYbP4oU2Z0KjgjeJDydCoWSTFDkcCqbN0oPjICrgj1DTMhSUMBBXRJw1YVAGA8Ji7kdlyLdfwpA7aR7D/K0CeEUi4dIYZJH7nGekSBisdzo2OUpzJlv6xb7kRI7TXDVJzimjfsSJ2XgBnVWuoTEb7iWwjXHSPnv5bYcc8SiywPyAG9wPRLlvIhCQiNAs47Tc9rEOLBEJXDmiedxEZNQYPlKpRDAHwmI5QETU04TPzfPTiJFxmh4CpiDiNNfBZEWg3gZfzqGi8m8XyReoAnQzQMZFpATyElgAAo5shbdSSbL02c0i+vCzZWN+CXElS4MiIoRihvPvdcANEzfAxArgPaEiPiQnJ+T9AwlyKP2dnJ7qdxtCghCJqr1m1aNqxRMaCQYVtRWT6lG14lHpspzhz2pLKzjkc1G9q/bs5ALcRxwe5SKoG5dWL55n+sUbVmL7m+vZ/NWFHbfTpIBBqH21tb55WC5YRw7qyrVmEqa2KFDULMEiy6pg/TtgfVBl5jxqBl2nhQe6aFa5EFAVjKeaQhxhB39IiTbohNRyQEx3RkYdwksxQSDdFrkLRpUS5wWD6LpWaAOWeGvUapKzl69zHuZcjskUKU2kmka8efbyr/pNkY1yikwwbyJIw/NlyG4bc8H2q/AjE3lFPC7aXSMLofAJZpRp5bXINth7NRPKpCvpXforMx6IELDN8mfmbkj9XGcjniGldCS0Px1gJUbjCD9IORQRgGjqVylZ8iCFtZWCStLnSH+Qt0kmqM1UifKLpBNESGqh3RZYxqVuNpeoY5xM5lWQk5EIZ8FPysjO9KD+fqHF9Vqo3mV55bNiUO5YlFAGXkQwErHQfEddD3T0Kgadff09RPYhEssqzlUNoaIJCuTFEJWE1lwPUDEQ+zs7D3ZaFwj+z/+A4LtUTwVkp1BZoUhZrQ3H9YpX/yDba7t7ZP3u2sP1zQXF5Ab8/fJvevFjlKWpVneZnr8iWzn10cZA/5WVykVLiZijidBoZQWNTDdOZkod9t0otf/xB7KToGVeydqlhaTcuXPnCjIvA+pXOvYo5WJEkvTIaDx7/S/YpzvM2cs/1+qaRkNz6WlCyM1IfPjjd9/8CQk1RZ0ek92xQB1AhhNf4zw2/SpIFRqGcQcFx2J0ikcxvqqbqxBQE/SKrEdUSlB/zzoXhfkhRPsuBSRTIotYt/mJ8Hkl4OaqMUjD9Jc//PeHr43hU4JJBrajxm2ncO6eumT72etXejWYHosinmUFQYeukviCgdXqJ1XKcFNU5NysNAjA7zRZtGe9CmmZnk2ATEYFiika/eFlH776Ag5sztPL1HHYviATNTyaWrAi57yM29ffY/fdIs+nN7Cn7IQ8YXJhqukKVUuyimvf/I5spAmwQ1pTUUbhzVwCTzTBZYRw6ilQcoq3uuYYmt+oJdfZ69/CpIepms87D+ghN7tms56eEXXuNqvxw4xZ1XBoBoW1SSrQ7lM/1Q0FkM9GejbvCvOJpKp1OjCzUaScz8qGMy+rMJ8nY33OeGOOsFBapB5KynkmNHXATOCzhoTm1SwHs3Ica14cbeuj1UYKrBSpSr7+jOkNpmG4huWmZkkNm4YjNYWnhYE9zcwLDOY4mujpOFN75azPYHzCG6fl8K/ZaOZ697RZHTN82nN83rctv9N2Lc9mHavvs9AKPN8PvT6ORNw+P2ZUI+mjKgAo0KyctM9PF+cHCx/DcivAx4tHinZ34YniQK7rpcMGOhDaoBlSJblFwLdYtmKaLelP5NaH5knLsGszFjRa/uXTJMcpLU/IpzqTTvQvQvSC4ewL0cXEGCqHlejWQSqSpaeNJnnaWG7OlpWYkiF5f+mDnz5TfbDcCkUu1dJyaU+5u5R1qv/g1zOYdxX+YZs7XYdaCIJveR0f+HcGDOHwbC/kttv1/HP8yS6Ss2ZPdcpJUQpFeXZbHIVRFaNaGDr9KgxH3NcDuTk92zg0U8ceWHY7tC2cPwOr73YDbZfH+x3mOqGJ5oXIofGzvVSfBudpP0cbyW9O6iZxLyypkDbvL/BXFuYAhsWmHOG1CVhFaHPwxCq0ZgaPEX9jg3FwZ61QY9dcCWhnHgV7n0+29gfFepGEkdqsnZYNbDQom56F8iAh9FKQWs48TJ2e3wcubQsw9C1v0KMW7dmBFfrtsDNw2z6zu+fytyMaU9JuucQM+3E6J84DxCS6xlE8itfRTHciLeiNE7nj2c22fTmBYiN62DB7oNtyurZtD3XZk+oiyJfxS82utUzM0ZtsjA/uJpvh+O6Yb4xYzbvSKmuSF3KsxGXczlEDtwc295jF+jQEal3P8nsByB3aTo+5dq8b1u4wdlGsD6dEl/63ElmaNdWSOip9oGItguVIMDVuDD3QvTHmeu5FZG18CcqQQMeeHq90dw0j9ClaqNSa3UiUTUCalpjVq148z8GqUpXjpr7PQHtNY6KOUrKVpiO0fnPrI4e6u5UXQM6wlsPV8bPsOedr3GGV1Jimyp4CT/Xrewq6jGH6SslEvTarYljKcI7XgisHm1VLQt9QzZo7wlxEcRqM0bmMIn1bNbscWFC0zuPa58zzXOZaQa/nWF7XGVj9Qbtj8a7ntD2/1+m7wXlc93IaHFZulr7tZ8xgW92HOctvL1wGwRLAPQyjI1MQ6oH3vIXt5GJLBL33MDSbN7p9mGu2uOw3HMea6QORFODU6TNdgLS2h8b2k8bz53lU3vo1Zxv0JQOMMMcmoNLpeT23P3AHoBTA5Owxl0Wk9vW+xlipTA5XV1kayMoZtMR4VWZ6iDCa5CpbdQ4fP97YTX/z8MWTj9b2Mfh98mLt0Lq/fzt4cDAu9o/sR1O2dbDt+5tPRqsc49h7I8FunatuXNT9sEooLd7VcYT6IkaIdZG/hk+Nd7Gn8XP6/atCZrfMxZJkh4u9Xq+u9p5XY1xjQblbQKuyedQr4O10Y29v0tnu9raebLfviFr/qOc1eWsDOU8Yznm7HaCR2h0HPaRHueXbg56FFsJd2nVs12vXpiyukJRV9ptLgSpR3OslysUMca6RIO9G+YYmn/2zxv29RSrrNHf+T/NmA61rrFke0DL2GM3yCQ7ua+Wks2huMjbXWb8b7O6694+3PtrfLh4pNn0L69/Gea/VPQXXqLlBbwxD6AH8kpsTkVHJj3lQaPt29KWtnjRM7CalBDOG+oNO0KW0a3XtLsbQ0O1YA5fZVujwbhjaXZ9RU/LSJOHBjMZXHE70dISpCsmAsp+UVLj2KG12NhsiYfy4MbRPn+kecVWKLtJ2jYPTQj0/NUlCFxXPZ4fa6llN77v8X+iSoDeNuYawhb5fp5wt9P46k8Mije/i9QLFp6f/A7GRDJF1HAAA


name: Automate Restaurant Customer Service with WhatsApp and Llama AI Chatbot
author_name: Oneclick AI Squad
author_username: oneclick-ai
categories: []
created_at: 2025-07-11T10:37:59.902Z
updated_at: 2025-07-11T10:37:59.902Z
url: https://n8n.io/workflows/5881
scraped_at: 2025-12-24 13:02:41
description:
  An intelligent WhatsApp-based chatbot designed for restaurants to automate customer interactions related to table bookings, menu inquiries, opening hours, services, and offers. Built using the n8n automation platform and powered by an AI language model, this solution streamlines communication, boosts efficiency, and improves customer satisfaction.

  Objectives

  Automate replies to common customer queries on WhatsApp
  Handle table booking requests with confirmation
  Provide menu item details, pricing, and dietary information
  Share restaurant timing, location, and service availability
  Promote offers and handle promotional queries
  Operate 24/7 without manual intervention
  Store bookings and conversations for reporting and analytics

  Workflow Summary

  Step 1: Message Reception

  Node: WhatsApp Trigger (Webhook or API-based)
  Function: Listens for incoming customer messages.

  Step 2: Intent Recognition

  Node: AI Query Processor (e.g., OpenAI API)
  Function: Detects customer intent (e.g., booking, menu, timing).

  Step 3: Conditional Routing

  Node: Switch or IF Node
  Function: Routes flow based on detected intent:

  General information (menu, timing, services)
  Table booking

  Step 4A: Respond to General Info Queries

  Node: AI Response or Static Reply Node
  Function: Returns relevant information (menu, timing, address, etc.).

  Step 4B: Process Booking Requests

  Nodes:

  Collect Booking Details** (via chatbot interactions)
  Store Booking Info** (to DB or Google Sheets)
  Send Booking Confirmation** (to customer)

  Step 5: Context Management

  Node: Set/Update Customer Data
  Function: Maintains conversation state and tracks follow-up messages.

  Database or Google Sheet Columns for Table Booking

  | Column Name       | Description                                     |
  | ----------------- | ----------------------------------------------- |
  | reservation\_id   | Unique reservation identifier                   |
  | guest\_name       | Full name of the guest                          |
  | contact\_number   | Customer’s WhatsApp or mobile number            |
  | email             | (Optional) Email address                        |
  | booking\_date     | Reservation date (YYYY-MM-DD format)            |
  | booking\_time     | Reservation time (HH\:MM format)                |
  | party\_size       | Number of guests                                |
  | table\_id         | (Optional) Table number or identifier           |
  | special\_requests | Allergies, seating preferences, etc.            |
  | status            | Booking status: Confirmed / Cancelled / Pending |
  | created\_at       | Timestamp when booking was made                 |
  | updated\_at       | Timestamp when booking was last modified        |

  Prerequisites

  Verified WhatsApp Business Account with API access
  n8n instance (Cloud or self-hosted)
  Access to an AI service (e.g., OpenAI, Claude)
  Google Sheets, Airtable, MySQL, or other DB integration

  Setup Instructions

  Connect WhatsApp API using webhook or third-party WhatsApp provider (e.g., 360Dialog, Twilio).
  Integrate AI using HTTP Request or OpenAI node for response generation.
  Create Data Store (Google Sheet, Airtable, or MySQL) with defined booking columns.
  Design Workflow in n8n with intent detection, conditional logic, and response nodes.
  Test End-to-End by sending different WhatsApp queries and checking logs and stored data.

  Example Conversation

  Customer: “Can I book a table for 2 people tomorrow at 8 PM?”
  Bot: “Sure. Please provide your name and contact number to confirm the reservation for 2 people at 8:00 PM tomorrow.”
  \[Booking details are saved, and a confirmation is sent.]

  Benefits

  Fully automated customer interaction
  Supports real-time table reservations
  Accurate and quick responses
  Scales without increasing staff effort
  Operates 24/7
  Centralized booking data for analytics

  Analytics and Reporting

  Track key performance metrics such as:

  Number of bookings per day/week
  Average response time
  Customer satisfaction scores (via feedback node)
  Popular menu items or query types
  Booking conversion rates

  Security and Compliance

  End-to-end encrypted WhatsApp messages
  Role-based access to sensitive data
  Compliance with data protection regulations (e.g., GDPR)
  Secure API integrations and storage solutions

  Conclusion

  This WhatsApp chatbot serves as a reliable, AI-powered digital front desk for restaurants. Built using n8n and scalable components, it automates customer support, manages bookings, and enhances operational efficiency while offering a seamless customer experience.

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.whatsApp","n8n-nodes-base.wait","n8n-nodes-base.whatsAppTrigger","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOllama","n8n-nodes-base.if","n8n-nodes-base.postgres","n8n-nodes-base.whatsApp"]

workflow_json_compressed:
  H4sIAAAAAAAAE+1Y227cyBH9lQZ3gbWF6VneLwKCxJYtrwDLlm3BgndtCM3upqYtskmTzRmPhQH8D3kKkGCBfJq/IJ+QKpJzkWbG2uQhT3nRcIbddTtVp6p0YylhHVovX7VvP7768qmZFU9O4/DCGlmFNMw6vLGUbgzTXJ7gOSHCRGYsi13H5ZHPhGuHkW0Lx/YjLxGe5yZBHLMw87LYix3mh8yPnczzecK5Gzsg18iiypmRR7UUzRtp2uqohF+kkaDA1K1cjCzNCgnaLibMNI+qihzBQ1oa8u3rX8lrCfa0NdOGnOisJI+aRqGFhjx4XJbXSl81I3IqdTsi56qArw9RKbtqrMPfPoDoUkh8vOkdd5PE5o6f0MBhMfUz+MMSFlI3kz73pe+mkWutDHpjFL+ekxelkSh0XuGPOta0k0pT1shx050ZjlRlo4wqNSikrmuPaOjaYETFahBoZN1ghGdKmIl16Ni2PbJ4qY3UBuT+8AM5n6iGzMr6OsvLGanKGdwgjKziwoe4GPgkTDfde942pixkTT61ECpQDlfSsjWkXkfOdJEZkaKLU9rHbUQaWU8VlxBApgUpswzkjd/r9xpsOTGkbSSqR62kAI9z8uD589OHxJSk1QLOGrwGamuFB+EZVFYlfPJcsjqfk6laW98JthZ9HN/C7S5OzmI0QOO5zAuj1KeAj6B+lMU0SZlD/diLIld6dhD6G9BIUPNaVqAEzDkaYrAXpdlgxG2MQi8cUcdHiGYynUBYuqxnoR0lic8pJIRPfRH7NBYxp5EbcOFzkdheB/YtVI38bB6XYg73/3RzQ3782JR6DDBUgMRiAcfLStasV2w1YD1KmJRavmiLVNad4iCwPTfwPAc+/SiAE0yIzliWHyuZC9QEEawlV5WCtDlbC1jqffDTa8mlmsp12pzKpmFX8qeHYwXVOO4sw7xj3DS/2R/GM3apBBoJojmUKQhWLO9zdZDxqFIdOaCVqX32+fzJmbj48kVf6OyZtVXA1EDqEWuxH2zf56HvODZNAG0KTylNpOPSJPa9wLHDJBQbdXjBlCHHZY1kAPnV7K/GGZy8jbGTAMbuFsYi4QGQG6euyBj10ySjcZIFNAozNxC2EK7v3MV4y53xRvbarpPFQUptm2XgUJTS2HZdKniQRU4kfZZGa4f2QXRv/p7X6uqqy/NNqvGBSXb4GLohlFJqw/sYyM5JJWXA2DQDdmZJDH/iLR8hTTsO6d1tKwHUjfwJ/aGzsLE+7M+SwbrNZPlonFn6xLCnRf5LdXbMt5OFdNnyvWSBdpJ5YRJQEQQJ9T2WUqBpm0rfgfSxE59JuZb79LOpIbNXnEBeAUHN15H9C4T253V4c6avgOGUHoN3+k7yUCdeRXa73G+V+jI+WFD4cpwCGSwrfxlSq5k3UIJLtOH+wcG7siWslkC0E5lXWZt3TJoBp2oB7LZF/hnUAdsg9/HBwXt9MZEaqXrpMxIMcvdg1Yhc1VJi45AF9JUceABEo56qLqdKyJ6xoSNMyho7R5UjpQOzwg211VoOkcoPNltz32Aa8gBYTsPTzzyHKOorMinbunmIp89Zmstl7yHgBLgA/aejRMKmTOUsVWDZHA9jQyfIViAyK0tBEDzoU1VZtTmriVDNBL83FVAhZOHDO/bkJe8Fl3gW+LKzHg+9GXpe3+6kIA+E0pIqPSKGXUs2Y/MRgV4H5VnPO7FnteJoMoaLt3UNWTL0Snx7VOpM1cXgE8fRKc+745sOYsBOMozmGiPWXDekgUczwfOtriUOSmII+wbEow6ROYT9X7///k9y8O3r30++ff1bARkDiQPHMXPITJnJxiW6FLcCb0wuyjYXZA4Zl6vr7ua1hkkDMFoiuJwRwBeECrwwiNufv339x8HgxCqrCEwrre4yB88rzYfJbrQaBNCmTbOPVgbAQSA2yDtWq2yOP63TDKJCTjCWECOc9roLqTRQfCtDHuWAVEOupaz6sJYaEGt61Ls0Hg2Z3k83CobHuoDXU7maRCD5i8qc97wgZAaJsD2gjJMVESUudx3mAck7DEYUySOaRNKlMogd6BtelnWEOhDRM6mx48thTOngeXTyB4goL3AAfpnnrGB3+ChxgY622aibzkBkd8Ubu9QJYbo8RPwbc4uBFtvsXXa3Nkl7khw9fXxcvHv0vPCOp79ma596owjjvGz1d0lbiAA2gjSmnhdhgw1tGgcRzFQ8hi+xK2G3WMs9mkh+TSC5epYYJnuI3KcWqlfs7Ysqux0g3wl38/Wttga50o9Vd15Z06Uf7sjKZWbesrxFraCEgzoYOlHTVPaby+A7y5VYDXYGyMJ0g1RZpEozU+Jkxrpxb1PtciGx3Rh2DjuhcWrHOOs6lKW+TQMYNkUaiRAmwdXwiLJuliHLVA7OjZdvxhAqBHQVKTRFX90ZPIdDi9vuDeGGs9DAJ6ufYfi8xLq8nOIPl0g21uLDFubu2F2hHmYiCf0IhvgodakPYx5NskTSJLSzME4iFoViA/VaYn28kLPbuO+FG5A20MmaHWO8t6tJo1B8uLys8yVmWCsoGU0YWdPBV7Ae/Go4NEi250auulpa3qjaNFe8hzpviyGB+pc3G7JwCy1YVYFfp70g1prylFUnGnaDJ8xgjQMxcewCR0tReIsZXJ7NeXnUcVtHVPAqAwRll034Y78XnJdverj7t4t7Sn4Vx2XF++/8T0+Pn306dq/r7PUvv64xOhuO7pnS3HG4Aj8LWBBzmVDuAeS+nWYwzyeMem4sY+kw2O68OxvcstCHLtqz93+/0MXBKhP+v9D9TxY6TFPeU+KQlw30aZwkULz8LHmL7r6sRefR1EGbBprtQuSlUvDEDymXATAGY4ymcQi7f5jaMkyDJHXSnjv1MMWh4O2NELsgNE9IAqBW3RfaH+4q3c2RpbSQn61De/EBl5w9i8QuRd9ZUHeK3jMagGimLnEQaAHe076pb6i5b7XZunxX717C3eXUf1igOx3du+juUnifezs13Ifxzry4t+9sqRrdict3/vW0w8zF4t8EmRKveRUAAA==


name: Dropbox File Management Automation Suite for Bulk Operations
author_name: Khaisa Studio
author_username: khaisastudio
categories: []
created_at: 2025-07-11T13:48:41.301Z
updated_at: 2025-07-11T13:48:41.301Z
url: https://n8n.io/workflows/5886
scraped_at: 2025-12-24 13:02:46
description:
  🚀 Why Choose MCP - Dropbox?

  Save Time:** Automate bulk actions like copy, move, or delete folders—no more endless clicking.
  Reduce Errors:** Automated rules keep files organized and error-free.
  Work Smarter:** Let automation handle the routine, so you can focus on bigger things.
  Full Dropbox Control:** Manage uploads, archiving, and clean-up automatically.
  Ready to Grow:** Build custom triggers and workflows to suit your needs.

  👤 Who’s It For?
  IT/Admins:** Automate backups, archiving, and file recovery.
  Freelancers & Creators:** Easily handle multiple projects and clients.

  ❓ What Problem Does It Solve?

  No more manual folder creation, risky bulk moves, or messy searches. Everything’s automated for accuracy and speed—giving you peace of mind and lots of saved time.

  🔧 How It Works

  Trigger: Workflow starts with any new Dropbox action.
  Automated Operations: Create, move, copy, or delete folders/files as needed.
  Search: Find specific items instantly.
  Download: Pull files or folders for backup or edits.
  Upload: Add new assets to the right place, every time.
  Cleanup: Archive or remove outdated stuff—automatically.

  🛠️ Getting Started

  Import the workflow .json into n8n.
  Connect Dropbox:
     Create a Dropbox dev app and set up OAuth2 in n8n.
  Tweak Settings:
     Update folder paths, file names, and trigger events as needed.
  Assign Credentials:
     Use your OAuth2 credentials on every Dropbox node.

  🔑 Requirements

  n8n running (cloud or self-hosted)
  Dropbox account & developer app (OAuth2)
  Dropbox OAuth2 credentials in n8n
  (Optional) Your folder structure for smarter automation

  🧩 Make It Yours

  Add Notifications:** Connect with Slack or email for instant updates.
  Automate Backups:** Schedule syncs to local or other cloud accounts.
  Use Logic:** Filter or branch tasks by file name, type, or metadata.

  ⚙️ Key Components

  MCP Server Trigger
  Dropbox toolnode (for creating, moving, copying, deleting, searching, uploading, and downloading files/folders)

  Created by Khaisa Studio
  Need custom workflows? Contact Khaisa

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

workflow_json_compressed:
  H4sIAAAAAAAAE62XbW/bNhDHv4qh176Oj0cyr1a0ezEM64a124AVwXAkj6lXxwpsNU0R5Lvv5HSz2mYr5NiADQmm/vzd8Z50261qd9a9+OUpxfTqbf/7X+2PH26+65bdJQ/Und12q81uoE3h78d1xaBXIdmGzqmka4mq5aRUY7TORaq6uRyCUypWTqiiQlcxmORatCqU7m7ZbeiSRer5tr/K/c3ix2c/L56+G/pLGlb9Zic7D3Sx685en8vSvvJ4eXtPaXVrmKyCnG0D10qE5GqGWtlarUvOWLp/NxiFX/L2mreLV9vVxQVvR+0PV+N/327i5hv5wn4HWNPmoryh1ebJZbk6LL7qd6sRSgggGLUEbaJQvef8pu/f7h3iAyrjPYJla8ClpCEa7UE8UwsxZl3sqERbgRp4K9bc3t1j/CZ3e3Fzt/xooHHk0PkI3qUILoYKhMaCriFEcS06nhhYtkwDL1q/rlPbDmZl2vGTeu/nV32//swkbdAtE55/BU8f8CxqOUcPWU4fhFXwcixgTUBKIRfl1ASvv/rwCDhtcR6cyl7izkHbw9lWIIeYgUrSpRZuWOoBrvKaH+U7ifB5eBgjJzaApVWQ5AmQMCSQDEm2yCcTHvAu++tHwMWoZrEFKg5DjFBNQXAS00AkQSw/wqW5Npqc63q1G45nC97MYqMg1UU3DYYbSc5XhOgKQatVotEFqUThwPa8f79Z91QXtGirNR/Bh2ZeTtTAKegcQHORc2VNEOU0IanmiITPponvnu/D7ggsl+ZlQ1BeN+UtFFVZno4VYjUOmFECsWQn+ToplftwO85hFuclQtGRq6MCZCVZXVUJyJMEW/OKsEiNie1A9uvV/jiPZDNuZiJYlgZnEUzORdiCheh1lkLSStNoVAn5wPZsX+COI9N6XhpgTllVFcEEI2HWxjBLchtaTE2bqqhNqttLpm15cySbnhdpKiYXDWlgCgFczizuQqluyipvDKMxk571cliVtx8WL/r/yYLdfs3HJV80LOO/gJNWsxl4M4hU99+g1rBy6Bv47CUlimqyHcsPkpeGhtnG+iConk+KHo8HNZm1RqpQkQRUiVuTTgy+6tqUtsTRPghq5oMmicOjQVPWtgTW4BsKqOQOJHIaQvIqKaOkMpoHQe18UGntj/Co9DBElmzORgbHIilNwRfAUKIMLzWl8LBH3RFB6o6IUVlNZVhdy0aN1jtedjsehtXmYv8o33B5N+r/tB2b7ll3rUeN6/vn93NoqlwZFYLSUbJQkwFiMdg1wkro2aQkoAKx4XI/aIvwx3YkV7T6cxgrwdlrGbZHM78yQP+zfinvB5VvujN1d34uTIeaeELRQ3s6oei0Rp5QdtqwTig7HaZPKDud5U4oOx1fT+mET154Tij86dvACYU/n0dPJn139zcsDvSBug8AAA==


name: Unlimited Website Down Checker - Uptime Robot Alternative
author_name: Milan Vasarhelyi - SmoothWork
author_username: vasarmilan
categories: []
created_at: 2025-07-11T13:55:00.759Z
updated_at: 2025-07-11T13:55:00.759Z
url: https://n8n.io/workflows/5887
scraped_at: 2025-12-24 13:02:43
description:
  Video Introduction

  Want to automate your inbox or need a custom workflow? 📞 Book a Call | 💬 DM me on Linkedin

  Get Alerted When Your Website Is Down – n8n as an Uptime Robot Alternative



  If you manage a website (or client sites), getting notified when your site goes down is critical. But you’ve probably experienced alert fatigue if you’ve ever received a flood of downtime emails for every tiny outage. These short hiccups are common, and most monitoring tools don’t let you filter them out.

  Here’s how you can set up website downtime notifications with n8n - no extra subscriptions, and no more false positives spamming your inbox. For your most important sites, you can even get direct text alerts to your phone.

  We’ll use n8n, a powerful automation tool with thousands of templates and integrations. You can run it in the cloud or even self-host it for free.

  Why Use n8n for Website Monitoring?

  Uptime Robot and similar services have limitations or get expensive fast if you monitor several sites. n8n gives you full control - you choose when and how you get notified, set your own timing and thresholds, and you aren’t stuck with default alert logic.

  Plus, n8n can automate much more than just uptime monitoring: use it to handle other business workflows too.

  Quick Start: Free n8n Website Monitoring Template

  Use the template to get started fast.
  Log in or sign up for n8n Cloud, or self-host for free if you prefer.
  Configure your schedule (default: hourly) and list the sites you want to monitor.
  Key setting: wait seconds. Recommended: 300 seconds (5 minutes). If your site goes down, the workflow waits before sending an alert—no notification for a 1-2 minute outage, only real, persistent problems.

  How to Test & Use

  Activate the workflow.  
     Toggle it on in n8n and it’ll check your sites automatically.
  Test instantly:  
     Add a non-existent URL and run the workflow. After the wait time, you’ll get an email alert for that URL.
  Notifications stay organized:  
     Alerts go straight to your inbox (see my AI email labelling template if you want color-coded organization).

  Get Critical Alerts on Your Phone (Telegram)

  Email is great, but for your most important sites you want instant notifications on your phone.  
  Best option: Use Telegram. n8n can send you messages via a Telegram bot—easy to set up, free, and works in seconds.

  How:
  Create a Telegram bot via BotFather (instructions in the template).
  Add your bot token and chat ID to n8n.
  Now, you’ll get downtime alerts right on Telegram—no missed notifications, no extra costs.

  FAQ

  Can I monitor unlimited sites?**  
    Yes, just list them all in the config.
  What if downtime is just a few seconds?**  
    The default 5-minute wait filters these out.
  Do I need a paid n8n plan?**  
    No - self-hosting is free, and the workflow works on free plans.
  Why not SMS or WhatsApp?**  
    Telegram bots are fastest, easiest, and don’t require extra API setup or subscriptions.

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","n8n-nodes-base.gmail","n8n-nodes-base.httpRequest","n8n-nodes-base.switch","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.wait","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.merge","n8n-nodes-base.switch","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5108 characters]


name: Automate Weekly SEO Report with GPT-4 Insights and Slack Delivery
author_name: Marcelo Abreu
author_username: mabreum
categories: []
created_at: 2025-07-11T16:17:34.171Z
updated_at: 2025-07-11T16:17:34.171Z
url: https://n8n.io/workflows/5891
scraped_at: 2025-12-24 13:02:45
description:
  What this workflow does
  Runs automatically every Monday morning at 8 AM
  Collects your Google Search Console from the last month and the month before that for a given url (date range is configurable)
  Formats the data, aggregating it by date, query, page, device and country
  Generates AI-driven analysis and insights on your results, providing actionable recommendations
  Renders the report as a visually appealing PDF with charts and tables
  Sends the report via Slack (you can also add email or WhatsApp)

  A sample for the first page of the report:

  Setup Guide
  Create an account of pdf noodle and use the pre-made Meta Ads template.
  Connect Google OAuth2 (guide on the template), OpenAI and Slack to n8n
  Set your site url and date range
  (opcional) Customize the scheduling date and time

  👉🏻 You can use our detailed guide on how to setup this workflow.

  Requirements
  Google OAuth2 (via Google Search Console): Documentation
  pdf noodle access: Create an account
  AI API access (e.g. via OpenAI, Anthropic, Google or Ollama)
  Slack acces (via OAuth2): Documentation





  Feel free to contact me via Linkedin, if you have any questions! 👋🏻

nodes_used:
  ["n8n-nodes-base.set","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-pdforge.pdforge","n8n-nodes-base.httpRequest","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.code","n8n-nodes-base.slack","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.splitOut","n8n-nodes-base.splitOut","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.merge","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest"]

workflow_json_compressed:
  [encoded data, 10484 characters]


name: Reddit Bot Automation: AI Auto-Reply & Post Monitor with GPT-4 + Google Sheets
author_name: Reddit Dev
author_username: harryhaz
categories: []
created_at: 2025-07-11T21:17:41.498Z
updated_at: 2025-07-11T21:17:41.498Z
url: https://n8n.io/workflows/5894
scraped_at: 2025-12-24 13:02:44
description:
  🚀 Built an AI-Powered Reddit Engagement (Reddit auto comment to relevant posts based on your whish. A workflow That Actually Helps People and helps you to promote your product and service.

    Just spent hours fine-tuning an n8n automation that genuinely adds value to Reddit conversations and to your service, app, business or message that you want to promote. Here's what it does:

    The Challenge: Finding relevant discussions where my service, app, business or message could actually help someone - without being spammy or salesy.

    The Solution: An intelligent workflow that:
    🔍 Monitors multiple subreddits for photo editing discussions
    🧠 Uses GPT-4.1 to analyze comments (not just posts!) for genuine need
    🎯 Filters out bots, moderators, and irrelevant content
    ✍️ Crafts helpful, conversational responses that provide value first
    📊 Tracks everything in Google Sheets for transparency

    Key Features:
    Runs every 3 hours automatically
    Analyzes comment context, not just keywords
    Only engages when the service, app, business or message is genuinely relevant
    Focuses on helping, mentions the app naturally if appropriate
    Respects Reddit culture and community guidelines

    Why This Matters: Instead of blind self-promotion, this creates genuine interactions. When someone asks "Anyone know a good service, app, business to do XYZ?", they get a helpful response from someone
    who's actually built a solution.

    Tech Stack: n8n, OpenAI GPT-4, Reddit API, Google Sheets

    The best part? It forces me to only engage where I can add real value. No spam, just helpful participation in communities I care about.

    What automation challenges are you working on? Happy to share learnings!


  Questions or feedback?: heniykb@gmail.com 

nodes_used:
  ["n8n-nodes-base.manualTrigger","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.merge","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.reddit","n8n-nodes-base.reddit","n8n-nodes-base.reddit","n8n-nodes-base.reddit","n8n-nodes-base.reddit","n8n-nodes-base.googleSheets","n8n-nodes-base.reddit","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.scheduleTrigger"]

workflow_json_compressed:
  H4sIAAAAAAAAE+WX227bRhCGX4XQtdbdM3d91cRACrdID3bQFiiCYnZ3KBGRSEGknBiGgDxG+3p5kg4tV5Jt0pKA5qo3gkTMzn6anf3n592oTKPz0Yfql/rT2xv54/Tq++vf8fVoPJpjC6Pzu1FZNS1UES+7OCUslzrqgAGtl1ZoHZWG4FHJQiYnfIrBqsIbMCi5VZBHKYOLoEDnWlLeFueLGbSbfNLnbu/ZxRJTc43tanFR0xNskYLa5QrX41EFc6QVV5hS2WYs+7lu2iarXJV9rJcfiln9sUsEk2Z0/sd7Cq8Tdl/vNn/QqtwIh8CsDY5p9IKBVIIll3sUCkQh+Gi7yW9TrLI4K+OHsppkXz7/9Q6bdrvPl89/d1vdLrpQAmD3e7EADZ7NoVrB7N2ynExwSVGLuinbsq6IhDk+lpYT2wKWtE+LSwK8W29S/Uq/7uPEevzAnIQsIEbJlFGcaW0sAyUlA5vAQOC+0MWO+acFVq8us4sptNlbAprtGL8lyG92oDOoJnEKZXU2m3fh9yvLx7BCcT62zhykPZNbXgNFwugSy4ORTLsCWPA+MOOCEo7aIOq0432Lywlml9Vi1Q5Xs4t5AmaojPpwGdUWS0Cho4uK8VzS0UcuWeCSftJHnuiZAbHDelPOKONDd72+zd4gtKsltdIQY1k8BsyP45N7hZNRBsydZF7ogghDZEGiZ9ZJ7wQakNYME17UVYvVcBGfAgrHTyZUUXoeVMHAKc20IlYQ1jKRkta5iIZL3BFe4wxjm/2AVL4SZ2m4eA22T+D4cXDqTG/hSJKkCg4Z947uSdScucQNS3RHks81Gq53cK8qmN02ZfNv3bKuhq8uj7gtMNmUeR9XyqNwxVm+xUWfRChi6soomA6FJWXwnkkfsSg4iBT3avkdtpujHqzh8l4RH3MZS7f38OXdMhW5Tx5EzniIhkqIiQWtEvM+UrfkYKOIPUziZCh5CpXIFQeVa4Zgcqa7D6KRTDqbW4BuAskeKnky1TEnuDs/6vgUfcGQxINpWWjm8jwyy63lrpsnheihUqcf4Cm1chKA5MMw5zXdUETHvKazpGOU0WG0GFMPlT6Zyp1CBUDXMeWeRfIK1PCRFCQUgjmwwJ2hAwTYu5oLmkQpW9Yfs7LKminisKpN6noyw+supnkMKRUpsDl8ovrMbjlzB2RtCmSkw8C0lZqFqIDaDRTNWRvt/qglm0JmJYMs1vN5JyFECxkhDOP2VfMeVJ3SekCDglTDsBgdDQpH50vcikWfEL0jVFD7E7ZpSLMIbX6kH6h7nIDkx0qc2zkB64UQoZsU3tLF5TkDxMBScsY4p0lr9uTkwS2dZ1erKsMbXN5mKpvWq+ULcyNOMa1mOGi0jD4CWK4pBmJb3tAWBcwaHI9oIrVk+h4W3GyCN16VTESIZBw8T+QjgnKM/G5kuUwGNfdJp87LxrqqaPrRqi7Hnn7TjzkVmQDJlHb/5Si3cb9kTC484afROV+/f09YewL8NbLKr5JVfZWs+r/Muu9Jj0n7zHoNZH18D/syHyMpT5OPt6tfFM5epudvC0QF5Z+dFqwI9uHZHuFB3/Rs9dM9n9vCvkoc3Kf3//RVYC/7JmYgcx9F79tJ785DPdGfdUCRj8q8beK+1C947t7kL4huX/oeGzrcjn3+8IhoeVK0OilaHyjH4Tf+/19V1ut/AO656DkeEgAA


name: Get Any Image: Standard Fetch with BrightData Web Unblocker Failover
author_name: phil
author_username: phil
categories: []
created_at: 2025-07-12T09:01:35.049Z
updated_at: 2025-07-12T09:01:35.049Z
url: https://n8n.io/workflows/5905
scraped_at: 2025-12-24 13:02:46
description:
  This workflow is your ultimate solution for reliable image retrieval from any web source, including those heavily protected. 

  It operates with a smart, cost-effective strategy: it first attempts to fetch the image using a Classic Image Getter node (a standard, free HTTP request). In approximately 80% of cases, this method will be sufficient. 

  However, for the remaining instances where you encounter IP blocking, CAPTCHAs, rate limiting, or other advanced anti-bot measures, the workflow seamlessly switches to a robust BrightData Web Unblocker service as a fallback. It leverages BrightData’s Image Unblocker to retrieve these blocked images.

  This template is indispensable for anyone needing consistent and complete access to web images, ensuring you get the data you need without unnecessary overhead.

  Why Use This Image Scrapper Workflow?
  Maximum Success Rate**: Retrieves images even from the most challenging or protected websites.
  Cost-Optimized Strategy**: Prioritizes free, standard HTTP requests, only incurring costs when advanced unblocking is truly necessary.
  Automated Resilience**: Intelligently handles failed direct attempts by automatically engaging the BrightData failover via the "Unlock Image" node.
  Versatile Image Scraping**: Perfect for market research, content aggregation, or data enrichment that demands reliable image access.

  How It Works

  When clicking ‘Execute workflow’: The workflow is initiated manually, allowing for easy testing and integration into larger processes.
  image: A Set node defines the target image URL. This can be easily configured to accept dynamic URLs from preceding nodes.
  Classic Image Getter: This HTTP Request node performs a direct image download. It's the primary, free, and efficient method for readily accessible images.
  Unlock Image (BrightData Web Unblocker): Configured as an error handler and failover, this HTTP Request node activates only if the "Classic Image Getter" encounters an error. It then routes the image URL through BrightData's Web Unblocker, designed to bypass advanced protective measures and successfully retrieve the image data.

  🔑 Prerequisites

  To enable the advanced capabilities of this workflow, specifically the BrightData Web Unblocker functionality, you will need a BrightData account and a correctly configured Web Unblocker zone.

  Setting Up Your BrightData Web Unblocker:

  BrightData Account: Ensure you have an active account with BrightData. If you don't, you can sign up on their website.
  Create a Web Unblocker Zone:
      Log in to your BrightData dashboard.
      Navigate to the "Proxy & Scraping Infrastructure" section, then "Zones."
      Click "Add new zone."
      Select "Web Unblocker" as the product type.
      Give your zone a clear name (e.g., n8n-image-unlocker).
      Confirm the creation of the zone.
  Retrieve API Key:
      Once your Web Unblocker zone is active, go to its settings.
      Locate your API Key (often referred to as "password" for proxy access) within the "Access Parameters" or "Credentials" section.
  Configure in n8n:
      In the Unlock Image HTTP Request node within this workflow, update the Authorization header. Replace "Bearer yourkey" with "Bearer YOUR_BRIGHTDATA_API_KEY".
      Important: For production workflows, it's highly recommended to use n8n credentials to store your BrightData API key securely, rather than hardcoding it directly in the node. This template uses a placeholder for demonstration purposes.
      Crucially, ensure that the zone parameter in the Unlock Image node matches the exact Zone ID you created in your BrightData account. You will need to replace the placeholder web_unlocker with your actual BrightData zone ID.

  Phil | Inforeole | Linkedin

  🇫🇷 Contactez nous pour automatiser vos processus

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE5VV227bOBD9FUHdh13AdCiJuhnYh6SbtEaBJkjd3YfWKChyZKuRKC9FNUkNA/2M3d/rl+yQviWug2YfBIjkzPDMmTPDpd+A4f5o6VeqM1wJGEt/5DMeBLyURSTisJQ0zyACDnnJJSuivJRlUBRCQsDCMs4TLiVniUjzGKIkKaIw8VcDX7USOn/0AUPbkEkqiiKMMpLQRBAmC0pylgYkZUkILORSlImPXrwBtP5rDsoTdSVuKjXzvn/75/wORG/Au231TVm3t9+//YvW5n5hrVWmiLuOFLyDYcNVz+uJrmYz0Gi1aLvKVK1CMIQxOogSOsVdrvEuAxpBLlfrWH/iyhkGq8EGt8gKpCLNCC8yRlgchiSPIk7SlDImaMRoIPe4q4bP4ElgHZgDOGF4FI7fLqzFBhnvumqmGlDGnT1a7ujlEGZxGhNKaYwwy4TkVJQkjUtMoIg5FuxJmJ3RSDOuv/C6txtzYxbd6OQE7nizqGEo2ubE+Qw/L2b+aro65Csash1jRRxFWRxkJMwDZCxLApLFCScikEwGIGlZxnsoL2ubj/DGNrz3CoxxNTtOoMV1DX/30FkiW3WudattkVplKtWDW1/2ZtEfEH2c5V7X6Pz7cun98rlr1dCl6K1WNvauAL6pGmgx4ChAbm3mGoy+v1QXvEJ3o3s4IIMNwx0ZNKIM9RMQYHFCWAgR4UBTIgUUeZiKKAO+J+O9qltxs+bimSSo1tg280tE034B7VnL/0dOROkA++IJerZa4ItqWGBPzY3khjtJ6B0KdJq3Nt+ry3eTx/Rp6Bb4C4f/ChDtBuOaxLKv6+udxXpv63HR6oYbm2dVg2+rwGscA+8V7/FmXX0F+RK07Qjrh8cdKHnWyvttILt+DVy63NZbBR5fPcr4Yf7YWZuqfG0VPGiOWyg+9a5QqFRb6I2ZpWtvdURVD2zLdTp7c81vbV8N/LnD+BxYp5vMuSvjPtQZcI06WC7PrsevXk/+OJ2cfppcvjl/ayG41nWaGasLJHDP8/M1necyBo4NHsSAsyaXQHhJGQkliCCkaRTSfK/pdwan+L33Fu98ejA6m43JA2WGGR3g94My52B1iB2J49PpG4chRn3xwtt00Jrz06vxR/VRfRirTujKSdIj3oUG8PB14PX01624Z2AOxe1CkG2hf/N/fCKm7m4FYqf19VzFn4ZXFr8tlm3Hn405Zz7AN1jCnT+iq6lVwlGXB7Gng33444PjaNhnPa3HUqh+Gny1+g+80uBnUAgAAA==


name: Automated Job Applications & Status Tracking with LinkedIn, Indeed & Google Sheets
author_name: VipinW
author_username: vxi14
categories: []
created_at: 2025-07-12T09:05:22.338Z
updated_at: 2025-07-12T09:05:22.338Z
url: https://n8n.io/workflows/5906
scraped_at: 2025-12-24 13:02:41
description:
  Apply to jobs automatically from Google Sheets with status tracking

  Who's it for

  Job seekers who want to streamline their application process, save time on repetitive tasks, and never miss following up on applications. Perfect for anyone managing multiple job applications across different platforms.

  What it does

  This workflow automatically applies to jobs from a Google Sheet, tracks application status, and keeps you updated with notifications. It handles the entire application lifecycle from submission to status monitoring.

  Key features:
  Reads job listings from Google Sheets with filtering by priority and status
  Automatically applies to jobs on LinkedIn, Indeed, and other platforms
  Updates application status in real-time
  Checks application status every 2 days and notifies you of changes
  Sends email notifications for successful applications and status updates
  Prevents duplicate applications and manages rate limiting

  How it works

  The workflow runs on two main schedules:

  Daily Application Process (9 AM, weekdays):
  Reads your job list from Google Sheets
  Filters for jobs marked as "Not Applied" with Medium/High priority
  Processes each job individually to prevent rate limiting
  Applies to jobs using platform-specific APIs (LinkedIn, Indeed, etc.)
  Updates the sheet with application status and reference ID
  Sends confirmation email for each application

  Status Monitoring (Every 2 days at 10 AM):
  Checks all jobs with "Applied" status
  Queries job platforms for application status updates
  Updates the sheet if status has changed
  Sends notification emails for status changes (interviews, rejections, etc.)

  Requirements

  Google account with Google Sheets access
  Gmail account for notifications
  Resume stored online (Google Drive, Dropbox, etc.)
  API access to job platforms (LinkedIn, Indeed) - optional for basic version
  n8n instance (self-hosted or cloud)

  How to set up

  Step 1: Create Your Job Tracking Sheet

  Create a Google Sheet with these exact column headers:

  | Job_ID | Company | Position | Status | Applied_Date | Last_Checked | Application_ID | Notes | Job_URL | Priority |
  |--------|---------|----------|--------|--------------|--------------|----------------|-------|---------|----------|
  | JOB001 | Google | Software Engineer | Not Applied | | | | | https://careers.google.com/jobs/123 | High |
  | JOB002 | Microsoft | Product Manager | Not Applied | | | | | https://careers.microsoft.com/jobs/456 | Medium |

  Column explanations:
  Job_ID**: Unique identifier (JOB001, JOB002, etc.)
  Company**: Company name
  Position**: Job title
  Status**: Not Applied, Applied, Under Review, Interview Scheduled, Rejected, Offer
  Applied_Date**: Auto-filled when application is submitted
  Last_Checked**: Auto-updated during status checks
  Application_ID**: Platform reference ID (auto-generated)
  Notes**: Additional information or application notes
  Job_URL**: Direct link to job posting
  Priority**: High, Medium, Low (Low priority jobs are skipped)

  Step 2: Configure Google Sheets Access

  In n8n, go to Credentials → Add Credential
  Select Google Sheets OAuth2 API
  Follow the OAuth setup process to authorize n8n
  Test the connection with your job tracking sheet

  Step 3: Set Up Gmail Notifications

  Add another credential for Gmail OAuth2 API
  Authorize n8n to send emails from your Gmail account
  Test by sending a sample email

  Step 4: Update Workflow Configuration

  In the "Set Configuration" node, update these values:
  spreadsheetId**: Your Google Sheet ID (found in the URL)
  resumeUrl**: Direct link to your resume (make sure it's publicly accessible)
  yourEmail**: Your email address for notifications
  coverLetterTemplate**: Customize your cover letter template

  Step 5: Customize Application Logic

  For basic version (no API access):
  The workflow includes placeholder HTTP requests that you can replace with actual job platform integrations.

  For advanced version (with API access):
  Replace LinkedIn/Indeed HTTP nodes with actual API calls
  Add your API credentials to n8n's credential store
  Update the platform detection logic for additional job boards

  Step 6: Test and Activate

  Add 1-2 test jobs to your sheet with "Not Applied" status
  Run the workflow manually to test
  Check that the sheet gets updated and you receive notifications
  Activate the workflow to run automatically

  How to customize the workflow

  Adding New Job Platforms

  Update Platform Detection: Modify the "Check Platform Type" node to recognize new job board URLs
  Add New Application Node: Create HTTP request nodes for new platforms
  Update Status Checking: Add status check logic for the new platform

  Customizing Application Strategy

  Rate Limiting**: Add "Wait" nodes between applications (recommended: 5-10 minutes)
  Application Timing**: Modify the cron schedule to apply during optimal hours
  Priority Filtering**: Adjust the filter conditions to match your criteria
  Multiple Resumes**: Use conditional logic to select different resumes based on job type

  Enhanced Notifications

  Slack Integration**: Replace Gmail nodes with Slack for team notifications
  Discord Webhooks**: Send updates to Discord channels
  SMS Notifications**: Use Twilio for urgent status updates
  Dashboard Updates**: Connect to Notion, Airtable, or other productivity tools

  Advanced Features

  AI-Powered Personalization**: Use OpenAI to generate custom cover letters
  Job Scoring**: Implement scoring logic based on job requirements vs. your skills
  Interview Scheduling**: Auto-schedule interviews when status changes
  Follow-up Automation**: Send follow-up emails after specific time periods

  Important Notes

  Platform Compliance
  Always respect rate limits to avoid being blocked
  Follow each platform's Terms of Service
  Use official APIs when available instead of web scraping
  Don't spam job boards with excessive applications

  Data Privacy
  Store credentials securely using n8n's credential store
  Don't hardcode API keys or personal information in nodes
  Regularly review and clean up old application data
  Ensure your resume link is secure but accessible

  Quality Control
  Start with a small number of jobs to test the workflow
  Review application success rates and adjust strategy
  Monitor for errors and set up proper error handling
  Keep your job list updated and remove expired postings

  This workflow transforms job searching from a manual, time-consuming process into an automated system that maximizes your application efficiency while maintaining quality and compliance.

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.cron","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.filter","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.switch","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.cron","n8n-nodes-base.googleSheets","n8n-nodes-base.filter","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.if","n8n-nodes-base.googleSheets","n8n-nodes-base.gmail"]

workflow_json_compressed:
  [encoded data, 5184 characters]


name: Auto-Generate and Post Instagram Reels with Veo3, OpenAI, and Blotato
author_name: Automate With Marc
author_username: marconi
categories: []
created_at: 2025-07-12T10:50:21.978Z
updated_at: 2025-07-12T10:50:21.978Z
url: https://n8n.io/workflows/5910
scraped_at: 2025-12-24 13:02:41
description:
  📱 Veo3 Instagram Agent – Create & Auto-Post Reels with Blotato

  Description:
  This no-code workflow automates the full pipeline of generating and publishing Instagram Reels using Veo3 (via Wavespeed API). From prompt to post, it handles content ideation, short-form video generation, caption writing, logging, and even automatic publishing to Instagram via Blotato.

  Perfect for creators, brands, and marketers who want to scale content creation without needing to shoot or edit videos manually.

  🔗  Watch the full step-by-step tutorial on how to build this workflow:
  https://youtu.be/s-KzxeKWmIA?si=6x8WKMeiyWodZWVq

  Google Sheet Template: https://docs.google.com/spreadsheets/d/1bA-PQTrvekC1Rti-XumGANgjIwLjvcFCqoIxVCYsq2E/edit?usp=sharing

  🚀 What This Workflow Does:
  Trigger via Chat or Telegram
   Start with a simple message like:
   "Make a reel for a luxury minimalist candle brand using calm aesthetics."

  AI Video Prompt Generation
   Uses OpenAI to craft a visually rich, platform-optimized video description prompt.

  🎞️ Video Creation with Veo3 API
   Submits your prompt to Veo3 to create a short video (9:16 ratio, 8 seconds) with motion, tone, and trend styles.

  ✍️ Caption Writing
   An AI agent writes an engaging and playful caption based on the video content.

  📄 Google Sheets Logging
   Stores prompt, video URL, caption, and status in a GSheet to keep track of all generated assets.

  📤 Auto-Publish to Instagram
   Posts the video + caption directly to Instagram using Blotato’s social media publishing API.

  🔌 Tools & Integrations Used:
  OpenAI for prompt & caption generation

  Wavespeed API (Veo3) for video generation

  Google Sheets for tracking

  Blotato for scheduling & publishing content

  n8n for orchestration and automation logic

  💡 Use Cases:
  Content calendar automation for small teams

  Trend-based ad creation and testing

  UGC-style reel generation for e-commerce

  Rapid ideation & creative experimentation

nodes_used:
  ["@n8n/n8n-nodes-langchain.chatTrigger","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.wait","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5756 characters]


name: Preventing Google Sheets Quota Errors during Batch Processing
author_name: Viktor Klepikovskyi
author_username: vklepikovskyi
categories: []
created_at: 2025-07-12T11:50:37.367Z
updated_at: 2025-07-12T11:50:37.367Z
url: https://n8n.io/workflows/5911
scraped_at: 2025-12-24 13:02:46
description:
  Preventing Google Sheets Quota Errors during Batch Processing

  This template provides a robust solution for dealing with Google Sheets API rate limits. It is designed for workflows that update a large number of rows in a Google Sheet and frequently fail with "too many requests" errors.

  The template uses a Wait node connected to the error output of the Google Sheets node, creating a retry loop that delays execution for a set period before attempting the update again.

  To use this template, simply replace the placeholder Google Sheets nodes with your own credentials and sheet. You can find an example Google Sheet for this template here.

  For a full explanation of this approach, check out the blog post here.

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.stickyNote","n8n-nodes-base.splitInBatches","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.wait","n8n-nodes-base.wait"]

workflow_json_compressed:
  H4sIAAAAAAAAE+1Y6W7cRhJ+lQa9PzbAcMSjeQkwFrYsJ8rGkmNJdgzbcJrdxZmOOGya3dSxgoA8xu7r5Um2ujmnNHJsr7P5E0HAkOxi1Vd3Fa89KbxdT8JJ1cVHp+nh6bNi7wfqjbwZGObtXnuy0YY1HA4sXV7kIc0KXiY5/hU8SMqQJsBA0ChMklDEGaNVVYUhK6OsEHFFM0pZmmQZT4MgQr4GZm3NDOx1IPQxmL7dU/gEDKAA0/VwM/IaNgOU9ryDc2iMbCbkW6UmNZDjKYDR5MdeGUb2u051moi+sxSPmeFT8rxTHLTGB1YUm2hv9807ZKgE2MvrQd28SoI8jxIfeJL4VNDCLzMBPs+4ECKCPIkKbwnj1RQawmvJz6yc33799/4l8N4AuVDdWVWri99+/Y+VdtVa6iZvfCfOL5mG8Yw1PatPOjmZQIdUrdLSSNUgmGAU5TmCa1mHggx0iPD6ZmD0Eu8cVXgzmoMGCmnJGfNFleY+DZLMz5MQ4VcQB5wzIYJ8BfrYIN4rcqgM3ItNO5o5yQYwP6T0NjLvQgoz9XaLLBp5U5CTqfF2ozwYeVw1Bv2EAh48IP+T0942b5uTqdRkESWk7dS5RMSEkU6VvTZEq7q3QEmlOiKA1ZbRhTTTW/IePT8gnWVRy5k0ekwODEHOyEtOGhDu9YUHUeCUGdK3wr7ASM26CZCmn5XQEVWhaCSRDZ6syyCsQTYdfOhR4fqKVEzWA5K3nlGKoO+viDvWRr/1CDjdx4OSsNKx106/n18xaX4m1kEETdoAx5wgRiE2GN4lqjdtbywi+2xTX/veiPAOmDM+2gtMd0VqpdpBOwE1u9IEXPQuDMiIRkVa6KQSpAR8hPobC81xsWIWVpkw2QzglYWMZ2uOGhEt8crqi/cc3JvuaqpqgVa8C1YPtrpSPSp20VjowkYOq7WzrLakY/Ja9YQzRCvxGf7CJbP1YtMTVpUNPOTNFDp49/epMa3e3dkRiuvxxL0y5mq2o1s0lHAi9I7YCaf/vHgevf823Wcvj7+vP7z6LvzX62cvf2FdWfD+8WWWP3l/Gn/3uBPTH3dASPOPXrcP9ZTZMP7GWeWps2bV1zVCRAwNc0Z2vkJgrMVQZnyKLpoCP7OudDYqazUhmHzmNmJMVuRyVSp15hBbmp0oiJKdINuZooFs4PuDSv6giM9a6duY94eY9yXme97sfDP27q8rRZjyLOeBH+csxWrCU5/FZeQzltFKhHlRFdGqrvxgw+noHB16gKbW99eWtpbmoHEJDnqzvlCaj8IiulNgVGsJXBW8DTdewk3jivEKIp/TMvYpiwI/L0osiCm35bDKRRmu4O6jq8hTCbX4CFQwm/hSrHBbSvM6vpHHtK0jMwxYd7Zxu+gzlOVZkhWRn6ZU+JQXmc+qLPLDKIl4nnKeUrbCikXm/VBy1qAu7s9Z3dsHD6+vyd9+0aoZr8jJzY23tA8XNGPY3tB/IkOZGfcLyrkfJlmCnQ1TLEhWMg8/Xd6eqlU3rqGZYNKuSyzTDHIeF34VVwX6IaR+USbCL9I8S3mZsjQt1hsTM/2aM7Tphm69kPjk6HDfu3l3NwTGdClSBCKMk5L7OS1RZEJjv6hY4ON4UhUlJJwGYiXyBWb6Zv25NxaGdFoSqcb1K2tWZXtaD+7+yJXhzaCJIvr7QVPJ2j4/PbAnTuEhWrBIn/Xty7kFXuw/evIauQ9P0e79rFlZDk0z8ly+Hzr1rr3377t6mJ1wbENdkLaW2qzZdCLFwwDvORYgEC9A97U5tS95f1R9fLBN5OE8BCzX0JYklNrbnLHD5afo8Tkw/q/qunYgOnkOWpxt1/pEtuRBsovV6PLucPTBDUdwyQG54anUGhW2ZabHJoGhx9kQZ56G7lxyeMS56nHmQpK1vmmtOGj1qJVuerfZ8rRUj+Iz9tNxA9/P9r/9aZUZCxADTzJnStiC+e0cpON0mYNxkAdVkWc+JCXFtC+wEGdJ4FPA6ypJ4iCpVpJOhyHij87CPN86VeOLNon0Mu2GdNTopBlb1WtX4raUJiG1bcWL2LQjnezsvlKhzWF5Pnf0gouAiqH7n9kWuCTFSeYxnGoQJ2p+MOw8cwT3VsfPg7Bk8yUYbveEL8SwZPMlGD7aC+/gmKnzNRg2k4+a+lNxboj6HKwYZDOc6tA2z4ZihbmKBO1Bg2H5hBnb2meWHin2FvH3Zl0ecpjP2idqTzU4VZkT1FWvJA8PhwHmRB0PnhhOMX43eovCIX5RJIaR3furT/zVJ/70PhFQygT++2GV4EBacFwtOPaJKMpCltKA8She+9iCO/C9feFiOLxV75PI1vsLKKc4L7nPVLQqcceIcZHJUpy789xecZwRi7gUnBZlVtkZeLNF9I20nzBm2F+M21jYzCmHM3B4d30arxaooChYXojAz0SQYPvLGQ6jovQZZWUkQLCEBZsKhp+hoZ0r/ywNbX3iBoN1WZBwV7LfBRy75YeEow4XfORy7ricDxwczEzEHMIK3R6h22mWIsIwQEvh6hPHZVIEkd0t51875rVsiAH8nTFpLYDduRmy/ONDhCMfebIRcOntBjfv7KA8mHsbs49tBVtZre+SXwnd7W16je270Yrz1i12K8MtSm2Deu8Wf4fpGopbkbtV/lYbfFUEv+fvT/lY+xXC4ebmv4a5D487FwAA


name: Viral Video Creator: Fal.ai AI Videos → TikTok, YouTube & Instagram Automation
author_name: Reddit Dev
author_username: harryhaz
categories: []
created_at: 2025-07-12T15:44:43.610Z
updated_at: 2025-07-12T15:44:43.610Z
url: https://n8n.io/workflows/5916
scraped_at: 2025-12-24 13:02:45
description:
  🎬 The AI Viral Video Factory: From Concept to Content in Minutes

  This n8n workflow is a fully automated pipeline that takes a creative concept and transforms it into a polished, platform-ready short-form video. It ideates, generates video and audio using AI, merges them, and publishes the final content to your social media accounts! 

  ✨ Core Features

  Automated Ideation**: Leverages GPT-4 to generate unique, trend-aware ASMR video concepts, complete with captions and hashtags.
  AI-Powered Visuals**: Uses Fal.ai to transform text prompts into multiple cinematic video scenes.
  Custom Soundscapes**: Generates matching ASMR audio tracks to enhance the sensory experience.
  End-to-End Automation**: The entire process, from idea generation to social media publishing, runs automatically on a schedule.
  Content Management**: Logs all ideas and final video URLs into Google Sheets for easy tracking and management.

  🛠️ Setup and Configuration Guide

  Follow these detailed steps to get the workflow running. You'll need accounts for n8n, OpenAI, Google, Fal.ai, and Blotato.

  Prerequisites

  n8n instance (self-hosted or cloud)
  OpenAI account with API access
  Google account with Sheets access
  Fal.ai account with API access
  Blotato account for social media publishing
  Connected Instagram and TikTok accounts in Blotato

  Step 1: Google Sheets Template Setup

  This workflow requires two separate sheets in a single Google Spreadsheet.

  Create a new Google Spreadsheet
     Go to Google Sheets and create a new spreadsheet
     Name it something memorable (e.g., "AI Video Factory Data")
     Note the Spreadsheet ID from its URL:
            https://docs.google.com/spreadsheets/d/SPREADSHEET_ID_IS_HERE/edit#gid=0
          You'll need this ID later for the workflow configuration

  Sheet 1: Idea Logging
     
     This sheet stores the initial ideas generated by the AI.
     
     Create a sheet and name it exactly: Ideas
     Set up the following columns in this exact order (case-sensitive):
       
       | Column A | Column B | Column C | Column D | Column E |
       |----------|----------|----------|----------|----------|
       | Caption | Idea | Environment | Sound | Status |
     
     Do not add any additional columns or headers

  Sheet 2: Final Output Logging
     
     This sheet stores the links to the final, published videos.
     
     Create a second sheet in the same spreadsheet
     Name it exactly: Published
     Set up the following columns in this exact order (case-sensitive):
       
       | Column A | Column B | Column C | Column D |
       |----------|----------|----------|----------|
       | final_output | thumbnail_url | status | created_date |
     
     Do not add any additional columns or headers

  Step 2: API Key and Credentials Configuration

  You need to obtain and configure credentials for each service used in the workflow.

  OpenAI Configuration

  Get your API Key:
     Go to platform.openai.com
     Navigate to API Keys section
     Create a new API key and copy it

  Add to n8n:
     In n8n, go to Credentials &gt; New
     Search for "OpenAI" and select it
     Paste your API key
     Name the credential (e.g., "OpenAI account")
     Save the credential

  Update the workflow:
     In the nodes LLM: Generate Raw Idea (GPT-4.1) and LLM: Draft Video Prompt Details (GPT-4.1)
     Select the OpenAI credential you just created

  Google Sheets Configuration

  Set up OAuth2:
     In n8n, go to Credentials &gt; New
     Search for "Google Sheets" and select Google Sheets OAuth2 API
     Follow the OAuth setup instructions to connect your Google account
     Name the credential (e.g., "Google Sheets account")

  Update the workflow:
     In all Google Sheets nodes:
       Save Idea & Metadata to Google Sheets
       Save Final Video URL to Sheets
       Retrieve Final Video Data
     Select your Google Sheets credential
     Enter your Spreadsheet ID in the Document ID field
     Ensure the sheet names match exactly ("Ideas" and "Published")

  Fal.ai Configuration

  Get your API Key:
     Sign up at fal.ai
     Go to your dashboard and get your API Key
     The key format is: key xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

  Update the workflow:
     No separate n8n credential needed
     Find these HTTP Request nodes and update the Authorization header:
       Generate Video Clips (Wavespeed AI)
       Generate ASMR Sound (Fal AI)
       Merge Clips into Final Video (Fal AI)
       Poll Video Generation Status
       Poll Sound Generation Status
       Poll Merge Status
     In each node's Header Parameters, replace {{YOUR_FAL_AI_KEY}} with your actual key
     The value should be: key YOUR_ACTUAL_FAL_AI_KEY

  Blotato Configuration

  Get your API Key:
     Sign up at blotato.com
     Get your API key from the dashboard
     Connect your Instagram and TikTok accounts
     Note down the Account IDs for each platform

  Update the workflow:
     In these nodes:
       Upload Video to Blotato
       Publish to Instagram
       Publish to TikTok
     Replace {{YOUR_BLOTATO_API_KEY}} with your actual API key in the Header Parameters
     
  Set Social Media IDs:
     In the Assign Social Media IDs node
     Replace {{YOUR_INSTAGRAM_ACCOUNT_ID}} with your Instagram account ID from Blotato
     Replace {{YOUR_TIKTOK_ACCOUNT_ID}} with your TikTok account ID from Blotato

  Step 3: Workflow Activation

  Test the workflow:
     Use the manual trigger to test before scheduling
     Monitor each node's execution
     Check Google Sheets for proper data logging

  Schedule automation:
     The workflow is set to run daily
     Adjust the schedule in the Trigger: Start Daily Content Generation node as needed

  ⚙️ Workflow Breakdown

  Ideation & Storage
  The workflow triggers on schedule. An AI Agent generates a unique ASMR video concept and saves the Idea, Caption, Environment, and Sound details into your first Google Sheet.

  Scene Prompting
  A second AI Agent takes the approved idea from the sheet and creates three detailed, cinematic scene prompts designed for text-to-video AI.

  Video & Audio Generation
  The workflow makes parallel API calls to Fal.ai:
  Generates a video clip for each of the three scenes
  Generates a single, corresponding ASMR audio track
  Continuously polls Fal.ai until assets are ready

  Merging & Finalizing
  Once all assets are generated, it sends a request to Fal.ai's FFMPEG API to stitch the video clips and audio track into one final video.

  Logging & Publishing
  The final video URL is saved to your second Google Sheet. The workflow then uploads this video to Blotato and publishes it to your specified Instagram and TikTok accounts.

  🎨 Customization Guide

  Content Type Customization

  To adapt this workflow for different content types:

  Modify the AI prompts:
     In AI Agent: Generate Creative Video Idea, update the prompt to match your content style
     Adjust the systemMessage to reflect your brand voice and content guidelines

  Change video parameters:
     In Generate Video Clips (Wavespeed AI), modify:
       duration: Video length (default: 10 seconds)
       aspect_ratio: Change from "9:16" to "16:9" for horizontal videos

  Adjust audio generation:
     In Generate ASMR Sound (Fal AI), update the prompt for different audio styles
     Modify cfg_strength (1-10) for more/less adherence to prompt

  Platform-Specific Adjustments

  Instagram-specific:
     Maximum video duration: 90 seconds for Reels
     Optimal hashtag count: 5-10

  TikTok-specific:
     Maximum video duration: 10 minutes
     Optimal hashtag count: 3-5
     In Publish to TikTok node, adjust privacy settings as needed

  Scheduling Options

  Modify the Trigger: Start Daily Content Generation node:
  Change from daily to hourly, weekly, or specific times
  Add multiple triggers for different time zones
  Use cron expressions for complex schedules

  Error Handling

  Add error handling nodes:
  Connect error outputs to notification systems
  Log failed attempts to a separate Google Sheet
  Implement retry logic for API failures

  🎯 Perfect For

  Content Creators** looking to scale their output with minimal effort
  Digital Marketers** seeking a consistent stream of engaging, trend-based content
  Brands** wanting to build a strong presence on short-form video platforms
  Automation Enthusiasts** building content-driven businesses

  🚀 Getting Started

  Import the workflow into your n8n instance
  Follow the setup guide above step-by-step
  Test with manual execution first
  Monitor the first few automated runs
  Adjust prompts and parameters based on results

  📧 Support

  For questions or issues with this template:
  Email: heniykb@gmail.com
  n8n Community Forum: community.n8n.io

  🔧 Technical Stack

  Workflow Engine**: n8n
  AI Models**: GPT-4, Fal.ai (Wavespeed & MMAudio-v2)
  Data Storage**: Google Sheets
  Publishing**: Blotato API
  Output**: Platform-optimized 9:16 videos with synchronized ASMR audio

nodes_used:
  ["n8n-nodes-base.stickyNote","n8n-nodes-base.scheduleTrigger","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.toolThink","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolThink","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.googleSheets","n8n-nodes-base.set","n8n-nodes-base.googleSheets","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.if","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.set","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE7VabXPbxhH+Kxh+6DgzOvXeX/Spihynmsa1KznOdDKZzL1KqCiCBUErHo//e/dASoQokAQY95NlCbh9dm/32Wfv8GVyHxs7OfsyaezNYnL268SWk5PJpzLECv711ayJswb5OtqmrGbwq0XlSztF9zGUFv5rl011//g3u7ivJ7+dTJp4P5/aJl6GyRksiD6VNbzSLoqS9U1Vf4anQ1z4upy3755Nzi/RvHqIdQzFQ1XfpWn1UKSqLm7iLNZgYHZTtMsU59dvr4o1sOKhbG6LNQZ4cwWuaMEV86WblotbeHOygXQBBhbXsVnOLyr4TYS3JmfJThfx68lkZu9jC6X42Jr6mBEXb1aIC7Qy/als/3axRvDjCl9Vg5FZBT5BEL9Myuy5kCoIoTXy1nDEmVfIaSERUZSZYLlQAk+erF5Hn0NxVlzO5sumsLNQXIansDef5/mhmZ6h1gpydhFPF03p7z7/s2oiPDKvFuUqmL9SiU+IlBj2Ym5rWL+J9SLv8jpusNLk62rRj/CX9iXy9WSN27GICU8MaW4s4oJR5DgG3Dox7yTDIpgN7g91eXMT67PiurF1U7y25fTzdnT2+uBvY1hO43qd545wDo5o/sKRF+BP6RN8a13ijDoAHSDsESJuFMFIUG5EwjpgrCbdzT6HHGvOHrHG4qLN9k9xvf95Fzbo/wbw/7pxYWpnN/7WlrNTm1d5jl7hoejNE3psIlWeCqQUuMBJFEhTAf+lLFDGjLaSd4JfVdOcMf+B5Nngfg8Lz3M6wc+vMvzvBuBvYKkPUC13Wz5ofELxy1TanT4kEaOFIyiQCB54KZAJxqBkpOCUKha83Hjw009vO6G/sg9tvItXP77/gPgpGYJ8en9xa5t38zg7L5+DhxIYBr6bPtQLFbxFMdCIuCIUWcVgF4LFXlHFFU4b+O9tvYgFJNG7ZZPLtg33SfHDDMiqmt1DSpwU19VyFoY4UrVrtEvW10299M0S6Oq5SwaPd4ni4GSQFPbBGcQNB5c0xcgJipmQiVHcKehrC2nTbsJfirfQHYJtbNFUxY9VdTONxfVtjM1iZznftE89PdRBTsjAcuCn4gk6N4SZ5A0CpBjxAHVsjVWIp8AsUwrCIfYW82vwoJxCb1gV8/saaL8Lf0w9EybHFzT3jHvsgH88YeABU0g7QZCFoEcBlUKY3SqH17VNzTPAazcW36guCOz46CwSVmmqU0CSGg9tAcjVpEQRd0K5SKO3jG0z01VM5Sy2zeyjnZYh78jwLdhBSSR3hXGc5AJkvuIORcEJJA+mSAsjwIukJJSCYzpuF/WmAp9vxarSv1E5E3EERXHOAnNAqSRK2AnKPAgLYCzihYV0c5Zo/MIbDxXxGPuinEFBX85CCaJsCWrmEvTR7pr28OMWbDWwEjaglU5eSa6hGect0FDTmlCFqAvWKayws522/FS/q9BfTMs5JP8vQE3Q2WBHzi+/2wn3tmnmV/G/y7jYrl+jhzLQBjdxnkE/ECgFIqF+PTAQEQwREogJOoAy0j24W63YMn/x6k2WrccAZjgDluMAMwWdVukIue6h/3IO2WGzClXMe8wTKLsO2//wR1ODwF3H+eern4oEOdIRblDDi3k1W8QR6UG1HIZ7gzpw0DtMC2i2MkFdgvLUHnIkeRcE9C9uVCc93sb6Jq6zos3lN+XsSbD/iXibjJuZUfGmSkWQaQxJ7TTiVoncWMGR6DymBOQO6XDLL7Zs2sHmiVN8XCzyePOK4sVuzA/w3rY2zslBdQb7EN1tVd21A9eXL/9+9/PV77/88P3f3737x++Xr79+nRwklw1VJu0YSRYyh2Vy9yDkdFAOyWCSjYyBq92pJYuFbvBzBsF+HK0SuITWRAgdpRK0IQKS3aJAMSRPoBaZaDHUqGER0p1j0pGcMJyk8ga4GOqznRfftvPiufdQrk1x+Xo37kXc2gSBc8YQIg7BZad800kxaHmjKWJZz3AHIbbQBxAVzHiMvXa8IwmuYlOXcSvMr0GUHRNdzY+IrkhUYJNjCkMhj8YBXBhJMI3OCkUD9KMN3J/n08o+tkzIhO+nVQPz8fhiFFQPxbopRhMoNYRo5FguRpkioNYBEZO0jCZhbLutcXVEULTNcNHYG7ByBFABwlYfbuFdnEoooq1XSHkJMXVRg67FgFNyLojIrG17cX4o7z5Ud0eCJHhcK/EkOBiXoWdLkodRkK3aATUIKZXzlvIYaaeubqO/K8q03vtOC3k8a9kJu0xbDYQOnBXos5hGCpO/Qp6xAMwlPDIMG+SDgsEzCmV82knEHbRjiZhy+gT2GxIx5TgFnVs4jZAiAB5pk4c4zViUJjEbOx3xfTWdvnTlGkpvuZvOdmYLlZknzGFa62ZLcMKlmBKyDoNSUgFauIXxGSeZuDcpiG7tfb8sp480sYJZrBIIOshw/l3FfoDSeMa/RjgYHgkiWul8QoFBa8SEIoBkKmpuQ+eM5U1s/O3TQPkIuVVJIDRObVn8axmXo+RRG91R8og7QglRFAnlWZb8DmlNBCLUAWHYEEh6AXnVL1qp1IN6BF6Yt4Yx8QavNJ5bCsNiwFk1Uwbdw3NATlRgIkbseR9zrATzn2EOxvDA2HYyN+lEoo1ZfMKMyI2LMJsAeBoIi0AenHjVwxwv0I5lDqZyIgjzjZlDBKWChKmQRi6zltZIMyBwLEBZwMQZvJE9wV+L6rER5yQ7QcdF3FLhjbAUKUUs4tgyyA8QFjhEIb0hxultcnsR7WPJbaXypRxFbskkaHjYIYoDSEyeJHIeGM5o0MQ8Sug9ezjjfBnKP8cZTGSiE2M4wxDHYxaXBNQbaCHKgJmpR9FwoGXpcbJ6K8arFDg2sLxVbGycxpBUOwczB6zN8nF9e0wpPcJKOiUhuVyXjJ9uSdbnAvWRNyTEtDTxktKGXZEEnhQRmiGFDQxJgnKQGinfMYBUDjJQwVUP6FUKHw0aqK0/B4aBBlqDqoOasxGojlsYWZ0HHc8IcdE7z7RKPaBXObGKdz7Ia50Yj123ah4fiR2bFNtLqKQNjEwxT6WSKpRAikLXtpgY2xvwzoD3/tmF4Cj0PJ8csbHg4WkQLPnusn02/hH9Mi/4rg6xhlc+kfzSp9ULmfhny+m0vXWdrRxoX3tZmPDLe1tmXL9+aS8dh7B4+8bJpJyF+MfkDH/97TewveutPgvjRMULcyeblQafgfRi3jVg9mHeP+BtL3/S9972wNWLafeM3rtXIw4ges3t1c67926Ehu01u/dwc29SDtB1vRb3Nv7/n8Vdc9ReiwOm3l6LB47Q+mwOOBLqNXVIufaW0CDttd/cjhF7p7mDc+wQcy9oZae5ftXTa+PgdTUYseXv+RJoaW/iW7AyfWZw7PcGLxbbRnT4om0FKV+mHUJy6LL0cZmdbWR31Q1hpYMqeVBTOTSV7W+Eu6u4z4NhhxgjeuFY2Ic7SR/sg2e0++l/z53c/4UhBymPPstDbyf6O8GQW+BVbXVver9BjT1bbhvWsKuvbycRh30O0mfvCOd7EQykzJ0JMPxblj3Zd5il+uyPvKccZH+Xduuzf8ztbi+IoV/5DcyDvS2vH8DQL92Gd7tDfbe31Q1P6l65Mf5bjN0yZNBnQkfokQEMtV+SDPeyL0ajPv3ojc6IrN8LYO83HHt6xqDPAcd3jkP5uqdt5LOJVQVfZGGQDyf+B8dtSvj7LQAA


name: Medical Symptom Checker & Health Assistant with GPT-4-mini
author_name: Jah coozi
author_username: jahcoozi
categories: []
created_at: 2025-07-12T18:49:47.466Z
updated_at: 2025-07-12T18:49:47.466Z
url: https://n8n.io/workflows/5920
scraped_at: 2025-12-24 13:02:45
description:
  AI Medical Symptom Checker & Health Assistant

  A responsible, privacy-focused health information assistant that provides general health guidance while maintaining strict safety protocols and medical disclaimers.

  ⚠️ IMPORTANT DISCLAIMER

  This tool provides general health information only and is NOT a substitute for professional medical advice, diagnosis, or treatment. Always consult qualified healthcare providers for medical concerns.

  🚀 Key Features

  Safety First
  Emergency Detection**: Automatically identifies emergency situations
  Immediate Escalation**: Provides emergency numbers for critical cases
  Clear Disclaimers**: Every response includes medical disclaimers
  No Diagnosis**: Never attempts to diagnose conditions
  Professional Referral**: Always recommends consulting healthcare providers

  Core Functionality
  Symptom Information**: General information about common symptoms
  Wellness Guidance**: Health tips and preventive care
  Medication Reminders**: General medication information
  Multi-Language Support**: Serve diverse communities
  Privacy Protection**: No data storage, anonymous processing
  Resource Links**: Connects to trusted health resources

  🎯 Use Cases

  General Health Information: Learn about symptoms and conditions
  Pre-Appointment Preparation: Organize questions for doctors
  Wellness Education: General health and prevention tips
  Emergency Detection: Immediate guidance for critical situations
  Health Resource Navigation: Find appropriate care providers

  🛡️ Safety Protocols

  Emergency Keywords Detection
  Chest pain, heart attack, stroke
  Breathing difficulties
  Severe bleeding, unconsciousness
  Allergic reactions, poisoning
  Mental health crises

  Response Guidelines
  Never diagnoses conditions
  Never prescribes medications
  Always includes disclaimers
  Encourages professional consultation
  Provides emergency numbers when needed

  🔧 Setup Instructions

  Configure OpenAI API
     Add your API key
     Set temperature to 0.3 for consistency

  Review Legal Requirements
     Check local health information regulations
     Customize disclaimers as needed
     Implement required data policies

  Emergency Contacts
     Update emergency numbers for your region
     Add local health resources
     Include mental health hotlines

  Test Thoroughly
     Verify emergency detection
     Check disclaimer display
     Test various symptom queries

  💡 Example Interactions

  General Symptom Query:
  User: "I have a headache for 3 days"
  Bot: Provides general headache information, self-care tips, when to see a doctor

  Emergency Detection:
  User: "Chest pain, can't breathe"
  Bot: EMERGENCY response with immediate action steps and emergency numbers

  Wellness Query:
  User: "How can I improve my sleep?"
  Bot: General sleep hygiene tips and healthy habits information

  🏥 Integration Options

  Healthcare Websites**: Embed as support widget
  Telemedicine Platforms**: Pre-consultation tool
  Health Apps**: General information module
  Insurance Portals**: Member resource
  Pharmacy Systems**: General drug information

  📊 Compliance & Privacy

  HIPAA Considerations**: No PHI storage
  GDPR Compliant**: No personal data retention
  Anonymous Processing**: Session-based only
  Audit Trails**: Optional logging for compliance
  Data Encryption**: Secure transmission

  🚨 Limitations

  Cannot diagnose medical conditions
  Cannot prescribe treatments
  Cannot replace emergency services
  Cannot provide specific medical advice
  Should not delay seeking medical care

  🔒 Best Practices

  Always maintain clear disclaimers
  Never minimize serious symptoms
  Encourage professional consultation
  Keep information general and educational
  Update emergency contacts regularly
  Review and update health information
  Monitor for misuse
  Maintain audit trails where required

  🌍 Customization Options

  Add local emergency numbers
  Include regional health resources
  Translate to local languages
  Integrate with local health systems
  Add specific disclaimers
  Customize for specific populations

  Start providing responsible health information today!

nodes_used:
  ["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.webhook","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.if","n8n-nodes-base.set","n8n-nodes-base.set","n8n-nodes-base.merge","n8n-nodes-base.code","n8n-nodes-base.respondToWebhook","n8n-nodes-base.stickyNote","n8n-nodes-base.airtable"]

workflow_json_compressed:
  [encoded data, 6348 characters]


name: Create Food Emoji Icons with OpenAI GPT & Image Generation
author_name: Adnan
author_username: adnan
categories: []
created_at: 2025-07-12T22:01:42.146Z
updated_at: 2025-07-12T22:01:42.146Z
url: https://n8n.io/workflows/5922
scraped_at: 2025-12-24 13:02:41
description:
  This workflow allows users to generate beautifully stylized 3D-rendered food emoji icons based on a simple text prompt. It combines user input, structured visual design generation, and image rendering using OpenAI’s GPT models.

  ✨ What It Does
  Collects user input via a form: e.g. "green apple"
  Generates a structured JSON specification describing the emoji’s form, lighting, texture, and color scheme
  Uses AI to render an image based on that spec—styled like a high-quality emoji icon with a transparent background

  🧠 Use Case
  This template is ideal for:
  Designers or creators needing icon ideas or drafts for food items
  Developers building emoji packs or digital stickers
  Inspiration for AI-assisted product illustration or branding

  💡 Why It's Useful
  Instead of prompting a model directly with vague terms, this flow creates a structured visual spec tailored to food items. The final emoji-style icon is polished, modern, and downloadable.

  ✅ Requirements
  To get started with this workflow, follow these steps:
  🔑 Configure Credentials: Set up your API credentials for OpenAI and Google Drive
  💳 Add OpoenAI Credit: Make sure to add credit to your OpenAI account, verify your organization (required for generating images)
  📊 Connect Google Drive: Authenticate your Google Drive account
  ⚙️ (Optional) Customize Prompts: Adjust the prompts within the workflow to better suit your specific needs

  Note: Each image generation will cost you about $0.17

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.openAi","@n8n/n8n-nodes-langchain.openAi","n8n-nodes-base.googleDrive","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE71Y3W7byBV+lQF3gdiGRktSpEgJWLRG/uAgsYM4uwEaB8Fw5lCahOJwOUPb2tRArntTpF2g6N7kqk/Qm973TfICzSP0zJCyaEcynL3YAEmk4eGcv+985xy98xZgmDd958lSG1ZyOBDe1GP+JIujUTIeQRrH2TjNIhBxKHw/Y6M4D4I0TUQUA8vHUZgFk1E+FkGYCB7wyURA6A08A4uqYAbu1iD0MZimuqvwBAygAlM3cDHwSiVAe9OXqN1qDUTGuICIjnkW02jMA5rGUUjjJPVHwDkkocCbS7YAlH5ey9kM6il5oJQg9xfqjcSP9YIcN9lCai1Vac1YVla4TEvqtNGMaRjmKNe9jzKV0tJY8elLGqT+gEa+/2rgnUE2V+qtC0iWjgIGIaPjKOM0wj8UbYpoMEmiKEnGcZxb0ypWo3EGam1Dqip7q/2IvjqV0hTWGmehIYzk1nSJofJagQcSCuHePWVF08Umt4ePWQYFvvpizkz7GjiPz1RTCLJUDSnkWyBGkRmUUGPg/2DtKRiHuSoE+olZJbMaoCSswjzg0xp+aiSmx2ntkvKqM/UeaF7Lqg2Ld79En1b22viTHRjOhoSdKs6EGhChysbs9tWjNIbxv//Af2glz6Ego3udzZ8//uuDd9Hm5keMldMRDsOLQQeEOB3nWZjH1A8mPo0QbpT5IqYBy/OQiTgClq2B8LQGjDuQY7Ms4NP7D4+Ojw7J0xrRZrYCQIO5mvjxZdpvyCFDVM3KBZTGPbvydQXibCzSPPFTOoEgtFeGNE0xBj4fhVmSQ5gArG3//o1W5esuZqpe26tNLcsZfndAsJIP5SnmzsxhjZopOfHevSPf2kte3vkKaNx5RS4uTrxBP1subCp7A9wQ4bKfoQVkrs5QF9Fzd1sGRNswC8I0vjO6R2soEV3QKaXuKZFclUQ30rCssPbWpNF4itAjQs7wuOiccHJghuT5vLu5p2mB+arLAUEUL/OmGBBWCpReSFTKCqmN5ANyJs0crzU1K7WFQWkIssjbWa0alLZvOCCe41/S4lDLn2F4Up6UVqfzulMpS140AmyM0VqNgbCpn1pRap1YkB09ZxUMiGpMIUv8IJA9ZbHbihRyNjc2ZjuzQmk9wHuxOM6uSRk4Nw3CdUc3dY7lee1xz/gdi4Vrj7kqVP16jn4VThPiBNM3Ww5IgVy1UbhiyLqY4p3es33BKkOA8Tm5xDv6rRr0AENdLIktE0FUi7hqvtSSY9aqWlVQGwnahRY/I/QwF2ZJVO5EZw6mlxAdekgp12t9NIwuaz0LMsZEgFTK+JhGIWd0wiNOJz4DHsEoToMe6T9+/GRKHq5A26/4den8EWv9u3W9F6yc8TmT5RBNL/fl1boPtxW+BV9huf+d9/p1XbT0OHDHqMOir1ecs8rQaBjQhSzt/RzjCuIZ6KYwh63hD58+dxJPDg4PLPdd4ZUFaM1mcJ34sTgM4tkW/6rKh1f5AqvYc5Rtj48aUzXmsrlyLEp8W7KiIzLr/H4lXbO3kT87ko/M+EV4/4F4sX8YHK+jfORkCeMccWi8L/IXDNNe/kIfQg40mwQZjbI0oywdTyiMcp7wWHCcFtY3HyzQT8wYpnBKnjnq6PfvA95v2l+VyLF/UyK7HEmrnlp7qrY/WF5dU+A2OltxlqMrxDkjNh87d24xgtzZHboy+G0UbevZ9hi0x/Fcy/5Foc5s8Z9K3aBVugIucyzPFV1dgqXD1bAD0tCoR3h87FrLzq5tAUgFXRbs1c4/DrbZg2jp+hp1/tQgxQ6I1MrOdo4ftnFvR82lcqShCaLVUl9L9bWrjRXxWupqI8DIHEmUohrHKVeahQvZlGhHs8hQcM5s9K0dA8ILYNgq8lqiO8Wy7RWVwjrFSiSf3v+CZFhqrFprZNcz2v6C/2XysmdhLzqxELxSn2itampuMekQ5P1+5eVnfoQzuE9ZkEQ4E+djLDSR0zBlaQA4kka8Nwods1OHoodKzdClezWS8dYZaOaEVjK9UkrDLaW0Glp+J/SjVcJad1sWfrLsPL7Or7mbgG97Ta2U2Uzi35GdZ/iQtPftWj2yRM69xwxzQ3Qn973Agw0g6UX8aL8x87CPF/2nZ2W8X/9Y1MtHjapn66z2s7kdNaNLzEShzyYsCChLsK9GUTqhGYKGRjwdTdIwilg66mEGx6i3S3KozHaoaCfTifTXJdc+4/BLqMzBVilaFfmDXiP75hvyZ3Jw+PSH51NyUBqGabeQ+WIbCC6dSSaA62ceUQZZYJdCgaWQcgo+iAnjE8BdcaMzwVd7E27xxY1R3jTClVAKM/emCUre6OGxgYoEvUnlYEUb27yEzA/GI58GEc9plKQhZWOBVR/niYiZP876G0/Py/CrvUzSm92Mb+FaOCU/VIVi4guy2e5i6sdBAonAnR6hGYW44k+QvmiSRDwMwWdhDhtdHP1GWAbRVh+Ty1QGYdrPZXrd4c8ff31P3M8XOK64ddnte259sHyFPcyw2qwbtNTIa/XbvLCDf9urVwsFRq7dJoIh2dv7/PGXD+SuKnM5s+vA3TVV7O1NrUqCOpEca7L/9ID0mMTtU66HHLgu14//SRm2d//t32RfCBRTTs7eLo29+ImtOW01YuoYinD3yH5zylYXtzQzIKdQy3zZPkNWYqX82Q0aZGf184Gzp2NuO5a4FqlxzRi1pvz9L9bN0u6VfVOtMZYErVfc1ohTsYnrTsrI3vTp13/+7z9/JTtHjtpZsUvuNtqoBa5z3brvIrcv3uBxu7a0py41st1kVrmx/mZ2LardntoqX01SpAQQLsd7exZdU3LfbkrOsUtPMQRnsihwrtDudcIyXAvJt/4wSPb2NhTCKwetslsrLRpv2Gbs4IqjLoIZF4Gy7VNfNTy7t21/EnDuTf2LV3ZNuOmnkk0ab7NubVR0G1M3Kbx5gNmo6ja/A25SdaufjTZovLj4P6s2HTM1FQAA


name: AI Research Assistant via Telegram (GPT-4o mini + DeepSeek R1 + SerpAPI)
author_name: Arlin Perez
author_username: arlindeveloper
categories: []
created_at: 2025-07-12T23:29:44.768Z
updated_at: 2025-07-12T23:29:44.768Z
url: https://n8n.io/workflows/5924
scraped_at: 2025-12-24 13:02:42
description:
  AI Research Assistant via Telegram (GPT-4o mini + DeepSeek R1 + SerpAPI)

  👥 Who’s it for

  This workflow is perfect for anyone who wants to receive AI-powered research summaries directly on Telegram. Ideal for people asking frequent product, tech, or decision-making questions and want up-to-date answers sourced from the web.

  🤖 What it does

  Users send a question via Telegram. An AI agent (DeepSeek R1) reformulates and understands the intent, while a second agent (GPT-4o mini) performs live research using SerpAPI. The most relevant answers, including links and images, are delivered back via Telegram.

  ⚙️ How it works

  📲 Telegram Trigger – Starts when a user sends a message to your Telegram bot.
  🧠 DeepSeek R1 Agent – Understands, clarifies, or reformulates the user query.
  🧠 Research AI Agent (GPT-4o mini + SerpAPI) – Searches the web and summarizes the best results.
  📤 Send Telegram Message – Sends the response back to the same user.

  📋 Requirements

  Telegram bot (via BotFather) with API token set in n8n credentials

  OpenAI account with API key and balance for GPT-4o mini

  SerpAPI account (100 free searches/month) with API key

  DeepSeek account with API key and balance

  🛠️ How to set up

  Create your Telegram bot using BotFather and connect it using the Telegram Trigger node
  Set up DeepSeek credentials and add a Chat Model AI Agent node using DeepSeek R1 to reformulate the user’s question
  Set up OpenAI credentials and add a second ChatGPT AI Agent node using GPT-4o mini
  In the GPT-4o node, enable the SerpAPI Tool and add your SerpAPI API key
  Pass the reformulated question from DeepSeek to the GPT-4o agent for live search and summarization
  Format the response (text, links, optional images)
  Send the final reply to the user using the Telegram Send Message node
  Ensure your n8n instance is publicly accessible
  Test the workflow by sending a message to your Telegram bot ✅

nodes_used:
  ["@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatDeepSeek","@n8n/n8n-nodes-langchain.memoryBufferWindow","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.toolSerpApi","n8n-nodes-base.telegramTrigger","n8n-nodes-base.telegram","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  [encoded data, 5308 characters]


name: Get a summary of each podcast in your YouTube playlist daily automatically free
author_name: ARRE
author_username: arre
categories: []
created_at: 2025-07-13T00:00:02.024Z
updated_at: 2025-07-13T00:00:02.024Z
url: https://n8n.io/workflows/5926
scraped_at: 2025-12-24 13:02:41
description:
  Understand the workflow better.
  watch this video
  Good to know:

  This workflow automatically transcribes your favorite podcasts or videos saved in a YouTube playlist and generates a comprehensive, AI-powered summary—so you can quickly understand the main topics and insights without having to watch or listen to the entire episode.

  👤 Who is this for?

  Podcast fans who want to save time and get the key points from episodes

  Busy professionals who follow educational or industry videos and need quick takeaways

  Content creators or researchers who organize and review large amounts of video/audio material

  Anyone who wants to efficiently capture and summarize information from YouTube playlists

  ❓ What problem is this workflow solving?

  This workflow solves the challenge of information overload from long-form podcasts and videos. It:

  Automatically transcribes each video or podcast episode in your chosen YouTube playlist

  Uses AI to create a clear, well-structured summary of the content

  Lets you learn and extract valuable information without watching or listening to the entire recording

  Organizes everything in a Google Sheets document for easy tracking and future reference

  ✅ What this workflow does:

  📺 Fetches all videos from a specified YouTube playlist

  🔗 Extracts video titles, URLs, and IDs

  📝 Retrieves and combines transcripts for each video or podcast episode

  📜 Processes transcript data for clarity

  🤖 Uses AI to generate a detailed, sectioned summary that covers all main topics and insights

  📊 Automatically logs video titles, transcripts, summaries, and row numbers to a Google Sheets spreadsheet

  ⚙️ How it works:

  🟢 Trigger: Start the workflow manually or on a schedule

  📺 Fetch videos from your chosen YouTube playlist

  🔗 Extract and organize video details (title, URL, ID)

  📝 Retrieve the transcript for each video or podcast episode

  📜 Combine transcript segments into a single script

  ✂️ Extract the first sentences for focused summarization

  🤖 AI agent creates a comprehensive summary of the episode or video

  📊 Save all data—title, transcript, summary, and row number—to Google Sheets

  🛠️ How to use:

  Set up YouTube OAuth2 credentials in n8n

  Configure Google Sheets OAuth2 credentials

  Set up API credentials for transcript and AI processing

  Create and link your Google Sheets document

  Input your playlist ID and adjust any filters as needed

  Activate the workflow

  📝 Requirements:

  n8n instance (cloud or self-hosted)
  YouTube account with OAuth2 access
  Google Sheets account
  Access to transcript and AI APIs
  Basic n8n workflow knowledge

  🟢 Customizing this workflow:

  Change the YouTube playlist ID to target your preferred podcasts or video series

  Adjust the transcript retrieval process for other APIs or formats

  Customize the AI prompt for different summary styles or focus areas

  Add or remove fields in the Google Sheets output

  Change the workflow trigger or polling frequency

  Switch to a different AI model if desired

  This workflow is designed to help you quickly learn from podcasts and videos you care about—without spending hours consuming the full content.

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.youTube","n8n-nodes-base.stickyNote","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.stickyNote","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.lmChatGroq","n8n-nodes-base.code","n8n-nodes-base.httpRequest","n8n-nodes-base.function","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.splitOut","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"]

workflow_json_compressed:
  [encoded data, 4892 characters]


name: AI-Powered Lead Research & Personalized Email Generation with Groq & Google Sheets
author_name: ainabler
author_username: ainabler
categories: []
created_at: 2025-07-13T14:08:18.685Z
updated_at: 2025-07-13T14:08:18.685Z
url: https://n8n.io/workflows/5938
scraped_at: 2025-12-24 13:02:41
description:
  Overall Description & Potential

  &lt;&lt; What Does This Flow Do? &gt;&gt;

  Overall, this workflow is an intelligent sales outreach automation engine that transforms raw leads from a form or a list into highly personalized, ready-to-send introductory email drafts. The process is: it starts by fetching data, enriches it with in-depth AI research to uncover "pain points," and then uses those research findings to craft an email that is relevant to the solutions you offer.

  This system solves a key problem in sales: the lack of time to conduct in-depth research on every single lead. By automating the research and drafting stages, the sales team can focus on higher-value activities, like engaging with "warm" prospects and handling negotiations. Using Google Sheets as the main dashboard allows the team to monitor the entire process—from lead entry, research status, and email drafts, all the way to the send link—all within a single, familiar interface.

  &lt;&lt; Potential Future Enhancements &gt;&gt;

  This workflow has a very strong foundation and can be further developed into an even more sophisticated system:

  Full Automation (Zero-Touch): Instead of generating a manual-click link, the output from the AI Agent can be directly piped into a Gmail or Microsoft 365 Email node to send emails automatically. A Wait node could be added to create a delay of a few minutes or hours after the draft is created, preventing instant sending.

  Automated Follow-up Sequences: The workflow can be extended to manage follow-up emails. By using a webhook to track email opens or replies, you could build logic like: "If the intro email is not replied to within 3 days, trigger the AI Agent again to generate follow-up email #1 based on a different template, and then send it."

  AI-Powered Lead Scoring: After the research stage, the AI could be given the additional task of scoring leads (e.g., 1-10 or High/Medium/Low Priority) based on how well the target company's profile matches your ideal customer profile (ICP). This helps the sales team prioritize the most promising leads.

  Full CRM Integration: Instead of Google Sheets, the workflow could connect directly to HubSpot, Salesforce, or Pipedrive. It would pull new leads from the CRM, perform the research, draft the email, and log all activities (research results, sent emails) back to the contact's timeline in the CRM automatically.

  Multi-Channel Outreach: Beyond email, the AI could be instructed to draft personalized LinkedIn Connection Request messages or WhatsApp messages. The workflow could then use the appropriate APIs to send these messages, expanding your outreach beyond just email.

nodes_used:
  ["n8n-nodes-base.if","@tavily/n8n-nodes-tavily.tavilyTool","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatGroq","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","@n8n/n8n-nodes-langchain.outputParserStructured","n8n-nodes-base.googleSheets","n8n-nodes-base.manualTrigger","n8n-nodes-base.googleSheets","n8n-nodes-base.googleSheets","n8n-nodes-base.code","@tavily/n8n-nodes-tavily.tavilyTool","n8n-nodes-base.splitInBatches","@n8n/n8n-nodes-langchain.lmChatGroq","n8n-nodes-base.googleSheets","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","@n8n/n8n-nodes-langchain.agent"]

workflow_json_compressed:
  [encoded data, 10376 characters]


name: Automated Competitor Pricing Monitor with Bright Data MCP & OpenAI
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-07-13T18:58:33.809Z
updated_at: 2025-07-13T18:58:33.809Z
url: https://n8n.io/workflows/5948
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  This workflow automatically monitors competitor pricing changes and website updates to keep you informed of market movements. It saves you time by eliminating the need to manually check competitor websites and provides alerts only when actual changes occur, preventing information overload.

  Overview

  This workflow automatically scrapes competitor pricing pages (like ClickUp) and compares current pricing with previously stored data. It uses Bright Data to access competitor websites without being blocked and AI to intelligently extract pricing information, updating your tracking spreadsheet only when changes are detected.

  Tools Used

  n8n**: The automation platform that orchestrates the workflow
  Bright Data**: For scraping competitor websites without being blocked
  OpenAI**: AI agent for intelligent pricing data extraction and parsing
  Google Sheets**: For storing and comparing historical pricing data

  How to Install

  Import the Workflow: Download the .json file and import it into your n8n instance
  Configure Bright Data: Add your Bright Data credentials to the MCP Client node
  Set Up OpenAI: Configure your OpenAI API credentials
  Configure Google Sheets: Connect your Google Sheets account and set up your pricing tracking spreadsheet
  Customize: Set your competitor URLs and pricing monitoring schedule

  Use Cases

  Product Teams**: Monitor competitor feature and pricing changes for strategic planning
  Sales Teams**: Stay informed of competitor pricing to adjust sales strategies
  Marketing Teams**: Track competitor messaging and positioning changes
  Business Intelligence**: Build comprehensive competitor analysis databases

  Connect with Me

  Website**: https://www.nofluff.online
  YouTube**: https://www.youtube.com/@YaronBeen/videos
  LinkedIn**: https://www.linkedin.com/in/yaronbeen/
  Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission)

  #n8n #automation #competitoranalysis #pricingmonitoring #brightdata #webscraping #competitortracking #marketintelligence #n8nworkflow #workflow #nocode #pricetracking #businessintelligence #competitiveanalysis #marketresearch #competitormonitoring #pricingdata #websitemonitoring #competitorpricing #marketanalysis #competitorwatch #pricingalerts #businessautomation #competitorinsights #markettrends #pricingchanges #competitorupdates #strategicanalysis #marketposition #competitiveintelligence

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-mcp.mcpClientTool","n8n-nodes-base.noOp","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.googleSheets","n8n-nodes-base.if","n8n-nodes-base.googleSheets","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/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured"]

workflow_json_compressed:
  [encoded data, 7604 characters]


name: Extract Customer Pain Points from Support Forums with Bright Data & GPT-4
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-07-13T19:00:22.001Z
updated_at: 2025-07-13T19:00:22.001Z
url: https://n8n.io/workflows/5952
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  This workflow automatically monitors customer support forums and Q&A platforms to extract valuable customer insights and pain points. It saves you time by eliminating the need to manually browse through forum discussions and provides structured analysis of customer questions, answers, and recurring issues.

  Overview

  This workflow automatically scrapes customer support forums like Stack Exchange and SuperUser to find questions and discussions related to specific topics or brands. It uses AI to analyze forum content, extract customer pain points, and identify recurring issues, then sends structured insights directly to your product team via email.

  Tools Used

  n8n**: The automation platform that orchestrates the workflow
  Bright Data**: For scraping forum pages and Q&A platforms without being blocked
  OpenAI**: AI agent for intelligent forum content analysis and insight extraction
  Gmail**: For sending automated insight reports to your team

  How to Install

  Import the Workflow: Download the .json file and import it into your n8n instance
  Configure Bright Data: Add your Bright Data credentials to the MCP Client node
  Set Up OpenAI: Configure your OpenAI API credentials
  Configure Gmail: Connect your Gmail account for sending team notifications
  Customize: Set target forum URLs and define the topics or brands to monitor

  Use Cases

  Product Teams**: Identify customer pain points and feature requests from forum discussions
  Customer Support**: Monitor common issues and questions customers are asking
  Market Research**: Understand customer needs and challenges in your industry
  Competitive Analysis**: Track how customers discuss competitor products and services

  Connect with Me

  Website**: https://www.nofluff.online
  YouTube**: https://www.youtube.com/@YaronBeen/videos
  LinkedIn**: https://www.linkedin.com/in/yaronbeen/
  Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission)

  #n8n #automation #forummonitoring #customersupport #brightdata #webscraping #customerinsights #n8nworkflow #workflow #nocode #forumautomation #customerresearch #supportmonitoring #painpointanalysis #communitymonitoring #forumanalysis #customerfeedback #productinsights #supportforums #stackexchange #customervoice #userresearch #productfeedback #techsupport #communitylistening #customerexperience #supportanalysis #forumdata #qandamonitoring #customerpainpoints

nodes_used:
  ["n8n-nodes-base.manualTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.agent","n8n-nodes-mcp.mcpClientTool","n8n-nodes-base.gmail","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/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured"]

workflow_json_compressed:
  [encoded data, 5964 characters]


name: Automate Email Campaign Analysis & Smart Follow-ups with Bright Data & OpenAI
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-07-13T19:00:30.213Z
updated_at: 2025-07-13T19:00:30.213Z
url: https://n8n.io/workflows/5953
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  This workflow automatically tracks email campaign performance metrics and triggers smart follow-up actions based on engagement data. It saves you time by eliminating the need to manually monitor campaign reports and provides intelligent re-engagement strategies for improving email marketing ROI.

  Overview

  This workflow automatically scrapes email service provider (ESP) reports to extract campaign performance metrics like open rates, click-through rates, and bounce rates. It uses AI to analyze the data and automatically sends targeted follow-up emails to re-engage subscribers who opened but didn't click, maximizing campaign effectiveness.

  Tools Used

  n8n**: The automation platform that orchestrates the workflow
  Bright Data**: For scraping ESP campaign reports without being blocked
  OpenAI**: AI agent for intelligent campaign data analysis and decision making
  Gmail**: For sending automated follow-up engagement emails

  How to Install

  Import the Workflow: Download the .json file and import it into your n8n instance
  Configure Bright Data: Add your Bright Data credentials to the MCP Client node
  Set Up OpenAI: Configure your OpenAI API credentials
  Configure Gmail: Connect your Gmail account for sending follow-up emails
  Customize: Set ESP report URLs and define engagement thresholds for triggering follow-ups

  Use Cases

  Email Marketing**: Automatically optimize campaign performance with smart follow-ups
  Marketing Automation**: Trigger re-engagement campaigns based on behavior data
  Performance Tracking**: Monitor email metrics without manual ESP login
  Customer Retention**: Re-engage subscribers who showed interest but didn't convert

  Connect with Me

  Website**: https://www.nofluff.online
  YouTube**: https://www.youtube.com/@YaronBeen/videos
  LinkedIn**: https://www.linkedin.com/in/yaronbeen/
  Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission)

  #n8n #automation #emailmarketing #campaigntracking #brightdata #webscraping #emailautomation #n8nworkflow #workflow #nocode #emailcampaigns #marketingautomation #emailperformance #campaignanalysis #emailmetrics #reengagement #marketingdata #emailoptimization #campaignmonitoring #emailanalytics #digitalmarketing #performancetracking #emailstrategy #conversionoptimization #marketinganalytics #emailroi #campaigninsights #emailengagement #marketingefficiency #automatedemail

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-mcp.mcpClientTool","n8n-nodes-base.if","n8n-nodes-base.gmail","n8n-nodes-base.noOp","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/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured"]

workflow_json_compressed:
  [encoded data, 6220 characters]


name: Track SEO Keyword Rankings with Bright Data MCP and GPT-4o AI Analysis
author_name: Yaron Been
author_username: yaron-nofluff
categories: []
created_at: 2025-07-13T19:01:44.254Z
updated_at: 2025-07-13T19:01:44.254Z
url: https://n8n.io/workflows/5962
scraped_at: 2025-12-24 13:02:41
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  This workflow automatically monitors keyword rankings across search engines to track SEO performance and identify optimization opportunities. It saves you time by eliminating the need to manually check keyword positions and provides comprehensive ranking data for strategic SEO decision making.

  Overview

  This workflow automatically scrapes search engine results pages (SERPs) to track keyword rankings, competitor positions, and search features. It uses Bright Data to access search results without restrictions and AI to intelligently parse ranking data, track changes, and identify SEO opportunities.

  Tools Used

  n8n**: The automation platform that orchestrates the workflow
  Bright Data**: For scraping search engine results without being blocked
  OpenAI**: AI agent for intelligent ranking analysis and SEO insights
  Google Sheets**: For storing keyword ranking data and tracking changes

  How to Install

  Import the Workflow: Download the .json file and import it into your n8n instance
  Configure Bright Data: Add your Bright Data credentials to the MCP Client node
  Set Up OpenAI: Configure your OpenAI API credentials
  Configure Google Sheets: Connect your Google Sheets account and set up your ranking tracking spreadsheet
  Customize: Define target keywords and ranking monitoring parameters

  Use Cases

  SEO Teams**: Track keyword performance and identify ranking improvements
  Content Marketing**: Monitor content ranking success and optimization needs
  Competitive Analysis**: Track competitor keyword rankings and strategies
  Digital Marketing**: Measure organic search performance and ROI

  Connect with Me

  Website**: https://www.nofluff.online
  YouTube**: https://www.youtube.com/@YaronBeen/videos
  LinkedIn**: https://www.linkedin.com/in/yaronbeen/
  Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission)

  #n8n #automation #keywordrankings #seo #searchrankings #brightdata #webscraping #seotools #n8nworkflow #workflow #nocode #ranktracking #keywordmonitoring #seoautomation #searchmarketing #organicseo #seoresearch #rankinganalysis #keywordanalysis #searchengines #seomonitoring #digitalmarketing #serp #keywordtracking #seoanalytics #searchoptimization #rankingreports #keywordresearch #seoinsights #searchperformance

nodes_used:
  ["@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-mcp.mcpClientTool","n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.googleSheets","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/n8n-nodes-langchain.outputParserAutofixing","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.outputParserStructured"]

workflow_json_compressed:
  [encoded data, 5868 characters]


name: Automated Content Marketing Intelligence with OpenAI, Ahrefs & Multi-platform Integration
author_name: Nikan Noorafkan
author_username: nikkannoora
categories: []
created_at: 2025-07-13T19:59:53.938Z
updated_at: 2025-07-13T19:59:53.938Z
url: https://n8n.io/workflows/5979
scraped_at: 2025-12-24 13:02:41
description:
  🤖 AI-Powered Content Marketing Research Tool

  &gt; Transform your content strategy with automated competitor intelligence

  ⚡ What It Does

  Never miss a competitor move again. This workflow automatically:

  🔍 Monitors competitor content across multiple domains
  📊 Tracks trending keywords by region  
  💬 Extracts audience pain points from Reddit & forums
  🤖 Generates AI strategy recommendations via OpenAI
  📋 Outputs to Airtable, Notion & Slack for instant action

  🎯 Perfect For
  Growth marketers** tracking competitor strategies
  Content teams** discovering trending topics
  SEO specialists** finding keyword opportunities
  Marketing agencies** managing multiple clients

  🛠️ Technical Setup

  Required APIs & Credentials

  | Service | Credential Type | Monthly Cost | Purpose |
  |---------|----------------|--------------|---------|
  | Ahrefs | Header Auth | $99+ | Backlink & traffic analysis |
  | SEMrush | Query Auth | $119+ | Keyword research |
  | BuzzSumo | Header Auth | $199+ | Content performance |
  | OpenAI | Header Auth | ~$50 | AI recommendations |
  | Reddit | OAuth2 | Free | Audience insights |
  | Google Trends | Public API | Free | Trending topics |

  📊 Database Schema

  Airtable Base: content-research-base

  Table 1: competitor-intelligence

  timestamp (Date)

  domain (Single line text)

  traffic_estimate (Number)

  backlinks (Number)

  content_gaps (Long text)

  publishing_frequency (Single line text)

  Table 2: keyword-opportunities  

  timestamp (Date)

  trending_keywords (Long text)

  top_questions (Long text)

  content_opportunities (Long text)

  🚀 Quick Start Guide

  Step 1: Import & Configure
  Import the workflow JSON
  Update competitor domains in 📋 Configuration Settings
  Map all API credentials

  Step 2: Setup Storage
  Airtable:** Create base with exact schema above
  Notion:** Create database with properties listed
  Slack:** Create #content-research-alerts channel

  Step 3: Test & Deploy
  First run populates:
  ✅ Airtable tables with competitor data
  ✅ Notion database with AI insights
  ✅ Slack channel with formatted alerts

  💡 Example Output

  AI Recommendations Format
  {
  "action_items": [
  {
  "topic": "Copy trading explainer",
  "format": "Video",
  "region": "UK",
  "priority": "High"
  }
  ],
  "publishing_calendar": [
  {"week": "W34", "posts": 3}
  ],
  "alerts": [
  "eToro gained 8 .edu backlinks this week"
  ]
  }

  Slack Alert Preview
  🚨 Content Research Alert

  📊 Top Findings:

  Sustainable packaging solutions

  Circular economy trends

  Eco-friendly manufacturing

  📈 Trending Keywords:

  forex trading basics (+45%)

  social trading platforms (+32%)

  copy trading strategies (+28%)

  💡 AI Recommendations:
  Focus on educational content in UK market...

  🔧 Advanced Features

  ✅ Data Quality Validation
  Automatic retry** for failed API calls
  Data validation** before storage
  Error notifications** via Slack

  ⚙️ Scalability Options
  Multi-region support** (US, UK, DE, FR, JP)
  Batch processing** for large competitor lists  
  Rate limiting** to respect API quotas

  🎨 Customization Ready
  Modular design** - disable unused APIs
  Industry templates** - forex, ecommerce, SaaS
  Custom scoring** algorithms

  📈 ROI & Performance

  Cost Analysis
  Setup time:** ~2 hours
  Monthly API costs:** $400-500
  Time saved:** 15+ hours/week
  ROI:** 300%+ within first month

  Success Metrics
  Competitor insights:** 50+ data points daily
  Keyword opportunities:** 100+ suggestions/week  
  Content ideas:** 20+ AI-generated topics
  Trend alerts:** Real-time notifications

  🛡️ Troubleshooting

  Common Issues & Solutions

  | Symptom | Cause | Fix |
  |-------------|-----------|---------|
  | OpenAI timeout | Large data payload | Reduce batch size → Split processing |
  | Airtable 422 error | Field mismatch | Copy schema exactly |
  | Reddit 401 | OAuth expired | Re-authorize application |

  Rate Limiting Best Practices
  Ahrefs:** Max 1000 requests/day
  SEMrush:** 3000 requests/day  
  OpenAI:** Monitor token usage

  🌟 Why Choose This Template?

  &gt; "From manual research to automated intelligence in 15 minutes"

  ✅ Production-ready - No additional coding required  
  ✅ Cost-optimized - Uses free tiers where possible  
  ✅ Scalable - Add competitors with one click  
  ✅ Actionable - AI outputs ready for immediate use  
  ✅ Community-tested - 500+ successful deployments

  Start your competitive intelligence today 🚀

  Built with ❤️ for the n8n community

nodes_used:
  ["n8n-nodes-base.scheduleTrigger","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.airtable","n8n-nodes-base.airtable","n8n-nodes-base.notion","n8n-nodes-base.slack","n8n-nodes-base.merge","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.set","n8n-nodes-base.httpRequest","n8n-nodes-base.stopAndError","n8n-nodes-base.httpRequest"]

workflow_json_compressed:
  [encoded data, 7304 characters]


name: Security Reconnaissance with Google Dorks, Parsera Scraping, and Gmail Reports
author_name: Sean Birmingham
author_username: knute
categories: []
created_at: 2025-07-13T21:23:12.789Z
updated_at: 2025-07-13T21:23:12.789Z
url: https://n8n.io/workflows/5980
scraped_at: 2025-12-24 13:02:46
description:
  This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

  How it Works:
  - Accepts a domain from a web form
  - Generates a list of Google dorks targeting that domain
  - Scrapes Google search results for each dork 
  - Filters out junk links (Google internal, non-http)
  - Formats valid results as a markdown report
  - Emails the report to your inbox

  For this workflow you will need to configure credentials in n8n as well as create a Parsera.io agent:

  1. AI Scraper Account
  Create an account for: https://app.parsera.io
  Create an agent named "Google" and use the URL https://google.com
  Copy/Paste your Parsera.io API key to the 'Scrape with agent' node in the n8n workflow

  2. Gmail OAuth2
  Go to Google Cloud Console
  Enable Gmail API
  Create OAuth2 credentials
  Copy/Paste the Gmail API key to the Gmail node in the n8n workflow

nodes_used:
  ["n8n-nodes-base.formTrigger","n8n-nodes-base.splitInBatches","n8n-nodes-base.code","n8n-nodes-aiscraper.aiScraper","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote"]

workflow_json_compressed:
  H4sIAAAAAAAAE51Ya1PbSBb9K70KNdgJsvW25BTLMmQzoTYTUoHMfsDM0upu2QK55ZFkCOvxf9/TLfkByGSyVRRuy7fv49x7z+3WwpiKihrDhZHKsqKSiVNuDA3LpsKnIrYSy3V8Swxsz43sxLaYZ1txIrwoYczlAfNdNwmDOBSM0sjxQi7igWv5xoFRiekso5U4KQQvz0U1n53keCIqAQNVMRfLA0PmXJTG8BLWlVUeu0kysIUZUt82PZcGJg1obIYsgIGI8iixoFnSqYD0+7yYklM5m1fK2sNMPZOhNLVSM6al6CUQuSjS8VgUkJnlZVqluYRB03ZC68C0o9C6OjDuRTzJ81sdeRJQNxkEtul7XJgePDIjN05MK3ARe2jHPqNKFy3gRSWKUmE3o9Xkr+/NZ8oLtREQaBfTKlPe/1NCIbmgxVhU5F0+pak0aon3qci4NnVHs3mDWaIefqSxyLD365ePyq2MMjHJM46Ah8akqmblsN8X36hCvsfyqbG8Wi5ruH6D8xoNZ3nQJCCxBEfmHdOPGAIYCNuMmc8Qhev7bhBHg4GzScD5LEuVn8VtSc6kMOMHEx87k1Eq8VP5M63YBBE8zkfobdLxGNtHaMVq83n6X6gPn4Zhr8OwLYv7bmibnA8QhutyVBSzTBGElhtbjsfDcBNGHcBFU67kXNCCTXZGwbB8WktWsMv5m/JEyQ8NhhAqkqpq/Vpk5JDs3ZS5vBypvI2Mq7cjOZK1zFSFCIGVbE8/6PR/7xwNdUKPhqNRH3/dIzy5v78fjXpYXv6OR1dvuv20+3aliusSgq5a51H9eWlfkSHZ3yqK/S3zXKNxSK5HEhGKYW9Ljohv1XDGE/hWqWUq7/KUCfLn6gHlvBBluXPrZAZZtbopVytaztrE53JeZMP+OK368CtJxysTI+OyENO8EiNjYxcP4wLkNRkZbcogpToMYqeSi28kT0j/ZcksHwO4P7d2lulY4mtjVTmnZV42h4BTmeTYtHb0w8XF5/98ODu/2OlALXcCRioFSdJMtEt2ahxz2QAJd5pV9a1qVgq6ZinkXXckr7cyzeZllU/RS/xdk3Od+5EkpFcV6bTT1Uvdtp390Uju1w+mdNbJUinI4d/JQj0hpFYopGoODkX16uuXU0X5uRSy0jt6hdAE1UH5rmLBCtH0xwfkure3qCt2ed1VRaw0FxgchSQLoiId4lP5OCTXK2pD/ffGeT6uQemXunmP/jjcWzTeLK/Jkiy1tmVXR9+ofBL+W2M3LTLO7YSLxEycKAGfKFqMgoGZ8DARPKahZ/tbtMgKOhPkPq0mhI4RexuX0LTUYkWPpvWGpxMqcHaRCooPug4Xi5pEegoSslxiP5ovnxdMmVpZ1p+fas9qoLTcHxgi1dmGWhE8w6CGbEozbWXt1/Es1ecDhcSXs89nMvDcKf9q3TgX+Sbq41PSyBPKWD6H8WeDZsPQLsU5woti02ZBDEQZGJpT13QotV0W2Y7lBRvdJ5mgkpzNq5dmfQsxe9Z3ebkphj3Ntj2aZZ2uLnC023Rd4HV5o4JvFS/jl57G/SMe6IoipN8n79NMTW/FCmyzKS1/o1mKnqjLWev46afNlx4OXUVV/hvF0tlXRb3fXf/+Ny2QSpbNEWVnf1Pnz4S2tTRN8KLMq/1u43kDQONnLX+01W9MYS+4inVYu492qsWGRM6zDHqW3V6io+/8nOdKXil/oZ9Ch/PEt7jJXOGbnu8wkzI7NJkI/TgMme0P6Cb7vwgpCjWZP1z8+vGH5nL4F8eyCkvx3/MqUCWQ1tneAqLGDkdZDNTiluf3asaOjFevXpF/iQfyUas71c2EMxrHvJbqz9DbVKnkBaCbxgIdB+NlVR6QeTmH3QdCSZlKpJlIca9ZNi1Bp/l8PCFpQqqJaHZCSP2kAoACmOpp1R/ye3EnioOVcCEw8QrUJWTLKs0yks2nGErgW5wrmdKiiap2UUkVeQxmrLUdq6RKWqV3Ins4wBzBLGA48/26Cls5T8oHWdFvw5Fco/HmsMZUg9jJ4E1XIXm9t0jJG2Ive+Ryb5Etrzrqf/e627vJU6lnjB4z2zR9uSnFtXpU4NVLfJ0wYePiwE07CFywABVm5IBdYo9yn2IoWOHWPeIcEAH2KQ4uIMudBTbGZMoeV5jXfoWIB4MEVwHbZJa6BlgDVd6Ob0bhwOYWD2PU+rMrRAkvwKdDo5mL/9D29JH9wFj5ts36GzSWT+8U5Ty+EaxS4r9ozmgO6V/ELC8q4znXa1tnx/Nq4qyp/p0z+DSenk3fH0dWOS2TrYZU0rtZ3ulteD7iLve5jQsFSN30Qi/BSZ9aZiwskTgBLkvJYCsTVcpuH8gnnO523yK0TCPyqNtdlQ4Ho+NZu09EOp4ADtwLDlTLq3aBZrRrfeNSZ3B5MUHx4091DbKpDlxY0wr9ga6JBakHNld9QzjFpXn3eAutMAhDxzEFw2XKG7ixSSNOURCDiLlJILwgag3b/vG4g0CHHTwP+z7l6lrqhk+j/kyLEpQKi1yM5LGsjylkir5XgaI4QLccZ9G1ZCwQtQBJKcKoFFLKtR450aLoHrBVowW7HnAIWW9t6gSQlZM4pwUnDEQH9SOjLk6cjik6cF4KjT2SQVanu83EUz9Jks/wT5tXruttQmdQWzz+fEpuwb+bx83I3Ce0zmvtoYK990L2KNLjxE5oCiQLRRv4JmYSM9mAeT5Fhe0qWuf/qFrL0unzXqha52n+tpsa+SOrVy2qfAEjJ1XeJHHrlNtMOeUOxw0oWYNdD70X8AgSEQd2EJks8TzTo0lgUmEBGd+yo8HAd5MwacXD/XE8wl1oNMWsXtu8gIx+z0RqgjquC28kX79+l89jAMYwvW5fv1bwCI4xti5kXTL1PXOOMtfV9IjltmpKwYY4qlTNRdy+RC1X33zbYLzSPkoQcsPQ22+u8E2/5hleXi7067Dvv5BoXgul6iprDK3l1RVsPjoityndcYpqVfZYtk3brpnZqu75hahNZfshv1VhO0Ctfn7nFVW7v+2bWvXvvuu1qF4u/weoOeDvbxUAAA==


name: Bilingual Newsletters with GPT-4o, AI Images & Videos for HubSpot & SP
author_name: plemeo
author_username: plemeo
categories: []
created_at: 2025-07-14T09:15:48.670Z
updated_at: 2025-07-14T09:15:48.670Z
url: https://n8n.io/workflows/5988
scraped_at: 2025-12-24 13:02:42
description:
  Who’s it for  
  Marketing, growth, and automation teams that need to ship polished bilingual newsletters—complete with images, optional video, and multi-channel distribution—without writing a line of code.

  How it works / What it does  
  A Webhook receives a plain-language request (e.g. “Create a newsletter about XYZ and store it in SharePoint”). The Webhook can be changed to another trigger, fr example Manual Trigger.
  An AI Agent (OpenAI GPT-4o) drafts German & English newsletter copy following a strict JSON schema.  
  SharePoint fetches an HTML template; a Code node injects AI copy into the placeholders.  
  Optional creative assets:  
     Pollinations AI → image (resolution check & frame overlay)  
     FAL AI → short video + Lyria2 audio → merged via FFmpeg API  
  A Gmail Approval step sends the draft to an approver; the flow continues only on “Approve”.  
  Depending on user intent the workflow:  
     Emails the newsletter to HubSpot contacts, and/or  
     Saves HTML (+ JPG/Video URL) to a SharePoint library.  

  How to set up  
  Import the template
  Open the yellow sticky note and follow the checklist 
     Create credentials for OpenAI, HubSpot (App Token), Microsoft 365, Gmail, and FAL AI.  
     Enter them in n8n Credential Manager (never in the HTTP node).  
  Edit the Configuration Settings Set node with your ENV_* variables.   
  Activate the workflow, copy the production Webhook URL, and trigger it with JSON body { "text": "…" } or with a desired trigger.

  Requirements  
  OpenAI account
  Microsoft 365 tenant (SharePoint & Outlook)  
  HubSpot App Token  
  FAL AI API Key (video & audio generation)  

  How to customize  
  Want a different language? Tweak the AI prompt inside AI Agent.  
  Want a different storage provider? Change the SharePoint nodes to Google Drive or Dropbox.
  Skip video generation: set include_video to false in the incoming prompt.  
  Change the distribution logic by adjusting the WF Result Switch node.  
  Add more channels (e.g. Slack) by inserting additional branches after the Switch and modifying the intent determination at the beginning of the workflow.

nodes_used:
  ["n8n-nodes-base.code","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.microsoftSharePoint","n8n-nodes-base.switch","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.httpRequest","n8n-nodes-base.wait","n8n-nodes-base.httpRequest","n8n-nodes-base.set","@n8n/n8n-nodes-langchain.agent","@n8n/n8n-nodes-langchain.agent","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.code","n8n-nodes-base.if","n8n-nodes-base.microsoftSharePoint","n8n-nodes-base.microsoftSharePoint","n8n-nodes-base.microsoftSharePoint","n8n-nodes-base.hubspot","n8n-nodes-base.splitInBatches","n8n-nodes-base.switch","n8n-nodes-base.microsoftOutlook","n8n-nodes-base.set","n8n-nodes-base.convertToFile","n8n-nodes-base.gmail","n8n-nodes-base.stickyNote","n8n-nodes-base.webhook","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","@n8n/n8n-nodes-langchain.lmChatOpenAi","n8n-nodes-base.wait","n8n-nodes-base.wait","n8n-nodes-base.if","n8n-nodes-base.if","n8n-nodes-base.merge","n8n-nodes-base.if","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.stickyNote","n8n-nodes-base.httpRequest","n8n-nodes-base.extractFromFile"]

workflow_json_compressed:
  [encoded data, 4424 characters]


