Gemini for HR: how a rejection left sitting for three weeks became three routines in Gmail, Docs and Sheets

A company of around 200 employees on Google Workspace had switched on Gemini in Gmail, Docs and Sheets for everyone. In HR, a team of two, nobody had clicked it. Three months later rejections went out the same day, and the works council had co-written the rules for it. This is how the project went.

5.0 out of 5 · 15+ reviewsGoogleProvenExpertTrustpilotRead all
In short

Gemini in Google Workspace works inside Gmail, Docs and Sheets with the content the individual user can already access. In this project an HR team built three routines with it: candidate communication from Gmail, onboarding documents from a checklist in Docs, analyses in Sheets without personal data. Building started in week one with the works council (Betriebsrat, the elected employee representation) at the table; the works agreement and the data protection review ran in parallel and were signed after three months. Since then the team runs the routines without me.

Nick Schäfer, AI for HR teams, Frankfurt am Main
At a glance

The project in three months

No new system, no new licence. Routines were built from week one together with the works council; the agreement and the data protection review ran in parallel and took three months. Then the team ran alone.

0months
0routines
0team that carries on

Starting point

The company, around 200 employees, had switched on Gemini for every organisational unit six months earlier. An IT email had announced it, and after that nothing happened in HR. The two people there had too much to do to try a new tool. A rejection started from the last rejection, name and role swapped. The onboarding document for a new hire was assembled on Friday afternoon from four old Docs. The quarterly turnover figures were built by one of the two alone, because only she knew the formulas.

The moment it tipped was a rejection. It sat in the inbox for three weeks because the person meant to write it was ill and the other did not know the case. The candidate eventually asked on LinkedIn, politely but for everyone to read, whether his application was still open. Management saw the post before HR did. The head of HR called me the next day. Not because she wanted a new system. She wanted candidate communication to stop depending on one person.

At the first meeting the head of HR, the works council chair and the data protection officer were all at the table. The works council said the sentence I hear in almost every one of these projects: nobody asked us when it was switched on what the tool does with personnel data. The data protection officer had read Google's documentation and was reassured about training and storage, but not about access to HR folders in Drive. That set the frame of the project before a single routine was built.

Approach

The first week belonged to the stopwatch. Both people in the team noted for a week which task came how often, how long it took and whether it ran in Gmail, Docs or Sheets. Added to that was a look at the Admin console with IT: Gemini was on for the whole company, with no distinction by organisational unit. The list in the end was short: candidate emails, onboarding documents and the analysis for management took the largest share of writing time, and none of the three needed a decision in the first step. Those became the three routines.

The works council was there from the first build session, not as an inspector but as a co-author. We walked through every routine together: what goes in, what comes out, who checks, where the result lands. The first decision concerned the Admin console: IT reset Gemini's activation per organisational unit, and the HR team's Drive has had a dedicated area ever since with the documents Gemini may use as context. Personnel files sit elsewhere. That separation ended up verbatim in the amendment to the IT works agreement, because the works council had phrased it itself.

Candidate communication was the first routine to stand. HR opens the application in Gmail, starts Gemini in the side panel with the company's prompt for acknowledgement, rejection or invitation, and gets a draft in the tone of its own templates. The review step is non-negotiable: salutation, role, date, no reason given in the rejection and nothing that points to a characteristic protected under the German Equal Treatment Act (AGG). Only then does the email go out. Onboarding followed in week three: one checklist per role sits in Docs, Gemini turns it into the document for the specific person, HR checks names, dates and rules.

The skeleton of the prompt from the project. This is the frame of the rejection prompt the team has worked with in Gmail since. It already works like this. What turned it into the company's own prompt during the project is listed below, and that is the part that gets the rejection out the same day.

The finished prompt, ready to copy

All six building blocks in one prompt. Replace the bracketed placeholders with your own details.

You are writing, as an HR officer at [company], a rejection email to [first name last name], who applied for the position of [job title]. The application is in this email.

Tone: [tone from the company's own rejections]. Short sentences, formal address, no stock phrases.

Content in this order: thanks for the application, naming the position. The decision in the first paragraph. One sentence on something specific from the application. Good wishes to close.

Boundary: give no reason for the rejection, no comparison with other applicants, and nothing about age, origin, gender, religion, disability or any other personal characteristic. If a phrase leans in that direction, delete it without replacement.

Mark every passage where you are unsure or make an assumption with [check].

Length: 120 words at most.
  1. The company's three rejection templates by stagewhich sentences follow the screening, the first interview and the second interview, and which never appear.
  2. The AGG checklistwhich phrases have led to a query in the company before and are therefore banned.
  3. The rule for follow-up questions from candidateswho answers, within what deadline, and what Gemini must not write in the process.
  4. The review stephow HR can tell in two minutes whether the draft can be sent.

The snag came in week four, with the analysis in Sheets. Gemini was meant to explain the turnover table and suggest formulas, and on the first attempt it pulled the name column into its explanation because the column was in the table. The sentence it wrote was accurate, and it should never have appeared in a document for management. The data protection officer then set the rule that has applied since: in Sheets Gemini gets only figures per department and month, no names, no employee IDs. The table was rebuilt, the works council added the rule to the agreement, and HR recalculates a sample of every explanation by hand.

In parallel ran the sessions on the wording of the works agreement. That was the slow part, and it should be: the works council meets every two weeks, the data protection officer reviewed the data processing terms with Google and the data transfers herself, and the clause on controlling the prompts was rewritten three times. The routines ran in test mode with anonymised applications during that time. At the end of month three the amendment was signed, and the team ran the three routines alone for a week while I stayed in the background.

Outcome

A rejection now runs like this: HR opens the application, starts Gemini with the company's prompt, checks salutation, role and boundary, sends. If one person is ill, the other does it with the same prompt, and no rejection is left sitting any more. The onboarding document comes from the role's checklist, without the predecessor's name. The analysis for management is built by Gemini in Sheets from figures without personal data, and the one person who knew the formulas is no longer the bottleneck.

The works council signed the amendment to the IT works agreement, with the three use cases, the activation per organisational unit, the review step, the no-personal-data rule in Sheets and a review date after six months. The team has since built a fourth routine on its own, job ads from the requirements profile in Docs, and presented it to the works council at the review, as the agreement provides. It did not need me for that, and that was the point of the project.

The frame

Built with the works council, settled by month 3

According to Google, prompts entered into Gemini count as customer data under the Cloud Data Processing Addendum and are not used to train models without permission, which answered the data protection officer's first question. Everything else ended up in the amendment to the works agreement, because the works council co-wrote it.

0points settled
0months, in parallel
0new licences

Does this fit your company?

  1. You have Google Workspace, but HR does not use GeminiThe most common case. The project needs no new licence, only the three routines and the works council at the table.
  2. Your IT switched Gemini on for everyone, without the works councilThen HR use is on thin legal ice. The amendment to the agreement catches up on that, and the activation per organisational unit is set deliberately.
  3. Your team has no time for a projectAbout one hour a week per person. The first routine wins that back from week three.

Frequently asked questions

What happens to our HR data at Google?

According to Google's documentation, prompts entered into Gemini count as customer data under the Cloud Data Processing Addendum, are not used for training without permission and are not reviewed outside your organisation. Gemini only sees what the user can already access. What the project adds: which organisational units need Gemini and which Drive folders HR really wants to open up. The review is done by your data protection officer, I do not replace them.

Do we need a new works council agreement for this?

Usually an amendment to the existing IT agreement is enough, with the use cases, the review step and the works council's control rights. If there is no IT agreement, it becomes a short standalone one, because Gemini in Workspace is a technical system subject to co-determination under Section 87 (1) No. 6 of the German Works Constitution Act (BetrVG). Both are written together with the works council, not for it.

What happens after the three months?

The team runs the routines itself, the prompts sit in the HR team's Drive, the review date is set. Whoever wants to build further routines does that in the next project or in the fractional model on fixed days.

How many hours do your HR routines take each week?

Three numbers, one result. The detailed calculation with every assumption arrives by email.

Hours tied up per week, estimated45 h
27 hof that freed up every week with clean routines, in my experience

The detailed breakdown shows every assumption.

3
5
6
Assumptions: 6 h per open role per week, 1 h per reference letter, 3 h of questions per HR headcount. Each one adjustable.

Thanks. The breakdown with your figures comes personally by email within one working day.

Shall we look at your routines?

30 minutes, directly with me. You describe what takes the hours, I tell you which three routines this tool carries in your team and what the works council will ask.

5.0 out of 5 · 15+ reviewsGoogleProvenExpertTrustpilotRead all