Extract & transform HackerNews data to Google Docs using Gemini 2.0 flash
Description This workflow automates the process of scraping the latest discussions from HackerNews, transforming raw threads into human readable content using Google Gemini, and exporting the final content into a well-formatted Google Doc. Overview This n8n workflow is responsible for extracting trending posts from the HackerNews API. It loops through each item, performs HTTP data extraction, utilizes Google Gemini to generate human-readable insights, and then exports the enriched content into Google Docs for distribution, archiving, or content creation. Who this workflow is for Tech Newsletter Writers: Automate the collection and summarization of trending HackerNews posts for inclusion in weekly or daily newsletters. Content Creators & Bloggers: Quickly generate structured summaries and insights from HackerNews threads to use as inspiration or supporting content for blog posts, videos, or social media. Startup Founders & Product Builders: Monitor HackerNews for discussions relevant to your niche or competitors, and keep a pulse on the community’s opinions. Investors & Analysts: Surface early signals from the tech ecosystem by identifying what’s trending and how the community is reacting. Researchers & Students: Analyze popular discussions and emerging trends in technology, programming, and startups—enriched with AI-generated insights. Digital Agencies & Consultants: Offer HackerNews monitoring and insight reports as a value-added service to clients interested in the tech space. Tools Used n8n: The core automation engine that manages the trigger, transformation, and export. HackerNews API: Provides access to trending or new HN posts. Google Gemini: Enriches HackerNews content with structured insights and human-like summaries. Google Docs: Automatically creates and updates a document with the enriched content, ready for sharing or publishing. How to Install Import the Workflow: Download the .json file and import it into your n8n instance. Set Up HackerNews Source: Choose whether to use the HN API (via HTTP Request node) or RSS Feed node. Configure Gemini API: Add your Google Gemini API key and design the prompt to extract pros/cons, key themes, or insights. Set Up Google Docs Integration: Connect your Google account and configure the Google Docs node to create/update a document. Test and Deploy: Run a test job to ensure data flows correctly and outputs are formatted as expected. Use Cases Tech Newsletter Authors: Generate ready-to-use summaries of trending HackerNews threads. Startup Founders: Stay informed on key discussions, product launches, and community feedback. Investors & Analysts: Spot early trends, technical insights, and startup momentum directly from HN. Researchers: Track community reactions to new technologies or frameworks. Content Creators: Use the enriched data to spark blog posts, YouTube scripts, or LinkedIn updates. Connect with Me Email: ranjancse@gmail.com LinkedIn: https://www.linkedin.com/in/ranjan-dailata/ Get Bright Data: Bright Data (Supports free workflows with a small commission) n8n automation hackernews contentcuration aiwriting geminiapi googlegemini techtrends newsletterautomation googleworkspace rssautomation nocode structureddata webscraping contentautomation hninsights aiworkflow googleintegration webmonitoring hnnews aiassistant gdocs automationtools gptlike geminiwriter
By Ranjan DailataKB tool - Confluence knowledge base
Enhance Query Resolution with the Knowledge Base Tool! Our KB Tool - Confluence KB is crafted to seamlessly integrate into the IT Ops AI SlackBot Workflow, enhancing the IT support process by enabling sophisticated search and response capabilities via Slack. Workflow Functionality: Receive Queries: Directly accepts user queries from the main workflow, initiating a dynamic search process. AI-Powered Query Transformation: Utilizes OpenAI's models or local ai to refine user queries into searchable keywords that are most likely to retrieve relevant information from the Knowledge Base. Confluence Integration: Executes searches within Confluence using the refined keywords to find the most applicable articles and information. Deliver Accurate Responses: Gathers essential details from the Confluence results, including article titles, links, and summaries, preparing them to be sent back to the parent workflow for final user response. To view a demo video of this workflow in action, click here. Quick Setup Guide: Ensure correct configurations are set for OpenAI and Confluence API integrations. Customize query transformation logic as per your specific Knowledge Base structure to improve search accuracy. Need Help? Dive into our Documentation or get support from the Community Forum! Deploy this tool to provide precise and informative responses, significantly boosting the efficiency and reliability of your IT support workflow.
By Angel MenendezDocument analysis & chatbot creation with Llama Parser, Gemini LLM & Pinecone DB
📄Description This automation workflow enables users to upload files via an N8N form, automatically analyzes the content using Google Gemini agents, and delivers the analyzed results via email along with a chatbot link. The system leverages Llama Cloud API, Google Gemini LLM, Pinecone vector database, and Gmail to provide a seamless, multilingual content analysis experience. ✅ Prerequisites Before setting up this workflow, ensure the following are in place: An active N8N instance. Access to Llama Cloud API. Google Gemini LLM API keys (for Translator & Analyzer agents). A Pinecone account with an active index. A Gmail account with API access configured. Basic knowledge of N8N workflow setup. ⚙️ Setup Instructions Deploy the N8N Form Create a public-facing form using N8N. Configure it to accept: File uploads. User email input. File Preprocessing Store the uploaded files temporarily. Organize and preprocess them as needed. Content Extraction using Llama Cloud API Feed the files into the Llama Cloud API. Extract and parse the content for further processing. Translation (if required) Use a Translator Agent (Google Gemini). Check if the content is in English. If not, translate it. Content Analysis Forward the (translated) content to the Analyzer Agent (Google Gemini). Perform deep analysis to extract insights. Vector Storage in Pinecone Store both: The parsed and translated content. The analyzed content. Use Pinecone to store the content as embeddings for chatbot use. User Notification via Gmail Send the analyzed content and chatbot link to the user’s provided email using Gmail API. 🧩 Customization Guidance To add more languages: Update the translation logic to include additional language support. To modify analysis depth: Adjust the prompts sent to the Gemini Analyzer Agent. To change the chatbot behavior: Retrain or reconfigure the chatbot to utilize the new Pinecone index contextually. 🔁 Workflow Summary User uploads files and email via N8N form. Files are parsed using Llama Cloud API. Content is translated (if needed) using Gemini Translator Agent. Translated content is analyzed by the Gemini Analyzer Agent. Parsed and analyzed data is stored in Pinecone. User receives email with analyzed results and a chatbot link.
By pavithGenerate UGC promo videos with OpenAI, Sora 2 and Blotato for eCommerce
💥 Generate UGC Promo Videos with Blotato and Sora 2 for eCommerce 🧩 Who is this for? This workflow is perfect for eCommerce brands, content creators, and marketing teams who want to automatically generate short, eye-catching videos from their product images — without editing software or manual work. 🚀 What problem does this workflow solve? Creating engaging promotional videos manually can be time-consuming and expensive. This automation eliminates that friction by combining Blotato, Sora 2, and AI scripting to turn static product images into dynamic UGC-style videos ready for TikTok, Instagram Reels, and YouTube Shorts. ⚙️ What this workflow does This workflow: Receives a product image directly from Telegram or another input source. Analyzes the image with OpenAI Vision to understand the product’s features and audience. Generates a natural, short UGC-style script using GPT-based AI. Sends the image and script to Sora 2 via the Fal API to generate a vertical promotional video. Monitors the video status every 15 seconds until completion. Downloads or automatically publishes the final video to your social platforms. 🧠 Setup Create a Fal.ai API key and set it in your n8n credentials (Authorization: Key YOURFALKEY). Connect your Telegram, OpenAI, and HTTP Request nodes as shown in the workflow. Make sure the Build Public Image URL node outputs a valid, public image link. In the HTTP Request node for Sora 2, set: Method: POST URL: https://fal.run/fal-ai/sora-2/image-to-video Headers: Authorization: Key YOURFALKEY Content-Type: application/json Body: Raw JSON with parameters like prompt, imageurl, duration, and aspectratio. Run the workflow and monitor the execution logs for your video URL. Blotato → API key for social media publishing 🎨 How to customize this workflow to your needs 🧾 Change the video tone: Edit the OpenAI prompt to produce educational, emotional, or luxury-style scripts. 🎬 Adjust duration or format: Use Sora 2’s supported durations (4, 8, or 12 seconds) and aspect ratios (e.g., 9:16 for social media). 📲 Auto-publish your videos: Connect the TikTok, Instagram, or YouTube upload nodes for full automation. ✨ Add branding: Include overlays, logos, or end screens via CapCut or an external API integration. 🎥 Watch This Tutorial --- 👋 Need help or want to customize this? 📩 Contact: LinkedIn 📺 YouTube: @DRFIRASS 🚀 Workshops: Mes Ateliers n8n --- 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube / 🚀 Mes Ateliers n8n
By Dr. FirasSample error workflow
A sample error workflow which when triggered sends a notification to the specified Mattermost channel as well as an SMS to the specified mobile number.
By tanaypantAutomate personalized cold emails with Apollo lead scraping and GPT-4.1
How This Works This automation automatically scrapes leads from Apollo using the Apify scraper, filters out those who do not have an Email or URL included, scrapes the leads' website content and writes personalised Icebreakers and subject lines based on the website's content. Set Up (Step-by-Step) Connect the API keys from the Apify scraper mentioned in the workflow sticky note. Insert Apollo URL and the amount of leads you want to scrape. Connect your Slack account (if needed) Reach Out To Me Send me an Email if you need further assistance: richard@advetica-systems.com
By Richard BesierAnalyze competitor LinkedIn posts with Bright Data + Google Gemini to Google Sheets
markdownThis workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically analyzes competitor LinkedIn posts to extract strategic insights and engagement patterns. It saves you time by eliminating manual competitive analysis and provides actionable marketing intelligence from your competitors' social media activity. Overview This workflow automatically scrapes LinkedIn post data including engagement metrics, comments, and content details, then uses AI to analyze the post's intent, effectiveness, and key marketing takeaways. It transforms raw LinkedIn data into structured competitive intelligence stored in Google Sheets. Tools Used n8n: The automation platform that orchestrates the workflow Bright Data: For scraping LinkedIn post data without restrictions Google Gemini: AI agent for intelligent post analysis and insight extraction Google Sheets: For storing structured competitive intelligence 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 scraping node Set Up Google Gemini: Configure your Google Gemini API credentials Configure Google Sheets: Connect your Google Sheets account and copy the template spreadsheet Customize: Simply paste any LinkedIn post URL and run the workflow Use Cases Marketing Teams: Understand what content drives engagement for competitors Content Strategists: Identify successful post formats and messaging strategies Social Media Managers: Benchmark your content performance against industry leaders Agencies/Consultants: Offer LinkedIn competitive analysis as a service to clients 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 linkedinanalytics competitiveintelligence brightdata webscraping marketinga
By Yaron BeenTelegram bot for finding top-rated restaurants with Google Maps via SerpAPI
Telegram Restaurant Bot Workflow --- This workflow creates a Telegram bot that fetches the top 5 rated restaurants for any specified area in Egypt using SerpAPI's Google Maps search. It's designed to provide quick, detailed, and richly formatted information directly in your chat. Key Features Simple Command Trigger: Activate the search with a straightforward command (e.g., التحرير) Real-Time Restaurant Data: Utilizes SerpAPI to pull live data, ratings, and details from Google Maps Top 5 Ranking: Automatically sorts restaurants by their rating in descending order and presents the top five Richly Formatted Replies: Generates a clean, user-friendly Markdown message with essential details: Rating ⭐ Phone Number ☎️ Website 🌐 Service Options (Dine-in ✅ | Takeaway ❌) A direct link to the location on a map 📍 Arabic Language Focused: The workflow is initially configured to process requests and format replies in Arabic How It Works A user sends a place name like التحرير to the Telegram bot The Parse Area node extracts the location name from the message text The Geocode (Nominatim) node finds the geographic coordinates for the area (this can be adapted for more precise location searches) The Find Restaurants (SerpAPI) node uses this area to perform a Google Maps search The Format Reply node processes the search results. It sorts them by rating, takes the top 5, and builds a detailed Markdown-formatted string The Send to Telegram node delivers the final formatted message back to the user who made the request Setup Telegram: Configure your credentials in the Telegram Trigger and Send to Telegram nodes SerpAPI: Add your free or paid API key in the Find Restaurants (SerpAPI) HTTP Request node
By M SayedAutomate Shopify orders from Airtable with Gmail confirmations
This n8n template from Intuz provides a complete solution to automate your order creation process. It seamlessly syncs order data from an Airtable base directly to your Shopify store, creates the official order, and automatically sends a beautiful confirmation email to the customer, closing the loop by updating the status in Airtable. Who's this workflow for? E-commerce Managers Operations Teams Businesses with Custom Order Processes (e.g., B2B, phone orders, quotes) Shopify Store Owners using Airtable as a CRM How it works Triggered from Airtable: The workflow starts instantly when an Airtable Automation sends a signal via a webhook. This happens when you mark an order as ready to be processed in your Airtable base. Fetch Order Details: n8n receives the record ID from Airtable and fetches the complete order details, including customer information and the specific line items for that order. Create Order in Shopify: All the gathered information is used to create a new, official order directly in your Shopify store. Send Confirmation Email: Once the order is successfully created in Shopify, a professionally formatted HTML order confirmation email is sent to the customer via Gmail. Update Airtable Status: Finally, the workflow updates the original order record in Airtable, marking its status as "Done" to prevent duplicate processing and keep your records in sync. Key Requirements to Use This Template n8n Instance: An active n8n account (Cloud or self-hosted). Airtable Base: An Airtable base on a "Pro" plan or higher (required for Airtable Automations). It should contain tables for Orders and Order Line Items. Shopify Store: An active Shopify store with API access permissions. Gmail Account: A Gmail account to send confirmation emails. Setup Instructions Configure the n8n Workflow: Webhook Node: Activate the workflow to get the Production URL from the "Webhook" node. Copy this URL. Airtable Nodes: In the Get a record and Update record nodes, connect your Airtable credentials and select the correct Base and Table IDs. Shopify Node: In the Create an order node, connect your Shopify store using OAuth2 credentials. Gmail Node: In the Send a message node, connect your Gmail account. Set Up the Airtable Automation (Crucial Step): Go to your Airtable base and click on "Automations". Create a new automation. For the trigger, select "When a record meets conditions". Choose your Orders table and set a condition that makes sense for you (e.g., When "Shopify Ordered" is "Pending"). For the action, choose "Run a script". Paste the code below into the script editor: JavaScript const inputConfig = input.config(); const recordId = inputConfig.recordId; const webhookUrl = 'PASTEYOURN8NPRODUCTIONURL_HERE'; await fetch(webhookUrl, { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ recordId: recordId }), }); ReplacePASTEYOURN8NPRODUCTIONURL_HERE with the Production URL you copied from n8n. Add an input variable to the script named recordId and set its value to the "Airtable record ID" from the trigger step. Test the script and turn your Airtable Automation ON. 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 Workflow Automation Click here- Get Started
By Intuz CYBERPULSE AI RedOps: generate daily RedOps security simulation reports
Description Automatically compiles a daily HTML report of all RedOps simulations (Modules 1–5), summarizing offensive activity, response logs, and module effectiveness. Designed for GRC teams, Red/Purple teams, and internal auditors — no manual formatting required. Who’s It For: Red Teams running daily simulations Purple Teams reviewing impact and response CISOs, SOCs, or compliance teams requiring summaries How It Works: Trigger manually or on schedule (e.g., daily cron) Reads simulation logs from a shared Google Sheet Filters data by time or module Formats data into an HTML summary table Sends email with report or uploads to Drive/S3 Requirements: Gmail or SMTP node for email Google Sheets connected (OAuth) Google Sheet Requirements: Columns: Date, Module, Action, Result, Status One row per offensive simulation log Make sure headers are in the first row Unified log format for RedOps Modules 1–5 File Templates: RedOpsAutoReportLog_Template.xlsx email module payload status response timestamp Customization Tips: Set filtering timeframe (24h, 7d) in JavaScript node Modify the table style in the HTML generator Connect to PDF node or S3 for exporting to other tools Ethics & Compliance: This workflow is designed for internal reporting only. It does not simulate attacks or initiate actions. Use for audit logs, red team reviews, and awareness tracking only. Setup Instructions Copy the provided Google Sheet template (linked in File Templates). Fill in your RedOps logs (columns: date, module, action, result, status). Connect Google Sheets node using OAuth credentials. In the Gmail node: Set recipient email (use your_email@example.com as a placeholder). Choose HTML output from the summary table. Trigger via Cron node (daily) or manually. Optional: Connect Drive or S3 node to store a backup. Supports: NIST 800-53 AU-6, AU-12 ISO 27001 A.16.1.6 ACSC Essential Eight reporting practices 🔗 Part of the CYBERPULSE RedOps Suite 🌐 https://cyberpulsesolutions.com 📧 info@cyberpulsesolutions.com
By Adnan Tariq