Automating Real Tasks with AI
Stop doing repetitive work manually. Learn to automate real tasks like email, scheduling, and data entry using AI-powered tools.
How much of your day is spent on tasks that are repetitive, predictable, and tedious? Copying data between spreadsheets. Sending follow-up emails. Organizing files. Checking for updates.
Now imagine those tasks just... happened. That's automation. And AI makes it smarter than ever.
What Is Automation?
Automation means setting up a system to do a task without you doing it manually each time. You've already used simple automation without thinking about it:
- Email filters that sort your inbox
- Auto-pay on your bills
- Spell check as you type
AI-powered automation takes this much further. Instead of simple rules ("if email contains 'receipt,' move to Receipts folder"), AI can understand context, make decisions, and handle tasks that used to require human judgment.
The Automation Mindset
Before you automate anything, ask yourself three questions:
- Do I do this task more than twice a week? If yes, it's worth automating.
- Does the task follow a pattern? If you can describe the steps, an AI can probably do them.
- What happens if it goes wrong? If a mistake would be catastrophic, add a human review step. If it's low-risk, let the automation run.
The best automations are the boring ones. Nobody misses manually copying data from emails into spreadsheets.
Tool #1: Zapier (No Code)
Zapier connects apps together and automates workflows between them. It uses a simple concept: triggers and actions.
- Trigger: Something happens (you receive an email, a form is submitted, a calendar event starts)
- Action: Something else happens automatically (data gets added to a spreadsheet, a Slack message is sent, a task is created)
Here's a real workflow you can build for free:
Job Application Tracker
- Trigger: You receive an email with subject containing "application" or "interview"
- Action 1: AI extracts the company name, position, and date from the email
- Action 2: Adds a new row to a Google Sheet with that information
- Action 3: Creates a calendar reminder for follow-up in one week
That entire workflow runs automatically. Every time you apply for a job and get a confirmation email, your tracker updates itself.
Tool #2: Make.com (Visual Automation)
Make.com (formerly Integromat) is similar to Zapier but uses a visual drag-and-drop interface. You can see your entire workflow as a flowchart, which makes complex automations easier to understand.
Make.com has a free tier that gives you 1,000 operations per month -- plenty for personal use.
Tool #3: ChatGPT Custom Instructions + Plugins
You can automate parts of your AI workflow by setting up custom instructions in ChatGPT:
Go to Settings > Personalization > Custom Instructions and add:
When I paste a job description, automatically:
1. List the top 5 required skills
2. Rate my fit (based on my background below)
3. Draft a cover letter opening paragraph
4. Suggest interview questions I should prepare for
My background: [Your skills and experience here]
Now every time you paste a job description, ChatGPT automatically does all four things without you asking.
Real Automation Examples
Here are automations that Community Incubator participants have built:
The Invoice Organizer. A freelance graphic designer receives invoices by email. She built an automation that extracts the invoice amount, client name, and due date, adds them to a Google Sheet, and sends her a weekly summary of outstanding invoices.
The Meeting Prep Bot. Before every meeting, an agent searches for the latest news about the company or person he's meeting with, summarizes it, and creates a one-page brief in Google Docs.
The Social Media Scheduler. A small business owner uses AI to generate social media post ideas based on her business type and target audience. The posts are automatically formatted and scheduled in a content calendar.
The Bilingual Responder. A community organization receives messages in both English and Spanish. An automation detects the language, translates if needed, drafts a response in the original language, and flags it for human review before sending.
Building Your First Automation
Let's walk through building a simple automation step by step. You'll need a free Zapier account.
Scenario: Automatically save important emails to a Google Sheet.
Step 1: Create a free account at zapier.com
Step 2: Click "Create a Zap"
Step 3: Set the trigger:
- App: Gmail (or your email provider)
- Event: "New Email Matching Search"
- Search query:
subject:(important OR urgent OR action required)
Step 4: Add a "Formatter" step:
- Use "Text" to extract key information from the email body
Step 5: Set the action:
- App: Google Sheets
- Event: "Create Spreadsheet Row"
- Map the email subject, sender, date, and extracted text to columns
Step 6: Test it and turn it on.
That's it. You just built a real automation that runs 24/7.
Automation Ethics
Remember from Module 5 -- just because you can automate something doesn't mean you should.
Do automate: Data entry, file organization, reminders, formatting, research compilation.
Think carefully about: Communication with people (always review AI-drafted messages), decision-making that affects others, anything involving sensitive data.
Don't automate: Firing someone, making medical decisions, legal filings, anything where a mistake could seriously hurt someone.
The rule is simple: automate the process, keep the judgment human.
Try This
Create a free Zapier account and build one automation. Some ideas: save Gmail attachments to Google Drive automatically, get a daily AI-generated summary of news in your industry, or create a Slack/email notification when a specific website updates. Share what you built with the class.
Talk About It
What's the most tedious part of your current job or daily routine? Could it be automated? What would you do with the time you save?
Go deeper: Stop Copy-Pasting: A Guide to Zapier, Make, and n8n, a Temerarii Media playbook by Dom Davis.