Does it update existing rows or only add new ones?

It only ever adds. Rows are appended to the bottom of the tab and nothing already in your spreadsheet is edited or deleted, so a mistake in the automation can never overwrite a record you depend on. Reconciling or de-duplicating rows stays a spreadsheet job.

Does this work with Outlook as well as Gmail?

Yes. The Google Sheets connection sits on the email pipeline rather than on one mail provider, so a Microsoft 365 or Outlook inbox logs to a Google Sheet in exactly the same way.

Can it write to Microsoft Excel instead?

Not yet. Google Sheets is the supported spreadsheet today, and an Excel connection is on the roadmap rather than in the product. If Excel is what your team runs on, say so on the contact page and we will tell you when it ships.

What actually goes into each row?

Whatever your header row asks for and the email can support: sender, subject, date, and the fields you mapped, such as an order or invoice number that appears in the message. InboxPilot reads your header row, so the sheet keeps the shape you already built it in.

Is our spreadsheet data secure?

InboxPilot is SOC 2 Type II certified, encrypts data in transit and at rest, and never uses your documents, spreadsheets, or email to train shared models. The Google connection asks for access to spreadsheets only, not the rest of your Drive.

Google Sheets logging

Every email worth tracking, added to Google Sheets

InboxPilot appends a row to the sheet you link each time it handles an email in Gmail or Outlook, and drafts replies that quote the same sheet back to the customer. You approve every send.

Gmail

Outlook

Free plan · Works inside Gmail & Outlook · You approve every send

InboxNew

Customer writing to a shared support inboxWhere is order 48812?

Hi — I ordered two weeks ago and still have not had a shipping confirmation. The order number is 48812.

AI draft by InboxPilotDrafted

Hi, thanks for chasing this. Order 48812 shipped on the 9th and is with the carrier now — tracking is 1Z999AA10123456784, showing delivery Thursday.

You should have had a confirmation when it left us and clearly did not, so I am sorry for the silence. I have noted it against the order so we can see why it never went out.

Grounded in your docs · approved by you

Why gmail to google sheets emails deserve automation

Most teams keep the real operational record in a spreadsheet: the order log, the claims tracker, the job list. The emails that should update it arrive all day in a shared inbox, so someone copies the details across by hand, or the sheet quietly falls behind. Logging Gmail emails to Google Sheets automatically closes that gap — and because InboxPilot reads the same tab as reference data, the spreadsheet stops being a write-only archive and starts feeding the replies your customers actually get.

Gmail

Google Sheets

What makes this workflow painful

The tracker is always a day behind

Rows get added when someone has a quiet hour, which is after the shift, after the rush, or not at all. Decisions get made against a sheet nobody fully trusts.

Re-keying is where the errors enter

Order numbers, addresses, and amounts get copied from an email into a cell by hand. One transposed digit becomes a wrong shipment or a wrong invoice.

The answer was already a row

The ship date, the price, the policy: it is sitting in the spreadsheet. Whoever writes the reply still has to go find it and paste it in.

How teams handle it today

None of these are wrong. They just spend skilled people on assembly work, and they all get slower exactly when volume spikes.

Copy-paste after the fact

Someone works back through the inbox at the end of the day and fills in the rows for everything that came in.

The log is only ever as current as the last quiet hour.

A script or no-code task per mailbox

An Apps Script or a single-purpose automation watches the inbox and appends whatever it can parse out of the subject line.

The rule breaks the moment a customer phrases it differently.

One person owns the tracker

A coordinator keeps the sheet correct by hand and everyone else asks them what the current state is.

The operational record leaves when they do.

How InboxPilot automates it

Step 1

Connect Gmail or Outlook

Scoped OAuth on the inbox that receives the email. Shared inboxes included, no migration, nothing changes for the rest of the team.

Step 2

Link the sheet and pick the tab

Choose a spreadsheet you already keep. InboxPilot reads its header row, so the columns come from your sheet rather than a schema we impose.

Step 3

Map the columns once

Say which column holds the order number, the customer, the amount. Anything InboxPilot can read off the email fills itself in from then on.

Step 4

Rows append as email is handled

Each handled email adds a row and never overwrites one, while the same tab is read back so drafts quote real values instead of guessing.

A real example, before and after

The incoming email on the left, the InboxPilot draft waiting for approval on the right.

Customer writing to a shared support inboxIncoming email

Where is order 48812?

Hi — I ordered two weeks ago and still have not had a shipping confirmation. The order number is 48812.

Can you tell me when it actually ships? I need it before the end of the month.

AI draft by InboxPilotWaiting for your approval

Hi, thanks for chasing this. Order 48812 shipped on the 9th and is with the carrier now — tracking is 1Z999AA10123456784, showing delivery Thursday.

You should have had a confirmation when it left us and clearly did not, so I am sorry for the silence. I have noted it against the order so we can see why it never went out.

Anything else on this one, just reply here and it comes straight back to us.

The ship date and tracking number come from the row in your linked Google Sheet, and handling this email appended its own row to the log tab.

Turn a sentence into automated actions

Describe what should happen in plain English and InboxPilot builds the workflow: a trigger, an AI decision, and the actions that run on their own.

Describe your workflowPlain English

“When a customer asks where their order is, look the order up in our Google Sheet, draft the reply with the ship date and tracking, and log the email to the tracker tab.”

Build workflow

InboxPilot builds

TriggerIncoming email recognized as an order status question

AI DecisionAI matches the order number against the rows in your linked sheet

Actions

Draft a reply with the ship date and tracking number taken from the sheet
Append a row to the log tab with the customer, the order, and what was answered
Flag the email for a person when no matching row exists

Related guides and pages

WISMO & order status automation

Build an email workflow in plain English

Gmail to Google Sheets: frequently asked questions

Connect the inbox, link a spreadsheet, and map the columns once. From then on every email InboxPilot handles appends a row to the tab you chose, carrying the fields it could read off the message. There is no script to maintain and no separate automation tool sitting in between.

Start with the emails you’re tired of.

Connect Gmail or Outlook, point InboxPilot at a few documents, and see your first drafts today.

Start free

Book a 15-minute demo

No credit card. Nothing sends without your approval.

Hey AI, learn about us

¡nboxpilot