Need Expert in Google Sheets and Automation
Skills Required
Description
Working on a project that heavily depends on Google Sheets, and I’m seeking someone who knows their way around formulas, data organization, and especially App Script automation. The goal is to reduce manual processes and make the system more intelligent.
One of the key challenges is automating email notifications through Gmail API when specific data changes occur. This will include triggering custom alerts, summarizing row changes, and sending formatted reports daily or weekly.
I’d also like to auto-update cells and pull data from other sources (like forms or internal sheets). The idea is to keep everything centralized but dynamic, so we don't have to babysit spreadsheets anymore.
If you’ve worked on conditional triggers, auto-formatting, or created interactive dashboards within Google Sheets, that’s exactly what I need. It’s not about building something massive — it's about refining and streamlining what already exists.
There are three sheets involved, each with its own set of rules and users. A good understanding of user roles and how to control access or visibility through scripting would be really helpful.
Ideally, you’ll be able to suggest optimizations I haven’t considered yet. I’m open to smarter workflows or simplifying complex formulas that may be slowing down performance.
I work async, so I appreciate clear comments in your code and a brief explanation of what you implemented after each milestone. Regular check-i...