n8n

How to Automate Google Sheets Domain Search?

Turn a simple spreadsheet into a bulk domain search tool. Teams that keep company lists in Google Sheets can push those names to a domain search service in one click. It is helpful for sales research, list building, and outreach prep.

Here is how it works. You start the run manually. The Google Sheets node reads the first column named company. A code node uses your API key, API secret, and user ID to build a signed request with a timestamp. The HTTP Request node sends a POST to the bulk search endpoint with the job name, your user ID, and the sheet data. The service processes the list in the background. Results are delivered in the app and by email when ready.

Setup is simple. Create a sheet with company in the first column and connect your Google account. Add your API details in the code node, then create a header credential for the Authorization value. Test with a small list to confirm you see results. Expect strong time savings as you avoid manual uploads and copy paste. Use it for prospect list enrichment, partner research, and market mapping.

What are the key features?

  • Manual start to control when bulk jobs run
  • Reads company names from the first column in Google Sheets
  • Code node generates API signature and timestamp using your key, secret, and user ID
  • HTTP Request node posts task, job name, user ID, and data to the bulk search endpoint
  • Header auth built with an Authorization value and a timestamp header
  • Asynchronous results delivered in the app and by email

What are the benefits?

  • Reduce manual uploads from 1 hour to 5 minutes
  • Automate up to 90 percent of repetitive list checks
  • Handle thousands of company rows in a single run
  • Connect Google Sheets and a domain search API without custom code
  • Keep your sheet as the single source of truth

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Sheets and Icypeas. See the Tools Required section above for links to create accounts with these services.
  3. Prepare your data: In Google Sheets, create a sheet with the first column header named company and add a few company names to test.
  4. Connect Google Sheets: Double click the Google Sheets node, choose your Document and Sheet, then in the credential dropdown click Create new credential and follow the on screen steps to sign in with your Google account.
  5. Add API details: Open the code node and replace the placeholders with your API key, API secret, and user ID from your Icypeas profile. Save the node.
  6. Set HTTP header auth: Open the HTTP Request node. In Credential to connect with, choose Create new credential for HTTP Header Auth. For Name enter Authorization. For Value choose expression and set {{$json.api.key + ':' + $json.api.signature}}. Save.
  7. Check headers and body: Confirm the X-ROCK-TIMESTAMP header uses the expression {{$json.api.timestamp}}. In the body, verify task is domain-search, name is your job label, user is {{$json.api.userId}}, and data is {{$json.data}}.
  8. Save and run: Click Execute Workflow. Watch the run complete without errors.
  9. Verify results: Open the bulk search page in your account and check for the new job. Also look for the email notification with results.
  10. Troubleshoot: If you see auth or signature errors, recheck your key, secret, and user ID. If Google Sheets returns no rows, confirm the company header and document access. On self hosted n8n, ensure the crypto module is enabled in Settings if the code node requires it.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Icypeas

Sign up

Basic: $19 / mo (+VAT), 1,000 credits; includes API access and n8n

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.