Your cart is empty.
Keep shopping
Build Subscription Reminder System with Apps Script & Gmail
New
42 students
Build Subscription Reminder System with Apps Script & Gmail
Create a real world fully automated cloud-based email alert subscription reminder system that runs 24/7
Created byBluelime Learning Solutions
Last updated 4/2026
English
What you'll learn
- Build a fully automated subscription reminder system using Google Sheets, Apps Script, and Gmail that runs 24 hours a day without any manual intervention
- Design and structure a Google Sheet as a six-column subscription database storing names, amounts, due dates, categories, notes, and active status
- Write and understand JavaScript code inside Google Apps Script without any prior programming experience whatsoever
- Explain what variables are and use them confidently to store configuration settings, calculated values, and text throughout a working script
- Create and call JavaScript functions to organise code into clean, reusable blocks each with a single clear responsibility
- Apply for loops to automatically iterate through every row of spreadsheet data and process multiple subscriptions in a single script execution
- Use if statements to make decisions in code — checking whether a subscription is active, whether a due date has passed, and whether a payment falls within a rem
- Work with JavaScript Date objects to capture today's date, calculate dates seven days and one day ahead, and compare dates reliably using the getTime method
- Calculate and format currency values using parseFloat, toFixed, and multiplication to display accurate monthly and yearly costs in every reminder email
- Format dates as readable sentences using toLocaleDateString so emails display due dates clearly as "Wednesday 15 April 2026" rather than raw numbers
- Send automated personalised emails programmatically using Google's built-in MailApp service with custom subject lines and structured multi-section email bodies
- Access and read Google Sheets data from within a script using the SpreadsheetApp object to connect to a spreadsheet, navigate to a specific tab, and load all ro
- Set up a time-driven cloud trigger using ScriptApp that automatically runs the subscription checker every morning at a scheduled time without requiring any manu
- Deploy a fully cloud-based automation that operates independently of your computer, handles month boundaries automatically, and delivers reliable reminders ever
- Troubleshoot common Apps Script errors including sheet name mismatches, date formatting issues, number formatting problems, and permissions errors with confiden
- Maintain and extend the system by adding new subscriptions, pausing reminders with the Active flag, changing delivery times, and applying ideas for future enhan
Explore related topics
Course content
2 sections • 23 lectures • 1h 7m total length
Requirements
- A free Google account — if you can send an email with Gmail or open a Google Doc, you already have everything you need to get started. No paid subscriptions or upgrades are required at any point in this course
- A web browser — Google Chrome, Microsoft Edge, or Mozilla Firefox all work perfectly. No software installation of any kind is required. Everything in this course runs directly inside your browser
- No programming experience needed — every single line of code is explained from scratch in plain conversational English. You do not need to know JavaScript, Python, or any other programming language before taking this course. If you have never written a line of code in your life, this course was designed specifically for you
- No knowledge of Google Apps Script required — Apps Script is introduced from the very beginning. We explain what it is, where to find it, and exactly how it works before writing a single character of code
- No prior Google Sheets experience needed — if you have ever typed into a cell in any spreadsheet application, you already know enough. We walk through every step of setting up the sheet together inside the course
- No technical or IT background required — this course is built specifically for everyday people who want to automate real tasks without having a developer background or computer science qualification
- No paid tools, plugins, or subscriptions — Google Sheets, Google Apps Script, and Gmail are all completely free. This project costs nothing to build and nothing to run. There are no hidden costs at any stage
Description
Are you paying for subscriptions you have completely forgotten about?
You are not alone. The average person pays for eight to twelve subscription services every month — streaming platforms, software tools, music apps, cloud storage — all quietly taking money from their account on different dates, often for amounts they stopped thinking about long ago. Individually each payment feels harmless. But added together across twelve months, the total is often surprisingly large.
This course gives you the solution.
What you will build:
In this hands-on micro course you will create a fully automated subscription reminder system using three completely free Google tools — Google Sheets, Google Apps Script, and Gmail. The system stores your subscriptions in a simple spreadsheet, checks for upcoming payments every morning at 8am, and sends you a personalised email seven days before and again the day before each payment is due. The email shows you exactly when the money goes out, how much it costs monthly, how much it is costing you every year, and prompts you with honest questions to help you decide whether you still need it.
Because the entire system runs on Google's cloud servers, it works 24 hours a day whether your computer is on or off. Set it up once and it runs itself every single month, every single year — completely automatically.
No coding experience required:
Every line of code is explained in plain English from scratch. If you have never written a single line of JavaScript before, this course was designed specifically for you. All you need is a free Google account and a web browser.
What makes this course different:
This is a pure project course. There are no abstract theory lectures or lengthy introductions. Every module builds directly towards the finished working system. You will understand what every line of code does and why — and by the final module your reminder system will be live, tested, and sending real emails to your inbox.
Enrol today and take back control of your subscriptions
Who this course is for:
- complete beginner who has never written code.
- Beginners to Apps Script
- Beginners to creating a fully automated systems