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-2.0-flash) 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 ask for permission. This is normal and safe — the script only reads your own Gmail and runs inside your own Google account. We never see your emails. Click Advanced → Go to (project name) → Allow to 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: Tell us which emails to scan

Add rules for specific senders. The AI reads them so you don't have to — and only flags the stuff that actually matters.

Think: newsletters that are 95% fluff, promo emails you keep just in case, notification digests you never read.

💡 Write your instructions in any language — Spanish, French, Portuguese, etc. The AI will understand and apply them to emails in any language.

Examples of great rules:

Amazon seller newsletters — from: norm@lwn.news, kevin.king@mail.billiondollarsellers.com — "Only flag stuff an Amazon seller needs to know — tactics, policy changes, things that affect my business. Skip the fluff."

Retail promos — from: @target.com, @bestbuy.com — "Only notify me for genuinely big deals (50%+ off or rare sales). Archive everything else."

SaaS notifications — from: @github.com, @linear.app — "Only flag things that need my action — assigned issues, failed builds, mentions. Skip digests and marketing."

Catch-all filter for any email not covered by your rules above. AI will archive obvious junk and only flag things that need your attention.

Step 2: Where should we send your important alerts?

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

📧 Email: We'll send alerts to your Gmail inbox.

Step 3: Last step before your personalized script

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

🔑 Gemini API Key (optional — paste now to skip the Settings tab entirely)

It's free. Get yours at aistudio.google.com/apikey in 30 seconds.

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 — think of it as the "behind the scenes" of your spreadsheet. 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. The install happens from your Google Sheet in the next step.
4

Click Install and add your key

Go back to your Google Sheet tab
Click ⏱️ 1hSaved (new menu) → 🚀 Install My Scanner

ℹ️ Google will ask for permission. This is normal and safe — the script only reads your own Gmail and runs inside your own Google account. We never see your emails. Click Advanced → Go to (project name) → Allow to continue.

Almost everything is pre-filled for you!

    ✅ That's it. Your inbox is now on autopilot. The scanner runs every minute and archives the garbage.