# How to Automate Repetitive Tasks for Free, No Code Needed > Automate repetitive tasks for free with Gmail filters and templates, Outlook rules and Quick Steps, and Sheets macros. Exact steps, and where they stop. _Source: https://professionalstoolkit.com/articles/automate-tasks-without-code — The Professional's Toolkit · updated November 2026_ --- You can automate repetitive tasks for free with tools you already have: Gmail filters and templates, Outlook rules and Quick Steps, and Google Sheets macros. The method is simple. Write down the task, name the trigger that starts it, name the action that follows, and let the built-in rule do it every time. This works well inside one app. It stops working when a task has to move data between apps, and that is the point where an automation platform earns its place. **3** — things every Outlook rule needs: a name, a condition and an action - **1 click** — runs several actions at once with an Outlook Quick Step - **0 code** — to record a Google Sheets macro - **1 app** — is where built-in rules stop; crossing apps needs a platform ## Find the repetitive tasks worth automating first Start with a one-week log, not a tool. Every time you do the same thing twice, write one line: what started it, what you did, which app you were in. By Friday you will have a short list of patterns such as *invoice arrives, I file it*, or *new inquiry, I paste the same answer*. **Pick the task that happens most often and follows the same rule every time.** Tasks that need judgment on each instance are poor first candidates. Each automation has two parts. The trigger is the event that starts it: a message from a certain sender, a subject line, a new row, a set time. The action is what happens next: label, move, forward, reply, format. If you cannot say the trigger in one sentence, the task is not ready yet. Split it into smaller pieces until each one has a clear trigger and a clear action. Check one more thing before you build. Does the whole task live inside one app? Filing email, replying with a standard answer and cleaning a spreadsheet each happen in a single place, and built-in tools handle them well. A task that starts in your inbox and ends in a spreadsheet or a chat app is a different problem. Our guide to [how workflow automation works](/articles/workflow-automation) explains that difference in more depth. ## Automate email for free with Gmail filters and templates Gmail filters can send mail to a label, archive it, delete it, star it, or forward it automatically [1]. To create one: 1. Open Gmail and click **Show search options** in the search box at the top. 2. Enter your search criteria, such as a sender or a subject word. Click **Search** to check which emails match. 3. At the bottom of the search window, click **Create filter**. 4. Choose what the filter should do, then click **Create filter** again. A shortcut works too: check the box next to an existing message, click **More**, then **Filter messages like these**. One limit is worth knowing. A forwarding filter only affects new messages, not the ones already in your inbox. Templates cover the other half of email work: the answers you type again and again. Turn them on first. Go to **Settings**, **See all settings**, **Advanced**, click **Enable** next to Templates, and save. Then write the reply in a compose window, open **More options**, choose **Templates**, and click **Save draft as template**. Google notes that you can only turn on and use templates from Gmail on your computer [2]. The two combine into a free auto-reply. Build a filter for the messages you answer the same way, check **Send template**, pick your saved template, and click **Create filter**. Every matching email now gets that answer without you touching it. > 💡 **Check the search before filtering:** In Gmail, click Search before Create filter and read the matching list. If a message you need shows up, narrow the criteria first. ## Automate repetitive tasks in Outlook with rules and Quick Steps Outlook rules act on email as it arrives. They can move messages to folders, change their importance level, or delete them based on criteria you set. In new Outlook for Windows, the fastest route is to right-click a message, hover over **Rules**, select **Create rule**, pick a folder and click **OK**. For more control, select **More options**. Every rule needs three things: a name, a condition and an action [3]. You can add more conditions, more actions and exceptions. Check **Stop processing more rules** when one rule should be the last word on a message. Rules run on incoming mail by default. To apply one to existing messages, open **Settings**, then **Mail**, then **Rules**, and select the run option next to it. Two caveats matter for small offices. New Outlook does not support rules for third-party accounts like Gmail, Yahoo and iCloud. And some rules built in classic Outlook are client-side rules that new Outlook cannot process. If an old rule stops firing after a switch, rebuild it. Quick Steps handle the jobs you trigger yourself. One click applies several actions at once, such as moving a message to a folder and marking it unread. In new Outlook, open **Mail**, select the drop-down next to **Quick steps** on the Home tab, choose **Manage quick steps**, then **+New quick step**. Name it, choose an action, add more with **Add another action**, and save. You can assign a keyboard shortcut from Ctrl+Shift 5 to 9. > ⚠ **Quick Steps cannot be undone:** Microsoft notes that Ctrl+Z does not reverse a Quick Step, because some actions, such as Permanently Delete, cannot be reversed. Test new ones on unimportant mail. ## Record a Google Sheets macro for spreadsheet chores Spreadsheet chores repeat as much as email does: the same formatting, the same cleanup, the same sort before a weekly report. Google Sheets can record them as a macro [4]. 1. Open the spreadsheet and click **Extensions**, then **Macros**, then **Record macro**. 2. Choose a cell reference type at the bottom. **Absolute** repeats the task on the exact cells you recorded. **Relative** repeats it on whatever cells you select next. 3. Do the task once, by hand. Click **Save**. 4. Name the macro, add a custom shortcut if you like, and click **Save**, then **Update**. To run it later, go to **Extensions**, **Macros**, and pick it from the list. Behind the scenes, Sheets writes the macro as an Apps Script. That script is also how you schedule it. Google says a macro can run based on actions, calendar updates, time intervals, or a chosen date and time, set up from the script editor. Relative references are the usual choice for chores that land in a new row or column each week. Absolute references suit a fixed report layout. ## Workflow automation examples you can copy today Here is how one small consulting business could combine the three tools. The owner gets a steady flow of invoices, client inquiries and a weekly sales export. | Task | Trigger | Free built-in tool | Action | |---|---|---|---| | File invoices | Sender is the accountant | Gmail filter | Apply the Invoices label, archive | | Answer inquiries | Subject contains *quote* | Gmail filter + template | Send the standard reply | | Route client mail | Sender is a client domain | Outlook rule | Move to the client folder | | Triage a thread | You click once | Outlook Quick Step | Move, flag and mark unread | | Weekly cleanup | Monday export | Sheets macro | Format, sort, add totals | None of these needs code or a new subscription. Each one removes a step that used to take a minute or two and a bit of attention. The pattern behind every row is the same: one trigger, one action, one app. > 💡 **Name each rule after its job:** Call it Invoices to label, not Rule 3. When something misfires months later, you will find the culprit in seconds. Build them one at a time. Run each for a week, check that it caught the right messages and only those, then add the next. A filter that is too broad can archive a message you needed to see. Narrow the criteria before you add a second action. ## Where the free way stops working The built-in way breaks at a specific point: **when one task has to cross from one app into another**. A Gmail filter can label a new lead, but it cannot add that lead to a spreadsheet and post a note in your team chat. A Sheets macro can clean a sheet, but it cannot notice a new form entry in a different tool. You end up copying data by hand between the automated parts, which is the job you wanted gone. It also breaks on decisions. A rule can match a sender, but it cannot send large orders down one path and small orders down another based on a number inside the message. And it breaks when the work belongs to a team. Personal rules live in one mailbox; when that person is out, nothing else knows the process exists. This is where automation platforms come in. They connect one app's trigger to another app's action, add conditions and branches, and run in the cloud without a mailbox open. Several have a free plan suitable for a first cross-app step. Zapier's Free plan links one trigger to one action, and our tutorial shows how to [build a first Zap step by step](/articles/zapier-tutorial). Make (Make.com) suits tasks that branch or repeat over a list, and its tutorial walks through a scenario that [loops over every attachment in an email](/articles/make-tutorial). To compare the full field side by side, see our guide to [workflow automation tools](/articles/workflow-automation-tools). ### Zapier — solves this A Zap watches one app for a trigger, such as a new form entry, and runs the action in another app. A Filter step stops runs that do not match, and Formatter cleans dates, names and text on the way. - Where it stops: Free allows two-step Zaps only (one trigger, one action) with 15-minute polling. - Plan: Multi-step Zaps, Paths and webhooks need Professional. - How Zapier does it: [Build your first Zap](https://professionalstoolkit.com/articles/zapier-tutorial) - More: [Zapier](https://professionalstoolkit.com/tools/zapier) ### Make — solves this A scenario chains modules on a visual canvas. Routers send each item down a different path, and iterators loop over lists, such as every attachment in an incoming email saved to Google Drive. - Where it stops: Free allows 2 active scenarios and runs at a minimum 15-minute interval. - Plan: Core unlocks unlimited active scenarios and scheduling down to 1 minute. - How Make does it: [Build your first scenario](https://professionalstoolkit.com/articles/make-tutorial) - More: [Make](https://professionalstoolkit.com/tools/make) ### Pabbly Connect — solves this A workflow starts from one trigger and chains actions in order, such as lead to CRM to email to Slack alert. Filters, routers and formatters run as free steps, so cleanup logic does not use the task allowance. - Where it stops: Free is limited to 2-step workflows (a trigger plus one action) and a monthly task cap. - Plan: Multi-step workflows need Standard. - How Pabbly Connect does it: [Build your first workflow](https://professionalstoolkit.com/articles/pabbly-connect-tutorial) - More: [Pabbly Connect](https://professionalstoolkit.com/tools/pabbly-connect) ## FAQ **Can I automate tasks for free across different apps?** Yes, for simple links. Zapier Free and Pabbly Connect Free both allow two-step automations, one trigger plus one action, which covers a single handoff such as form entry to spreadsheet row. **Do Gmail templates work on the phone app?** No. Google says you can only turn on and use message templates from Gmail on your computer. Filters that send a template still reply automatically once they are set up. **Will a new rule sort the email already in my inbox?** In new Outlook, rules run on incoming mail by default, but you can run a rule on existing messages from Settings, Mail, Rules. In Gmail, a forwarding filter only affects new messages. **What is the easiest repetitive task to automate first?** Filing email from one known sender. The trigger is unambiguous, the action is a single label or folder, and a mistake is easy to spot and undo. ## The bottom line The simplest way to automate repetitive tasks is to use what you already have. Gmail filters and templates, Outlook rules and Quick Steps, and Google Sheets macros cover most single-app chores at no extra cost, and they take minutes to set up from the maker's own instructions. Log your week, start with the most frequent rule-bound task, and add one automation at a time. When a task has to carry data from one app into another, or branch on what the data says, the built-in tools have reached their limit. That is the moment to try an automation platform's free plan on one real workflow. ## Sources [1] Gmail Help — https://support.google.com/mail/answer/6579 (Nov 2026) [2] Gmail Help — https://support.google.com/mail/answer/14864208?hl=en (Nov 2026) [3] Microsoft Support — https://support.microsoft.com/en-us/office/use-rules-to-manage-your-email-messages-in-outlook-c24f5dea-9465-4df4-ad17-a50704d66c59 (Nov 2026) [4] Google Docs Editors Help — https://support.google.com/docs/answer/7665004 (Nov 2026)