data.day
google-apps-script / automation / standardization / workflow

The Fix: Google Apps Script That Turns One Email Template Into a Clean Task

Vague emails are the enemy. We replace 'free text' requests with a strict template and a script that parses them into perfect tasks.

Marta Clarity Marta Clarity

Garbage In, Garbage Out

If you work in Ops, IT, or HR, your inbox is a landfill of unstructured requests.

  • “Hi, I need a laptop.” (Who are you? Which department?)
  • “Please update the report.” (Which report? By when?)

You cannot automate “Please update the report.” Automation requires Data, not vibes.

The Chaos: The Translation Tax

Every vague email requires a “Translation Phase.” You have to reply: “What is the deadline?” They reply “Tuesday.” You reply “Which Tuesday?”

This back-and-forth is The Chaos. It is invisible work that shows up nowhere on your performance review, but eats your entire morning.

The System: Template + Regex = Freedom

We fix this by restricting the input. I deployed a system for a client that reduced their “clarification emails” by 90%.

Step 1: The Template (The Law)

We told the team: “We no longer accept free-text emails for Support. You must use this format.”

Subject: [REQUEST] - [Project Name]

Body: GOAL: [What needs to be done] DEADLINE: [YYYY-MM-DD] LINK: https://www.investopedia.com/terms/a/asset.asp

Step 2: The Script (The Enforcer)

We wrote a Google Apps Script (GAS) attached to the inbox. It runs every 5 minutes.

It scans for the tag [REQUEST]. Then, it uses Regex (Regular Expressions) to pull the data.

  • It finds the text between GOAL: and DEADLINE:. That becomes the Task Title.
  • It finds the date after DEADLINE:. That becomes the Due Date.
  • It finds the URL. That goes into the Description.

Step 3: The Handoff

The script takes these variables and calls the API for their project tool (Trello/Asana). It creates the card. It assigns it to the “Triage” column.

Finally, it applies a label to the email: Processed_by_Bot and archives it.

// A taste of the Monster Hack
var subject = message.getSubject();
if (subject.includes("[REQUEST]")) {
  var body = message.getPlainBody();
  var goal = body.match(/GOAL:\s*(.*)/)[1];
  var deadline = body.match(/DEADLINE:\s*(.*)/)[1];
  // Create Task logic here...
}

The Result

Now, when someone emails a request:

If they follow the template, Then their task appears on the board instantly. Service is fast.

If they write “Hey can you help?”, the script ignores it. I reply manually (eventually) with a link to the template.

You teach people how to treat you. Require structure, and you will get clarity.

FAQs

People will hate filling out a template.

They will hate it less than they hate you ignoring their vague email for three days. Structure is speed.

I'm not a coder.

Google Apps Script is basically JavaScript lite. Or use Zapier's Formatter. The logic matters more than the code.

What if they mess up the format?

The script replies automatically: 'Error: Invalid Format. Please use the template.' They learn fast.