Give yourself one less thing to do next week. Pick a recurring task and see how you can make it run automatically.
The Free Automation Scripts tool turns a chore you describe into a ready-to-paste Google Apps Script. Write the part of your workday you would hand off, or pick one of 20 starter ideas, like emails you never answered, a report you rebuild every week or form responses that sit unread. The tool picks out up to three problems in what you wrote and offers a fix for each. Answer three quick questions, with defaults filled in, and it writes the full script from ready-made templates, not AI. Copy it, paste it at script.google.com, run setup, allow the permissions Google asks for and send yourself a test. If nothing fits, it builds a starter script with a marked spot for your own steps.
Office workers, managers, freelancers and small business owners who lose time each week to the same Gmail, Sheets or Calendar chores: chasing replies, copying numbers, saving receipts, sending reminders. You don’t need to know how to code. You need a Google account and about five minutes to paste the script in and run it.
In Challenge the Process, Kouzes and Posner say change starts with taking the initiative and asking, “Why do we do this?” and that big changes go best as small wins. Each script is one small win: a chore that no longer needs you. Read our summary of The Leadership Challenge by Jim Kouzes.
Yes. The Free Automation Scripts tool on 45 Book Summaries costs nothing and needs no account. Describe a chore in plain words or pick one of 20 starters, answer three questions, and it writes a complete Apps Script from ready-made templates, not AI, so the same answers always give the same code. Fixes include follow-up drafts in Gmail, a weekly report from a sheet, a change log, form alerts and receipts saved to Drive. You paste the code at script.google.com and approve Google’s permissions, so you need a Google account, but no coding.
Yes. Google says all you need is a Gmail account to start building with Apps Script, and there is nothing to install. Apps Script is a cloud-based JavaScript platform: your scripts are saved to Drive and run on Google’s servers. Google does set daily quotas, and work accounts get more. A script can email 100 recipients a day from a personal account or 1,500 from Google Workspace, and triggers can run 90 minutes a day in total, or 6 hours on Workspace. The mail-merge fix in the Free Automation Scripts tool notes the email limit in its code.
Turn on Google Forms’ own alerts: open the form, click Responses, then More, then Get email notifications for new responses. For more options, Google points to its Form notifications add-on. To get each person’s answers by email, link the form to a Sheet with Link to Sheets and add a short script. The form fix in the Free Automation Scripts tool writes one that emails every new response, question by question, and can thank each person by email if your form collects email addresses.
Use a script that drafts the follow-up for you when a sent email gets no reply. Gmail’s nudges, turned on under Settings, General, can bring up sent emails you may need to follow up on. The follow-up fix in the Free Automation Scripts tool goes further. Each morning before 8am, it checks your sent mail from the last 30 days, and when someone hasn’t replied in three business days (or two, or five, as you choose), it leaves a draft in Gmail that names your original email. Nothing goes out until you press Send.
For a quick look, right-click a cell and choose Show edit history, or open the file’s version history. Google notes that some changes don’t show in a cell’s history, such as added rows, format changes and changes made by formulas. For a lasting record, use a script. The change log fix in the Free Automation Scripts tool adds a Change Log tab with the time, the person, the tab, the cell, and the old and new values, and can email you on each change. If Google doesn’t pass along the editor’s name, the log records “someone outside your organization.”
Use a short script, since Gmail’s Add to Drive button saves one attachment each time you click it. The attachment fix in the Free Automation Scripts tool checks your email every hour for messages with words you choose, like invoice or receipt, and saves each attachment to a Drive folder with its date at the front of the file name. The fix can sort files into a folder for each month, labels each saved thread Saved to Drive, skips small signature images, and on its first run also saves the past week.
Facts last checked October 2026.