Status: Performance Review

Subject: Low-Code, High-Impact Workflows

We often talk about “Digital Transformation” as if it requires a million-pound budget and a room full of developers. The truth is much simpler. Most of the friction in your business comes from the “micro-tasks”—the tiny, repetitive actions that eat five minutes here and ten minutes there.

By the end of the week, those “five minutes” have aggregated into a massive hole in your productivity. This week at Empower Automation, I leaned on three specific Google Apps Scripts to reclaim 10 hours of my life.

Here is the breakdown of the logic and the code so you can do the same.

---

1. The “Zero-Effort” Lead Tracker

The Problem: Leads coming in from a website form, LinkedIn messages, and direct emails. I was manually copying them into a “Master Prospect” sheet. It was messy, and I was losing track of who I’d actually followed up with.

The Solution: A script that watches a specific Gmail label (e.g., “New Enquiry”) and automatically parses the sender’s info into a Google Sheet.

function trackNewLeads() {
  const label = GmailApp.getUserLabelByName("New Enquiry");
  const threads = label.getThreads();
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Leads");

  threads.forEach(thread => {
    const message = thread.getMessages()[0];
    sheet.appendRow([new Date(), message.getFrom(), message.getSubject()]);
    thread.removeLabel(label); // Archive after tracking
  });
}

---

2. The Inbox “Noise” Filter

The Problem: My “Primary” inbox was constantly cluttered with newsletters and automated “Bark” notifications. I was spending 20 minutes every morning just hitting “Archive.”

The Solution: An auto-sorter that looks for specific keywords or “Unsubscribe” headers and moves them to a “Read Later” label instantly. It keeps the Primary tab for humans only.

function filterInboxNoise() {
  const threads = GmailApp.search('label:inbox "unsubscribe" -label:important');
  const readLater = GmailApp.getUserLabelByName("Read Later");

  threads.forEach(thread => {
    thread.addLabel(readLater);
    thread.moveToArchive();
  });
}

---

3. The Real-Time Budget Sync

The Problem: Checking three different banking apps and a PayPal business account just to see my “True Balance.” It was making me anxious and prone to over-checking my finances.

The Solution: A script that uses a webhook to pull transaction data into a “Financial Command Centre” sheet. Instead of logging into four apps, I open one spreadsheet.

function syncBudget(e) {
  // Simple webhook receiver for transaction data
  const data = JSON.parse(e.postData.contents);
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Transactions");

  sheet.appendRow([data.date, data.description, data.amount, data.source]);
  return ContentService.createTextOutput("Success");
}

---

The Verdict: Why It Works

None of these scripts are “complex” in the grand scheme of software engineering. But collectively, they act as a silent administrative assistant.

• The Lead Tracker ensures no money is left on the table.
• The Noise Filter protects my focus during the first two hours of the day.
• The Budget Sync removes the emotional weight of “not knowing” where my finances stand.

If you are spending your Sunday night dreading the manual admin of Monday morning, pick one of these and implement it. Reclaiming just one hour is the first step toward a proactive, rather than reactive, business model.