Latest / AI Fire Daily / #7 Eric: Google Workspace Automation — Building Smarter Workflows Across Gmail, Sheets, Docs, and Everyday Tasks
Transcript
- 0:00Imagine a perfectly automated factory line, like
- 0:03a glass bottle goes under a nozzle, gets exactly
- 0:06three ounces of soda, a cap gets screwed on,
- 0:09and it just moves down the line. Right. It's
- 0:11this flawless mesmerizing operation to watch.
- 0:15Exactly. But it has a fatal flaw. I mean, the
- 0:17entire system is just incredibly fundamentally
- 0:20dumb. Oh, yeah. Because it really only works
- 0:23if every single bottle arriving on that belt
- 0:27is, you know, Completely identical in height
- 0:30and volume right absolutely identical the second
- 0:32a slightly taller bottle shows up Or like a crushed
- 0:35can instead of a pristine glass bottle The machinery
- 0:38doesn't pause to assess the situation. It just
- 0:41blindly follows its programming. Exactly. It
- 0:43just crushes the can and sprays soda literally
- 0:45everywhere. And if you've ever tried to automate
- 0:47your own digital workflows, you have probably
- 0:49sprayed data everywhere. Oh, totally. We all
- 0:52have. You set up a rule, and then a slightly
- 0:53weird email or a strangely formatted PDF arrives,
- 0:57and boom, your digital conveyor belt just shatters.
- 1:00But welcome to today's Deep Dive, because we
- 1:02are looking at how to build a conveyor belt that
- 1:04can actually think for itself. is quite the promise.
- 1:08It is. And this deep dive is custom tailored
- 1:11for you to solve exactly that problem. Our mission
- 1:14today is navigating Google's expanding universe
- 1:17of AI tools. We want to figure out how to stop
- 1:21doing those mind -numbing, repetitive tasks that
- 1:23just eat up your day while also keeping your
- 1:27fluid, creative projects entirely on track. It's
- 1:29a really fascinating dual challenge, I think.
- 1:32Because on one hand, creativity requires this
- 1:35immense flexibility iterative thinking. But on
- 1:38the other hand, administrative work demands rigid,
- 1:41almost mathematical reliability. So, finding
- 1:43the architectural bridge between those two completely
- 1:46different modes of working, that is where the
- 1:48real value lies for you. Yeah, and to find that
- 1:50bridge, we are pulling from some fantastic source
- 1:52material today. We have excerpts from Teal, DR,
- 1:55B .O .X. specifically focusing on a really comprehensive
- 1:57guide by Eric Liff. Yeah, his guide on building
- 2:00AI workflows inside Google Workspace. Okay, let's
- 2:03unpack this, because the guide actually starts
- 2:05by tackling the creative side of the house. Google
- 2:08has quietly built an entire ecosystem of specialized
- 2:11creative AI. tools. Right. And we need to understand
- 2:14that this is no longer just a generic chatbot
- 2:17window where you type a question and get a paragraph
- 2:20back. Exactly. We have firmly moved past the
- 2:23era of the single monolithic AI interface. The
- 2:27guide details how Google is shifting towards
- 2:30specialized purpose -built tools for distinct
- 2:33stages of the creative process. Which makes sense
- 2:36because you don't use the same physical tools
- 2:38for brainstorming as you do for final production.
- 2:41Right. The source breaks down this toolkit beautifully.
- 2:43So you've got Gemini, which acts as your flexible
- 2:45starting point, like the blank canvas where you
- 2:47ideate. But then you transition into Pimeli.
- 2:50And the source notes Pimeli is specifically for
- 2:52building around a business or a brand. And there's
- 2:55Stitch, which basically takes your creative direction
- 2:58and turns it into actual user interfaces. Oh,
- 3:01wow. Yeah. And for video, you have Flow, which
- 3:04handles highly cinematic media generation. And
- 3:07then Google Viz, which is geared toward more
- 3:09structured professional business. presentations.
- 3:12Yeah and the source uses this incredible example
- 3:14of building a fictional menswear brand called
- 3:16Velen. Yes I loved that part. They literally
- 3:19take it from a basic list of product facts all
- 3:22the way to a functional website prototype and
- 3:24a cinematic commercial just by moving the project
- 3:28through these different tools. Which is wild.
- 3:30Yeah. But why is that progression you know from
- 3:33basic facts to a cinematic commercial? Why is
- 3:36that the crucial takeaway from the section of
- 3:38Eric Lee's guide? Because the biggest leap forward
- 3:41in this creative AI ecosystem isn't necessarily
- 3:45that the raw text or image generation is just
- 3:47getting slightly more photorealistic. OK, then
- 3:50what is it? It's the architectural ability to
- 3:52carry your approved work forward into the next
- 3:55stage of the process. That is huge. Oh, right.
- 3:58Because the guide points out that right now,
- 4:00the biggest mistake users make is constantly
- 4:02asking new tools to recreate an approved direction
- 4:06from scratch. Yes. They just use a brand new
- 4:08text prompt every time they open a new window.
- 4:10Which is kind of madness when you step back and
- 4:11look at it. It's incredibly inefficient because
- 4:15it treats the AI as if it just has total amnesia.
- 4:18I mean, you spend three hours getting the perfect
- 4:20brand voice, the exact color palette, and the
- 4:23visual aesthetic dialed in using one tool. Right.
- 4:26And then you open a video tool and just type,
- 4:29make me a cool modern menswear video. And you're
- 4:32just hoping the new system magically guesses
- 4:35what you just spent hours refining elsewhere.
- 4:37It's like baking a multi -tiered cake. You don't
- 4:40throw out the batter and start completely from
- 4:41scratch every single time you want to add a new
- 4:43layer of frosting or a new tier. That's a great
- 4:46way to put it. You carry that approved baked
- 4:48foundation forward and you build the next layer
- 4:50directly on top of it. You lock in the base and
- 4:53then you decorate. Yeah, that really captures
- 4:55the spirit of it. Mechanically, though, it's
- 4:57almost more like a relay race where the baton
- 4:59itself carries the memory of the runner before
- 5:01it. In AI terms, you are establishing a persistent
- 5:06context window. You aren't just handing the next
- 5:09tool a quick text summary. You're passing the
- 5:12structural metadata of the brand forward. So
- 5:14the new tool operates within strict, pre -approved
- 5:17guardrails. Which is just incredibly powerful
- 5:20for design and marketing. we kind of have to
- 5:23pivot here, because while AI is clearly becoming
- 5:26fantastic at these fluid, iterative, creative
- 5:29projects, How do we apply this flexible intelligence
- 5:33to the rigid, boring, repetitive administrative
- 5:37work, like the dreaded admin tasks? Right. The
- 5:41stuff nobody actually wants to do. This brings
- 5:43us to the core thesis of Eric List's guide, which
- 5:46establishes a really vital distinction between
- 5:48AI assistance and AI automation. OK, break that
- 5:51down for me. Well, most people interacting with
- 5:53AI today are just using assistance. You open
- 5:55Gemini, you ask it to summarize a document, and
- 5:58it helps you in that specific moment. It's a
- 5:59localized interaction. Right, but automation
- 6:02is a totally different beast. Because automation
- 6:04means an event happens and a predefined workflow
- 6:06kicks off automatically in the background without
- 6:08you clicking anything. Exactly. When X happens,
- 6:11automatically do Y. And the source gives us this
- 6:14brilliant, incredibly simple framework for how
- 6:16to integrate AI into this process. It's trigger,
- 6:19then think, then act. Trigger, think, act. It
- 6:25fundamentally redefines how we approach automated
- 6:27systems. Because traditionally automation was
- 6:31really just trigger and act. Wait, I actually
- 6:32have to challenge this framework for a second.
- 6:34Doesn't adding a think step explicitly slow down
- 6:37traditional automation? I knew me. Well, I thought
- 6:40the whole point of automation was to be that
- 6:42incredibly fast dumb factory conveyor belt we
- 6:45talked about earlier. If the software has to
- 6:48stop to think about what to do next, aren't we
- 6:50just introducing a massive processing bottleneck?
- 6:53What's fascinating here is that this perceived
- 6:55bottleneck is exactly the paradigm shift you
- 6:58need to embrace. Really? Yeah. You still use
- 7:01standard lightning fast automation rules for
- 7:03the obvious things, the predictable conveyor
- 7:05belt stuff, but you insert the AI think step
- 7:08exclusively for points of uncertainty. You use
- 7:11it for the messy data that requires actual semantic
- 7:14understanding. Okay, give me an example of the
- 7:16difference between the two. Like what is messy
- 7:17versus obvious? Sure. So if an email arrives
- 7:20with an attachment, that's your trigger. If that
- 7:23email needs to be saved to a specific Google
- 7:25Drive folder you've already designated, you don't
- 7:28need AI to deeply reason about that action. Because
- 7:32it's just a basic rule. Right. That is a deterministic
- 7:34rule. It happens instantly. But if you need to
- 7:37know what the total amount due is on a randomly
- 7:40formatted PDF invoice attached to that email,
- 7:43That is messy. Oh, because the total amount might
- 7:46be in the top right corner or the bottom left.
- 7:48Exactly. Or it might be called amount due or
- 7:50may be total payable. That requires understanding
- 7:53context. And that is exactly where you insert
- 7:56the AI to think and parse the document before
- 7:58the system moves on to the final act phase. OK,
- 8:01that distinction clarifies so much. So you use
- 8:03rigid rules for what the system knows, and you
- 8:06use AI for what the system needs to understand.
- 8:09Spot on. But practically speaking, for you listening
- 8:12right now, where are you supposed to actually
- 8:14build these smart conveyor belts? Because...
- 8:17I mean, I am not a software engineer, and I assume
- 8:19most people listening don't want to spend their
- 8:21weekend writing code. Well, the good news is
- 8:24the guide completely sidesteps the need for a
- 8:27computer science degree. It breaks down two distinct
- 8:30paths Google offers for building these workflows.
- 8:33The first is Workspace Studio, which is a no
- 8:36-code visual layer built specifically for Google
- 8:38-first workflows. And the second is App Script,
- 8:42which is a JavaScript -based route intended for
- 8:45when you need highly custom, complex programming
- 8:47logic. And just to be totally clear, for this
- 8:49deep dive, we are focusing strictly on Workspace
- 8:52Studio. The guide makes it very clear that Workspace
- 8:54Studio can handle the vast majority of administrative
- 8:58tasks you're going to encounter without you ever
- 9:01needing to look at a single line of code. Yeah,
- 9:03we are leaving the JavaScript for another day.
- 9:06Workspace Studio is where the everyday magic
- 9:07happens. You are basically just visually snapping
- 9:10blocks together. Love that. But before you start
- 9:12trying to automate every single aspect of your
- 9:14professional and personal life, the source provides
- 9:17four strict criteria for what is actually worth
- 9:20automating. Right, because if a task doesn't
- 9:22meet these four rules, attempting to automate
- 9:24it will actually cost you more time than it saves,
- 9:27right? Precisely. It becomes a huge time sink.
- 9:30OK, let's hear the four rules. Rule one, it happens
- 9:34repeatedly. Rule two, it has a clear trigger,
- 9:37meaning a definitive digital event that starts
- 9:39it. Makes sense. Rule three. The process follows
- 9:43roughly the same steps every single time. And
- 9:46rule four, the input and the output are predictable
- 9:50enough that you can actually verify if the system
- 9:52worked correctly. Okay, so do a quick mental
- 9:55audit of your own workday against those four
- 9:57rules repeatedly. Clear trigger, same steps,
- 10:00predictable input and output. The source gives
- 10:02a really great contrast here. If you were brainstorming
- 10:05a new marketing campaign, is that an automation
- 10:07candidate? Absolutely not. Right. because it
- 10:09doesn't follow the same steps, and the output
- 10:11is entirely unpredictable. But what about processing
- 10:14an incoming vendor invoice? That's a different
- 10:16story. Yeah, an email arrives that's a clear
- 10:18trigger. You save the PDF, you read the amounts,
- 10:21you log it in a spreadsheet. That follows roughly
- 10:23the same steps, and it is highly predictable.
- 10:25It is the perfect candidate for automation. Invoices
- 10:28are essentially the holy grail of repetitive,
- 10:31soul -crushing administrative work. They really
- 10:34are. And having identified invoices as the perfect
- 10:37test subject, Eric Le's guide walks us through
- 10:41dissecting exactly how to build the ultimate
- 10:43invoice processing machine in Workspace Studio.
- 10:46Yes. And it's a very elegant flow. I actually
- 10:48want to walk through the exact workflow from
- 10:50the source, step by step, because the goal here
- 10:53is to turn unstructured emails into perfectly
- 10:56structured data in Google Sheets all while you're
- 10:59asleep or, you know, drinking coffee. Living
- 11:01the dream. Exactly. So here is the flow. First,
- 11:05an email with an attachment arrives in your Gmail.
- 11:07That's our trigger. Second, the PDF attachment
- 11:10is automatically saved to a specific Google Drive
- 11:13folder called Incoming Invoices. Third, and this
- 11:17is the AI ThinkStep Gemini, is given access to
- 11:19that file in Drive and is explicitly told to
- 11:22extract five specific variables. And those are?
- 11:25The vendor name, the invoice number, the invoice
- 11:27date, the due date, and the total amount. We
- 11:30should probably pause on that third step because
- 11:32it really highlights how far the technology has
- 11:34come. How so? Well, historically. optical character
- 11:37recognition, or OCR, would just blindly read
- 11:40text left to right, top to bottom. It didn't
- 11:42know what a total amount actually was, it just
- 11:44saw numbers on a page. But Gemini is utilizing
- 11:48multimodal semantic understanding. It is looking
- 11:52at the spatial layout of the unstructured PDF,
- 11:56understanding the relationship between the word
- 11:57total and the number next to it. and pulling
- 12:00out just those five variables, it completely
- 12:03ignores all the other visual noise and fine print
- 12:06on the invoice. It's literally reading it the
- 12:08way a human accountant would read it. Exactly.
- 12:11And finally, we hit the act step. The extracted
- 12:14data is automatically logged into an accounts
- 12:16payable ledger in Google Sheets as a brand new
- 12:19row. And it even pulls in system metadata, like
- 12:23the exact time the email was received and the
- 12:25subject line of the source email. It is a beautiful
- 12:27seamless flow. It is, but here's where it gets
- 12:29really interesting. Because the guide highlights
- 12:32a specific technical quirk in Workspace Studio
- 12:34that will absolutely break your workflow if you
- 12:37aren't paying attention. Ah, yes, the branching
- 12:39logic issue. Yeah, regarding branching logic.
- 12:42Specifically, the interaction between the decide
- 12:45and check if modules. So the source notes that
- 12:48if you use an AI decide step followed by a check
- 12:52if step, for example, asking AI, is this attachment
- 12:55a PDF? And then checking if the answer is true.
- 12:59it creates a conditional sub -branch in the workflow.
- 13:02I like to think of it kind of like a locked hallway
- 13:04in a video game. You are walking down the main
- 13:06path of your workflow. You take a turn into this
- 13:09check -if hallway, and the door firmly locks
- 13:11behind you. That's a great analogy. So if you
- 13:13execute a step, like saving your file to drive,
- 13:16while you're inside that locked hallway, the
- 13:18link to that file stays locked in that branch.
- 13:20You cannot use it in the top level steps later
- 13:22on, and you can't nest another conditional branch
- 13:25inside of it. Yeah, in software engineering this
- 13:27is known as scope limitation. The system essentially
- 13:30treats the variables generated inside that sub
- 13:33-branch as local. meaning they belong only to
- 13:37that specific condition and they do not flow
- 13:39back out to the global main path. Visual builders
- 13:42enforce this to prevent memory leaks and conflicting
- 13:45logic downstream. And this is exactly where the
- 13:48source provides a brilliantly smart architectural
- 13:51fix to bypass this technical limitation. Right,
- 13:54because instead of using a complex AI decide
- 13:57branch just to check if an attachment is a PDF
- 13:59which traps your workflow in that sub -branch,
- 14:02You use a simple filter -a -list step. Yes. Filter
- 14:05-a -list doesn't create a locked branch. It just
- 14:07looks at the file extension. If it's a PDF, it
- 14:09stays on the main path. If it's not, it's just
- 14:11dropped entirely. But wait, I'm a little confused
- 14:14here. Where's the holdup? If both the filter
- 14:16step and the decide step are ultimately just
- 14:18checking a file type? Why does one break the
- 14:21workflow scope and the other doesn't? Like, what
- 14:23is the actual difference to the system? Okay,
- 14:25the difference lies in deterministic rules versus
- 14:28probabilistic AI reasoning. Okay. So the filter
- 14:31step is deterministic. It is a piece of hard
- 14:34-coded software logic that simply says, does
- 14:36this string of text end in .PDF, yes or no? Okay,
- 14:40very straightforward. Right. It requires zero
- 14:43cognitive overhead from the system. So the visual
- 14:45builder can keep it on the main global path.
- 14:48But the decide step fires up the large language
- 14:51model. It asks the AI to probabilistically reason
- 14:54about the input. Oh, I see. And because AI outputs
- 14:57can be unpredictable, the visual builder actively
- 15:00forces that reasoning into an isolated sub -branch
- 15:02to contain any potential errors. Ah, so you don't
- 15:06need AI to read a file extension. You save the
- 15:09AI reasoning that heavy decide step for the harder
- 15:12semantic question later down the line. Is this
- 15:15PDF actually an invoice? Precisely. It separates
- 15:18the mechanical sorting from the cognitive interpretation.
- 15:20Like a PDF could just be a takeout menu, a co
- 15:23-worker email you, right? The deterministic rule
- 15:25knows it's a PDF, but only the probabilistic
- 15:27AI knows it's a menu and not a vendor invoice.
- 15:30So by filtering first, you keep the workflow
- 15:32on the main path, ensuring your drive link is
- 15:34still globally available for the data extraction
- 15:36step later. It is an incredibly elegant workaround.
- 15:41However... The expert guide doesn't just hand
- 15:43you the keys and walk away. Eric Law warns that
- 15:46even the smartest, most elegantly designed workflow
- 15:49has dangerous blind spots. Yes, we definitely
- 15:52have to talk about the guardrails of automation.
- 15:54Right, like what can actually go wrong when you
- 15:57turn these systems on? Well, the guide outlines
- 15:59several very specific limitations you absolutely
- 16:02must respect. First, variables can fail silently.
- 16:06What does that mean in practice? Say an email
- 16:09comes in that is missing an invoice number entirely,
- 16:11and empty data is passed to the next step. The
- 16:14workflow might just continue running, it could
- 16:16return an unexpected result, or just a blank
- 16:18cell in your spreadsheet without flashing a giant
- 16:20red warning sign to alert you. So you really
- 16:23have to build in your own error checking. You
- 16:25do. And second, and this is a critical operational
- 16:28warning, when you run test workflows in Workspace
- 16:31Studio, they perform real actions. Wait, really?
- 16:34Yes. The APIs are live. Meaning it's not just
- 16:37a simulation. Like, if I'm testing my invoice
- 16:39workflow, it's actually doing the work in my
- 16:41real accounts. Exactly. Because it's a live API
- 16:44integration, if your test involves sending an
- 16:47email to a client or updating a live financial
- 16:49spreadsheet, it will actually execute those actions
- 16:52during the test run. Oh, wow. That could be disastrous.
- 16:55Very. You must use isolated disposable practice
- 16:59data when you're building and testing these flows.
- 17:02But honestly, the most important guardrail of
- 17:05all the philosophical core of the guide is understanding
- 17:08that automation still requires human judgment.
- 17:11This was my absolute favorite takeaway from the
- 17:13whole guide. Eric Lay writes a sentence you should
- 17:16probably put on a post -it note on your monitor.
- 17:18Automate the repetitive handoff. Keep humans
- 17:21around consequential decisions. It's such a great
- 17:23rule of thumb. Right. Having Gemini extract an
- 17:26invoice amount and log it in a spreadsheet, that
- 17:28is just a repetitive handoff of data. But actually
- 17:31paying that invoice automatically based on what
- 17:33the AI extracted, that is a high -risk consequential
- 17:36decision. You don't automate the checkbook, you
- 17:38just automate the grueling data entry leading
- 17:40up to the checkbook. And if we connect this to
- 17:43the bigger picture, everything we've discussed
- 17:47today, Workspace Studio, the deterministic filters,
- 17:51the probabilistic think steps, the scope limitations,
- 17:54It all relies entirely on us designing the path.
- 17:57Right. We are the architects. We tell the system
- 18:00where to start, what specific criteria to check,
- 18:03and exactly where to put the data at the end.
- 18:05We are holding the map. Which is the perfect
- 18:07tease for the final section of the source material
- 18:09we're looking at today, because the guide hints
- 18:11at what is coming next in Lesson 7, and it represents
- 18:14a massive paradigm shift in how we interact with
- 18:17software. Oh, yeah. We are moving from workflows
- 18:19to... agents. It is the monumental leap from
- 18:23a system that follows strict instructions to
- 18:25a system that pursues broad goals. Yeah, because
- 18:28in a workflow, even a smart one with AI in the
- 18:31middle, you still have to define every single
- 18:33transition. You define the trigger. You define
- 18:35the think step. You define the act step. But
- 18:37in an agentic system, you don't draw the map
- 18:39at all. You give the AI a broader objective like
- 18:43resolve any discrepancies in this month's accounts
- 18:45payable. You give it context, you give it access
- 18:48to tools like your inbox, your calendar, and
- 18:50your spreadsheets, and then you let the AI choose
- 18:53the path it takes to accomplish that goal. It
- 18:56fundamentally changes the relationship between
- 18:58the human and the machine. You know, you transition
- 19:00from being a micromanager writing step -by -step
- 19:03rules to being a macro manager assigning outcomes.
- 19:06So what does this all mean? I mean, we've gone
- 19:08from dumb conveyor belts that spray soda everywhere
- 19:12to smart workflows that can read and understand
- 19:14invoices. And now we are staring down the barrel
- 19:17of autonomous agents that determine their own
- 19:20workflows. entirely. It leads us with something
- 19:23critical to mull over as this technology accelerates.
- 19:27Yeah. Well, we established earlier that the golden
- 19:29rule is to keep humans in the loop for consequential
- 19:32decisions, like officially paying an invoice.
- 19:35Right. Don't automate the checkbook. But as we
- 19:37move from rigid step -by -step workflows to autonomous
- 19:41AI agents that are highly capable of semantic
- 19:44reasoning, error correction, and problem solving,
- 19:46What happens when the AI gets so good at its
- 19:49job that the very definition of a consequential
- 19:52decision starts to shrink? Oh, wow. Right. When
- 19:56the system has processed 10 ,000 invoices flawlessly
- 19:59and flagged the exactly three that were fraudulent,
- 20:02at what point do you stop checking its work?
- 20:05Where will you draw your personal line when the
- 20:07AI inevitably asks for the keys to the company
- 20:10checkbook? That is a slightly terrifying but
- 20:12incredibly important thought to leave on. As
- 20:15the AI gets smarter, your role as the architect
- 20:17changes. Where do you draw the line? Well, we
- 20:19hope this deep dive into Google's AI workflows
- 20:22has given you the tools to audit your own workday,
- 20:24to navigate the quirks of visual programming,
- 20:26and to build your own smart conveyor belts. Remember,
- 20:29don't let the factory line spray data everywhere
- 20:31build a system that actually understands what
- 20:33it's looking at. Until next time, keep exploring.