Job titles are hard to automate because humans write them.
New titles are invented daily, and spelling mistakes happen. Hence basic text comparison quickly becomes unhelpful.
Our machine-learning API sorts job titles into two ensembles: field (e.g. "sales, finance, I.T...") and role (e.g. "exec, management, assistant...") so you can prioritize the ones you're interested in.
To use JobtitlesAI (from API, Spreadsheet, or Hubspot) you need an API key. once you’ve chosen a plan on our website, you’ll receive a key charged with credits.
Once you’ve got your API key, you can use this formula to invoke JobtitlesAI with a given job title
=IMPORTDATA("<https://jobtitlesai.com/api/categorize?csv=noheaders&key=YOUR_API_KEY&jobtitle=YOUR_JOB_TITLE",",","fr>")
In general you will want to store the API key in a cell and reference it. Same for your job title cell.
=IMPORTDATA("<https://jobtitlesai.com/api/categorize?csv=noheaders&key="&$E$2&"&jobtitle="&A2,",","fr>")
Here $E$2 is the cell with the API key and A2 the cell with the job title.
Notice the parameter: csv=noheader , this is so we can read the results and put them back in two cells (the first one is fields, the second positions)
Feel free to duplicate this template 👇
Once you’ve got your API key, you can use REST to invoke JobtitlesAI with a given job title