Choose your method. Both are free.
This tutorial shows you exactly how Gmail filtering with AI works. No account needed.
Go to sheets.new to create a blank Google Sheet. Name it "1hSaved".
In your sheet, click Extensions â Apps Script. This opens the script editor.
Delete any code already there (the default myFunction).
Copy ALL the code below and paste it into the Apps Script editor:
After pasting, click the đž save icon (or Ctrl+S).
You need a free API key from Google to power the AI scanning.
Go back to your Google Sheet tab. You should see a new menu: âąī¸ 1hSaved
Click âąī¸ 1hSaved â đ Install My Scanner
After install, go to the Settings tab in your sheet. Paste your Gemini API key in the "Gemini API Key" row (column B, row 2).
That's it! The scanner runs every minute automatically.
Enter your email to get the pre-built Google Sheet â just copy it and click Install.
â Check your inbox! We sent you the link.
Get a pre-built Google Sheet with everything ready. Just add your API key and click Install.
We'll send you the Google Sheet link. No spam â just the tool.
â Check your inbox! We sent you the link.