I used Claude today to write me some Google Apps Script to go through an email inbox and find all replies to an autoresponder, and save each one to a Google Sheet. 

Then, using Gemini 1.5 Pro (chosen for it's huge context window), I was able to load in that sheet straight from Google Drive and analyze the content of all the emails (how many times was X mentioned, other types of semantic analysis on the whole DB) 

:)

The Farcaster formerly known as Kchamp. Books, beats, bodybuilding, bright ideas and beautiful things.

katherinechampagne.com 

O wow I think I might finally be able to use this to clean my inbox. I never even thought about connecting Gmail to G Sheets.

🫡 you can run any apps script on your own data at script.google.com w/out having to deal with like, keys/scopes/approvals. dump code in, add services used, accept perms, and run ▶️