You will get a Gmail intake tracker with audit log and dashboard
Rising Talent
Rising Talent
Project details
I will build a lightweight Gmail-to-Google-Sheets intake workflow that turns incoming emails into an organized, trackable operations log.
Typical workflow:
1) New emails enter a Gmail label-based intake queue.
2) The workflow reads only queued items and skips already processed records.
3) Structured fields are extracted and appended to Google Sheets as an audit-ready intake log.
4) Priority, SLA, status, and summary views are generated for follow-up.
5) A dashboard shows intake counts and operational visibility by request type and priority.
What you receive:
• Gmail label queue workflow
• Google Sheets intake log
• Audit fields for traceability
• Duplicate prevention
• Priority / SLA tracking
• Dashboard view
• Setup notes
Typical use cases:
• Support intake tracking
• Quote request triage
• Inquiry logging
• Small team workflow monitoring
• Google Workspace-based intake automation
Typical workflow:
1) New emails enter a Gmail label-based intake queue.
2) The workflow reads only queued items and skips already processed records.
3) Structured fields are extracted and appended to Google Sheets as an audit-ready intake log.
4) Priority, SLA, status, and summary views are generated for follow-up.
5) A dashboard shows intake counts and operational visibility by request type and priority.
What you receive:
• Gmail label queue workflow
• Google Sheets intake log
• Audit fields for traceability
• Duplicate prevention
• Priority / SLA tracking
• Dashboard view
• Setup notes
Typical use cases:
• Support intake tracking
• Quote request triage
• Inquiry logging
• Small team workflow monitoring
• Google Workspace-based intake automation
Programming Languages
JavaScriptWhat's included
| Service Tiers |
Starter
$179
|
Standard
$399
|
Advanced
$749
|
|---|---|---|---|
| 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 | 1 | 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 - 10:55 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 queue rules and tracked fields
We confirm which emails should enter the intake queue, which labels to use, and which fields must be logged in Sheets.
Build and test the intake workflow
I build the Gmail label queue, Sheets intake log, extraction flow, dedup logic, and dashboard, then test with sample emails.