Searches each account in your sheet for hiring pages once a week and records what it found, in the pages' own words.
Uses
Google Sheets
Serper
Track hiring activity at your target accounts
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 nullYes
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 searchErrorTry
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 emptyYes
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 5Yes
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 emptyYes
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.