Step 6 of 8 in Tech Lab
Next in your path: 7.3.2 Data Analysis in Practice: statistics and visualisation on real data
Think of a sheet that does chores for you, like a dishwasher. You put dirty dishes in, press a button, and clean dishes come out. Automation is just deciding what goes in, what the rules are, and what should come out.
| Level | Tool | Good for |
|---|---|---|
| 1 | Formulas (ARRAYFORMULA, QUERY, FILTER) | Calculations and summaries that update by themselves |
| 2 | Google Forms feeding a sheet | Collecting data without retyping |
| 3 | Apps Script (code) | Sending emails, tidying data, running on a schedule |
Videos by other creators on YouTube, for reference. They are not made by or affiliated with The Future Market.
[Host] "Before you automate anything, answer three questions."
[Text on screen: Input. Rule. Output.] "Where does the data come from? What should happen? What should come out?"
[Screen: Extensions > Apps Script] "Formulas handle calculations. For emails and schedules, open Extensions, then Apps Script."
[Host] "And always work on a copy first, so one mistake does not hit your real data."
Pick one boring task you repeat weekly (for example "add up unpaid orders and email a reminder"). Write its Input, Rule and Output in one sentence each. Then make a TEST copy of your sheet.
Copy this, open Claude, paste it, and Claude will walk you through the lesson step by step.
For a grown-up: Claude is for adults (18+). Copy this, paste it into Claude, and use the answer to explain the lesson to your child.
I'm learning "Sheets Automation: array formulas, forms and Apps Script basics" on The Future Market. Lesson 1: "From manual to automatic". What the lesson teaches: - Before this course: Google Sheets for Business (course 7.2). There you learned sharing, Google Forms, drop-downs, COUNTIF, SUMIF, XLOOKUP, UNIQUE, FILTER, a first look at ARRAYFORMULA, QUERY, IMPORTRANGE and dashboards. This course does not repeat those basics; it connects them and adds Apps Script. - You have three levels of automation in Sheets: - Level - Tool - Good for - 1 - Formulas (ARRAYFORMULA, QUERY, FILTER) - Calculations and summaries that update by themselves - 2 - Google Forms feeding a sheet - Collecting data without retyping - 3 - Apps Script (code) - Sending emails, tidying data, running on a schedule - Apps Script is opened from the spreadsheet with Extensions > Apps Script (names can differ by version). The exercise I'm working on: Pick one boring task you repeat weekly (for example "add up unpaid orders and email a reminder"). Write its Input, Rule and Output in one sentence each. Then make a TEST copy of your sheet. I'm stuck. Please: 1. Explain the main idea in plain, simple words with one everyday example. 2. Walk me through the exercise one small step at a time. Ask me what I've done so far before giving the next step. 3. Don't just give me the final answer. Help me do it myself, and check my work when I share it.
I'm a parent helping my child (about 8 years old) with a lesson called "From manual to automatic" from the course "Sheets Automation: array formulas, forms and Apps Script basics". Here's what the lesson says: Think of a sheet that does chores for you, like a dishwasher. You put dirty dishes in, press a button, and clean dishes come out. Automation is just deciding what goes in, what the rules are, and what should come out. The activity: Pick one boring task you repeat weekly (for example "add up unpaid orders and email a reminder"). Write its Input, Rule and Output in one sentence each. Then make a TEST copy of your sheet. Please explain this so an 8-year-old understands: short sentences, a fun everyday example, and no hard words. Then give me 3 simple questions I can ask my child to check they understood, and a way to do the activity together, one tiny step at a time.
This lesson is part of full access: every course and every level for one payment.
This lesson is part of full access: every course and every level for one payment.
This lesson is part of full access: every course and every level for one payment.
This lesson is part of full access: every course and every level for one payment.
This lesson is part of full access: every course and every level for one payment.
This lesson is part of full access: every course and every level for one payment.
This lesson is part of full access: every course and every level for one payment.
What are the three boxes to write before you automate?
Input, Rule, Output.
How do you open the Apps Script editor from a sheet?
Extensions, then Apps Script.
What does ARRAYFORMULA do?
Shows values from an array formula across many rows or columns, so one formula can fill a whole column.
Which key combination adds ARRAYFORMULA to the start of a formula?
Ctrl+Shift+Enter.
What can't be done with array formulas, according to Google's help page?
They can't be exported.
In QUERY, which comes first: group by or limit?
Group by (limit comes later in the fixed order).
How do you write a date in a QUERY where clause?
With the date keyword, like date '2026-11-03' (yyyy-MM-dd).
What does the pivot clause do?
It turns the values of one column into new columns.
What does getDataRange().getValues() return?
All data in the sheet as a 2D array (rows, then columns).
Can a custom function send email with MailApp?
No; custom functions cannot request authorization. Use a trigger or a normal function.
What account does an installable trigger run under?
The account of the person who created it.
How many email recipients per day can a gmail.com account use in Apps Script?
100 (Google Workspace accounts: 1,500).
This lesson is part of full access: every course and every level for one payment.
This lesson is part of full access: every course and every level for one payment.
Your notes stay on this device only. No account needed.