🏆 Winner of Hack With Google 2023 - $5,000 Prize
A comprehensive device performance monitoring system built with AppSheet and Google Workspace
📖 View Complete Documentation Index | ⚙️ Setup Guide | 🔗 Integration Guide
- Introduction
- Project Overview
- Key Features
- Implementation Details
- Business Impact
- Getting Started
- GitHub-AppSheet Integration
- Future Roadmap
- Contributing
- Team & Acknowledgments
- License
This project was developed during the Hack With Google event, sponsored by BeMyApp, Google, and Onix. The hackathon focused on expanding knowledge about AppSheet and other generative AI features in Google Workspace, AppSheet, and Google Cloud products.
Event Details:
- Tracks: Independent Developer & Emerging Mid-Market
- Theme: Manufacturing
- Result: 🏆 1st Place Winner - $5,000 Prize
- Event Link: Hack With Google
Our project leverages AppSheet to create a comprehensive device performance monitoring system that revolutionizes how companies and electricians manage utility infrastructure. The solution enables real-time tracking of meters and transformers in the field, allowing immediate reporting of:
⚠️ Artificial outages- 📉 Non-technical losses
- ❌ Errors and warnings
- 📍 Device status and location
By implementing features such as interactive views, dashboards, performance graphs, and automated actions, along with integrations for Google Maps, OCR, and intelligent bots, our solution:
- ⚡ Streamlines Operations - Real-time monitoring and automated workflows
- 💰 Optimizes Budget - Reduces operational costs by up to 15%
- 📊 Maximizes Performance - Data-driven insights for better decision-making
- 🌱 Promotes Energy Conservation - Monitors and reduces energy consumption
- 🎯 Saves Time - Potential to save 30% of workload for over 1 million electricians in the US
Our solution delivers measurable benefits to three key stakeholder groups:
Impact on Testing & Quality:
- ⏱️ 25% reduction in testing time
- 💰 15% cost savings on average
- 📈 Real-time performance analysis during manufacturing
- ✅ Instant adjustments and optimizations
- 🎯 Improved device quality and customer satisfaction
How it works: Manufacturing companies can implement our product during device testing phases, enabling immediate identification and resolution of issues during the production process.
Impact on Operations:
- 📉 20% reduction in outage durations
- 🔧 Decreased downtime and maintenance costs
- 🔍 Proactive monitoring of meters, transformers, and circuits
- 🎯 Improved service reliability for customers
- 📊 Better asset management and lifecycle tracking
How it works: Real-time monitoring allows utility companies to identify and respond to issues before they escalate into major outages.
Impact on Productivity:
- ⏰ 30 minutes saved per inspection (via OCR automation)
- 📈 15% productivity increase
- 📱 Digital audit logs replace physical paperwork
- 🤖 Automated form filling reduces manual data entry
- ✅ Reduced human errors in reporting
How it works: OCR technology automatically fills inspection forms from meter photos, allowing electricians to focus on critical tasks and handle more service requests efficiently.
- 📊 Real-time Dashboard - Comprehensive overview of device performance metrics
- 🗺️ Interactive Google Maps Integration - Visual device status tracking with color-coded pins
- 📝 Digital Audit Logs - Paperless inspection and maintenance records
- 🤖 OCR Technology - Automatic data extraction from device photos
- 📈 Performance Analytics - Filterable charts and graphs for data-driven decisions
- 🔔 Automated Alert System - Email notifications for status changes
- 📱 Mobile-First Design - Optimized for field technicians on-the-go
- ☁️ Cloud-Based Storage - Google Sheets integration for centralized data management
The project is built entirely on Google Products (G-Suite, AppSheet) where the main interface is developed using AppSheet and data is managed in Google Sheets.
Landing Page with Key Metrics:
The dashboard provides at-a-glance insights into your device network:
- ⚡ Average Power consumption
- 📊 Number of Active Meters
⚠️ Number of Errors/Warnings- 🔌 Power Outages in the last 24 hours
Each metric card is interactive - click to view detailed information and drill down into specific data points.
Google Maps API Integration with Status Indicators:
The Map tab integrates Google Maps API to display real-time device locations and status:
Color-Coded Status System:
- 🟢 Green Pin - Device operating normally
- 🟡 Yellow Pin - Warning status, requires inspection
- 🔴 Red Pin - Device down or broken, immediate action needed
Interactive Features:
- Click on any pin to view/edit device information
- Update device status in real-time
- View technician visit history
- Add specific notes for each device
- Track who last inspected or repaired the device
This enables both electricians and management to respond to status changes as quickly as possible, minimizing downtime.
Digital Paperwork Replacement:
Eliminates physical paperwork by allowing electricians to modify and submit inspection forms directly through the app.
Smart Features:
- 📝 Autofill Functionality - Time-efficient for managing thousands of meters
- 📷 OCR Integration - Take a photo and automatically extract device information
- ✍️ Digital Signatures - Sign and submit instantly
- ✅ Validation - Quick review before submission
- ⏱️ Time Savings - Average 30 minutes saved per inspection
How OCR Works:
- Electrician takes a photo of the device
- System automatically reads and fills form fields
- Technician reviews, signs, and submits
- Data syncs to cloud storage instantly
This reduces both time spent and human errors in data entry.
Data Visualization & Analytics:
Integrated with Google Sheets to build comprehensive visual analytics:
Features:
- 📊 Overall device performance metrics
- 📅 Filterable by date and time ranges
- 🔍 Filter by specific device ID
- 📈 Trend analysis over time
- 💡 Data-driven insights for decision-making
Perfect for management to track performance, identify patterns, and make informed operational decisions.
Intelligent Alert System:
Automated Response System:
- 🔴 Detects when device status changes from Green → Yellow or Red
- 📧 Automatically sends customized emails to assigned electricians
- ⚡ Includes device details, location, and priority level
- 💰 Saves significant costs through rapid response
- 🎯 Reduces manual monitoring requirements
This automated notification system ensures that issues are addressed immediately, minimizing downtime and preventing cascading failures.
- AppSheet account (free or paid)
- Google Workspace account
- Access to Google Sheets
-
Create an AppSheet Account
- Visit AppSheet.com and sign up
-
Access the Application
- Click this link: Device Performance Monitoring App
- Copy the app to your AppSheet account
-
Configure Data Source
- The template data is available in this repository (
Template Data.xlsx) - Upload to your Google Drive and connect to AppSheet
- Alternatively, create a new Google Sheet with the same structure
- The template data is available in this repository (
-
Customize Settings
- Configure email addresses for automated notifications
- Set up Google Maps API key (if not already configured)
- Adjust OCR settings based on your meter types
The application uses the following main data tables:
- Devices - Meter and transformer information
- Audit Logs - Inspection and maintenance records
- Users - Electricians and administrators
- Alerts - Status change notifications
See Template Data.xlsx in this repository for the complete data schema.
While AppSheet doesn't natively support direct GitHub integration, you can connect your GitHub repository to AppSheet using several methods:
Using Integrately (No-Code Solution):
- Sign up at Integrately.com
- Connect your GitHub and AppSheet accounts
- Create automation workflows:
- New GitHub issue → Create AppSheet record
- AppSheet form submission → Create GitHub issue
- GitHub commit → Update AppSheet data
Benefits:
- ✅ No coding required
- ✅ Pre-built templates
- ✅ 1-click setup
- ✅ Suitable for basic automations
For Live GitHub Data in AppSheet:
- Use CData Connect Cloud to connect GitHub
- Authenticate with OAuth2
- Connect AppSheet to CData as a data source
- Build dashboards using live GitHub data (issues, PRs, commits)
Use Cases:
- 📊 Project management dashboards
- 🐛 Bug tracking integration
- 📈 Development metrics reporting
Using n8n or Pipedream (For Custom Workflows):
- Build custom automations with visual workflow builders
- Connect multiple services (GitHub, AppSheet, Slack, etc.)
- Trigger actions based on complex conditions
- Suitable for advanced integration needs
Example Workflows:
- Deploy app updates when code is merged
- Sync issue tracking between GitHub and AppSheet
- Automated testing and deployment pipelines
For maximum control, use Google Apps Script to create custom integrations:
// Example: Webhook handler for GitHub events
function doPost(e) {
var payload = JSON.parse(e.postData.contents);
// Process GitHub webhook
// Update AppSheet via API
}Integrating GitHub with this AppSheet application could enable:
- 📝 Version Control - Track changes to app configuration
- 🐛 Issue Tracking - Link device issues to GitHub issues
- 📊 Documentation - Keep technical docs in GitHub, sync to app
- 🔄 Automated Backups - Backup AppSheet data to GitHub
- 👥 Collaboration - Coordinate development between teams
For detailed setup instructions, see INTEGRATION.md.
We're developing this product into a fully functional solution with enhanced features:
- Comprehensive outage reports
- Detailed billing integration
- Custom report builder
- Export to multiple formats (PDF, Excel, CSV)
- Interactive Device Connections - Click on a device to see all connected devices
- Geo-Navigation - Direct routing for technicians to device locations
- Heat Maps - Visualize outage patterns and high-risk areas
- Network Topology View - Understand device relationships
- Solar panel monitoring
- Battery storage systems
- EV charging stations
- Smart grid integration
- Interconnected dynamic charts
- Predictive maintenance algorithms
- AI-powered anomaly detection
- Energy consumption optimization
- Train OCR for additional meter types
- Read more data points (currently: voltage and power)
- Support for handwritten notes
- Multi-language support
- Multi-tenant architecture
- Role-based access control
- API for third-party integrations
- SLA tracking and compliance
We're looking to expand this product! If you're interested in collaborating, here's how you can help:
- 💡 Ideas & Feedback - Share your thoughts on new features
- 🐛 Bug Reports - Found an issue? Let us know!
- 📖 Documentation - Help improve our docs
- 💼 Business Partnerships - Interested in deploying this solution?
For collaboration opportunities, please reach out:
- 📧 Email: [email protected]
- 💼 LinkedIn: Connect with the team
- 🐛 Issues: Use GitHub Issues for bug reports and feature requests
- Fork the repository
- Create a feature branch
- Make your changes
- Submit a pull request with detailed description
Special thanks to our amazing team who worked together to create this award-winning solution!
We extend our gratitude to:
- Hayden & Google Team - Technical guidance and platform support
- Lucas & BeMyApp Team - Event organization and mentorship
- Solange Jacob & Onix Team - Industry insights and support
This hackathon provided an invaluable learning opportunity and platform to showcase innovative solutions for the manufacturing and utility sectors.
Copyright © 2023 Khang Nguyen Huynh. All rights reserved.
This project is proprietary software. Unauthorized copying, modification, distribution, or use of this software, via any medium, is strictly prohibited without explicit permission from the copyright holder.
For licensing inquiries, please contact: [email protected]
- 📖 AppSheet Documentation
- 🎥 Project Presentation - Download the PowerPoint
- 📊 Template Data - Sample data structure
- 🔗 Live App Demo
If you find this project helpful or interesting:
- ⭐ Star this repository
- 🔄 Share with your network
- 💬 Provide feedback and suggestions
- 🤝 Consider collaboration opportunities
Built with ❤️ using AppSheet and Google Workspace
Hack With Google 2023 Winner 🏆