Automated PDF Candidate Profiles

PROJECT TITLE:
Google Workspace Automation — AI-Powered Candidate Profile Generator

PROJECT OVERVIEW:
We need an experienced developer to build an end-to-end automation system within our existing Google Enterprise Suite (Google Workspace) environment. The system must automatically generate a branded, formatted PDF candidate profile every time a candidate submits an application form — with zero manual effort from our team.
This is a real, well-scoped project. A detailed RFP with full functional requirements is attached. Please read business requirements carefully. Generic proposals will not be shortlisted.

WHAT THE SYSTEM MUST DO :
Auto-trigger on every Google Form submission — no manual action
Auto-extract 70+ candidate fields from the linked Google Sheet
Auto-read the candidate's uploaded resume/CV from Google Drive (PDF or image)
Auto-generate a 17-section structured candidate profile using an AI engine (you propose the right AI model/provider)
Auto-calculate all tenure durations and age using the system date
Auto-build a branded, formatted PDF profile document — logo, colours, tables, all sections
Auto-email the profile to the internal team and to the candidate (branded HTML emails)
Auto-save the PDF to a Google Drive folder with a consistent naming convention
Auto-update the tracking spreadsheet with processing status and a clickable profile link
Batch process all historical form submissions already received — not just new ones going forward

TECHNOLOGY
Current Platform: Google Workspace (Google Forms, Sheets, Drive, Docs, Gmail)
Preferred delivery : deploy code in live production environment and ensure all automations are working as expected. And documentations of solution design and to support ongoing maintenance support.
AI engine: your recommendation — we are open to the best approach
You must propose the technical stack; we are not prescribing it

MANDATORY: DEPLOYMENT + SUPPORT
You must deploy the working system in our live Google Workspace environment — not just hand over code
1 month post-deployment support required — any production bugs fixed at no extra charge within 2 business days

WHAT WE PROVIDE :
Detailed requirement ( Attached )
Live Google Form with 70+ fields (view access provided on shortlisting)
Google Sheet with historical submissions already in it
Company logo and brand colour guidelines
Existing company profile templates.

IDEAL CANDIDATE
Proven experience with Google Apps Script automation in production environments
Experience integrating AI/LLM APIs in real projects
Can show examples of similar deployed automations
Comfortable with Google Docs programmatic document building

Timeline: approx. 10–14 weeks including deployment and start of support. We are open for proposed timelines for this project.