BuiltWith Technology Stack Lead Generation to Google Sheets - n8n Workflow

• Sales development representatives (SDRs) looking for targeted leads based on technology usage.


• Marketing analysts needing automated competitive intelligence and technology tracking.


• SaaS businesses prospecting companies that use complimentary or competing tech stacks.


• Developers or users of n8n who need a practical example of complex API integration and data transformation.

Lead generation and market research often require knowing which companies utilize specific software or technology stacks. Manually searching for this data is slow and inefficient. This expertly crafted n8n workflow solves this by providing a hands-free solution. It leverages the powerful BuiltWith API, allowing you to instantly find thousands of domains running a specific technology (like 'Shopify' or 'React'). The integration of the Google Sheets n8n node ensures that once the raw data is retrieved, it is cleaned, structured, and immediately logged into an actionable spreadsheet. This specific n8n workflow acts as a powerful template for anyone needing to bridge complex external data sources into standardized organizational tools.

This n8n workflow is designed for manual execution, ensuring you control when data retrieval occurs.

1. Start and Set: The process begins with the Manual Trigger, which is the starting n8n trigger for the flow. Immediately following, the Set n8n node is configured to define the target Technology (e.g., 'Shopify') that the n8n workflow will search for.


2. API Request: The workflow then utilizes an HTTP Request n8n node to connect to the BuiltWith API. It dynamically inserts the defined technology name and your required API key into the query parameters to fetch relevant website results.


3. Data Transformation: The response, which is typically complex JSON, is passed to the Function n8n node (labeled 'Extract Site Info'). This custom code iterates over the results, structuring the data by extracting key fields like domain, technology, firstIndexed, and vertical into a clean, spreadsheet-ready format.


4. Logging Results: Finally, the processed items are passed to the Google Sheets n8n node. This final n8n node appends the clean data (one row per site) into your designated spreadsheet, successfully completing the data logging for your lead generation efforts.

To use this n8n workflow, follow these steps:

1. Import the n8n template: Copy the provided JSON code and paste it into your n8n instance using the 'New' button or by navigating to the 'Workflows' menu and selecting 'Import from JSON'.


2. BuiltWith API Key: Locate the 'Fetch BuiltWith Data' HTTP Request n8n node. Replace the placeholder YOURAPIKEY in the Query Parameters with your actual BuiltWith API key.


3. Set Technology: Adjust the 'Set Technology' n8n node to define the technology you wish to track (e.g., change 'Shopify' to 'WooCommerce').


4. Google Sheets Credentials: Click on the 'Log to Google Sheet' n8n node and set up or select your Google Sheets OAuth2 API credentials.


5. Configure Spreadsheet: In the Google Sheets n8n node, ensure you select the correct 'Document ID' and 'Sheet Name' where you want the scraped data to be appended. Ensure your sheet has corresponding headers (Domain, Technology, First Indexed, Vertical) for mapping clarity.


6. Run: Execute the n8n workflow using the 'Manual Trigger' n8n node to begin tracking.

This n8n workflow relies on a few key n8n node types to achieve its goal:

Manual Trigger (n8n trigger): The starting point for this specific n8n workflow. It allows the user to initiate the data pull process on demand.
Set Technology (Set n8n node): Used to inject a specific, static piece of information (Technology: Shopify) into the workflow stream, making the subsequent API calls dynamic.
Fetch BuiltWith Data (HTTP Request n8n node): This is the crucial connection point. It performs a GET request to the BuiltWith API, passing the technology variable and the required API key as query parameters to retrieve the raw technological data.
Extract Site Info (Code n8n node): Handles data manipulation. It takes the complex JSON output from the BuiltWith n8n node, iterates through the Results array, and transforms the structure into simple, clean objects suitable for spreadsheet entry.

• Log to Google Sheet (Google Sheets n8n node): Configured to the 'Append' operation. It receives the clean data objects from the previous n8n node and writes the domain, technology, index date, and vertical information directly into the specified row of the Google Sheet.