Classmethod says Claude Code made its developers up to 10 times faster

How to do it yourself

Our suggested steps. The company didn't publish theirs.

1. 1

   Write down a spreadsheet chore you do by hand every week.

2. 2

   Ask Claude with the prompt below to write an Apps Script for it.

3. 3

   Paste the script into Extensions > Apps Script and run on a copy of the sheet.

4. 4

   Fix any errors by pasting them back to Claude.

5. 5

   Add a time-based trigger so it runs automatically.

The instructions to give the AI

Paste this into Claude (the free plan is fine), swap the [brackets] for your details, and test it on a few real examples.

This is one part of the setup. It won't connect to your phone, inbox or other apps on its own; the steps above cover that.

Write a Google Apps Script for this sheet: [describe columns]. It should [task, e.g. email each overdue customer, move paid rows to 'Archive', build a weekly summary tab]. Include comments, a dry-run mode, and instructions to add a weekly trigger.

What you should get back: A ready-to-paste Apps Script that, for example, emails every overdue customer and archives paid rows.

Written by Quickly and Good, inspired by this case.