You will get a Google Forms and Sheets operations dashboard with action tracking
Rising Talent
Rising Talent
Project details
I will build a lightweight Google Forms and Sheets operations tracking workflow for daily task logging, summaries, and manager review.
Typical workflow:
1) Staff submit task records through a mobile-friendly Google Form.
2) Responses flow into Google Sheets and are normalized into a Cleaned_Log with work_date, week_key, issue_flag, and next_action.
3) Daily, weekly, and employee summaries are generated automatically.
4) A manager dashboard shows output metrics and a daily trend chart.
5) An Action Board surfaces flagged records for follow-up.
What you receive:
• Google Form
• Cleaned log
• Daily/weekly summaries
• Employee summary
• Manager dashboard
• Action Board
• Basic Apps Script automation and setup notes
Typical use cases:
• Warehouse task tracking
• Daily team reporting
• Field activity logging
• Small business workflow monitoring
Typical workflow:
1) Staff submit task records through a mobile-friendly Google Form.
2) Responses flow into Google Sheets and are normalized into a Cleaned_Log with work_date, week_key, issue_flag, and next_action.
3) Daily, weekly, and employee summaries are generated automatically.
4) A manager dashboard shows output metrics and a daily trend chart.
5) An Action Board surfaces flagged records for follow-up.
What you receive:
• Google Form
• Cleaned log
• Daily/weekly summaries
• Employee summary
• Manager dashboard
• Action Board
• Basic Apps Script automation and setup notes
Typical use cases:
• Warehouse task tracking
• Daily team reporting
• Field activity logging
• Small business workflow monitoring
Programming Languages
JavaScriptWhat's included
| Service Tiers |
Starter
$149
|
Standard
$349
|
Advanced
$699
|
|---|---|---|---|
| Delivery Time | 4 days | 6 days | 8 days |
Number of Revisions | 1 | 2 | 2 |
Number of Pages Mined/Scraped | 1 | 1 | 1 |
Number of Sources Mined/Scraped | 3 | 1 | 1 |
Install Script | |||
Test Script | |||
Task Automation |
Optional add-ons
You can add these on the next page.
Fast Delivery
+$80 - $180
Additional Revision
+$40Frequently asked questions
About Shigeru
Python & Google Apps Script Automation for Sheets, PDF, Gmail
Chiba, Japan - 6:49 am local time
My core specialty is Google Sheets-centered automation: ingesting data from Gmail/API sources, extracting and normalizing structured fields (including AI-assisted extraction when useful), generating outputs (PDFs/reports), and preparing or sending email delivery workflows.
I focus on practical operations, not just scripts:
- audit-ready logs (run_id, status/error tracking)
- duplicate prevention and rerun-safe design
- clear configuration and maintainable structure
- lightweight systems for teams before ERP/CRM adoption
---
Core workflows I build:
- Google Sheets → PDF (invoices, receipts, reports)
- Gmail/API → Google Sheets intake automation
- Scheduled reporting pipelines (ingest → transform → output)
- Email delivery automation (Gmail API drafts/send, optional SMTP)
- Google Apps Script automations with time-driven triggers
---
Recent portfolio work:
- Python Automation: scrape/ingest data → CSV → charts → multi-page PDF → email workflow (logged, reproducible, auditable)
- Gmail to Sheets AI Intake Automation (Google Apps Script + Gemini): scheduled Gmail query, structured extraction, append-only audit log, duplicate prevention (label + msg_id checkpoint), and status/error tracking
- Google Sheets → PDF invoice / receipt automation (Drive + Gmail integration)
---
Typical problems I solve:
- “We use Google Sheets but still create PDFs and emails manually.”
- “We need weekly/monthly reports generated and delivered automatically.”
- “We need a Google Apps Script workflow with logs and safe re-runs.”
- “We want a lightweight system before moving to a full ERP/CRM.”
---
What you get:
- Maintainable Python and/or Google Apps Script code
- Clear configuration and setup instructions
- Operationally usable outputs (Sheets/PDF/email flow)
- Documentation (README + setup + run procedure)
- Basic audit logging and rerun guidance
---
How I work:
- Communication: Upwork messages only (async, written-first)
- Timezone: JST (UTC+9), weekday response within 24 hours
- Process:
1) Confirm inputs/outputs and one sample (redacted is OK)
2) Build the end-to-end automation
3) Deliver a documented mini-system you can run and maintain
If you share your workflow and one sample file/email/report, I can propose the simplest build plan with a clear scope.
Steps for completing your project
After purchasing the project, send requirements so Shigeru can start the project.
Delivery time starts when Shigeru receives requirements from you.
Shigeru works on your project following the steps below.
Revisions may occur after the delivery date.
Confirm fields, tasks, and dashboard needs
We confirm the form fields, task categories, manager view, and the rules for flagged items before I build the workflow.
Build and test the tracking workflow
I build the Google Form, Cleaned_Log, summaries, Apps Script automation, dashboard, and Action Board, then test them with sample data.