Project Description
I’m streamlining several internal projects in Google Sheets and want a tech-savvy hand to bring them together. The core file needs clean data entry workflows, well-structured tables, custom formulas that cut down on manual math, plus clear summaries and charts that anyone on my team can read at a glance.
My main goal is to take the repetitive typing out of the process. I’d like an OpenAI-powered script—or any sensible approach you suggest that still leverages the OpenAI API—to recognize incoming text, classify or transform it, and drop it into the right cells automatically. Once that foundation is solid, the sheet should run its own calculations and refresh the visuals without extra clicks.
Deliverables
• A Google Sheet template (or connected workbook) with automated OpenAI data-entry logic in place
• Custom formulas and error-proof data validation for ongoing accuracy
• At least one dynamic dashboard or report page pulling from the live data
• Brief walkthrough or loom video so my team understands how to tweak and extend the setup
If you’re comfortable with Apps Script, GPT function calls, and advanced Sheets features, this should be a quick but interesting build. I’m ready to start as soon as you can outline the approach.
THE PAY IS 100 USD for 2 weeks . We meet 2 hours per day