SaaS & AIInternal tool · Cloudpacer

Google Chat HR Assistant

Employees get leave balances, payroll dates and policy answers inside Google Chat, with no new app, login or server.

Built by Talha Saleem
private build
Google Chat HR Assistant screenshot

01The problem

Employees looked up HR policies, leave balances and payroll dates across disconnected tools, and sent HR the same questions again and again.

02My contribution

Built a serverless assistant in six Apps Script modules. A two-call GPT-4o-mini pipeline turns a question into search queries, then answers from live Notion policy pages; employee and leave data come live from Google Sheets; answers render as interactive Google Chat cards. Handled service-account JWT auth, merged-header column mapping and spreadsheet timezone quirks.

03Outcome

HR answers in the chat tool the company already uses, with nothing to deploy or host.

04Tech stack

  • Google Apps Script
  • OpenAI GPT-4o-mini
  • Notion API
  • Google Sheets
  • Google Chat
Talha Saleem

Built by Talha Saleem

Want something like this built for you?