How to Add Expenses to Google Sheets From Your iPhone

To add expenses to Google Sheets from your iPhone, you have four options: type into the Google Sheets app, fill a Google Form linked to your sheet, run an Apple Shortcut that submits that form, or use an app that turns one sentence into a whole row. All four work. The difference is how long each entry takes, and that decides whether you keep logging after week one.

Below we compare the four on time per entry, then walk through each one step by step, plus home screen widgets and logging with no signal.

The four methods compared

Here's what each method costs you per expense, for a typical four-column row (Date, Category, Amount, Notes). Times are approximate and assume the sheet already exists.

The quick summary: the Sheets app is fine for the occasional fix, but too slow for every coffee. A Shortcut is the best free option if you don't mind some set-up. An app is the least work over time.

How do you add expenses to Google Sheets from your iPhone?

Pick the method that matches how often you log. If it's a few times a month, the Sheets app is enough. If it's daily, go for a Form, a Shortcut or an app. Each one is explained below.

Method 1: Type into the Google Sheets app

1. Install Google Sheets from the App Store and sign in with your Google account.
2. Open your expense spreadsheet. If you don't have one yet, start with our guide to tracking expenses in Google Sheets for the columns and formulas.
3. Scroll to the first empty row and double-tap the Date cell.
4. Type the date, tap the next cell, and repeat for Category, Amount and Notes.
5. Tap the checkmark to save.

Tips that help: freeze the header row (tap the row number, then Freeze) so you can see which column you're in. Use a dropdown for Category so you pick instead of typing.

Where it breaks: finding the next empty row in a long sheet, tapping the right cell on a small screen, and the keyboard covering half the grid. It's the method most people try first and the one they give up on.

Method 2: A Google Form linked to your sheet

A form shows one field per question in a phone-sized layout, and each response becomes a row in a linked sheet.

1. On a computer, go to Google Forms and create a blank form.
2. Add questions: Category (Dropdown), Amount (Short answer, with response validation set to Number), Notes (Short answer).
3. In the Responses tab, choose Link to Sheets and create a new spreadsheet or pick an existing one.
4. Click Send, copy the link and open it in Safari on your iPhone.
5. Tap the Share button, then Add to Home Screen.

Google adds a Timestamp column automatically, so you don't type the date. The catch: the timestamp is when you submit, not when you spent. Add a Date question if you often log after the fact.

Where it breaks: the form loads from the web each time, so it needs a signal, and responses land in their own tab with Google's column layout, not your existing tracker.

Method 3: An Apple Shortcut that submits the form

This is the method Apple fans like, and with good reason: once set up, it's fast. The Shortcut asks you a couple of questions, then sends the answers to your Google Form in the background.

1. Build the Google Form from Method 2 first.
2. In the form editor, open the ⋮ menu and choose Get pre-filled link. Type any value in each field, click Get link and copy it. The link contains IDs like entry.123456789 for each question.
3. On your iPhone, open Shortcuts and create a new shortcut.
4. Add Ask for Input (type: Number, prompt "Amount"). Add Choose from Menu with your categories, or a second Ask for Input for Category.
5. Add a URL action with your form's address, ending in formResponse instead of viewform, followed by the fields: …/formResponse?entry.111=[Amount]&entry.222=[Category]. Insert the answers as variables.
6. Add Get Contents of URL and set its method to POST.
7. Name it "Log expense" and add it to your home screen, the Action Button on newer iPhones, or Back Tap (Settings → Accessibility → Touch → Back Tap).

Where it breaks: set-up is fiddly, and if you rename or reorder form questions the IDs can change and entries silently fail. There's no confirmation that the row landed unless you add one, and it doesn't work offline.

Method 4: An app that adds rows for you

Voice Sheet is an iPhone and Android app that adds rows to a Google Sheet you own. Connect a sheet and it reads your header row, column types and dropdown options, then builds a form from them. Unlike the Google Form, it writes into your existing tracker, not a separate responses tab.

1. Install Voice Sheet and connect your Google account.
2. Pick an existing spreadsheet, or create one from the Personal Finances template.
3. Choose your currency (one per spreadsheet).
4. Tap + and fill the form, or, with Premium, tap the microphone and say the entry.

With voice entry, you say a sentence like:

"Lunch 12.50 yesterday, card"

and Date, Category, Amount and Payment are filled in, ready for you to check and save. Your iPhone's speech recognition turns the audio into text on the phone; the text and your column names go to Google Gemini to fill the columns. The audio isn't uploaded. In-app voice input is English only. For a deeper look at how this works and what to say, see our voice expense tracker guide.

The form built from your columns is free. Voice entry, Quick Capture and the widget are part of Premium ($4.99/month or $39.99/year).

Where it breaks: it's Google Sheets only (no Excel), and voice is the paid part. It also doesn't scan receipts or import bank transactions: you record what you choose, which is the point if you'd rather not link your bank.

Logging from the home screen: widgets

The fastest entry is the one you start without opening anything. On iPhone you have three routes:

• Google Sheets' own widget shows recent or starred files. It saves a tap, but you still land in the grid and type into cells.
• A Shortcut on your home screen (Method 3) asks for the amount straight away.
• Voice Sheet's home screen widget opens the Quick Capture text box directly, with no splash or loading screen. Type or dictate with the iPhone keyboard's microphone, for example "coffee 4.50, bus 2.75", and each item becomes its own row.

Because Quick Capture uses your keyboard, iPhone dictation works there in other languages too, even though the in-app microphone is English only.

Adding expenses with no signal

Expenses happen in the Underground, on flights and in basements. Here's how each method copes:

• Google Sheets app: open the file's ⋮ menu and turn on Available offline before you need it. Edits sync when you reconnect.
• Google Form and Shortcut: both need a connection. A form submitted offline fails, and the Shortcut returns an error.
• Voice Sheet: form entries are saved on the phone and synced to your sheet automatically, oldest first, when you're back online. Quick Capture keeps your text as a draft per sheet until you're connected. More on the offline mode.

Which method should you use?

• You log a few times a month: the Google Sheets app.
• You want free and a bit faster: a Google Form saved to your home screen.
• You like tinkering and want free and fast: an Apple Shortcut on the Action Button.
• You log daily and want it to stick: an app that writes to your own sheet, with voice if typing on a phone is what makes you quit.

Whichever way you add expenses to Google Sheets from your iPhone, the spreadsheet does the rest: totals by category, a monthly budget and a link you can share with a partner or accountant. If you're on Android too, we'll cover the equivalent methods in a separate guide. For other ways to get rows in, see our comparison of expense tracker apps that sync to Google Sheets.