<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Jack Dang</title>
    <description>The latest articles on DEV Community by Jack Dang (@jackdang_replynodes).</description>
    <link>https://dev.to/jackdang_replynodes</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4254673%2F7de45da7-05ac-42d6-8307-10ef77ebeaba.png</url>
      <title>DEV Community: Jack Dang</title>
      <link>https://dev.to/jackdang_replynodes</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/jackdang_replynodes"/>
    <language>en</language>
    <item>
      <title>n8n workflow: enrich a Google Sheet of domains with company data (name, size, funding), plus a 99-domain benchmark</title>
      <dc:creator>Jack Dang</dc:creator>
      <pubDate>Fri, 20 Nov 2026 03:30:50 +0000</pubDate>
      <link>https://dev.to/jackdang_replynodes/n8n-workflow-enrich-a-google-sheet-of-domains-with-company-data-name-size-funding-plus-a-2c7</link>
      <guid>https://dev.to/jackdang_replynodes/n8n-workflow-enrich-a-google-sheet-of-domains-with-company-data-name-size-funding-plus-a-2c7</guid>
      <description>&lt;p&gt;&lt;strong&gt;What you get:&lt;/strong&gt; an n8n workflow that takes a column of company domains in Google Sheets and fills in name, description, industry, HQ, employee range and funding on the same rows. On a hand-picked list of 99 domains it finished in about 5 minutes 45 seconds with no manual lookups. A second template builds a company list from a keyword instead.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why use it
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;No copy-pasting between tabs.&lt;/strong&gt; Put domains in column A, click Execute, and every row is enriched in place.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Nothing to code.&lt;/strong&gt; Import &lt;code&gt;workflow.json&lt;/code&gt; into n8n, connect Google Sheets, add one API credential.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;You can trust what a row means.&lt;/strong&gt; Each row ends with a status: &lt;code&gt;found&lt;/code&gt;, &lt;code&gt;found_live_only&lt;/code&gt;, &lt;code&gt;not_found&lt;/code&gt;, &lt;code&gt;skipped_duplicate&lt;/code&gt; or &lt;code&gt;error&lt;/code&gt;. Failed lookups are never written as blank rows.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Safe to re-run and cheap to run.&lt;/strong&gt; Rows that already have a status are skipped. You pay 1 credit per company found; misses and errors are free.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Works in the other direction too.&lt;/strong&gt; Template 2 turns a keyword, countries and a size range into a list of matching companies, skipping ones already in your sheet.&lt;/li&gt;
&lt;/ul&gt;

&lt;blockquote&gt;
&lt;p&gt;Disclosure: I run ReplyNodes, the company database these templates call, and I wrote the templates. They are MIT licensed, but they need a ReplyNodes API key. New accounts get 500 free credits; after that it is paid (see &lt;a href="https://replynodes.com" rel="noopener noreferrer"&gt;replynodes.com&lt;/a&gt; for pricing). The templates are not in the n8n template library yet, so import them from the repo: &lt;a href="https://github.com/replynodes/n8n-company-research" rel="noopener noreferrer"&gt;https://github.com/replynodes/n8n-company-research&lt;/a&gt;&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  At a glance
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;&lt;/th&gt;
&lt;th&gt;Template 1: enrich by domain&lt;/th&gt;
&lt;th&gt;Template 2: ICP list builder&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Input&lt;/td&gt;
&lt;td&gt;domains in a Google Sheet&lt;/td&gt;
&lt;td&gt;keyword, countries, size range&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Output&lt;/td&gt;
&lt;td&gt;company fields added to the same rows&lt;/td&gt;
&lt;td&gt;matching companies appended to a sheet&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Cost&lt;/td&gt;
&lt;td&gt;1 credit per company found&lt;/td&gt;
&lt;td&gt;1 credit per page of up to 10 companies&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Result I measured&lt;/td&gt;
&lt;td&gt;99 domains: 93 found, 4 website-only, 2 not found, 0 errors&lt;/td&gt;
&lt;td&gt;1 page, 6 companies, 1 credit&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Tested on&lt;/td&gt;
&lt;td&gt;n8n 2.35.7 and n8n Cloud, real Google Sheet&lt;/td&gt;
&lt;td&gt;same&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Last updated 2026-11-20.&lt;/p&gt;

&lt;h2&gt;
  
  
  How do I enrich a Google Sheet of domains in n8n?
&lt;/h2&gt;

&lt;p&gt;Put domains in column A, click Execute, and the same rows get filled in:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F7pbheczmlm9vtrbquf1f.gif" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F7pbheczmlm9vtrbquf1f.gif" alt="The workflow filling a Google Sheet of domains with company data" width="800" height="492"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Columns per row: &lt;code&gt;status&lt;/code&gt;, &lt;code&gt;source&lt;/code&gt;, &lt;code&gt;name&lt;/code&gt;, &lt;code&gt;description&lt;/code&gt;, &lt;code&gt;industries&lt;/code&gt;, &lt;code&gt;hq_country&lt;/code&gt;, &lt;code&gt;hq_region&lt;/code&gt;, &lt;code&gt;employees_min&lt;/code&gt;, &lt;code&gt;employees_max&lt;/code&gt;, &lt;code&gt;funding_total_usd&lt;/code&gt;, &lt;code&gt;latest_round_type&lt;/code&gt;, &lt;code&gt;latest_round_date&lt;/code&gt;, &lt;code&gt;data_loaded_at&lt;/code&gt;, &lt;code&gt;checked_at&lt;/code&gt; and &lt;code&gt;error&lt;/code&gt;.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Input.&lt;/strong&gt; Full URLs are normalized (&lt;code&gt;https://www.Stripe.com/pricing&lt;/code&gt; becomes &lt;code&gt;stripe.com&lt;/code&gt;). Invalid domains get an &lt;code&gt;error&lt;/code&gt; status. Duplicates in the same run are skipped and marked.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Statuses.&lt;/strong&gt; &lt;code&gt;found_live_only&lt;/code&gt; means the company is not in the database and only the name and description were read from the live website, so do not expect size or funding. A hit counts only if its domain is exactly the one you asked for.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Re-running.&lt;/strong&gt; Only rows with an empty &lt;code&gt;status&lt;/code&gt; are processed, so you can add rows and run again. To re-check a row, clear its &lt;code&gt;status&lt;/code&gt; cell.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Pace.&lt;/strong&gt; One lookup at a time, about one per second (that is what the API allows), with a single retry on 429, 503 or 504. A bad row never stops the run.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Credits.&lt;/strong&gt; 1 credit per lookup that finds a company. Lookups that find nothing, and errors, are free. The website fallback uses a keyless endpoint with its own public daily limit.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  How do I build a list of target companies from a keyword in n8n?
&lt;/h2&gt;

&lt;p&gt;Template 2 appends matching companies to a sheet and skips companies already in it. In the &lt;strong&gt;Settings&lt;/strong&gt; node you set:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;code&gt;keyword&lt;/code&gt;, one term or a quoted phrase, for example &lt;code&gt;carbon accounting software&lt;/code&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;countries&lt;/code&gt;, for example &lt;code&gt;US&lt;/code&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;employeesMin&lt;/code&gt; and &lt;code&gt;employeesMax&lt;/code&gt;, for example 11 and 200&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;industries&lt;/code&gt; (optional) and &lt;code&gt;maxPages&lt;/code&gt; (default 5, capped at 10)&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Cost is 1 credit per page of up to 10 companies; empty pages and errors are free, and &lt;code&gt;maxPages&lt;/code&gt; caps the spend. On a real run with the settings above and &lt;code&gt;maxPages&lt;/code&gt; 1 it fetched one page, added 6 companies, stopped with "no more results" and used 1 credit.&lt;/p&gt;

&lt;p&gt;Search is by keyword, not by meaning: "top 10 fintech startups in Berlin" will not work, a plain term plus filters will. Avoid &lt;code&gt;OR&lt;/code&gt; and &lt;code&gt;-exclusion&lt;/code&gt; in the keyword, those queries often hit the API's 5-second limit. A search returns at most 1,000 results.&lt;/p&gt;

&lt;h2&gt;
  
  
  How well does it work? A 99-domain benchmark
&lt;/h2&gt;

&lt;p&gt;I ran template 1 on 99 domains: 97 well-known SaaS, developer-tool and climate-tech companies, plus 2 made-up domains to check the failure path. Default settings, on n8n Cloud, writing to a real Google Sheet.&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Result&lt;/th&gt;
&lt;th&gt;Rows&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;
&lt;code&gt;found&lt;/code&gt; (in the database)&lt;/td&gt;
&lt;td&gt;93&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;
&lt;code&gt;found_live_only&lt;/code&gt; (website metadata only)&lt;/td&gt;
&lt;td&gt;4&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;
&lt;code&gt;not_found&lt;/code&gt; (the 2 made-up domains)&lt;/td&gt;
&lt;td&gt;2&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;&lt;code&gt;error&lt;/code&gt;&lt;/td&gt;
&lt;td&gt;0&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;ul&gt;
&lt;li&gt;Of the 93 database hits, all 93 had an employee range, 82 had a description and 78 had funding data. So funding was missing on 15 of the 93.&lt;/li&gt;
&lt;li&gt;It used 93 credits (one per found company; the live-only, not-found and error rows were free) and took about 5 minutes 45 seconds, roughly 3.5 seconds per row end to end.&lt;/li&gt;
&lt;li&gt;No retries were needed.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What are the limits?
&lt;/h2&gt;

&lt;p&gt;The list is hand-picked and popular, so the hit rate on obscure domains will be lower. A smaller earlier check on 20 well-known domains returned the right company for 16, with &lt;code&gt;calendly.com&lt;/code&gt;, &lt;code&gt;typeform.com&lt;/code&gt; and &lt;code&gt;firecrawl.dev&lt;/code&gt; missing (the website fallback fills those in). Please do not read 93 of 97 as a promise for your own list.&lt;/p&gt;

&lt;p&gt;The data comes from third-party datasets and it is not perfect. While spot-checking I found at least two wrong matches: &lt;code&gt;gumroad.com&lt;/code&gt; came back as a record named AirPitch, and &lt;code&gt;notion.so&lt;/code&gt; came back as a different company. Some industry labels are odd (Stripe is labelled "facilities services"). Lookup is by exact domain only, not by company name. Every row carries &lt;code&gt;data_loaded_at&lt;/code&gt;, which shows when the record was last loaded. Treat the output as a good first pass and spot-check anything you are going to act on. For template 2, keyword results can include loosely related companies, so read the &lt;code&gt;description&lt;/code&gt; column before using a list for outreach.&lt;/p&gt;

&lt;p&gt;This is a lightweight option for these fields, not a replacement for a full enrichment platform.&lt;/p&gt;

&lt;h2&gt;
  
  
  How do I set it up?
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Create a Google Sheet and paste the header row from the README of the template you use (template 2 adds &lt;code&gt;query&lt;/code&gt; and &lt;code&gt;page&lt;/code&gt; columns).&lt;/li&gt;
&lt;li&gt;Download &lt;code&gt;workflow.json&lt;/code&gt; from the repo and import it (Workflows, Import from File).&lt;/li&gt;
&lt;li&gt;Open the Google Sheets nodes (template 1: &lt;strong&gt;Read domains&lt;/strong&gt; and &lt;strong&gt;Write row&lt;/strong&gt;; template 2: &lt;strong&gt;Read existing rows&lt;/strong&gt; and &lt;strong&gt;Add to sheet&lt;/strong&gt;), connect your Google account and pick the same spreadsheet and tab in both.&lt;/li&gt;
&lt;li&gt;Create a Header Auth credential called &lt;code&gt;ReplyNodes API&lt;/code&gt; with header name &lt;code&gt;Authorization&lt;/code&gt; and value &lt;code&gt;Bearer &amp;lt;your key&amp;gt;&lt;/code&gt;, and select it in the HTTP Request nodes (template 1: both &lt;strong&gt;Search company&lt;/strong&gt; nodes; template 2: &lt;strong&gt;Search page&lt;/strong&gt;).&lt;/li&gt;
&lt;li&gt;Template 2 only: open &lt;strong&gt;Settings&lt;/strong&gt; and describe your target. Then click Execute workflow.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;One n8n quirk worth knowing: every time you pick a document or sheet in a Google Sheets node, n8n resets the column mapping. After choosing the sheet, set Mapping Column Mode back to Map Automatically (and, in &lt;strong&gt;Write row&lt;/strong&gt; of template 1, set Column to match on to &lt;code&gt;row_number&lt;/code&gt;). The READMEs say so, but it is easy to miss.&lt;/p&gt;

&lt;p&gt;A wrong API key shows up in the &lt;code&gt;error&lt;/code&gt; column as an HTTP 401 message ending with "(check the ReplyNodes API credential)", not as a silent empty sheet.&lt;/p&gt;

&lt;h2&gt;
  
  
  FAQ
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Does it need coding?&lt;/strong&gt; No. You import the workflow JSON and connect two credentials: Google Sheets and a Header Auth credential for the API.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;How much does it cost?&lt;/strong&gt; Template 1 costs 1 credit per company found. Template 2 costs 1 credit per page of up to 10 companies. New accounts get 500 free credits, then it is paid.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;What if a company is not in the database?&lt;/strong&gt; The row is marked &lt;code&gt;found_live_only&lt;/code&gt; (name and description from the website) or &lt;code&gt;not_found&lt;/code&gt;, and it costs nothing.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Can I look up by company name?&lt;/strong&gt; No, template 1 is an exact-domain lookup.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;What does the X-Source header do?&lt;/strong&gt; Requests carry &lt;code&gt;n8n-company-research/enrich-by-domain&lt;/code&gt; or &lt;code&gt;n8n-company-research/icp-list-builder&lt;/code&gt; so I can count template usage. Only the domains you submit (template 1) or your search settings (template 2) are sent. To remove it, clear the &lt;code&gt;sourceHeader&lt;/code&gt; value in the &lt;strong&gt;Settings&lt;/strong&gt; node and the header in the HTTP Request nodes.&lt;/p&gt;

&lt;h2&gt;
  
  
  Links
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;Repo with both workflows and READMEs: &lt;a href="https://github.com/replynodes/n8n-company-research" rel="noopener noreferrer"&gt;https://github.com/replynodes/n8n-company-research&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;Free API key and 500 credits: &lt;a href="https://replynodes.com/auth.md" rel="noopener noreferrer"&gt;https://replynodes.com/auth.md&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you try them on a real list, I would like to hear what the hit rate looks like on yours, and which columns you wish were there.&lt;/p&gt;

</description>
      <category>n8n</category>
      <category>automation</category>
      <category>googlesheets</category>
      <category>tutorial</category>
    </item>
  </channel>
</rss>
