Project overview
The challenge
- Businesses needed to automate repetitive Google Drive document workflows but lacked technical expertise to build custom integrations.
- Existing automation tools didn't provide granular control over Google Drive file operations or secure multi-user authentication.
- Manual document processing across teams led to versioning conflicts and lost productivity.
- Sensitive business documents required enterprise-grade security (Secret Manager, OAuth) not available in consumer automation tools.
Engineered a comprehensive workflow automation platform enabling businesses to orchestrate document processing workflows across Google Drive, with secure OAuth authentication and real-time collaboration features.
Built modern frontend with Angular 19 and Material Design components, providing intuitive UI for workflow configuration, document management, and real-time progress tracking. Implemented JWT authentication with Auth0 for secure multi-user access.
Developed Express backend integrated with Google Drive API, Firebase Admin for authentication, and Cloud Secret Manager for secure credential storage. Deployed to Google Cloud Platform with auto-scaling capabilities.
Technical architecture
Frontend: Angular 19 SPA with Material Design, RxJS for reactive data streams, and Auth0 JWT for secure authentication.
Backend: Express.js REST API with Passport OAuth 2.0, handling Google Drive operations and Firebase authentication.
Security: Google Cloud Secret Manager for API credentials, OAuth 2.0 for user delegation, JWT tokens for session management.
Cloud Integration: Firebase Admin SDK for user management, Google Drive API for file operations, deployed on GCP App Engine.
Notifications: Nodemailer integration for workflow completion alerts and error notifications.
Key challenges & solutions
Google Drive API Rate Limiting
Implemented intelligent request batching and exponential backoff strategies to handle Google Drive API quotas, ensuring workflow reliability for high-volume operations.
Secure Credential Management
Integrated Google Cloud Secret Manager to store OAuth tokens and API keys securely, eliminating hardcoded credentials and enabling dynamic secret rotation.
Angular 19 Material Design Integration
Leveraged latest Angular Material components with Flex Layout for responsive design, ensuring consistent UX across desktop and mobile devices.
Impact & results
Automated document workflows saving 10+ hours/week per team
Secure OAuth 2.0 authentication protecting sensitive business documents
GCP deployment enabling auto-scaling for growing user base
Material Design UI reducing training time for non-technical users
Key features
- Angular 19 with Material Design UI
- Google Drive API integration
- Firebase Admin authentication
- Google Cloud Secret Manager
- OAuth 2.0 with Passport.js
- Express.js RESTful API
- Nodemailer email notifications
- GCP deployment ready
- JWT token management
- Real-time document sync