I used to copy emails by hand.
Now one folder does it.
A two-hour copy-and-paste job became a few seconds. One folder watches my inbox, pulls every email from a chosen sender into a clean Google Sheet, and hands me reusable data. Here is exactly how it works, with prompts you can use.
One folder watched. A clean sheet out.
This automation takes a slow, boring job and hands it to a folder. It watches the folder, pulls everything out of each email, and lines it up neatly so you can use it. Here is who it’s for, what goes wrong without it, how it works under the hood, and what you get back.
Who it’s for
Anyone who needs the text from a stack of emails in one place. Writers studying a style, builders filling a knowledge base, anyone who keeps copying emails into a doc. If you do it by hand, this does it for you.
What goes wrong
You open each email, copy the text, paste it into a file, then do it again, and again. An hour later your hand hurts, you’ve missed a few, and you have to repeat the whole thing next month for new emails.
How the machine works
You point it at one folder in your inbox. When an email from your chosen sender lands there, it reads the email and writes the sender, subject, date, and full text into a Google Sheet. No opening, no copying.
What you get back
Every email from that person, in tidy rows, ready to reuse. Feed it to a helper bot, build templates from it, study the writing. The data sits there, clean, the moment you need it.
The situation
One day I wanted every email from a single person. I liked the way they wrote, and I wanted to study it properly, line by line, to learn from it.
So I did the obvious thing. I opened the first email, copied the text, pasted it into a file. Then the second. Then the third. There were a lot of them, scattered across months.
Two hours later I was still going, pulling my hair out, copying and pasting like a machine. And the worst part was knowing that next month there would be new emails from the same person, and I would have to do all of this again.
That was the moment I stopped. There had to be a better way, and there was. I built a small automation that watches one folder. The second an email lands in it, the automation reads the whole thing and drops every detail into a Google Sheet, all on its own.
Now I move an email into that folder, or set the sender to file there automatically, and the work is done before I’ve blinked. What took two hours by hand now takes a few seconds, and it never asks me to do it again. The sheet just keeps filling itself.
Proof point: I run my whole business on small machines like this, and I’ve documented my actual numbers on YouTube, in A Day In My Life and my income streams breakdown. The time these little jobs give back is what frees me to build the next one.
Three steps that turn a messy inbox into reusable data
What made this work wasn’t a clever tool. It was a simple way of thinking about the job: stop touching the emails, and let a folder do the harvesting. Three steps, in order. Skip one and you’re back to copying by hand.
Watch one folder
The first step is to pick one folder and have it watched. You decide what lands there: every email from a chosen sender, or every email matching a rule you set, like a subject word or a label. From then on, the folder is the only thing the automation looks at. You never search your whole inbox again. You just decide what belongs in the folder, once.
Capture every field automatically
The second step is to let the automation read each new email and pull out what matters: who sent it, the subject, the date, and the full text of the message. It writes all of that into a Google Sheet as a clean new row. No opening the email, no copying, no missing one. Every email becomes a neat, labelled record without you lifting a finger.
Feed it into everything else
The third step is the reason the first two are worth it. Once the emails sit in a sheet as plain rows, every other tool can read them. I use mine to study a writer’s style, to fill a knowledge base for a helper bot, and to build templates, examples, and frameworks. The harvest is only the start. The data feeds the rest of your work.
Step one decides what gets collected. Step two collects it without you. Step three turns that pile of text into something you can actually use, over and over, for months.
The old copy-and-paste way
- Open every email, one at a time
- Copy the text, paste it, repeat
- Two hours gone, hand aching
- A few emails missed by accident
- Do it all again next month
The Inbox Harvest
- One folder watched, nothing to open
- Sender, subject, date, text captured for you
- A clean Google Sheet in seconds
- Every email caught, none missed
- New emails added on their own, forever
How I set up the folder to watch
The whole thing starts with one decision: what belongs in the folder. Get that right and the rest runs itself. Here’s the prompt I used to plan it, in plain English.
Plan your watched folder
I want one folder in my inbox to collect every email from a specific person (or every email matching a rule), so I can pull them all into a Google Sheet automatically. Help me with three things, in plain English, no jargon: 1. The simplest way to make sure the right emails land in that folder (a rule on the sender's address, a label, or a subject word). 2. The exact fields worth saving from each email (sender, subject, date, full text, and anything else useful). 3. One sanity check I can do to confirm nothing is being missed. Keep it simple enough that a non-technical person could set it up this week. Output as a short checklist.
The folder is the whole game. Once the right emails land there on their own, you’ve turned the hardest part, the hunting and gathering, into a one-time decision. Set the rule once and the folder does the searching for you, forever.
How I decide what to pull from each email
An email holds more than its text. The sender, the subject, the date, even the time of day can matter later. Here’s the prompt I use to decide exactly what to capture into the sheet.
Map the fields to capture
I'm collecting emails from one folder into a Google Sheet. Each new email should become one tidy row. Help me design the columns: - List the fields worth saving from every email (sender name, sender address, subject, date received, and the full message text). - Suggest one or two extra columns that would help me sort or filter later (for example a short tag, or the word count). - Tell me the cleanest order for the columns so the sheet stays readable as it grows to hundreds of rows. Output as a simple table: column name, what goes in it, why it helps.
Start with the basics, sender, subject, date, and the full text, and add a column only when you know you’ll use it. The goal is a sheet you can scan in one glance, not a wall of data you’ll never read.
The 3-minute overview of how this works
Before the build steps, watch this short overview. It’s the exact video from the Automations Made Easy page, and it walks through the mechanics behind machines like this one. 1,000+ students have used these mechanics to save two hours a day, with zero coding.
Want to build a folder like this in your business?
1,000+ students. Save 2 hours a day. No coding required. In Automations Made Easy you’ll learn the simple skills to build little machines that gather and tidy your data for you, including an inbox harvest just like this one.
What changed when the folder did the work
The first time I needed every email from one person, I did it by hand. About two hours, gone. The second time, the folder did it in seconds, and it has done it ever since.
Let me keep the math modest. Say a job like this comes up just twice a month: pulling one sender’s emails to study, or gathering a thread to build a template. By hand that’s roughly two hours each, so about 4 hours a month of slow copying. The folder gives almost all of that back.
A job that took 2 hours by hand
Now runs in a few seconds, on its own
Roughly 4 hours a month handed back to you
That’s close to 50 hours a year, without doing anything
Fifty hours a year is more than a full working week you get back, for something you set up once. And the time is only half of it. The real win is what those clean sheets unlock: I’ve fed them into the same systems I walk through on YouTube, training helpers and building templates I’d never have had the patience to gather by hand.
Over a few years that compounds. A week back every year, plus a growing store of data you actually use, from a folder that quietly works while you do something else. Nothing I copy by hand any more.
I wrote more about building little machines like this in my Substack, including how I keep them all running with a few hours a month.
How I turn the sheet into something useful
A sheet full of emails is nice, but the point is what you do next. The third step of the framework is feeding that data into your real work. Here’s the prompt I use to decide what to build from it.
Put the harvested emails to work
I now have a Google Sheet with every email from one person: sender, subject, date, and full text, one email per row. Help me decide what to do with it. My goal is [study their writing style / fill a knowledge base for a helper bot / build templates and examples]. For that goal: - Tell me which columns matter most and which I can ignore. - Suggest the simplest first thing to build from this data. - Give me one example of the output I should expect, so I know it worked. Keep it practical and beginner-friendly. Output as three short steps.
This is where the two hours you saved turn into something bigger. The sheet is the raw material. Studying a style, training a bot, or building a template library is the thing that actually moves your business.
How I keep the harvest clean over time
A sheet that fills itself can also fill with junk if you’re not careful. The last prompt sets up a simple way to keep it tidy as it grows, so the data stays useful months from now.
Keep the sheet tidy as it grows
My Google Sheet collects emails from a watched folder automatically. Over time it will reach hundreds of rows. Help me keep it clean and useful: - A simple way to spot and remove duplicates if the same email gets captured twice. - One column or tag that lets me filter to just the emails I care about right now. - A short weekly habit (five minutes) to check the harvest is still catching the right emails and nothing is broken. No fancy formulas. Just plain steps a non-technical person can follow. Output as a short checklist.
With this in place the sheet stays trustworthy. You can come back in six months, filter to exactly what you need, and trust that every email from that person is sitting there, clean and complete.
The exact build, step by step
Pick one folder to watch
First, choose a single folder in your inbox and tell the automation to watch only that one. This is step one of the framework. From now on, the folder is the whole job. You decide what belongs in it, and the automation looks nowhere else.
Send the right emails into it
Next, set a simple rule so the right emails land in the folder on their own. Every message from your chosen sender, or anything matching a subject word or label. You make this decision once. After that, the inbox files the emails for you.
Read each new email automatically
The moment an email lands in the folder, the automation reads it. Step two of the framework in action. It looks at the whole message: who sent it, the subject line, the date, and the full body text. No opening, no scrolling. The reading is done for you.
Drop the details into a Google Sheet
The automation writes what it found into a clean new row: sender, subject, date, and the full text, each in its own column. One email becomes one tidy record. The sheet grows on its own, neatly, every time a new email arrives in the folder.
Let it keep filling, on its own
Now the machine runs without you. Every future email from that sender is captured the moment it arrives. You never search, open, or copy again. The two-hour job is gone for good, and the sheet quietly keeps itself complete.
Feed the data into your real work
Step three of the framework, and the whole point. With every email sitting in clean rows, you put the data to work: study a writing style, train a helper bot, or build a library of templates and examples. The harvest was just the start. This is the payoff.
One folder gets watched
You pick it once, and decide what lands there
Each new email is read automatically
Sender, subject, date, and full text, all captured
The details drop into a clean Google Sheet
One email becomes one tidy row, no typing from you
You feed the data into your real work
Study a style, train a bot, build templates and examples
Want to build this in your own business?
Automations Made Easy teaches you, step by step, how to build little machines like the one you just read about. Zero coding. Plain English. 1,000+ students have already used it to gather, tidy, and reuse their data on autopilot.
The hours this quietly hands back
The first month I built this, I only used it twice. By month six it had become a habit: any time I needed a sender’s emails in one place, I let the folder do it. Here’s the time it saved me, month by month, against doing the same jobs by hand.
Keep the numbers modest. Each job that would have cost me about two hours of copying now costs me seconds. The bars below count the hours the folder handed back, growing as I trusted it with more jobs.
Hours saved vs doing it by hand · 6 months
Six months in, the folder had handed back close to 40 hours of slow copying, and the habit was still growing. Build cost: about an hour of my time, once. Over a full year that lands near 50 hours, a working week back, for a machine that runs while I sleep.
Why this became one of my quiet favourites
It isn’t flashy. It doesn’t close sales or recover payments. It just removes a chore I used to dread, and it does it perfectly every time. That’s exactly why I love it. The best automations are the ones you forget are even running.
And it never gets tired. It reads an email at 3am the same way it reads one at 3pm. It never misses one, never copies the wrong line, never gives up two hours in. It is the most patient assistant I have, and it costs me almost nothing to keep it going.
If you want a free taste of how I think about small machines like this, my Growth Hacking playlist on YouTube walks through the full stack and the systems behind them.
What other students built
I teach the simple skills behind machines like this in Automations Made Easy. Students who built their own version sent back what changed in their first month.
“I’d been copying a supplier’s emails into a doc for a year. Built the folder harvest in an afternoon and now it does it for me. I got my Sundays back.”
“I wanted to study how a writer I admire structures his emails. This pulled two years of them into one sheet in seconds. Game changing for my learning.”
“I fed the sheet straight into a helper bot so it answers in our own voice. The hardest part used to be gathering the examples. Now the folder does it.”
“No coding, no fuss. I set the folder rule once and forgot about it. Months later the sheet is full and I never lifted a finger.”
What’s inside Automations Made Easy
AME isn’t a library of pre-built folders. Every business is slightly different. What’s reusable across all of them is the underlying mechanics: how to watch one source, how to capture and tidy what lands there, and how to feed that clean data into the rest of your work.
The program walks you through six modules: The Right Tools (the cost-effective, no-code stack I actually use), Task Selection Mastery (which automations are worth building first), Design Secrets (mapping an automation before you build it), Zero to Hero (complete beginner to confident automator), Real-World Application (we build a full automation together, end to end), and Monetization Mastery (turn the skill into a side-business).
It also includes done-for-you templates you import in two clicks, over-the-shoulder training videos, and the same playbook 1,000+ students have used to save two hours a day. No coding required. If you can copy and paste, you can build this.
Gather emails from a sender: common questions
Pulled from what readers and Automations Made Easy students ask most.
What does this automation actually do?
It watches one folder in your inbox. The moment an email from a chosen sender lands there, it reads the email and drops the sender, subject, date, and full text into a tidy Google Sheet. You end up with every email from that person in one place, ready to reuse, without opening a single message.
Why not just search my inbox and copy the emails?
You can, and I did, for about two hours once. Opening each email, copying the text, pasting it into a file, then doing it again. The automation does the same job in a few seconds and keeps doing it for every new email, so you never touch it again.
What can I use the collected emails for?
Anything that needs clean text from one source. I use mine to study a writer’s style, to fill a knowledge base for a helper bot, and to build templates and examples. Once the emails sit in a sheet as plain rows, every other tool can read them.
Does it keep working after I set it up?
Yes. It runs on its own. Once the folder is being watched, every future email from that sender is captured the moment it arrives. You set it up once and the sheet keeps filling itself.
Do I need to code to build this?
No. It is built by connecting a few friendly steps with no-code tools. If you can move an email into a folder and open a Google Sheet, you can build this. That is exactly the kind of mechanics Automations Made Easy teaches.
More Money Makers like this one
Built from the same handful of mechanics. Each one quietly captures, tidies, or earns time and money that would have slipped away.
Build the Inbox Harvest yourself, or work with me directly.
If you want to learn the mechanics and build it on your own inbox, Automations Made Easy is the playbook. If you’d rather work with me one-on-one to plan it for your specific business, I take a small number of consulting clients each month.
€497 one-time · Lifetime access · 1,000+ students
