Beginning
Imagine this: Every time you receive a new email in your inbox, its sender, subject, and date automatically appear in a Google Sheet — no copying, no typing, no checking your inbox every an hour. By the end of this lesson, that won't be an example anymore. It will be something you actually built.
So far, you've learned the theory (Lesson 1), compared tools (Lesson 2), and explored the Make.com interface (Lesson 3). Now it's time to put all of that together and build your very first real, working automation — completely from scratch.
This is the lesson where no-code automation stops being an idea and starts being a skill you own.
In this lesson, you'll learn:
- How to create a brand-new Scenario from a blank canvas
- How to set up Gmail as your Trigger
- How to set up Google Sheets as your Action
- How to map data from one app into the other
- How to test and activate your automation so it runs on its own
Core Concept: One Quick Recall
Before we build, let's recall the three words from Lesson 3 — because you'll use all of them in the next ten minutes:
Scenario = the entire automation where you will Build the automation
Module = each individual step (we'll have exactly two: one Trigger, one Action)
Connection = how Make logs into your Gmail and your Google Sheets account
The automation we're building today is simple on purpose: "When a new email arrives in Gmail, add its details as a new row in a Google Sheet." This is one of the most common automations in the real world — freelancers use it to track client inquiries, business owners use it to log orders, and support teams use it to catalog incoming requests.
Tool Walkthrough: Building Your First Scenario
Step 1 — Create a Blank Scenario
From your Make.com dashboard, click "Create a scenario." You'll land on the same empty canvas you saw in Lesson 3 — just a single plus icon waiting for your first Module.
Step 2 — Add Gmail as Your Trigger
Click the plus icon, search for "Gmail," and select it. Make will show you a list of possible actions — choose "Watch Emails." This becomes your Trigger: the "when this happens" part of your automation.
Step 3 — Connect Your Gmail Account
The first time you use Gmail in Make, you'll be asked to create a Connection. Click "Sign in with Google," choose your account, and allow Make the permissions to request it. This Connection will now be saved and reusable for any future Scenario that needs Gmail connection.
Step 4 — Configure the Trigger
Once connected, you'll see a settings page for this Watch Emails module — things like which folder to watch (choose Inbox) and how many emails to fetch at one time (leave this at the default for now). These settings tell Make exactly what counts as "a new email."
Step 5 — Add Google Sheets as Your Action
Click the plus icon on the right side of your Gmail module to add the next step. Search for "Google Sheets" and select it. From the list of actions, choose "Add a Row." This becomes your Action: the "then do this" part of your automation.
Step 6 — Connect Your Google Sheets Account and Choose a Spreadsheet
Just like with Gmail, you'll create a Connection for Google Sheets by signing in with Google. Once connected, select the specific spreadsheet and sheet tab you want new rows added to. Before this step, it helps to open Google Sheets and create a simple sheet with column headers like Sender, Subject, and Date Received.
Step 7 — Map Gmail Data into Sheets Columns
This is the most important step. Make will show your Sheets columns (Sender, Subject, Date Received) each with an empty field next to it. Click each field and select the matching piece of data from Gmail — the Sender's email, the Subject line, and the Date. This mapping is what actually moves information from one app into the other app.
Step 8 — Test and Activate
Click "Run once" to test your Scenario. If you have a recent email in your inbox, you should see it appear as a new row in your Google Sheet within seconds. Once you've confirmed it works, toggle the Scenario to Active (usually a switch near the bottom of the screen) — this is what makes it run automatically from now on, even when you're not watching.
Congratulations — you just built, tested, and activated your first real automation.
Real Example: Where This Fits in Real Life
This exact Gmail-to-Sheets setup is one of the most requested automations by small business owners and freelancers. A few common variations of what you just built:
- A freelance designer logs every new client inquiry email into a spreadsheet to track leads
- An online store owner catalogs every "New Order" email into a Sheet for easy monthly reporting
- A support assistant keeps a running log of every customer complaint email for the team to review
The structure never changes — Trigger (new email) → Action (add row) — only the use case does. This is exactly the kind of automation freelancers list on platforms like Fiverr and Upwork.
Common Mistakes
Mistake 1: Watching the wrong folder
If your Gmail trigger is set to "All Mail" instead of "Inbox," you may end up capturing promotional emails, spam, or sent messages you didn't intend to log.
Mistake 2: Not creating column headers first
If your Google Sheet doesn't already have headers like Sender, Subject, and Date, Make has nothing clear to map data into — must be need to set up your sheet structure before connecting it.
Mistake 3: Forgetting to activate the Scenario
Testing with "Run once" only runs the automation a single time. If you forget to flip the Active toggle, your Scenario will sit there doing nothing the next time a real email arrives.
Try This Yourself
Before moving to Lesson 5, try this small extension:
- Change your Gmail trigger to watch a specific label (like "Starred" or a custom label you create) instead of the full Inbox
- Add one more column to your Google Sheet (like "Has Attachment") and map it to the matching Gmail field
Key Takeaways
- A real automation is just a Trigger Module followed by an Action Module, connected through field mapping
- Gmail's "Watch Emails" is a Trigger; Google Sheets' "Add a Row" is an Action
- Field mapping is what actually transfers data from one app into another
- Always set up your destination (like Sheet column headers) before mapping data into it
- A Scenario does nothing automatically until you switch it to Active
Frequently Asked Questions
Will this watch emails I've already received?
No. By default, Make only watches for new emails that arrive after the Scenario is activated — it won't go back and process your old inbox.
Can I use a different spreadsheet app instead of Google Sheets?
Yes — Make supports Excel Online, Airtable, and others. The same Trigger → Action logic applies; only the Action module and its field names would change.
What happens if I get a lot of emails at once?
Make processes them based on your plan's scheduling interval (as low as every 15 minutes on the free plan, or faster on paid tiers) — so even high email volume will eventually be captured without being lost.
Next Lesson Preview
In Lesson 5, we'll add intelligence to this automation using Filters — so instead of logging every single email, your Scenario will only act when specific conditions are met, like emails from one particular sender or containing a certain keyword.
Navigation:
→ Next: Lesson 5 — Filters & Conditional Logic (If This, Then That)
🏠 Back to Course Hub