Skip to content

Search setups and tools

Type a few words to search.

Browse all setups

Job emails to a sheet with Claude Code

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.

For trades and service owners whose job requests arrive by email · Claude Code · Intermediate

Tested Nov 17, 2026Claude Code in a cloud session, made-up mailbox, passed with snags: the same session wrote the sample and the script.See the receipt

Copy the prompt

Fill in the [brackets] after you paste it.

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.

Three ways to run this setup

  • Free

    Copy and paste it yourself

    Copy the prompt above into ChatGPT, Claude or Grok. It drafts. You approve.

    Go to the prompt
  • $9 once

    Complete Pack

    One payment, no membership. Opens the pack pages: Bot Safety Checklist, Second Brain Starter Vault, Voice File Starter, Tested Grok Bot prompt pack, Write it as code prompts.

    See the Complete Pack
  • Free to start, VIP $19 a month

    Save it as a bot in the guided setup app

    The app turns this setup into a bot with the draft-only rules. 3 setups build free; the rest are part of VIP. A human reviews a prompt or setup for you within 24 hours, up to 2 a month.

    Build it in the app

What you get back

Example written for this page with made-up names. Not from a test run.

  • Read 214 emails from Job_requests.mbox. Wrote 198 rows to requests.csv (16 were your own replies).
  • 2026-11-04 | Rosa Delgado | 555-0142 | Elm St, Rutland | furnace repair | "Our furnace is making a banging noise..." | needs-check: no
  • 2026-11-05 | Tom B. | (blank) | (blank) | gutter | "Can you quote gutters for a two-story..." | needs-check: YES

3 steps

  1. Copy the prompt.
  2. Paste it into Claude Code.
  3. Fill in the [brackets], then read the answer before you send or use it.

Quick answer

Put a Gmail label on your job request emails, export that label with Google Takeout, and save the file in a new folder. Open Claude Code in that folder and paste the prompt below. It writes a small script that reads the export and makes a spreadsheet: date, name, phone, address, job and the first lines of the message. You check the rows, then open the file in Google Sheets or Excel. Rerun it whenever you export again.

How do you set it up?

Skip this if

  • You get only a few requests a week. Copying them by hand is faster.
  • Your requests come in through a booking tool that already exports a spreadsheet.

Done after day one

A spreadsheet of every request under one label, and a script you can rerun on the next export.

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.

Where to paste this prompt

Claude Code → terminal, IDE extension, or web session in your project directory

More ways to run it

Which chat tools work with this prompt?

Paste the prompt into any of these assistants (free or paid tiers).

  • Claude Code

The receipt

Tested by AI Setups That Work

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.

What this sticker means

TestedRead-only

Leads · Intermediate · Small business

Last updated: · Last reviewed:

Before you use this

Who it is 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.

What it is allowed to do: Read-only. Only reads, researches, or summarizes. It never drafts outbound content or changes anything.

At a glance: time, cost and difficulty

At a glance

All outcome figures are estimates from cited sources, not independent verification by us.

What it is allowed to do
Read-only

Only reads, researches, or summarizes. It never drafts outbound content or changes anything.

Reviewed Nov 9, 2026

Time saved (estimate)
Not measured yet
Difficulty
Intermediate
Tools needed
Claude Code, Gmail, Google Sheets
Typical 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.

Basis (estimate): Not measured yet. We haven't timed this.

What went wrong in the test, and the rule that fixed it

Where agents tend to stall on this job. More patterns in Where AI gets stuck.

  • 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.

What tips make it smoother?

  • 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.

Where do the claims come from?

Summaries use public sources linked below, not independent verification. How setups are picked.

  • Read Anthropic’s write-up (code.claude.com)

    Anthropic: 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).

  • Read Anthropic’s write-up (code.claude.com)

    Anthropic: 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.

  • Read Google’s write-up (support.google.com)

    Google: 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.

Common questions

What does this setup do?
Put a Gmail label on your job request emails, export that label with Google Takeout, and save the file in a new folder. Open Claude Code in that folder and paste the prompt below. It writes a small script that reads the export and makes a spreadsheet: date, name, phone, address, job and the first lines of the message. You check the rows, then open the file in Google Sheets or Excel. Rerun it whenever you export again.
Who is it 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.
What does it cost to run?
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.
What usually goes wrong?
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.
How much time might it save?
Not stated in sources. Not measured yet. We haven't timed this.

Free kit by email

Get the free kit by email

The starter pack and the Portable AI Office, sent to your inbox. New setups by email after that. Unsubscribe any time.

What to do next