Sync Multi-Laptop Battery to Sheets
Budget: ₹600 – ₹1,500 INR
I need a small Python utility that reads the current battery level from several laptops and pushes that value to a Google Sheet every ten minutes. The sheet only needs one visible number per machine—one dedicated cell that always shows the latest percentage—so the script should overwrite the previous value rather than append rows or columns.
Here is what I have in mind:
• Each laptop runs the same script locally, detects its own battery percentage (cross-platform support for Windows and macOS is ideal), and then updates a specific cell in a shared Google Sheet using the Google Sheets API (gspread, google-api-python-client, or a similar library).
• A simple identifier (hostname or a label I can set in a config file) tells the script which cell to update, allowing me to add or remove machines without editing the code.
• The update interval is ten minutes; this can be a scheduled loop or a cron-friendly one-shot mode.
• If the machine is on AC power, the script should still report the current percentage—no special handling is required beyond that.
• Clear instructions are needed for obtaining API credentials, installing any required packages, and setting the script to launch automatically at login.
Deliverables:
1. Well-commented Python script ready to run on multiple laptops.
2. A short README covering setup, Google Cloud credential steps, and how to map each laptop to its cell.
3. Optional: a lightweight requirements.txt or Pipfile for quick environment setup.
As soon as I can drop the script on each machine and see the numbers update in my sheet, we’re done.
Here is what I have in mind:
• Each laptop runs the same script locally, detects its own battery percentage (cross-platform support for Windows and macOS is ideal), and then updates a specific cell in a shared Google Sheet using the Google Sheets API (gspread, google-api-python-client, or a similar library).
• A simple identifier (hostname or a label I can set in a config file) tells the script which cell to update, allowing me to add or remove machines without editing the code.
• The update interval is ten minutes; this can be a scheduled loop or a cron-friendly one-shot mode.
• If the machine is on AC power, the script should still report the current percentage—no special handling is required beyond that.
• Clear instructions are needed for obtaining API credentials, installing any required packages, and setting the script to launch automatically at login.
Deliverables:
1. Well-commented Python script ready to run on multiple laptops.
2. A short README covering setup, Google Cloud credential steps, and how to map each laptop to its cell.
3. Optional: a lightweight requirements.txt or Pipfile for quick environment setup.
As soon as I can drop the script on each machine and see the numbers update in my sheet, we’re done.