# Job emails to a sheet with Claude Code

> Tested by AI Setups That Work. Small business · Intermediate · Leads. Updated 2026-11-17.
> Receipt: Ran with Claude Code in a cloud session, Nov 17, 2026, on made-up data: the page prompt turned a 12-message sample mailbox into a 10-row requests.csv in one run, and 10 of 10 rows matched the known answers. It passed with snags: the same session wrote the sample and the script, so the script fit the sample, and a rerun rewrites the whole file. Manual mode and a real mailbox were not tested.

Canonical page: https://www.aisetupsthatwork.com/setups/turn-job-emails-into-a-spreadsheet-with-claude-code/

## What it does
Turn a pile of repair or job request emails into one spreadsheet with a small script, instead of a bot that reads your inbox all day.

## Who it's for
Trades and service owners whose job requests arrive by email and who want a list of every request without paying an AI to read the inbox on a schedule.

## Tools
- Claude Code, in the terminal or the desktop app
- A Gmail label on your job request emails
- Google Takeout to export that label
- Google Sheets or Excel to open the result

## Steps
1. In Gmail, put one label, such as "Job requests", on the request emails. A filter can do it for new ones, for example on your contact form's sender address.
2. Go to Google Takeout, deselect everything, select Mail, and choose only that label. Takeout sends a download link; Gmail arrives as an MBOX file inside a ZIP.
3. Make a new folder, unzip the export into it, and open Claude Code in that folder in Manual mode (cd into the folder, then type claude --permission-mode manual).
4. Paste the prompt below. In Manual mode, Claude Code stops and asks before it edits files or runs commands. Read what it wants to do, then approve. Newer versions start in auto mode by default, so check the mode indicator shows Manual.
5. Open the CSV it makes in Google Sheets or Excel. Check 10 rows against the real emails before you trust the rest.
6. Next week, export again into the same folder and ask Claude Code to rerun the script. Only new emails should add rows.

## Copy-paste prompt
Adapt bracketed fields to your situation.
```text
In this folder is an MBOX file exported from one Gmail label. Each email is a job or repair request from a customer.

Write a small script, in a language you can run here, that reads the MBOX and writes requests.csv with one row per email and these columns:
date, from name, from email, phone (if one is in the message), address or town (if given), job type (one or two words), first 300 characters of the message, and a needs-check column.

Rules:
- Only read the file. Do not send, delete or change any email, and do not connect to Gmail.
- Use only what is in each email. If a field is missing, leave it blank. Do not guess.
- Put YES in needs-check when you are unsure about the phone, address or job type.
- Skip emails that are replies I sent.
- Before you run it, tell me what the script will do. After you run it, show me the first 5 rows and the total count.
```

## Guardrails
- What it touches: Chat input you provide (Claude Code, in the terminal or the desktop app; A Gmail label on your job request emails).
- Needs your OK: Send, pay, publish, delete, and CRM updates stay with you unless you explicitly opt in.
- Safety level: Read-only
- Why a script instead of a bot: A bot that reads your inbox on a schedule spends usage every run. A local script can be rerun on each new export without an AI reading your inbox on a schedule. Changing the script still uses your Claude plan.
- Keep it read-only: The workflow reads an exported copy, not your live inbox, and the prompt tells Claude not to connect to Gmail or send, delete or change any email. That is an instruction, not a lock, so stay in Manual mode and read each action before you approve it. You still reply to every customer yourself.
- The export misses emails. A label export only includes messages with that label; label older emails before you export.
- Phone numbers come out wrong. Ask Claude Code to show you the rows marked needs-check and fix them by hand.
- Claude Code asks to install something. Ask it what and why before you approve.
- The script may only know the towns and job words it was shown. Check the job type and address columns against the real emails, and expect a rerun to rewrite the whole file.

## Tips
- Name the label the same thing forever, so every export works with the same script.
- Ask Claude Code to add a "status" column you fill in yourself: quoted, booked, lost.
- If you also get requests by text, add them to the sheet by hand under the same columns.

## Estimates (labeled, not measured)
- Time saved: Not stated in sources.
- Money saved: Not stated in sources.
- Tool cost: Claude Code needs a paid Claude plan (Pro, Max, Ultra, Team or Enterprise) or a Claude Console account. Google Takeout and Google Sheets are free. Plan prices: see claude.com/pricing.

## Sources
Summaries use the public sources below, not independent verification.
- Anthropic: https://code.claude.com/docs/en/quickstart (Claude Code quickstart (read Nov 9, 2026): install commands for macOS, Linux, WSL and Windows, a desktop app option, plans that include it (Pro, Max, Ultra, Team or Enterprise, or a Claude Console account), start it with "cd" into a folder then "claude". Whether it asks before acting depends on the permission mode (see the permission modes page).)
- Anthropic: https://code.claude.com/docs/en/permission-modes (Claude Code permission modes (read Nov 9, 2026): in Manual mode Claude Code stops and asks before most actions that edit files, run shell commands or reach the network; auto mode is the built-in starting mode for interactive terminal and VS Code sessions on current versions; start in Manual with claude --permission-mode manual, or switch with Shift+Tab.)
- Google: https://support.google.com/accounts/answer/3024190 (How to download your Google data (Google Takeout). Our build machine could not open Google help pages; checked through search results on Nov 9, 2026: Mail can be limited to chosen labels, and Gmail exports as an MBOX file inside a ZIP or TGZ.)

## Get the free starter pack
Five beginner copy-paste AI setups, free by email: https://www.aisetupsthatwork.com/starter-pack/?utm_source=ai-agent&utm_medium=markdown&utm_campaign=setup-turn-job-emails-into-a-spreadsheet-with-claude-code

Related:
- [Track the bids you sent and follow up](https://www.aisetupsthatwork.com/setups/track-sent-bids-and-follow-up/index.md)
- [Summarize customer calls and flag local leads](https://www.aisetupsthatwork.com/setups/summarize-service-calls-for-small-business/index.md)
- [Stop one job eating your bot usage](https://www.aisetupsthatwork.com/setups/find-which-bot-routine-burns-your-usage/index.md)
