Case · GVIC · Environmental assessment
Five business days after the request, the first five emails had gone out.
None of them needed a correction, in form or substance. Each one started from the specific observation on a project under assessment in Chile’s environmental system (SEA) and from the rule that applies to it.
A task they knew how to do, but never managed to finish.
The request was to find, among the projects under assessment at the SEA, those with observations from the DGA or the DOH (Chile’s water and hydraulic works authorities) and sector permits for hydraulic works and watercourses, and to write each project owner an email on technical and legal grounds.
GVIC did it by hand, file by file, and almost never managed to finish.
Three layers, and control of every send.
Each layer does one thing, and the spreadsheet ties the three together.
A web app on the SEA
It organizes more than 17,000 public SEA projects and reads the official letters of those under assessment: what each agency asks for, about which permit, whether the owner has already replied and when the deadline expires.
A shared spreadsheet
The filtered projects live there, and so does the control of every send and its follow-up: what went out, to whom and what is still awaiting a reply.
An AI assistant
It drafts each email from the specific observation on the project, consulting the regulations that apply to those permits.
Each email starts from its project, not from a template with the name swapped.
The emails came out flawless because each one is built from the observation the agency made on that project and from the rule that applies to that permit. The text changes because the case changes, not because the owner’s name is replaced.
Today a hundred more are awaiting review, and the SEA is checked every week on its own.
Every week, an agent pulls new or updated projects and their observations from the SEA. Whatever has already been contacted stays behind, so only what is missing reaches review.
Do you have a task like this, one you know how to do but never manage to finish?
If it is manual and repetitive, it can be organized the same way: the data, the spreadsheet and control of every step. Write to us.