Weekend Side Projects That Teach You Automation

The most effective way to learn automation is to build things that solve real problems, even small ones. Weekend projects work because they are short enough to finish, practical enough to be useful, and concrete enough to teach specific skills. Here are projects you can complete in a day or a weekend, each one targeting a different automation concept.

Why weekend projects beat long courses for building skills

Courses teach concepts. Projects teach execution. Both matter, but most beginners spend too much time watching tutorials and too little time building. A weekend project forces you to encounter the specific problems that arise when you actually connect tools, handle errors, and make something work end to end.

The projects below are designed to be completable in four to eight hours each. They use free tiers of no-code tools. They solve problems that you or someone you know actually has. And each one teaches a specific automation skill that employers and clients value.

Project 1: Personal email sorter

What you build

An automation that reads incoming emails and sorts them into categories. For example: emails from specific senders get labeled and archived, emails containing certain keywords (like "invoice" or "meeting") get forwarded to a specific folder or forwarded to another account, and newsletters get a "read later" label.

Tools needed

Gmail, Make or Zapier (free tier).

Skills you learn

Email triggers, conditional logic (if/then routing), filtering based on content, and working with text patterns.

How to do it

Set up a Make scenario that triggers on new Gmail messages. Add a router module with different branches based on sender address and subject line keywords. Each branch applies a different action: label, forward, archive, or flag. Test with real incoming emails over the weekend.

Time estimate

Three to four hours, including setup and testing.

Project 2: Expense tracker from M-Pesa messages

What you build

An automation that reads M-Pesa confirmation SMS messages (forwarded to email or entered into a Google Form) and logs the transaction details into a Google Sheet. The sheet includes date, amount, recipient, and category.

Tools needed

Google Forms (as the entry point), Google Sheets, Make or Zapier.

Skills you learn

Data parsing (extracting structured information from unstructured text), spreadsheet data management, and form-to-sheet automation.

How to do it

Create a Google Form with fields for the M-Pesa message text. Set up an automation that triggers on new form submissions, parses the message text to extract the amount and recipient, categorizes the transaction (you can use simple keyword matching: "Safaricom" = airtime, "KPLC" = electricity), and writes a clean row to the expense tracking sheet. Optionally, add a weekly summary email showing total spending by category.

Time estimate

Four to six hours. The parsing logic takes the most time.

Project 3: Daily news briefing email

What you build

An automated system that collects headlines from news sources you care about and sends you a single morning email with a summary. Instead of checking five different news sites, you get one email at 7 AM with the highlights.

Tools needed

RSS feeds from news sources (most Kenyan news sites have them), Make or Zapier, Gmail, and optionally the ChatGPT API for summarization.

Skills you learn

Scheduled automations (time-based triggers), RSS feed processing, data aggregation (combining multiple sources into one output), and optional AI integration.

How to do it

Identify RSS feeds for three to five news sources (Business Daily Africa, The Standard, TechCrunch Africa, or whatever you follow). Set up a Make scenario that runs daily at 6:30 AM, pulls the latest five headlines from each feed, formats them into a readable email body, and sends it to your inbox. If you want to add AI, include a step where ChatGPT writes a one-paragraph summary of the combined headlines.

Time estimate

Three to five hours.

Project 4: Birthday and event reminder system

What you build

A system that reads important dates from a Google Sheet (birthdays, anniversaries, subscription renewals, licence expirations) and sends you a reminder email one week before and one day before each event. Optionally, it sends a pre-written WhatsApp message or birthday email to the person.

Tools needed

Google Sheets, Make or Zapier, Gmail.

Skills you learn

Date-based logic (comparing today's date with stored dates), scheduled checks, and multi-step notification sequences.

How to do it

Create a Google Sheet with columns: name, date, event type, and notes. Build an automation that runs daily, checks if any dates are within seven days or one day of today, and sends you appropriate reminders. The date comparison logic is the core skill here. You will learn to work with date functions and conditional checks.

Time estimate

Three to four hours.

Project 5: Job listing aggregator

What you build

An automation that monitors job boards for listings matching your criteria and sends you a daily summary email with relevant postings. Instead of manually checking BrighterMonday, LinkedIn, and Fuzu every day, you get the results delivered.

Tools needed

Make or Zapier, email or RSS feeds from job boards, Gmail, Google Sheets.

Skills you learn

Web monitoring, data filtering, deduplication (making sure the same listing does not show up twice), and aggregation.

How to do it

Set up automated checks against job board RSS feeds or use Make's HTTP modules to check specific search result pages. Filter for keywords relevant to your target role. Store seen listings in a Google Sheet to avoid duplicates. Compile new listings into a daily email. This project teaches you how to think about data flow: input, filtering, storage, and output.

Time estimate

Five to seven hours. This one is more complex due to the deduplication logic.

Project 6: Meeting notes distributor

What you build

After a meeting, you paste your notes into a Google Form. An automation formats the notes, adds the date and attendee list, saves them to a shared Google Drive folder, and emails a copy to all attendees.

Tools needed

Google Forms, Google Docs, Google Drive, Make or Zapier, Gmail.

Skills you learn

Document creation automation, file management, and multi-recipient email distribution.

How to do it

Create a form with fields: meeting title, date, attendees (comma-separated emails), and notes. The automation creates a Google Doc from a template, fills in the fields, saves it to a designated Drive folder, and sends an email to each attendee with a link to the document. The multi-recipient handling (splitting a comma-separated list into individual emails) is a useful skill that applies to many business automations.

Time estimate

Four to five hours.

Project 7: Social media content recycler

What you build

A system that takes your old, well-performing social media posts (stored in a Google Sheet) and schedules them for reposting at appropriate intervals. This solves the "I ran out of content ideas" problem by resurfacing your best past content.

Tools needed

Google Sheets, Make or Zapier, Buffer or a social media scheduling tool (free tier).

Skills you learn

Scheduled posting, database cycling (picking the next item in a list and looping back to the beginning), and social media API integration.

How to do it

Create a Google Sheet with columns: post text, image URL (optional), platform, last posted date, and performance notes. Build an automation that runs daily, picks the post with the oldest "last posted" date, sends it to Buffer for scheduling, and updates the "last posted" date. Over time, your best content cycles through automatically.

Time estimate

Three to four hours.

How to get the most from these projects

Actually finish them

A half-built automation teaches you half the skills. Push through the frustrating parts (there will be error messages and unexpected behaviours). The debugging process itself is where the deepest learning happens.

Document what you build

After each project, write a brief summary: what it does, what tools you used, what you learned, and what you would improve. This documentation becomes portfolio material. It also helps you retain what you learned.

Extend the ones that interest you

If the expense tracker resonates with you, add features: monthly budget comparisons, spending trend charts, or alerts when you exceed a category limit. Extensions teach you to think beyond the basic requirements, which is exactly what employers and clients value.

Share your projects

Post about them on LinkedIn or in tech communities. Describe the problem you solved and what you learned. Other people's questions and feedback teach you things you would not discover on your own. For structured learning that builds on these project-based skills, our course AI and Automation for Beginners offers guided projects with step-by-step instruction.

FAQ

What if I get stuck on a project and cannot figure out the next step?

This is normal and expected. Use the automation platform's documentation first (Make and Zapier both have detailed help articles). Search YouTube for the specific step you are stuck on. Check the platform's community forums. Getting stuck and finding your way through is the most valuable part of the learning process.

Can I list these weekend projects on my CV or portfolio?

Yes. Frame them as practical projects that demonstrate specific skills. "Built a personal expense tracking automation that parses M-Pesa transaction messages and categorizes spending in a Google Sheet" is a legitimate portfolio item. Employers care about what you can do, not whether you built it for a client or for yourself.

Do I need any paid tools for these projects?

No. Every project above can be completed using free tiers of the tools mentioned. Make's free plan allows a limited number of operations per month, which is enough for learning projects. Zapier's free plan also works for basic automations. Google Workspace tools are free for personal use.