Job Harvester

Hosted at divij-uc/postgrad-job-search
This is built entirely on the work of necabotheking and klinkoberstar. It is their idea, give them a shoutout and a github star if you like the work!

How to use

  1. Open the following google sheet https://docs.google.com/spreadsheets/d/19kdQAZzyb_1xmfqrXNoZ56WYW0orUIHI0PQaP0spZQM/edit#gid=0
  2. Go to File > Make a Copy
  3. Fill the columns shown in the sheet
    • Company should be a name for you to identify the firm you are applying for
    • URL should be the link to a page with jobs posted for that company
    • Keywords is a list of job titles you are interested in
    • Exclude is a list of other related words that you definitely do not want
  4. DO NOT CHANGE THE COLUMN NAMES
  5. You can add new columns, and change the locations of the columns, but do not change their names
  6. Once the sheet is ready, go to File > Share > Publish to Web
  7. Change "Entire Document" to the specific sheet
  8. Change "Web page" to "Comma-separated values"
  9. Click Publish
  10. Copy the link shown and paste below
  11. For the Sample Sheet shown above, this would be https://docs.google.com/spreadsheets/d/e/2PACX-1vTVzdEYMugeCsJiJsl9IgzzM4qlDx809eCVb6v1h_JPjuL59At11uIiEd06viOGp4jD3jFtSF2fuA5C/pub?gid=0&single=true&output=csv