Enrich Company Domains with Business Data using Perplexity AI and Google Sheets

This n8n workflow automates the process of enriching a list of company domains from a Google Sheet with detailed business information using Perplexity AI. It's designed to streamline data collection for sales, marketing, or research teams by providing comprehensive insights into companies based on their website domains.

What it does

This workflow performs the following steps:

1. Triggers Manually: The workflow starts when manually executed.
2. Reads Company Domains from Google Sheets: It connects to a specified Google Sheet and reads a list of company domains.
3. Loops Over Items: It processes each company domain individually.
4. Enriches Data with Perplexity AI (via HTTP Request): For each domain, it makes an HTTP request to Perplexity AI (or a similar AI service) to gather business data. This typically involves crafting a prompt to the AI asking for specific company information based on the domain.
5. Processes AI Response (Code Node): A Code node is used to parse and extract relevant information from the AI's response, transforming it into a structured format.
6. Updates Google Sheet: The extracted and enriched data is then written back to the Google Sheet, updating the original entries or adding new columns with the gathered intelligence.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Account: With access to Google Sheets. You'll need to set up Google Sheets credentials in n8n.
• Perplexity AI API Key (or similar AI service): Access to an AI service like Perplexity AI that can answer questions based on web content. This will require an API key or equivalent authentication for making HTTP requests.
• Google Sheet: A Google Sheet containing a list of company domains in a designated column.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click on the "Import from JSON" button (usually a cloud icon with an arrow pointing down) and paste the JSON code.
2. Configure Credentials:
   • Google Sheets: Click on the "Google Sheets" node. Under "Credentials", select an existing Google Sheets credential or create a new one. Follow the n8n documentation for setting up Google Sheets OAuth credentials.
   • HTTP Request (Perplexity AI): Click on the "HTTP Request" node. Configure the URL to your Perplexity AI endpoint and add your API key or other necessary authentication (e.g., as a header or query parameter).
3. Configure Google Sheets Node:
   • Google Sheets (Read): In the first "Google Sheets" node, specify the "Spreadsheet ID" and "Sheet Name" where your company domains are located. Ensure the column containing domains is correctly identified.
   • Google Sheets (Write): In the second "Google Sheets" node (after the Code node), configure it to write back to the same spreadsheet and sheet, specifying how the new data should be appended or updated (e.g., by matching on the domain name).
4. Configure HTTP Request Node for Perplexity AI:
   • Adjust the "URL" to point to the Perplexity AI API endpoint.
   • Modify the "Body" of the request to include a prompt that asks Perplexity AI for the desired business information, referencing the {{ $json.domain }} from the previous Google Sheets output.
   • Set up "Headers" for authentication (e.g., Authorization: Bearer YOUR_PERPLEXITY_API_KEY).
5. Configure Code Node:
   • The "Code" node is crucial for parsing the response from Perplexity AI. You will need to inspect the structure of the AI's response and write JavaScript code to extract the specific data points you want (e.g., company size, industry, location, funding, etc.).
   • The output of this node should be an array of objects, where each object contains the original domain and the newly extracted business data, ready to be written back to Google Sheets.
6. Activate and Test:
   • Save the workflow.
   • Click "Execute Workflow" to run a test. Monitor the output of each node to ensure data is flowing correctly and the AI is returning expected results.
   • Once satisfied, activate the workflow.