Turn your inbox into a follow-up tracker with Claude for Sheets
Have Claude read 30 days of Gmail, build a follow-up tracker in Google Sheets, and draft your overdue replies.
TL;DR
You'll install Claude for Sheets, connect it to your Gmail, and let Claude find every loose end from the last 30 days: what you owe people and what they owe you. It builds a sorted, color-coded follow-up tracker right in your spreadsheet, then drafts replies to your most overdue emails straight into Gmail.
Who this is for
- Freelancers and consultants juggling lots of client emails Account managers and team leads who make promises over email all day Anyone who's ever forgotten to get back to someone
What you'll build
A follow-up tracker in Google Sheets listing every loose end from the last 30 days (who, what, who owes who, days waiting, priority), plus 3 reply drafts saved in Gmail.
Steps in this tutorial
- Turn your inbox into a follow-up tracker with Claude for Sheets
- Step 1: Install Claude for Sheets
- Step 2: Open a blank sheet and launch Claude
- Step 3: Turn on the Gmail connector
- Step 4: Paste the follow-up assistant prompt
- Step 5: Read your follow-up tracker
- Step 6: Have Claude draft your replies
- Step 7: Review and send the drafts in Gmail
- Step 8: Make it yours
- Recap
The step-by-step instructions, prompts and screenshots are for AI Academy subscribers.
Unlock the full AI Academy
This tutorial and every other one, on ChatGPT, Claude, Midjourney & the other AI tools we cover
Start risk-free · Cancel anytime
Already a member? Sign inUnlock the full AI Academy
This tutorial and every other one, on ChatGPT, Claude, Midjourney & the other AI tools we cover
Start risk-free · Cancel anytime
Already a member? Sign in