Track hiring activity at your target accounts

Every Monday at 07:00, each account in your spreadsheet is searched on the web for its hiring and careers pages, and a row is appended to your signals tab recording what came back, so the tab becomes a history of how each account's hiring moves.

Each row holds the date, the company, how many hiring pages the search returned, the titles of up to five of them exactly as listed, one example link and the search that was run. Nothing is rated or scored: it reports a signal and leaves the conclusion to you, and nothing is written that the search did not return. Personal profiles, social posts and anything carrying an email address are dropped first, so the row is about the organisation only. If a search fails, that company is skipped rather than recorded as a zero.

You need an accounts tab with a 'Company' column, plus an existing tab for the signals. Rows are only ever appended to it, and your accounts tab is never changed.

Run every Monday at 07:00.Run every Monday at 07:00.

Set accountsSpreadsheetUrl to blank.Set accountsSpreadsheetUrl to blank.

Set accountsTabName to blank.Set accountsTabName to blank.

Set signalsTabName to blank.Set signalsTabName to blank.

Set maxCompaniesPerRun to 12.Set maxCompaniesPerRun to 12.

Google SheetsRead the rows of accountsSpreadsheetUrl. Save it as accounts.Read the rows of accountsSpreadsheetUrl. Save it as accounts.

Set accountRows to accounts.rows.Set accountRows to accounts.rows.

Set companiesChecked to 0.Set companiesChecked to 0.

Set companiesRecorded to 0.Set companiesRecorded to 0.

For each accountRow in accountRows:For each accountRow in accountRows:

Trim accountRow.Company and save it as company.Trim accountRow.Company and save it as company.

If company is empty or company is nullIf company is empty or company is null

Yes

Skip to the next item.Skip to the next item.

No

No steps

If companiesChecked is greater than or equal to maxCompaniesPerRun multiplied by…If companiesChecked is greater than or equal to maxCompaniesPerRun multiplied by…

Yes

Stop repeating.Stop repeating.

No

No steps

Add 1 to companiesChecked.Add 1 to companiesChecked.

Set searchQuery to company careers job openings.Set searchQuery to company careers job openings.

Set searchResults to an empty list.Set searchResults to an empty list.

If a step below fails, save the error as searchErrorIf a step below fails, save the error as searchError

Try

Change searchResults to the results from the Serper “Search Google” step.Change searchResults to the results from the Serper “Search Google” step.

On error

Show in the output: The search for company did not run, so nothing was recorded for it this week. A missing row means no search, not no hiring.Show in the output: The search for company did not run, so nothing was recorded for it this week. A missing row means no search, not no hiring.

Skip to the next item.Skip to the next item.

Set rolesAsListed to an empty list.Set rolesAsListed to an empty list.

Set hiringPages to 0.Set hiringPages to 0.

Set exampleLink to blank.Set exampleLink to blank.

For each searchResult in searchResults:For each searchResult in searchResults:

Trim searchResult.title and save it as resultTitle.Trim searchResult.title and save it as resultTitle.

Trim searchResult.link and save it as resultLink.Trim searchResult.link and save it as resultLink.

If resultTitle is empty or resultLink is emptyIf resultTitle is empty or resultLink is empty

Yes

Skip to the next item.Skip to the next item.

No

No steps

If resultLink in lowercase contains linkedin.com/in/ (ignoring case) or…If resultLink in lowercase contains linkedin.com/in/ (ignoring case) or…

Yes

Skip to the next item.Skip to the next item.

No

No steps

If not resultTitle contains hiring (ignoring case) or resultTitle contains…If not resultTitle contains hiring (ignoring case) or resultTitle contains…

Yes

Skip to the next item.Skip to the next item.

No

No steps

Add 1 to hiringPages.Add 1 to hiringPages.

If the length of rolesAsListed is less than 5If the length of rolesAsListed is less than 5

Yes

Add resultTitle to the end of rolesAsListed and save it as rolesAsListed.Add resultTitle to the end of rolesAsListed and save it as rolesAsListed.

No

No steps

If exampleLink is emptyIf exampleLink is empty

Yes

Change exampleLink to resultLink.Change exampleLink to resultLink.

No

No steps

Google SheetsAdd a row to signalsTabName in accountsSpreadsheetUrl.Add a row to signalsTabName in accountsSpreadsheetUrl.

Add 1 to companiesRecorded.Add 1 to companiesRecorded.

Show in the output: Recorded hiring activity for companiesRecorded of the companiesChecked companies checked. Every role line is the wording of a page the search returned.Show in the output: Recorded hiring activity for companiesRecorded of the companiesChecked companies checked. Every role line is the wording of a page the search returned.