When a respondent uploads a receipt through a Google Form, the file is stored in the form owner's Google Drive, not in the spreadsheet. Respondents must be signed in to a Google account to upload. The responses sheet then holds a link to each file in that row, so you can open the receipt from the same line as the expense.
Where do the uploaded files actually go?
Google creates a folder in the Drive of whoever owns the form. The folder is named after the form, with a note that it holds file responses. Each upload lands in it as a normal Drive file, usually with the respondent's name added to the file name so you can tell whose receipt it is.
- The files count against the form owner's Drive storage, not the respondent's.
- The respondent cannot remove a file after submitting; only the owner can.
- If you later delete the folder or a file, the link in the response sheet will no longer open.
- If the form is owned by one person and the receipts belong to a household, think about who should own it before the first upload.
Why does the form ask people to sign in?
File upload questions need a Google account, because the file has to be tied to someone. A family member who is not signed in will be asked to sign in before they can fill the form. That also means a guest or a vendor without a Google account cannot send a receipt through it. For a household where everyone already uses Google, that is an easy trade.
What settings can I choose for uploads?
| Setting | What it does | A sensible choice for receipts |
|---|---|---|
| Allowed file types | Limits uploads to categories such as images, PDF, document or video | Images and PDF only, since receipts arrive as photos or downloaded invoices |
| Maximum number of files | Chosen from a short list in the question settings | One per entry keeps each row tied to one receipt |
| Maximum file size | Chosen from a short list in the question settings | Pick the smallest option that still fits a phone photo, and test with a real picture |
| Required | Forces an upload before submission | Leave off if cash spends often have no receipt |
The exact choices in each list are set by Google and can change, so look at the options in your own form. Test a real phone photo before you go live, because a high-resolution image can be bigger than you expect.
How do I link the file to the sheet row?
Link the form to a sheet from the Responses tab. The column for the upload question holds the address of the file in Drive. It is already in the same row as the amount, date and category, so the link exists as soon as the response arrives.
To make it tidy, build a clean tab that shows a short label. If the upload link sits in column F of the responses tab, put =HYPERLINK('Form responses 1'!F2, "Receipt") in a cell on the clean tab. Click it and the file opens, provided your account can see the owner's Drive. A person who is not the owner needs the file or folder shared with them.
What are the weak points?
- No automatic reading: the receipt is just a file; nothing extracts the amount.
- A filename is not a record. Always fill in amount and date in the form too.
- If the respondent changes their Google account, they may no longer be able to see their own upload.
- Large files fill Drive storage over time. Check the folder size once in a while.
A routine that keeps receipts findable
- Keep the form and the Drive folder under the account of the person who manages the household money.
- Make the upload optional for cash spends and required for anything you may need later for a warranty or a return.
- At month end, open each uploaded file and confirm it matches its row; fix the sheet if not.
- Move closed months of receipts into a folder named by month and year.
If you would rather have each receipt sit directly on its transaction, SpendixAI keeps receipts with their transactions in a single workspace that you sign in to with Google. A form and a sheet remain a perfectly good set-up when you want to run everything yourself.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


