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) 

:)

Here's some sample output! I tested this workflow using the email newsletter "THIS WEEK IN CPG" -- I analyzed every copy I had, so 36 weeks of the newsletter

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

katherinechampagne.com