Google Sheets
Google Sheets email integration
ForwardThis adds what arrives by email to a Google Sheet as a new row, with the values filled in. It can find a row by its text and change named cells too.
Setup in 30 seconds.
How it works
Connect Google Sheets
Create a free account and connect Google Sheets. It takes about 30 seconds, and you only do it once.
Forward an email
Forward any email to your ForwardThis address along with your instructions. One email can ask for several things at once.
Done.
ForwardThis replies when it's done, with a short summary and links to what it made, and an undo button if something doesn't look right.
Just forward it
to do@forwardthis.io
Fwd: Invoice INV-2214 - August
Add this to my Expenses sheet with the supplier, amount and due date, and file the invoice under Accounts/2026.
---------- Forwarded message ----------
Hi - August's invoice is attached. Total is £1,240.00 including VAT, payment due 24 September on the usual terms.
meridian-inv-2214.pdf182 KB
Added a row to Expenses
Meridian Supplies · £1,240.00 · due 24 Sep
Saved meridian-inv-2214.pdf
Accounts / 2026
Undo available for 24 hours if something does not look right.
Some other examples
- “Log this order in the Sales sheet: customer, item, value.”
- “Add the new subscriber's name and email to the bottom of the Mailing List sheet.”
- “Change the Northgate row's status to signed and set the date to today.”
Everything ForwardThis can do in Google Sheets
Append row
Add rows to a spreadsheet
Edit spreadsheet cells
Edit cells in a row
Delete spreadsheet row
Delete a row
Read a spreadsheet
Read or search a spreadsheet
Create document
Create a spreadsheet
Copy file
Copy a spreadsheet
Share file
Share a spreadsheet with someone
Remove access
Remove someone's access to a spreadsheet
Check who has access
Check who can see a spreadsheet
Rename file
Rename a spreadsheet
Move file
Move a spreadsheet into a folder
Move file to trash
Move a spreadsheet to trash
Restore file from trash
Restore a spreadsheet from trash
Find files
Find your spreadsheets
Try it with a real email.
Forward any email to the address below to see what ForwardThis can do. No signup required.
Occasional product emails may follow.
Why you need ForwardThis
Email is messy, every message asking for something different. It means constantly leaving your inbox and juggling tabs. ForwardThis skips all of that: forward an email along with some simple instructions, and it’s handled. Compatible with every email provider, and it works across the apps you’re already using.
Questions
- How does the Google Sheets email integration work?
- In Google Sheets the email becomes a new row under the headings your sheet already has, so "amount" lands under Amount, and ForwardThis reads the whole sheet rather than the first few hundred rows, so a match on row 900 is still a match. Forward the email to your ForwardThis address with a simple instruction saying which sheet it belongs in and what to record, like "add this to my Expenses sheet with the supplier, amount and due date". ForwardThis writes the row and replies to confirm with a link to it. The first time, you'll need a free account with Google Sheets connected, which takes about 30 seconds, and that's the entire Google Sheets email integration. Adding an email to Google Sheets as a row has a page of its own.
- Do I have to build anything before I can turn an email into a spreadsheet row?
- No. Sending an email to a spreadsheet usually means building something first: a form, a rule or a script that watches a Gmail label and runs on a timer. Here you write the sheet name and the fields you want on the email itself, so a different email can go to a different sheet tomorrow with nothing changed at either end.
- How does it know which column each value goes in?
- It matches what you asked for against the headings already in your sheet, so "amount" lands under Amount and "due date" under Due date. Nothing is guessed: where the sheet has no column for, it tells you which one it couldn't find instead of putting the value somewhere convenient.
- Can it update or read a row as well as add one?
- Yes. It can change a value in an existing row, delete a row you tell it to, and answer questions about what's in the sheet by reading it back to you in a reply. It reads the whole sheet, not just the first few hundred rows, so a match on row 900 is still a match.
- What if it writes the wrong thing?
- The confirmation email includes an undo that works for 24 hours. For a row it added, undo clears the cells it wrote and leaves the empty row behind, because deleting the row would shift everything written after it. It checks nobody has edited those cells first, and tells you if they have.
- Is this better than a Zapier rule or a Google Form?
- Not always. If the same email arrives in the same shape every day, a Zapier rule or a form will do that job more cheaply. ForwardThis is for the emails that are all different, where writing a simple instruction beats building a rule you'd only use once.