Email into a Sheet
Capture emails from specific senders or labels and log the sender, time, subject and replies into one Google Sheet.
Services Google Apps Script
Google Apps Script automation for Gmail, Sheets and Chat
Small scripts that run inside your Google account: log the right emails into a Sheet, post alerts to Google Chat, send a summary every evening, and stop the copy-paste.
What I build
Google Apps Script: what's included
Alerts in Google Chat
Post a message to a Google Chat space through a webhook the moment something important arrives.
Scheduled summaries
A time-driven trigger that emails a summary at the same time every day, for example everything still marked pending.
Sheets that keep themselves tidy
Status columns, conditional formatting, filtered tabs and dropdowns set up by script, so the sheet stays usable as it grows.
Scripts that time out
Apps Script stops a run after 6 minutes. Long jobs get split into batches that pick up where they left off, with logging so failures are visible.
Calls to other tools
Connections from Apps Script to outside APIs such as Twilio, Stripe or your CRM, with keys kept in Script Properties instead of the code.
Sound familiar?
Requests like these
- “Log every email from our key clients into a shared Sheet”
- “Ping our team's Google Chat space when a customer replies”
- “Email me everything still pending at 8 PM every day”
- “Our script worked for a year and now it times out”
Examples of the kind of request this covers, not quotes from clients.
What I can show you
Apps Script is JavaScript, which is what I write every day
Tessavio Auto, my largest build, is written in TypeScript, the typed version of the same language Apps Script uses, and talks to Twilio and Stripe through their APIs and webhooks. Click through it to judge the quality of my work.
What I won't build
Scripts that log into other companies' websites or get around their logins. If a system has no API, I'll tell you what can be done within its rules.
FAQ
Straight answers
Have you built Apps Script projects for clients before?
Not yet, and I won't pretend otherwise. What I can show you is Tessavio Auto, a complete system in the same language family. The first job is small and fixed-price, and on Upwork the payment sits in escrow until you approve it, so your risk is one milestone.
Does it need a paid Google Workspace plan?
No. Apps Script runs on free Gmail accounts too. Workspace accounts get higher daily limits, which matters for scripts that send a lot of email.
Who owns the script?
You do. It lives in your Google account, and I hand over a short written explanation of what it does and how to change it.
Start here
Describe the job in a few lines
I reply in writing with how I’d build it and a fixed price. $55/hour for small fixes; fixed quotes for everything else.
info@tessavio.com
Found me on Upwork? Please message me there: Upwork’s rules keep our conversation on Upwork until a contract starts.
Other services: Custom software · AI integration · Workflow automation · Twilio SMS · QuickBooks & Stripe