Skip to content
Back to Portfolio/Serverless Automation Script
Evolved System: Reclaim PWAZero-Cost Native Apps Script
Google Apps ScriptGemini 3.6 Flash API2025 Production Core

The AI Control Plane

Autonomous Google Apps Script Engine & Multi-System AI Pipeline

Gemini 3.6
Flash AI Engine
Daily 8AM
Automated Trigger
3 Brands
Content Lab
100%
Data Sovereignty

Executive System Overview

The AI Control Plane is an autonomous, serverless Google Apps Script engine that functions as my private Executive Assistant and Creative Director. Executing on a daily morning trigger, it triages unread Gmail threads, Google Calendar schedules, recent Drive projects, OpenWeather data for Falkirk, and live horoscopes synthesising them via Gemini 3.6 Flash into a beautifully styled HTML briefing delivered straight to my inbox.

This script engine laid the technical foundation that later evolved into Reclaim (The PWA Sanctuary OS).

01 / The Origin Story

Why I Built It: From Decision Fatigue to Code

"I suffered from severe decision fatigue, some mornings opening my laptop and literally not knowing where to start. I needed a personal project manager."

I was learning Apps Script and had already built a script that could read my emails and update my calendar. But what I really needed was structure to my day. As a solo founder and mum raising three kids, opening a noisy inbox every morning created instant cognitive friction.

I started using Gemini's scheduled actions inside a long chat thread. Every morning before lifting my head off the pillow, I'd open the chat thread, tell Gemini to plan my day, confirm "yes" twice, and sync the scope to my calendar. But within a month, it stopped working so well, the long chat thread caused context drift and friction.

"I asked myself: I can already write Apps Script, and I know how to fetch weather APIs... can I add AI directly into my script? YES!"

Instead of dealing with the hassle of chat-based scheduled actions, I wrote this standalone Google Apps Script.

Then came marketing. Building my portfolio and sharing what I do required consistent content. So I expanded the script to include social media prompts generating full captions, image concepts, and blog outlines across my three business pillars (Empower Virtual Assistant Services, Empower Automation, and Empower Digital Solutions).

System Output 01

The Daily Executive Briefing Email

HTML / CSS Output

The script generates a clean, modern HTML briefing sent directly to Gmail every morning. It structures the day into Biological Support, Movement & Errands, Zone Cleaning, Work Mode (10:00–18:00), Mum Mode (18:00–21:00), and Glow Up (21:00), alongside full social media captions and blog outlines.

Nicola Berry Executive Briefing Email Output

Figure 1: Full-length Executive Briefing Email delivered directly to Gmail at 8:00 AM

System Output 02

Automated Trello Content Pipeline

Trello API Integration

A downstream script reads the daily briefing email, parses the generated social media posts (captions, image prompts, and hooks), and automatically creates cards on a Trello board, categorised into posted & ideas lists across Empower VA, Automation, and Digital Solutions.

Automated Trello Social Media Content Board

Figure 2: Automated Trello Content Board staged with image prompts, captions, and hooks

System Architecture

System Architecture & Data Flow

System Diagram

High-level technical architecture detailing input sources (Gmail, Calendar, Drive, OpenWeather), the Google Apps Script & Gemini 3.6 Flash processing engine, email output, API integrations, and the self-feeding Drive feedback loop.

Reclaim Protocol System Architecture Diagram

Figure 3: System Architecture & Automated Data Flow Protocol

02 / Architecture

The 4-Stage Connected Automation Pipeline

1. Daily Briefing & Sanctuary

Executes `generateDailyBriefing()` using Gemini 3.6 Flash. Rotates 7 Zone Cleaning routines, 7 Glow-Up self-care rituals, 3 Content Pillars, and 7 Content Angles into a formatted HTML email.

2. Gmail-to-Calendar Sync

A secondary Apps Script monitors incoming confirmation emails and automatically parses dates, titles, and details directly into Google Calendar.

3. Trello API Content Pipeline

Parses social media captions and image prompts from the email and calls the Trello API to automatically stage structured cards on the content board.

4. Gemini Spark Drive Feedback Loop

Gemini Spark reads the briefing email daily, writes complete blog articles for my websites, and saves them to Google Drive, which `getProjectContext()` then reads for tomorrow's brief!

System Evolution

From Script Engine to Full PWA Operating System

This Apps Script pipeline was so transformative in managing daily cognitive load that it became the core foundation for Reclaim, my full-stack React & PWA Sanctuary OS.