Log Gmail emails to Google Sheets, automatically
Adds a row to your sheet for every email InboxPilot handles in Gmail or Outlook, and drafts replies that quote the same sheet.
Gmail
OutlookTom Becker9:41 AM
Where is order 48812?
I ordered two weeks ago and still haven't had a shipping confirmation. The order number is 48812.
Looked up
- Orders sheet, row 48812: shipped the 9th
- Tracker tab: new row logged
From:orders@brightlineparts.comCc Bcc
Re: Where is order 48812?
Hi Tom,
Order 48812 shipped on the 9th and is with the carrier. Tracking is 1Z999AA10123456784, showing delivery Thursday.
Sorry the confirmation never reached you. I've noted it against the order.
NinaBrightline Parts
Drafted by InboxPilot, waiting for youSend
Your sheet stays current, and your replies quote it
New order enquiry from Dana Whitfield
Added a row to Orders: Dana Whitfield, order enquiry, Sep 25.
InboxPilotLog every email
Adds a row with the sender, subject and the fields you mapped.
When does order 48812 ship?
It shipped on the 9th. Tracking is 1Z999AA10123456784.
InboxPilotAnswer from the sheet
Finds the order's row and quotes the ship date and tracking.
Where is order 99120?
There's no row for 99120, so I've flagged this for the team.
InboxPilotFlag what's missing
No matching row? The email goes to a person instead of a guess.
Build a workflow once, it runs on every email after
Write what should happen in one sentence. InboxPilot turns it into steps that run on every matching email.
Your instruction
“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.”
When
Incoming email recognized as an order status question
Checks
AI matches the order number against the rows in your linked sheet
Then
- 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
Set it up once, in four steps
01
Connect the inbox
Gmail or Outlook, the address the emails arrive at.
02
Link the sheet
Pick a spreadsheet and tab. Columns come from your header row.
03
Map the columns
Say which column holds the order number, customer or amount.
04
Rows append
Every handled email adds a row. Nothing in the sheet is edited.
Gmail to Sheets questions, answered
Connect the inbox, link a spreadsheet and map the columns once. From then on, every email InboxPilot handles adds a row to the tab you chose. Google Sheets is available from the Starter plan, $39 a month.