I will build an ai gmail and google sheets assistant with gemini


About this gig
Drowning in customer emails, form submissions or support requests? I'll build an AI assistant inside Google Sheets that reads every new message and does the sorting for you.
For each request, the AI can:
Categorise it (booking, complaint, quote, support, spam, or your own categories)
Score urgency and sentiment
Write a one-line summary
Detect the language (works with English, Malay, Chinese and more)
Draft a reply in the customer's language, ready for you to review
Extras on request: a "Needs attention" view for urgent items, auto-run on new Gmail or Google Form entries, and email alerts.
Built with Google Apps Script and Google's Gemini AI, running in your own Google account. You use your own Gemini API key, so your data stays between you and Google. No monthly SaaS fees.
Please message me first with what kind of messages you receive and roughly how many per day.
Get to know Stephen K
Google Apps Script Developer
- FromMalaysia
- Member sinceOct 2022
- Avg. response time5 hours
Languages
English, Chinese, Malay
My Portfolio
FAQ
Does the AI send emails automatically?
By default it only drafts replies so a person checks them first. Auto-sending can be added for simple cases, but I recommend review.
What does the AI cost to run?
You use your own Gemini API key. Google offers a free tier that covers light use; higher volumes are billed by Google, usually cents per hundred messages.
Is my data safe?
Everything runs in your Google account with your own API key. I work on a copy with dummy data and never need your password.
Can it use ChatGPT instead of Gemini?
Yes, if you have an OpenAI API key with billing enabled. Mention it before ordering.
Which languages does it handle?
Most major languages. I've tested English and Malay; replies are drafted in the customer's language.

