HumationHuman + Automation
Back to Catalog

Automated weekly tech stack reports with BuiltWith, GPT-4o & Gmail

Yaron BeenYaron Been
316 views
2/3/2026
ExtractionJSONData TransformationRaw DataUtility
Official Page

Automated weekly report that summarizes technology stack changes, trends, and insights from your tracked companies.

🚀 What It Does

  • Compiles weekly technology updates
  • Highlights significant changes
  • Identifies emerging trends
  • Provides actionable insights
  • Delivers scheduled reports

🎯 Perfect For

  • CTOs and technical leaders
  • Sales and marketing teams
  • Business intelligence
  • Technology consultants
  • Market researchers

⚙️ Key Benefits

✅ Weekly digest of changes
✅ Trend analysis
✅ Competitive intelligence
✅ Time-saving automation
✅ Data-driven decisions

🔧 What You Need

  • BuiltWith API access
  • n8n instance
  • Email service (for delivery)
  • Google Sheets (for data storage)

📊 Report Includes

  • New technology adoptions
  • Technology removals
  • Industry trends
  • Competitive analysis
  • Custom metrics

🛠️ Setup & Support

Quick Setup

Get your first report in 15 minutes with our step-by-step guide

📺 Watch Tutorial

YouTube

💼 Get Expert Support

LinkedIn

📧 Direct Help

Email

Stay ahead of technology trends with a comprehensive weekly digest of your industry's technology landscape.

Automated Weekly Tech Stack Reports with BuiltWith & GPT-4o

This n8n workflow automates the generation and delivery of weekly tech stack reports for a list of target companies. It leverages the BuiltWith API to gather technology data, processes this data with an AI agent (GPT-4o) to create a concise summary, and then emails the report.

What it does

  1. Schedules Report Generation: Triggers weekly on a defined schedule (e.g., every Monday at 9 AM).
  2. Fetches Company List: Reads a list of company names from a Google Sheet.
  3. Retrieves Tech Stack Data: For each company, it queries the BuiltWith API to get their current technology stack.
  4. Generates AI Summary: Uses a LangChain AI Agent with an OpenAI Chat Model (GPT-4o) to summarize the tech stack data into a concise report.
  5. Sends Email Report: Compiles the AI-generated summary into an email and sends it via Gmail to a specified recipient.

Prerequisites/Requirements

  • n8n Instance: A running n8n instance.
  • Google Sheets Account: A Google Sheets spreadsheet containing a list of company names.
    • Credential: Google Sheets OAuth2 or API Key credential configured in n8n.
  • BuiltWith API Key: An API key for the BuiltWith service to retrieve tech stack data.
    • Credential: BuiltWith API Key credential configured in n8n.
  • OpenAI API Key: An API key for OpenAI to power the GPT-4o chat model.
    • Credential: OpenAI API Key credential configured in n8n.
  • Gmail Account: A Gmail account to send the reports.
    • Credential: Gmail OAuth2 credential configured in n8n.

Setup/Usage

  1. Import the Workflow: Import the provided JSON into your n8n instance.
  2. Configure Credentials:
    • Google Sheets: Set up your Google Sheets credential. Ensure the spreadsheet ID and sheet name in the "Google Sheets" node are correctly configured to point to your company list.
    • BuiltWith: Set up your BuiltWith API Key credential.
    • OpenAI: Set up your OpenAI API Key credential.
    • Gmail: Set up your Gmail credential.
  3. Customize Schedule: Adjust the "Schedule Trigger" node to your desired reporting frequency (e.g., weekly, daily, specific time).
  4. Review Code Node: The "Code" node likely contains logic to format the BuiltWith API response before sending it to the AI agent. Review and adjust if your BuiltWith data structure or desired output differs.
  5. Configure AI Agent: The "AI Agent" node uses an "OpenAI Chat Model". Ensure the model (e.g., gpt-4o) and any specific instructions for summarization are configured as desired.
  6. Configure Gmail Node:
    • Set the recipient email address(es) in the "Gmail" node.
    • Customize the email subject and body using expressions to include the AI-generated report.
  7. Activate the Workflow: Once configured, activate the workflow to start generating and sending weekly tech stack reports.

Related Templates

AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.

higashiyama By higashiyama
90

Generate Weather-Based Date Itineraries with Google Places, OpenRouter AI, and Slack

🧩 What this template does This workflow builds a 120-minute local date course around your starting point by querying Google Places for nearby spots, selecting the top candidates, fetching real-time weather data, letting an AI generate a matching emoji, and drafting a friendly itinerary summary with an LLM in both English and Japanese. It then posts the full bilingual plan with a walking route link and weather emoji to Slack. 👥 Who it’s for Makers and teams who want a plug-and-play bilingual local itinerary generator with weather awareness — no custom code required. ⚙️ How it works Trigger – Manual (or schedule/webhook). Discovery – Google Places nearby search within a configurable radius. Selection – Rank by rating and pick the top 3. Weather – Fetch current weather (via OpenWeatherMap). Emoji – Use an AI model to match the weather with an emoji 🌤️. Planning – An LLM writes the itinerary in Markdown (JP + EN). Route – Compose a Google Maps walking route URL. Share – Post the bilingual itinerary, route link, and weather emoji to Slack. 🧰 Requirements n8n (Cloud or self-hosted) Google Maps Platform (Places API) OpenWeatherMap API key Slack Bot (chat:write) LLM provider (e.g., OpenRouter or DeepL for translation) 🚀 Setup (quick) Open Set → Fields: Config and fill in coords/radius/time limit. Connect Credentials for Google, OpenWeatherMap, Slack, and your LLM. Test the workflow and confirm the bilingual plan + weather emoji appear in Slack. 🛠 Customize Adjust ranking filters (type, min rating). Modify translation settings (target language or tone). Change output layout (side-by-side vs separated). Tune emoji logic or travel mode. Add error handling, retries, or logging for production use.

nodaBy noda
52

AI-powered document search with Oracle and ONNX embeddings for recruiting

How it works Create a user for doing Hybrid Search. Clear Existing Data, if present. Add Documents into the table. Create a hybrid index. Run Semantic search on the Documents table for "prioritize teamwork and leadership experience". Run Hybrid search for the text input in the Chat interface on the Documents table. Setup Steps Download the ONNX model allMiniLML12v2augmented.zip Extract the ZIP file on the database server into a directory, for example /opt/oracle/onnx. After extraction, the folder contents should look like: bash bash-4.4$ pwd /opt/oracle/onnx bash-4.4$ ls allMiniLML12_v2.onnx Connect as SYSDBA and create the DBA user sql -- Create DBA user CREATE USER app_admin IDENTIFIED BY "StrongPassword123" DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON users; -- Grant privileges GRANT DBA TO app_admin; GRANT CREATE TABLESPACE, ALTER TABLESPACE, DROP TABLESPACE TO app_admin; Create n8n Oracle DB credentials hybridsearchuser → for hybrid search operations dbadocuser → for DBA setup (user and tablespace creation) Run the workflow Click the manual Trigger It displays Pure semantic search results. Enter search text in Chat interface It displays results for vector and keyword search. Note The workflow currently creates the hybrid search user, docuser with the password visible in plain text inside the n8n Execute SQL node. For better security, consider performing the user creation manually outside n8n. Oracle 23ai or 26ai Database has to be used. Reference Hybrid Search End-End Example

sudarshanBy sudarshan
211