BuiltWith Technology Stack Extraction to Google Sheets - n8n Workflow

Market Researchers: Anyone needing scalable data collection on competitor or target website technologies.
Sales and Lead Generation Teams: Users who need to enrich lead lists in Google Sheets with technology intelligence (e.g., detecting if a company uses Shopify or WordPress).
n8n Automation Users: Developers or analysts looking for practical n8n templates integrating APIs and Google Sheets.
Data Engineers: Professionals seeking a robust n8n node structure for repetitive data cleaning and API interaction.

Manually researching the technology stack of hundreds of websites is time-consuming and prone to error. This efficient n8n workflow solves this by fully automating the process. By leveraging the BuiltWith API, this automation reads a list of domains stored in a Google Sheet, fetches the key technology details (like the main CMS or cloud provider), and seamlessly writes the structured results back to the original sheet. This specific n8n workflow is a crucial tool for anyone aiming to scale their tech-based market analysis, ensuring your data is always up-to-date without writing complex scripts. Using this n8n template allows you to focus on strategy rather than tedious data entry.

This automation follows a linear, three-step data enrichment process:

1. Trigger and Input: The n8n workflow begins with the Manual Trigger n8n node (easily swappable with a Cron n8n trigger for scheduling). It then connects to the 'Read Domains from Google Sheets' n8n node, which pulls the list of domains requiring analysis, including the unique rownumber for later updating.


2. API Lookup: For each domain item read from the sheet, the 'Fetch detail via BuiltWith' n8n node (an HTTP Request n8n node) sends a query to the BuiltWith API, passing the domain name as a lookup parameter. This step requires a valid BuiltWith API key.


3. Data Transformation: The 'Extract Tech Stack Info' n8n node (a Code n8n node) then processes the verbose BuiltWith JSON response. It specifically isolates and extracts the primary technology, its category, and detection dates (First Detected, Last Detected) into a clean, standardized format, making the data ready for storage.


4. Sheet Update: Finally, the 'Update Google Sheet' n8n node uses the unique rownumber retrieved in the first step to match and update the corresponding row in the Google Sheet with the newly extracted technology details. This ensures precise, non-destructive data population, completing the n8n workflow execution.

To deploy and run this powerful n8n workflow, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON and paste it directly into your n8n instance using the 'New' menu and selecting 'Import from JSON'. This imports the core logic of this specific n8n template.


2. Google Sheets Credentials: Click on the 'Read Domains from Google Sheets' n8n node and the 'Update Google Sheet' n8n node. Set up or select your existing Google Sheets OAuth2 API credentials. Ensure the referenced Document ID and Sheet Name match your target spreadsheet where the domains are listed.


3. BuiltWith API Key: Locate the 'Fetch detail via BuiltWith' n8n node. In the Query Parameters section, replace the placeholder value for the KEY parameter ('YOURAPIKEY') with your actual BuiltWith API key. This is essential for the HTTP Request n8n node to function.


4. Prepare the Sheet: Make sure your Google Sheet has a column named 'Domain' and create empty columns for the data that will be written back, such as 'Technology', 'Category', 'First Detected', and 'Last Detected'.


5. Execution: Save the n8n workflow. Use the Manual Trigger n8n trigger to test the flow, or replace it with a Cron n8n node for scheduled, automated runs.

Manual Trigger (n8n trigger): The starting point of this n8n workflow, used for immediate execution and testing.
Read Domains from Google Sheets (Google Sheets n8n node): Reads all domain inputs from the specified sheet and tab. Crucially, it captures the hidden rownumber attribute, which is necessary for the final update operation.
Fetch detail via BuiltWith (HTTP Request n8n node): Sends an authenticated API request to BuiltWith using the domain input. The configuration uses the expression ={{ $json.Domain }} to dynamically look up the domain for each item passing through the n8n node.
Extract Tech Stack Info (Code n8n node): Contains custom JavaScript logic. This key n8n node processes the nested JSON output from BuiltWith, prioritizing and extracting the single most relevant technology along with its associated metadata (Category, detection dates).

• Update Google Sheet (Google Sheets n8n node): Configured to use the 'update' operation. It matches rows based on the incoming rownumber and writes the refined technology data back into the columns of the target spreadsheet, concluding the n8n workflow.