DeliveredCreated forDerec

AI vacancy texts in bulk

AI rewrites hundreds of existing vacancy texts in one go from a spreadsheet, so they all get the same structure.

What it is

Derec is a Dutch staffing agency for education. It has hundreds of vacancies, each with a text of its own. When the house style changes, all those existing texts have to be written again. I built a solution that lets AI rewrite all the vacancy texts in a spreadsheet in one go. The result comes back by e-mail.

Vacancies.xlsxUploaded in the chat
1Dutch teacherOld text2Year 4 teacherOld text3Maths teacherOld text
The vacancy texts have been rewrittenAttached: Vacancies.xlsx
1Dutch teacherRewritten2Year 4 teacherRewritten3Maths teacherRewritten

What it improves

Hundreds of texts in one go

AI rewrites all the vacancies in one spreadsheet in one go. Nobody has to rewrite the existing texts by hand, one by one, any more.

The same structure for every text

Every vacancy text gets the same five parts. AI follows the same instructions each time. That way candidates find the same information in the same place in every vacancy.

Existing vacancies in the new style too

Derec can carry a new house style through to the vacancies that already exist too. That way old and new texts no longer drift apart.

The problem

BEFORE

Existing vacancies stayed in the old style

New vacancies follow new agreements about style and structure straight away. The vacancies that already exist have to be rewritten by hand, one by one. With hundreds of vacancies that does not happen in practice. Old and new texts then stay side by side.

THE USUAL SOLUTION

Why not vacancy by vacancy in a chat

The usual solution is a chat with AI. In it, AI rewrites the texts one at a time. That works well for a few vacancies. With hundreds of vacancies, the copying and pasting itself becomes the manual work. That is why I chose batch processing: one file with all the vacancies that the system processes in one go.

The solution

THE SPREADSHEET

One file with all the vacancies

A colleague uploads a spreadsheet with one vacancy on every row. Nothing more is needed.

1Dutch teacherOld text2Year 4 teacherOld text3Maths teacherOld text

THE TEXT

AI writes five fixed parts

For each vacancy, AI writes the introduction, the job, the organisation, what the candidate brings and what the candidate gets. AI does not change the details of the vacancy itself.

Dutch teacherRow 1 of the spreadsheetIntroductionReady for a new class?The jobDutch in the upper yearsThe organisationA school with a close teamWhat you bringA qualification in DutchWhat you getRoom to grow

THE RESULT

The same spreadsheet, new texts

The result is the same spreadsheet, with the new texts in place of the old ones.

Vacancies.xlsx
Dutch teacherIntroductionWe are looking for a Dutch teacher right awayReady for a new class?

CONTROL

Nothing goes live automatically

The rewritten texts come back as a file. The tool posts nothing by itself. A colleague reads everything and decides which texts the team takes over. That keeps the team in control of what candidates get to read.

Vacancies.xlsxBack by e-mail
Dutch teacherText rewritten
Year 4 teacherText rewritten
Maths teacherText rewritten
Other columnsUnchanged
The website still shows the old text

What it runs on

  • Chat interface with file uploadTakes the spreadsheet and confirms straight away that the work has started.
  • Job queueProcesses every vacancy in the background as a task of its own.
  • LLM with fixed instructions (prompt)Writes every text in the same five parts.
  • E-mailSends back the spreadsheet with the new texts.

The payoff

Rewriting hundreds of textsBy handOne by one, per vacancyWith this toolUploading one spreadsheet
The structure of a textBy handDiffers per writer and per momentWith this toolThe same five parts for every vacancy