Set Up 1hSaved

Pick how you want to get started.

Already set up? Update your rules →

1

Create a New Google Sheet

Go to sheets.new to create a blank Google Sheet.

2

Open Apps Script

In your sheet, click Extensions → Apps Script. Delete any code already there.

3

Get the Script from Any AI

Copy the prompt below and give it to any AI (ChatGPT, Claude, Gemini). It'll generate the Apps Script code for you.

Create a Google Apps Script for Gmail that: - Runs every minute via a time-based trigger - Searches Gmail using a configurable query (default: newer_than:1d category:primary) - Sends each email's subject, sender, and snippet to Google's Gemini API (gemini-3.1-flash-lite-preview) for scoring 1-10 - Only notifies me (via email, Slack webhook, or Telegram bot) when score >= threshold - Logs every scanned email in a "Logs" sheet with timestamp, subject, sender, score, decision, reason - Stores useful emails in a "Results" sheet with a link back to the Gmail thread - Has a "Settings" sheet where I can configure: Gemini API key, model, Gmail search query, AI prompt, strictness, notification threshold, notify email, Slack webhook URL, Telegram bot token, Telegram chat ID, emails per scan, mark as read, archive after scan - Includes prompt templates for Amazon sellers, business, job search, freelancers, personal - Deduplicates using PropertiesService so emails aren't scanned twice - Has a custom menu with Install, Run Test Scan, View Results, Reset Settings, Stop Scanner - Color-codes log rows by score (green for high, yellow for medium) Give me the complete code to paste into Apps Script.

Paste the generated code into the Apps Script editor and save (Ctrl+S / Cmd+S).

4

Get Your Free Gemini API Key

  1. Go to aistudio.google.com/apikey
  2. Click "Create API Key"
  3. Copy your API key
💡 Free tier = 15 requests/minute. More than enough.
5

Install & Add Your Key

Go back to your Google Sheet. Click ⏱️ 1hSaved → 🚀 Install My Scanner

Then go to the Settings tab and paste your API key in the "Gemini API Key" row.

ℹ️ Google will show warning screens. This is normal. The script only runs inside your own Google account. We never see your emails.

Here is exactly what to click:

  1. Click Advanced (bottom left of the warning)
  2. Click "Go to [project name] (unsafe)" — the name matches your Apps Script project
  3. Click Allow
  4. On the next screen, click Continue
  5. Check Select all, then click Continue
✅ Done. Your scanner runs every minute. Check the Logs tab to see it working.
1
Your Rules
2
Alerts
3
Your Script
4
Install

Step 1: Which emails should AI read for you?

Add the senders you want AI to monitor. It reads them so you don\'t have to.

Step 2: Where should we send your important alerts?

Pick one or more. Click to expand and set up.

Auto-archive emails after scanning?
AI extracts the nuggets and sends them to you. Emails get archived so your inbox stays clean.

Step 3: Last step before your personalized script

We'll create a custom script with everything pre-filled.

You're almost done! Follow these 4 steps:

1

Open a new Google Sheet

2

Open the script editor

In the top menu of your sheet, click Extensions → Apps Script

A new browser tab opens with a code editor.

Delete the few lines already there.

3

Paste your personalized script

1hSaved.gs
// Loading...

Paste it into the Apps Script editor, then click the 💾 Save icon (or Ctrl+S / Cmd+S).

⚠️ Just save. Do NOT click the blue "Deploy" button.
4

Click Install and add your key

1. Go back to your Google Sheet tab and refresh the page ↻ Refresh

2. In the top menu, click ⏱️ 1hSaved → 🚀 Install My Scanner

ℹ️ Google will show warning screens. This is normal. The script only runs inside your own Google account. We never see your emails.

Here is exactly what to click:

  1. Click Advanced (bottom left of the warning)
  2. Click "Go to [project name] (unsafe)" — the name matches your Apps Script project
  3. Click Allow
  4. On the next screen, click Continue
  5. Check Select all, then click Continue
✅ That's it. Your inbox is now on autopilot. The scanner runs every minute and archives the garbage.

If you like 1hSaved, follow me on X and let me know!