<?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: careersitejobs_api</title>
    <description>The latest articles on DEV Community by careersitejobs_api (@careersitejobs_api_11e07b).</description>
    <link>https://dev.to/careersitejobs_api_11e07b</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%2F4245105%2Fe401ce75-0f3d-4e0e-9f3f-95664e3ca7bc.png</url>
      <title>DEV Community: careersitejobs_api</title>
      <link>https://dev.to/careersitejobs_api_11e07b</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/careersitejobs_api_11e07b"/>
    <language>en</language>
    <item>
      <title>Track which of your target accounts are hiring, every week, with n8n and Google Sheets</title>
      <dc:creator>careersitejobs_api</dc:creator>
      <pubDate>Sun, 15 Nov 2026 06:31:26 +0000</pubDate>
      <link>https://dev.to/careersitejobs_api_11e07b/track-which-of-your-target-accounts-are-hiring-every-week-with-n8n-and-google-sheets-489h</link>
      <guid>https://dev.to/careersitejobs_api_11e07b/track-which-of-your-target-accounts-are-hiring-every-week-with-n8n-and-google-sheets-489h</guid>
      <description>&lt;p&gt;Hiring is one of the best buying signals in B2B. A company that just opened five sales roles is growing its sales team. A company posting ten data engineering jobs is probably shopping for data tools. The problem is that checking 200 career sites by hand every week is nobody's idea of a good Monday.&lt;/p&gt;

&lt;p&gt;This post shows a small n8n workflow that does it for you. You keep a list of company domains in a Google Sheet, and every Monday the workflow adds one row per company with its open jobs, new jobs since last week, closed jobs, top departments, locations and median salary. After a few weeks you have a history you can sort, filter and alert on.&lt;/p&gt;

&lt;h2&gt;
  
  
  What you get
&lt;/h2&gt;

&lt;p&gt;Each Monday, one row per company in a &lt;strong&gt;Signals&lt;/strong&gt; tab:&lt;/p&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;input&lt;/th&gt;
&lt;th&gt;company&lt;/th&gt;
&lt;th&gt;open_jobs&lt;/th&gt;
&lt;th&gt;new_jobs_7d&lt;/th&gt;
&lt;th&gt;new_since_last_run&lt;/th&gt;
&lt;th&gt;closed_since_last_run&lt;/th&gt;
&lt;th&gt;median_salary_max_usd&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;example.com&lt;/td&gt;
&lt;td&gt;Example&lt;/td&gt;
&lt;td&gt;142&lt;/td&gt;
&lt;td&gt;18&lt;/td&gt;
&lt;td&gt;12&lt;/td&gt;
&lt;td&gt;7&lt;/td&gt;
&lt;td&gt;165000&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;Plus jobs posted in the last 30 days, remote job counts, top departments, locations and countries, seniority mix, and the newest job title with its link.&lt;/p&gt;

&lt;p&gt;Companies without a public job board land in a &lt;strong&gt;Not found&lt;/strong&gt; tab, so you know what isn't covered instead of silently missing it.&lt;/p&gt;

&lt;h2&gt;
  
  
  How it works
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Schedule trigger&lt;/strong&gt;, every Monday at 07:00.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Google Sheets&lt;/strong&gt; reads the &lt;code&gt;Domain&lt;/code&gt; column of an &lt;strong&gt;Accounts&lt;/strong&gt; tab.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Code node&lt;/strong&gt; cleans the list: lowercase, strips &lt;code&gt;https://&lt;/code&gt;, &lt;code&gt;www.&lt;/code&gt; and paths, removes duplicates, and splits it into batches of 50.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;HTTP Request&lt;/strong&gt; sends each batch to an Apify Actor that finds each company's career site (Workday, Greenhouse, Lever or Ashby) and summarizes its open jobs. It runs in "signals" mode, which returns one summary per company instead of every job.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;IF&lt;/strong&gt; splits companies with a job board from those without one.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Google Sheets&lt;/strong&gt; appends the results to &lt;strong&gt;Signals&lt;/strong&gt; or &lt;strong&gt;Not found&lt;/strong&gt;.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;The cleaning step is the part people usually skip and regret. CRM exports are full of &lt;code&gt;https://www.Company.com/about&lt;/code&gt; style values, and without normalizing them you pay twice for the same company or miss it entirely:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight javascript"&gt;&lt;code&gt;&lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;seen&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="k"&gt;new&lt;/span&gt; &lt;span class="nb"&gt;Set&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;domains&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;item&lt;/span&gt; &lt;span class="k"&gt;of&lt;/span&gt; &lt;span class="nv"&gt;$input&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;all&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="kd"&gt;let&lt;/span&gt; &lt;span class="n"&gt;d&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nb"&gt;String&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;item&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;json&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nc"&gt;Domain&lt;/span&gt; &lt;span class="o"&gt;||&lt;/span&gt; &lt;span class="s1"&gt;''&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;trim&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;toLowerCase&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
  &lt;span class="n"&gt;d&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;d&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;replace&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="o"&gt;/^&lt;/span&gt;&lt;span class="n"&gt;https&lt;/span&gt;&lt;span class="o"&gt;?:&lt;/span&gt;\&lt;span class="o"&gt;/&lt;/span&gt;\&lt;span class="c1"&gt;//, '').replace(/^www\./, '').split('/')[0];&lt;/span&gt;
  &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;d&lt;/span&gt; &lt;span class="o"&gt;&amp;amp;&amp;amp;&lt;/span&gt; &lt;span class="o"&gt;!&lt;/span&gt;&lt;span class="n"&gt;seen&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;has&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;d&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;seen&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;add&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;d&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt; &lt;span class="n"&gt;domains&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;push&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;d&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="kd"&gt;const&lt;/span&gt; &lt;span class="n"&gt;batches&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="kd"&gt;let&lt;/span&gt; &lt;span class="n"&gt;i&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="mi"&gt;0&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt; &lt;span class="n"&gt;i&lt;/span&gt; &lt;span class="o"&gt;&amp;lt;&lt;/span&gt; &lt;span class="n"&gt;domains&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;length&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt; &lt;span class="n"&gt;i&lt;/span&gt; &lt;span class="o"&gt;+=&lt;/span&gt; &lt;span class="mi"&gt;50&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;
  &lt;span class="n"&gt;batches&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;push&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;json&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="n"&gt;companies&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;domains&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;slice&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;i&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;i&lt;/span&gt; &lt;span class="o"&gt;+&lt;/span&gt; &lt;span class="mi"&gt;50&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="n"&gt;batches&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The HTTP Request calls Apify's synchronous endpoint, so the results come straight back into n8n without polling:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight http"&gt;&lt;code&gt;&lt;span class="no"&gt;POST&lt;/span&gt; &lt;span class="n"&gt;https&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="c1"&gt;//api.apify.com/v2/acts/carmelon~career-site-jobs-api/run-sync-get-dataset-items&lt;/span&gt;
&lt;span class="nc"&gt;Authorization&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="nc"&gt;Bearer&lt;/span&gt; &lt;span class="o"&gt;&amp;lt;&lt;/span&gt;&lt;span class="n"&gt;your&lt;/span&gt; &lt;span class="nc"&gt;Apify&lt;/span&gt; &lt;span class="n"&gt;token&lt;/span&gt;&lt;span class="o"&gt;&amp;gt;&lt;/span&gt;

&lt;span class="p"&gt;{&lt;/span&gt; &lt;span class="s2"&gt;"companies"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"stripe.com"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"datadoghq.com"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"mode"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"signals"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"feedName"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"weekly-accounts"&lt;/span&gt; &lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;feedName&lt;/code&gt; is what makes "new since last week" and "closed since last week" work: the Actor remembers what it saw for that feed on the previous run. Keep it the same every week, and keep the batches running one at a time (batch size 1 in the HTTP node options) so the memory stays consistent.&lt;/p&gt;

&lt;h2&gt;
  
  
  Setup (about 10 minutes)
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Create a free Apify account and copy your API token (Console &amp;gt; Settings &amp;gt; API &amp;amp; Integrations).&lt;/li&gt;
&lt;li&gt;In n8n, create a &lt;strong&gt;Header Auth&lt;/strong&gt; credential: name &lt;code&gt;Authorization&lt;/code&gt;, value &lt;code&gt;Bearer &amp;lt;token&amp;gt;&lt;/code&gt;.&lt;/li&gt;
&lt;li&gt;Make a Google Sheet with three tabs: &lt;strong&gt;Accounts&lt;/strong&gt; (one column, &lt;code&gt;Domain&lt;/code&gt;), &lt;strong&gt;Signals&lt;/strong&gt; and &lt;strong&gt;Not found&lt;/strong&gt;.&lt;/li&gt;
&lt;li&gt;Import the workflow, pick your sheet in the three Google Sheets nodes, and run it once by hand.&lt;/li&gt;
&lt;li&gt;Activate it.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;The first run leaves "new" and "closed since last week" empty, because there is no last week yet. From the second Monday on they fill in.&lt;/p&gt;

&lt;h2&gt;
  
  
  Cost
&lt;/h2&gt;

&lt;p&gt;The Actor charges $0.003 per company found, and nothing for companies with no job board. Tracking 200 accounts weekly is about $0.60 a week, which fits in Apify's free monthly credit.&lt;/p&gt;

&lt;h2&gt;
  
  
  Ideas to extend it
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Only track some roles.&lt;/strong&gt; Add &lt;code&gt;"keywords": ["sales", "account executive"]&lt;/code&gt; to the request body, and the new-job counts and top lists cover just those jobs (&lt;code&gt;matching_jobs&lt;/code&gt; shows how many matched). Good for "which accounts are building a sales team right now".&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Alerts.&lt;/strong&gt; Add an IF on &lt;code&gt;new_since_last_run &amp;gt; 5&lt;/code&gt; and send a Slack message or email, so you hear about hiring spikes without opening the sheet.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Score accounts.&lt;/strong&gt; In the sheet, rank by &lt;code&gt;new_jobs_30d / open_jobs&lt;/code&gt; to find companies that are hiring faster than usual.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Limitations
&lt;/h2&gt;

&lt;p&gt;It only covers companies whose career site runs on Workday, Greenhouse, Lever or Ashby. That's a large share of tech and mid-market companies, but not all of them. A few Workday companies can't be matched from the domain alone and show up under &lt;strong&gt;Not found&lt;/strong&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  Get the workflow
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;The Actor: &lt;a href="https://apify.com/carmelon/career-site-jobs-api" rel="noopener noreferrer"&gt;https://apify.com/carmelon/career-site-jobs-api&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;The n8n workflow: submitted to the n8n template library, link coming once it is approved&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If you build something on top of it, like a CRM sync or a Clay enrichment, I'd like to hear how it goes in the comments.&lt;/p&gt;

</description>
      <category>n8n</category>
      <category>automation</category>
      <category>sales</category>
      <category>nocode</category>
    </item>
  </channel>
</rss>
