Step 1 / 5 · about 8 min

Open the Apps Script editor

In your Google Sheet, click Extensions → Apps Script. A code editor opens in a new tab.

💡 1-minApps Script is free code that lives inside your Google account and can read your Sheet, call AI, and run on a schedule — no separate server.

▶ Apps Script for beginners (6 min) ↗

✅ Check: The Apps Script editor is open with an empty function.

Step 2 / 5 · about 8 min

Get an OpenAI API key

Create an API key at platform.openai.com (the video shows where). Copy it somewhere safe.

💡 1-minThe key lets your script ask the AI to write the summary. Treat it like a password — anyone with it can use your account.

▶ How to get an OpenAI API key (4 min) ↗

✅ Check: You have an API key copied.

Step 3 / 5 · about 8 min

Paste the starter script

Replace the editor contents with a script that reads your range and sends it to the AI. Use the video's template and paste your API key + sheet range into it.

💡 1-minYou don't have to write it from scratch — start from a working template and change only two things: your key and your data range. That's the whole 'coding' here.

▶ Apps Script + OpenAI example (7 min) ↗

✅ Check: The script saved without errors (Ctrl/Cmd+S).

Step 4 / 5 · about 8 min

Run it once and authorize

Click Run. Google asks for permission the first time — approve it. Check that a report email arrives.

💡 1-minThe first run asks permission because the script touches your Sheet and email. This is normal and one-time.

✅ Check: A report email/summary was generated by the script.

Step 5 / 5 · about 8 min

Add a weekly trigger

In the editor, click the clock icon (Triggers) → add a trigger: run your function every Monday morning.

💡 1-minA trigger makes the script run on schedule with no one touching it — the report now writes itself every week, right inside your Google account.

✅ Check: A weekly time-based trigger is listed in the Triggers panel.

⏰ Every Monday the script runs itself and emails the report — fully yours, no monthly fees.

Auto-generated weekly report from your spreadsheet

Open the Apps Script editor

Get an OpenAI API key

Paste the starter script

Run it once and authorize

Add a weekly trigger

Want us to set it up for you?