Track Website Technology Changes with BuiltWith and Google Sheets - n8n Workflow

Sales and Marketing professionals looking for targeted lead generation based on technology stack.
Market Researchers tracking competitor usage of specific platforms.
n8n users seeking practical n8n templates for external API integration and data logging.
Automation Specialists who need a robust n8n node structure for data transformation.

This comprehensive n8n workflow is designed to streamline market intelligence gathering. By leveraging the powerful BuiltWith API, this specific n8n workflow allows users to identify websites utilizing a chosen technology stack—such as Shopify or WordPress—and automatically record this valuable data. It solves the challenge of manually performing technology stack analysis, providing clean, structured results directly in a spreadsheet. This n8n template is highly efficient for lead generation, competitive analysis, and tech trend monitoring. Every n8n node, from the n8n trigger to the final logging step, is configured for performance and ease of use, making it one of the most useful n8n templates for business intelligence.

1. Start: The process begins with the Manual Trigger n8n node, ideal for ad-hoc checks or testing this robust n8n workflow.


2. Define Target: The Set Technology n8n node defines the specific platform being tracked (e.g., "Shopify"). This variable setup ensures the n8n workflow is highly reusable.


3. Fetch Data: An HTTP Request n8n node connects to the BuiltWith API. It dynamically passes the chosen technology name and your API key to request a list of matching domains, forming the core data retrieval mechanism of this n8n workflow.


4. Data Transformation: The Extract Site Info n8n node (a Code n8n node) processes the resulting complex JSON payload. It extracts crucial fields like domain, technology, firstIndexed, and vertical, transforming the raw API data into clean, structured items, preparing them for the next step of the n8n workflow.


5. Logging: Finally, the Log to Google Sheet n8n node appends the newly formatted site information to a specified Google Sheets document, providing a permanent and organized record of technology adoption tracked by this automated n8n workflow. This completes the action initiated by the n8n trigger.

1. Download the provided n8n workflow JSON file.


2. Navigate to your n8n instance and click "Import Workflow" to load this specialized n8n template.


3. BuiltWith API Key: In the Fetch BuiltWith Data n8n node (HTTP Request), replace YOURAPIKEY in the Query Parameters with your actual BuiltWith API key.


4. Google Sheets Credentials: Click on the Log to Google Sheet n8n node, select "Credentials," and set up your Google Sheets OAuth2 API account. Grant necessary permissions (read/write access to spreadsheets) for the n8n node.


5. Google Sheets Target: Configure the Document ID and Sheet Name in the Log to Google Sheet n8n node where the extracted BuiltWith data should be stored.


6. Activate: Save and activate the n8n workflow. Run it using the Manual Trigger n8n trigger to test the data pipeline.

Manual Trigger n8n node (Trigger): Function: Initiates the n8n workflow execution manually. Key Configuration: Serves as the starting n8n trigger for testing and ad-hoc runs of the n8n templates.
Set Technology n8n node (Set): Function: Defines the critical input variable (Technology set to "Shopify") used in subsequent API calls. Key Configuration: Assignment of static string value 'Shopify' to the Technology key.
Fetch BuiltWith Data (HTTP Request n8n node): Function: Connects to the BuiltWith API to retrieve domains using the specified technology. Key Configuration: Uses query parameters KEY (API Key placeholder) and TECH (dynamic expression: ={{ $json.Technology }}).
Extract Site Info (Code n8n node): Function: Transforms the nested JSON response from BuiltWith into simplified, flat data items suitable for spreadsheet logging. Key Configuration: Custom JavaScript code maps the BuiltWith results, extracting domain, technology, firstIndexed, and vertical for clean output in this n8n workflow.

• Log to Google Sheet (Google Sheets n8n node): Function: Appends the clean, processed domain data to a Google Sheet. Key Configuration: Operation set to append, mapping specific input fields (domain, technology, firstIndexed, vertical) to corresponding spreadsheet columns.