AI-Powered PMO Office Setup

# AI Developer Needed: Google Drive Integration, File Analysis and Dashboard

I am looking for an experienced **AI Integration Developer or AI Solutions Engineer** to build a secure system connecting a private Google Drive repository with artificial intelligence, automated reporting, AI chat and a live dashboard.

The developer must have proven technical experience integrating AI with Google Drive. Detailed business rules and confidential documents will be shared only with the selected candidate.

## Required Workflow

**Google Drive → Automatic File Detection → AI Analysis → Generated Report → AI Chat → Live Dashboard**

## Core Requirements

The system must:

* Connect securely to selected Google Drive folders and subfolders.
* Monitor existing, new and updated files.
* Detect uploaded, modified, renamed, moved and deleted files.
* Process files automatically without manual uploading.
* Read PDF, Word, Excel, PowerPoint and scanned documents.
* Extract text, tables, numbers and relevant metadata.
* Analyze every new or updated file using configurable review criteria.
* Compare the file with related documents when available.
* Identify missing, conflicting, duplicated or outdated information.
* Highlight key findings, gaps, risks and required actions.
* Generate a standardized report for every analyzed file.
* Provide source citations for important AI findings.
* Update a live dashboard automatically.
* Allow users to ask questions through an AI chat interface.
* Maintain a complete audit log.

## Google Drive Integration

The solution must use the official Google Drive API and support:

* Google OAuth 2.0 or service-account authentication.
* Access limited to approved folders.
* Initial indexing of existing files.
* Incremental synchronization.
* Google Drive Changes API.
* Push notifications, events or webhooks where appropriate.
* File-version and modification tracking.
* Automatic retries after synchronization failures.
* Prevention of duplicate file processing.
* Secure storage of credentials and access tokens.

The system must not depend on browser automation, repeated full downloads or manual file transfers.

The developer must recommend whether OAuth 2.0 or a service account is more appropriate and explain why.

## AI File Analysis

For each new or updated file, the AI must:

* Retrieve and analyze the latest authorized version.
* Identify the document type, date, subject and owner when available.
* Extract important information and structured fields.
* Apply predefined business rules and review criteria.
* Assess document completeness and consistency.
* Compare the file with relevant existing files.
* Detect missing information and supporting documents.
* Identify inconsistencies, risks and warning indicators.
* Recommend corrective actions.
* Separate confirmed facts from AI observations.
* Provide a confidence level for AI-generated findings.
* Cite the supporting file, page, section, sheet or cell.
* State “Not Available” or “Not Evidenced” when information is missing.
* Avoid inventing unsupported information.

The analysis criteria must be configurable without rebuilding the system.

## Automated Analysis Report

The system must generate a report containing:

1. File name, type and folder.
2. Upload and modification dates.
3. Executive summary.
4. Key extracted information.
5. Completeness assessment.
6. Missing information.
7. Conflicts or outdated information.
8. Identified risks and warning indicators.
9. Recommended corrective actions.
10. Responsible owner when identified.
11. Source references.
12. AI confidence level.
13. Overall review status.
14. Items requiring human review.

The report must be:

* Linked to the original file.
* Available through the dashboard.
* Searchable through AI chat.
* Exportable to PDF and Excel.
* Updated when the source file changes.
* Recorded in the audit log.

## AI Chat

Authorized users must be able to ask questions such as:

* What files were uploaded or updated today?
* What did the AI identify in the latest file?
* Which files contain missing information?
* What risks or inconsistencies were detected?
* What changed between two file versions?
* Which documents require human review?
* Show the source supporting this finding.
* Generate a summary for a selected folder or period.

Answers must use authorized information, cite supporting sources, respect access permissions and clearly state when information is unavailable.

## Live Dashboard

The dashboard must show:

* Total monitored files.
* New and updated files.
* Analysis status.
* Files requiring human review.
* Missing information.
* Key risks and findings.
* Recommended actions.
* Generated reports.
* Synchronization failures.
* Last successful synchronization and refresh.

Filters should include folder, file type, date, review status, risk level, owner and AI confidence level.

Users must be able to open the relevant source file and generated report from the dashboard.

## Notifications

Notify authorized users when:

* A file is uploaded or updated.
* AI analysis is completed.
* A critical gap or risk is identified.
* Human review is required.
* A report is ready.
* Google Drive synchronization fails.

## Security and Governance

The solution must include:

* Role-based access control.
* Minimum necessary Google Drive permissions.
* Secure API-key and OAuth-token management.
* Encryption in transit and at rest.
* No public exposure of source documents.
* User-access and system-activity logs.
* Backup and recovery procedures.
* Separation of testing and production environments.
* Clear disclosure of where documents and extracted data are processed and stored.
* No use of confidential files for model training without authorization.

The AI must never automatically approve documents, delete or modify source files, make final decisions or present predictions as confirmed facts.

## Required Experience

Applicants must demonstrate experience with:

* Google Drive API.
* OAuth 2.0 and service accounts.
* Google Drive Changes API and webhooks.
* OpenAI API and Responses API.
* Retrieval-Augmented Generation (RAG).
* Function calling and Structured Outputs.
* Vector databases or semantic search.
* PDF, DOCX, XLSX and PPTX processing.
* OCR and table extraction.
* Backend and database development.
* Dashboard development.
* Scheduled background jobs.
* Security, audit logging and cloud deployment.

## Expected Deliverables

1. Technical architecture and data-flow diagram.
2. Secure Google Drive integration.
3. Automatic file-change detection.
4. Document extraction pipeline.
5. AI analysis engine.
6. Configurable analysis rules.
7. Structured database.
8. Automated analysis reports.
9. AI chat interface with source citations.
10. Live dashboard and notifications.
11. Audit logs and access control.
12. Testing and production deployment.
13. Full source code and documentation.
14. Administrator training.
15. Warranty and post-deployment support.

## Proof of Concept

The project must begin with a proof of concept demonstrating:

1. Secure connection to a test Google Drive folder.
2. Automatic detection of an uploaded or updated file.
3. Extraction and AI analysis of the file.
4. Comparison with a related file.
5. Generation of a cited review report.
6. Automatic dashboard update.
7. AI follow-up questions.
8. Complete audit logging.

Full implementation will proceed after successful approval of the proof of concept.

## Proposal Requirements

Please provide:

* Examples of similar AI and Google Drive integrations.
* Proposed technology stack and architecture.
* Authentication and security approach.
* File-change detection method.
* Document extraction and AI-analysis approach.
* Method for providing accurate source citations.
* Proof-of-concept timeline and cost.
* Full implementation timeline and cost.
* Estimated recurring hosting and API costs.
* Support and maintenance terms.
* Confirmation of source-code ownership and handover.

## Screening Questions

1. Describe a previous AI system you connected to Google Drive.
2. How will you detect new, updated, moved and deleted files?
3. Would you use OAuth 2.0 or a service account, and why?
4. How will the AI analyze different file formats automatically?
5. How will you ensure each finding cites the correct source?
6. How will you prevent duplicate processing?
7. How will you protect confidential documents and credentials?
8. What will you demonstrate in the proof of concept?

I am not looking for only a dashboard designer, prompt writer or basic ChatGPT user. I need a developer with proven experience in:

**Google Drive Integration + Automated File Monitoring + AI Document Analysis + Automated Reports + AI Chat + Live Dashboard**

Generic proposals without clear technical answers or relevant examples will not be considered.