ReceiptToSheet
Get started
← All posts

October 29, 2026· By Daniel Shao

How to Scan Receipts With Google Drive (and Get Them Into Sheets)

Last updated: October 2026

Short answer: The Google Drive app has a free built-in scanner: tap the camera button, photograph the receipt, and Drive saves it as a searchable PDF (or a JPG) in whatever folder you pick. What it doesn't do is pull out the merchant, date and total. You get a file, not a row. If you want the numbers in a Google Sheet, you need one more step: type them in, build an automation, or use a scanner that writes the row for you.

Most people who search for this are already living in Google. Gmail for the e-receipts, Drive for the files, a Sheet for the budget or the Schedule C. So it's reasonable to expect Google to have a receipt button somewhere that connects those. It mostly doesn't, and it's worth knowing exactly where the gap is before you set anything up.

I build a receipt scanner for Google Sheets, so I have an obvious interest here. The Drive part of this post is useful whether or not you ever use it.


How to Scan a Receipt With the Google Drive App

On Android, from Google's own help page:

  1. Open the Drive app and tap the camera icon in the bottom right.
  2. Point the camera at the receipt. A blue outline shows what it's going to crop to. You can switch between auto capture and manual.
  3. Fix it up if you need to: crop, rotate, switch to black and white, or erase a thumb that got in the shot. You can add more pages for a long receipt.
  4. Tap Done.
  5. Give it a file name, or pick one of the suggested titles.
  6. Choose .pdf or .jpg, tap Location to pick a folder, then Save.

There's also a Drive scan widget you can put on your home screen and point at one folder. If you scan receipts often, set that up. It saves you picking the folder every time.

On iPhone and iPad, Google added the same scanner to the Drive app in late 2023. The flow is close to the Android one. Google's help page has a separate iPhone tab if a button isn't where you expect.

That's genuinely all there is to it, and it works fine. The scan quality is good, the edge detection is good, and it's free within your Drive storage.


What You Get From a Drive Scan (and What You Don't)

You get a searchable PDF sitting in a folder. "Searchable" means Drive reads the text in the image so that searching your Drive for "costco" will find it. That's handy when you're hunting for one receipt.

What you don't get is data. Drive doesn't know that $84.12 is the total, that the date is October 3rd, or that it was groceries. There's no column, nothing to sum, nothing to filter. A folder of 200 receipt PDFs is an archive. It can't tell you what you spent on supplies last quarter.

That's the whole gap. Storage is solved. Turning the receipt into a line in a spreadsheet isn't.


How to Organize Receipts in Google Drive

If you're going to keep the files in Drive anyway, a little structure up front saves a lot of scrolling at tax time.

Folders by year, then by month. Receipts/2026/2026-10. Boring, and it's the structure that still makes sense three years later. Category folders sound nicer, but you'll second-guess the category on every receipt that could go in two places.

A file name you can sort. Something like 2026-10-03 Costco 84.12. Date first means the folder sorts itself in order. Merchant and amount in the name mean you can find a receipt from the file list without opening it. Drive suggests a title when you save a scan; replace it with this.

Point the scan widget at the current month's folder. Re-point it when the month changes. It takes ten seconds and means nothing lands in the root of your Drive.

One folder for everything that arrives by email. Save e-receipt PDFs from Gmail into the same month folder, so paper and digital live together.

This is a perfectly good system for keeping the records. It just stops short of the part where you add them up.


Google Photos and Google Lens

A lot of receipts never make it to Drive at all. They get photographed with the normal camera and end up in Google Photos, between a dog picture and a screenshot of a parking spot.

Google Lens, which is built into Photos, can read the text on a receipt photo and let you copy it. That's useful for grabbing one number. But what you copy is a block of text: every line item, the store address, the return policy, the total somewhere in the middle. You'd still be picking the merchant, date and total out by hand and typing them into a Sheet.

If your receipts are in Photos now, the simplest fix isn't a new tool. It's deciding where receipts go and taking the photo there in the first place, whether that's the Drive scanner or something else.


Receipts That Arrive in Gmail

Online orders, subscriptions and ride shares send receipts by email, and for a lot of freelancers that's most of the pile.

Gmail doesn't turn those into rows either. Your options:

  • Save the PDF into your Drive receipts folder. Many receipt emails have a PDF attached or a "download receipt" link. That gets the file into the same archive as your paper receipts.
  • Use a Gmail add-on built for this. ExpenseBot is one: it runs inside Gmail and Google Workspace, finds receipts in your inbox, and writes merchant, date, amount and tax to a Google Sheet, with the files kept in your Drive. Its Workspace Marketplace listing offers a 60-day free trial; the paid price isn't on the listing. If most of your receipts are emails, look at a tool like that first.
  • Upload the PDF to a scanner that reads PDFs. ReceiptToSheet accepts a PDF as well as a photo. It doesn't connect to your Gmail. You save the PDF and upload it, the same as taking a photo.

Getting Receipts From Drive Into a Google Sheet

There are three real ways to get from "receipt" to "row in my Sheet." Each one is the right answer for someone.

Type it in Open the PDF, type merchant, date and total into the Sheet A handful of receipts a month
Build an automation A Drive folder trigger, an OCR or AI step, and a write to Sheets, wired up in Apps Script, Zapier, Make or n8n People who enjoy building it and will maintain it
Use a scanner that writes the row Photograph or upload the receipt; the row appears in your Sheet Anyone who wants the data and not a project

Typing it in is underrated at low volume. If it's ten receipts a month, a Drive folder plus five minutes of typing on a Sunday works, and costs nothing.

The automation route works and there are plenty of templates for it. The honest part: it's a small piece of software you now own. The OCR step will misread a faded receipt, the AI step needs an API key and a bill, and when a Zap or a script fails quietly, you find out at tax time. Also check how your setup avoids writing the same receipt twice if it runs again on a folder. Not every template does.

A scanner that writes the row is what I built, so here's how it works and where it falls short.


How ReceiptToSheet Fits In

You open receipttosheet.com in your phone's browser. There's no app to install. Sign in with Google once and pick the Sheet you want receipts to go into. Then photograph a receipt, or upload a photo or PDF you already have. It reads the merchant, date, total and category, shows them to you so you can fix anything it got wrong, and when you confirm, a row is added to your Sheet. Usually that's under ten seconds.

What it doesn't do, so you can decide:

  • It doesn't save the receipt file into your Google Drive. The image is stored on our side. On the Pro plan you can view and download it from your history. If you want the PDF in your own Drive as well, keep scanning with Drive for the archive and upload the same file to ReceiptToSheet for the row.
  • It doesn't read your Gmail. E-receipts are a save-and-upload step.
  • It only sees the files you give it. It asks Google for access to the Sheet you pick, not to your whole Drive.

The free plan is 20 scans a month with Google Sheets sync included, and no card. Pro is $15 a month ($12 billed annually) for unlimited scans and access to your receipt images. For the step-by-step setup, see how to scan receipts to Google Sheets automatically. If you want a Sheet layout to start from, the business receipt tracking template has one.


A Setup That Uses Both

If you like having the original file in your own Drive (plenty of people do, and for taxes it's sensible to keep the receipt itself and not just the number), this combination works well:

  1. Drive keeps the file. Scan with the Drive widget into the month folder, named date merchant total.
  2. The Sheet keeps the numbers. Upload the same scan to a scanner that writes the row, or type it in if it's low volume.
  3. Add a column for the file. Paste the Drive link next to the row and you can get from any number back to its receipt in one click.

That's the setup where nothing lives only in an app you might stop paying for. The files are in your Drive and the numbers are in your Sheet.


Frequently Asked Questions

Does Google Drive extract data from receipts?

No. Drive's scanner makes the receipt's text searchable, so you can find it, but it doesn't pull out the merchant, date or total into fields or a spreadsheet. You get a PDF or JPG file in a folder.

Is scanning receipts with Google Drive free?

Yes. The scanner is part of the Drive app and the files count against your normal Google storage.

Can Google Sheets read a receipt?

Not on its own. You can put an image in a cell, but Sheets doesn't read the merchant, date and total off it. Getting those into columns takes typing, an automation, or a scanner that writes to Sheets.

What's the best way to scan receipts into Google Drive and Google Sheets at the same time?

Keep the file in Drive and the numbers in the Sheet. Scan into a dated Drive folder, then send the same file to a tool that writes the row. Or type the row in yourself if you only have a few a month. Linking the Drive file in the row keeps the two connected.

Do I need Google Workspace to do any of this?

No. The Drive scanner, Gmail and Sheets all work on a free personal Google account. ReceiptToSheet works with a personal account, and with a Workspace account unless your admin blocks third-party apps.


Bottom Line

Google Drive is a good place to keep receipts and a free, decent scanner for getting them there. It isn't a receipt tracker, because the numbers never leave the PDF. Decide which you need. If it's an archive, the Drive app and a dated folder structure are enough. If you need the totals in a Sheet, add the one step Drive doesn't do.

Try ReceiptToSheet free →

Related reading

Ready to stop exporting CSVs?

Try it free →