Case study · tinyEmail MCP

A new row in the sheet becomes a personal email journey. Nobody copies a thing.

A home furniture retailer collects design requests in a Google Sheet. With tinyEmail's MCP Server and Claude Code, every new lead is checked, added, tagged, placed in the right workflow and sent a first email written just for them. Then the sheet is updated with what happened.

4 minfrom new row to first email, down from the next business day
24 hrsa week of copy-and-paste handed back to the team
0duplicate contacts or mistyped emails added
Every rowmarked with its result, so sales knows where a lead stands
The challenge

240 leads a week, each one copied by hand

Design requests come in from the website, Instagram ads and the showroom floor. They all land in one Google Sheet. From there, someone on the marketing team moved each lead into tinyEmail, one row at a time.

The work was done in a batch once a day. That meant a shopper who asked about dining tables on Monday morning heard back on Tuesday, often after they'd already found a table somewhere else.

What one lead took, by hand
  • Copy the row out of the sheet1 min
  • Check the email and look for duplicates1 min
  • Add the contact, tags, budget and city1.5 min
  • Pick the right workflow0.5 min
  • Edit the first email so it doesn't feel generic1.5 min
  • Go back and mark the row as done0.5 min
6 min × 240 leads a week24 hrs
What changed

One instruction replaced six manual steps

With the MCP Server connected, Claude Code works directly inside the retailer's tinyEmail account. The team wrote the onboarding rules once, in plain English. Now Claude Code reads the new rows and handles every lead the same way, every time: Google Sheets lead onboarding without the copy and paste.

Follow one lead

What happens to each lead, step by step

Pick a lead to see how Claude Code handled them. Each one gets a different path, and a lead with a bad email address never reaches your audience.

  1. ✓
    Check and add to tinyEmailEmail looks valid and isn't in the audience yet. Added to “New leads”.
  2. ✓
    Apply tags and custom fieldslead · instagram · diningTags: lead, instagram, dining. Budget and city saved on her contact so later emails can use them.
  3. ✓
    Enroll in the right workflowDining room welcomePicked a room, budget under $5,000, so she joins Dining room welcome: three emails over seven days.
  4. ✓
    Write her first emailClaude Code wrote a first email around dining tables in her price range and the Austin showroom.
  5. ✓
    Start the automationSent 9:04 AMThe workflow started and her first email went out at 9:04 AM.
  6. ✓
    Update the Google SheetRow 2 status set to “Email sent · Dining room welcome”.
The first email, written by Claude Code
From Hearth Home Design TeamTo Maya Chen
Maya, let's find your dining table

Hi Maya,

Thanks for asking about dining furniture. We picked five tables in your $2,000–3,000 range, from extendable oak to round tables that seat six.

If you're near our Austin showroom, you can see all five in person this week.

See the tables
leadinstagramdiningbudget: $2,000–3,000city: Austin
  1. ✓
    Check and add to tinyEmailEmail looks valid and isn't in the audience yet. Added to “New leads”.
  2. ✓
    Apply tags and custom fieldslead · showroom · living-roomTags: lead, showroom, living-room. Budget and city saved on her contact.
  3. ✓
    Enroll in the right workflowDesign consult journeyBudget is $5,000 or more, so she skips the standard series and joins the Design consult journey.
  4. ✓
    Write her first emailClaude Code wrote an invitation to a free design session at the Chicago showroom she visited.
  5. ✓
    Start the automationSent 9:05 AMThe workflow started and her first email went out at 9:05 AM.
  6. ✓
    Update the Google SheetRow 4 status set to “Email sent · Design consult journey”.
The first email, written by Claude Code
From Hearth Home Design TeamTo Priya Nair
Priya, your free design session is ready to book

Hi Priya,

Thanks for stopping by our Chicago showroom. For a full living room refresh, one of our designers can put together layouts, fabric options and a quote in a single session.

It's free and takes about an hour. Pick a time that works for you.

Book your session
leadshowroomliving-roombudget: $5,000+city: Chicago
  1. !
    Check and add to tinyEmailStopped here“gmial.com” looks like a typo for gmail.com. Sam was not added to the audience.
  2. –
    Apply tags and custom fieldsSkipped, because the contact wasn't added.
  3. –
    Enroll in the right workflowSkipped.
  4. –
    Write the first emailSkipped. No email is written for an address that would bounce.
  5. –
    Start the automationSkipped.
  6. ✓
    Update the Google SheetRow 5 status set to “Needs review · check email address” so the team can fix it.
What happened insteadNo email sent. Row held for review.

“gmial.com” looks like a typo for gmail.com. Sending to it would bounce and hurt the retailer's sender reputation, so Claude Code stopped at step one and flagged the row.

Needs review · check email address

Once someone fixes the address and clears the status, the next run picks Sam up like any other new lead.

The rules behind it

Every lead lands in the right place

The team wrote four rules. Claude Code applies them to every row, and the tags and custom fields it saves mean each workflow knows exactly who it's talking to.

If the lead picked a roomMatching welcome series

Dining, living room, bedroom or home office. Three emails over seven days, all about that room.

If the budget is $5,000 or moreDesign consult journey

An invitation to a free one-hour session with a designer at the nearest showroom.

If they're already in the audienceUpdate, don't duplicate

New tags are added to the existing contact. No second copy, no repeat welcome email.

If the email looks wrongHold for review

Nothing is added or sent. The row is flagged so a person can fix it.

The result

Leads hear back while they're still shopping

The first email now arrives minutes after someone asks for help, and it talks about the room, budget and showroom they mentioned. The marketing team spends its time on the workflows themselves, not on moving rows between tools.

More ways teams use it

Ask Claude Code next

  • Every morning, onboard new leads from the Design requests sheet using our usual rules.
  • Which leads from last week haven't opened their first email yet?
  • Move anyone who booked a design session out of the welcome series.
  • Show me how many leads came from Instagram versus the showroom this month.
  • List every row in the sheet marked Needs review.
  • Write a second email for Dining room welcome leads who clicked but didn't buy.
Set it up

Three steps, about five minutes, one time

  1. 1

    Get your API key

    In tinyEmail, go to Account Settings › API Keys. It's the secure pass your assistant uses, and it's never stored.

  2. 2

    Connect Claude Code

    Add tinyEmail to Claude Code with your API key. It works the same way in Claude Desktop and ChatGPT.

  3. 3

    Write your onboarding rules

    Tell Claude Code which sheet to watch and how to route each lead. Start from the instruction in this story.

FAQ

Lead onboarding questions 

Can't find your answer? Our team is here 24/7.

No. Claude Code takes instructions in plain English. You describe the rules, and it does the work inside your tinyEmail account.

Yes. Add “show me each email before you start the automation” to your instruction, and Claude Code will wait for your go-ahead.

That's up to your rules. In this story, existing contacts get new tags and no repeat welcome email, so nobody is added twice.

Yes. Your API key goes straight from your assistant to tinyEmail. The MCP Server never stores or logs it.

It's available to tinyEmail Enterprise customers. Contact your account team or support through in-app chat to get started.

Let your next lead get a reply before they close the tab

If you haven't set up the tinyEmail MCP yet, watch the tutorial to connect it to ChatGPT or Claude Code and start using it today.