Who have I ever visited in…
Every time I travel to a city, I wrack my brain to try to remember who lives there so I can reach out to visit. And I’m terrible at it.
So I found a new solution.
Step 1: Download your whole calendar. I used Google Takeout.
Step 2: In ChatGPT with o3, upload the file with this prompt.
I’ve just uploaded a calendar file. I want an xlsx with all the people I’ve ever met with in the bay area. Consider only meetings with 5 or fewer attendees (including me). Filter out people who have glowforge.com emails. It might not say the location in the location field, and ‘the bay area’ covers a lot, so you’ll need to be creative about this. The results should be a spreadsheet with: Name, email, number of meetings, last meeting. Sort by most recent meeting first. Then show the first 10 rows.
Phone numbers are often followed by location, so if a line has “+1” in it, ignore that line.
That’s it. Sit back and watch the gears whirl for a bit, then download a spreadsheet of all the folks you’re overdue to catch up with.
(You might want to subscribe or follow me on Twitter so you don’t miss new articles)