How to ask Gemini about your Apple Card transactions
To ask Gemini about your Apple Card transactions, connect the Google Workspace app in Gemini, then ask about the spreadsheet that WalletFeed keeps up to date. WalletFeed reads your Apple Card, Apple Cash and Savings transactions on your iPhone and sends them to Google Sheets.
WalletFeed does not send your transactions to Gemini. Gemini reads the spreadsheet from your Google Drive when you ask about it.
Before you start
You must have these items:
- An iPhone with iOS 26 or a newer version (WalletFeed is available only in the US)
- WalletFeed on your iPhone, with access to your Wallet accounts
- WalletFeed Pro (a subscription with a 1-week free trial, or a one-time Lifetime purchase)
- A Google Account
- Keep Activity on in Gemini. Without it, Gemini cannot connect to Google Workspace.
Step 1: Make the spreadsheet in WalletFeed
-
On your iPhone, open WalletFeed.
-
Tap Destinations at the bottom of the screen.
-
Tap + at the top of the screen.
-
In Sheets & Databases, tap Google Sheets.
-
Tap Sign In with Google, then give WalletFeed access on the Google page.
-
Tap Add at the top of the screen.
-
In the message Send Transactions to Google Sheets?, tap Send.
Result: WalletFeed makes the spreadsheet WalletFeed Transactions in your Google Drive and sends your transactions to it.
Send Apple Card transactions to Google Sheets gives all the steps and the columns.
Step 2: Connect Google Workspace in Gemini
Use the Google Account that has the spreadsheet. On a computer, do these steps:
-
Go to gemini.google.com.
-
On the sidebar, click Customize.
If you do not find Customize, click More first.
-
At the top, click Connectors.
-
Find Google Workspace.
-
Click Add.
-
Obey the instructions on the screen.
On your iPhone, open the Gemini app, then tap Menu › Customize › Connectors. Then tap Add for Google Workspace.
Step 3: Ask Gemini about the spreadsheet
- In Gemini, start a new chat.
- Type
@, then select Google Drive. - Paste the prompt from Prompt to start with.
- Send the prompt.
- In the same chat, ask about your transactions.
The Gemini help page tells you not to paste the URL of a document. Use the name of the spreadsheet, as in the prompt. In each new chat, tell Gemini again to use the spreadsheet in your Google Drive.
You can also add the spreadsheet as a file. In the message box, click Add files, then click Add from Drive. In the Gemini app for iPhone, tap Add files, then tap Drive.
Prompt to start with
Copy this prompt, then paste it in the chat. It gives the columns and the rule for spending. The rule is the same as in the WalletFeed app.
Read the Google Sheets spreadsheet "WalletFeed Transactions" in my Google Drive. Use the tab "Transactions". Row 1 has the column names. Each row below row 1 is one transaction from my Apple Card, Apple Cash or Savings account.
The columns are:
- WalletFeed ID: an ID that the WalletFeed app uses. Ignore it.
- Date: the date of the transaction.
- Merchant: the name of the merchant.
- Amount: money out of the account is a negative number. Money into the account is a positive number.
- Currency: the currency code, for example USD. Amount is in this currency.
- Category: the category, for example Groceries or Dining.
- Status: the status from Apple Wallet, for example booked or pending.
- Pending: TRUE (a checkmark) when the transaction is pending.
- Account: the account, for example Apple Card, Apple Cash or Savings.
- Description: the description of the transaction from Apple Wallet.
- Type: the type of the transaction from Apple Wallet, for example pointOfSale, refund, transfer or billPayment.
- MCC: the merchant category code.
- Foreign Amount and Foreign Currency: for a purchase in a different currency, the amount and the currency code in that currency. Empty for other transactions.
To find the spending of one row, use only the columns Type and Amount, in this order. Do not use Category, Merchant or Description for this.
1. If Type is exactly transfer or billPayment, the spending of the row is 0. This is true even when Amount is negative.
2. Otherwise, if Amount is negative, the spending of the row is Amount without the minus sign.
3. Otherwise, if Type is exactly refund, the spending of the row is minus Amount. A refund makes the total smaller.
4. Otherwise, the spending of the row is 0.
The total spending of a group of rows is the sum of the spending of each row.
- Include the rows where Pending is TRUE, unless I ask you to leave out pending transactions.
- Use the Date column for periods, for example a month or a year.
- Do not add amounts in different currencies. Give one total for each currency.
- Show the totals, and list the rows that you used for each total.
- If you cannot read all the rows, tell me the first and the last date that you read.
First, tell me the number of rows and the first and the last date in the spreadsheet.
Then ask about your transactions, for example:
How much did I spend on Dining last month?Compare my spending in September and October by category.Show my purchases in a different currency this year.Make a chart of my spending each month this year.
Large spreadsheets
The Gemini help page says that if a file is too large, Gemini can miss details in it. A file can be 100 MB at most.
- Ask about one month or one category at a time.
- Ask Gemini to show the rows that it used, and do a check of the totals.
- In WalletFeed, use Filter on the destination to send only some accounts or categories (refer to Choose what a destination receives).
The help page also says that Google AI Pro and Google AI Ultra give a larger context window and higher limits for files.
Privacy
- WalletFeed sends your transactions from your iPhone to Google only. WalletFeed has no account, and no WalletFeed server keeps your transactions or keys.
- With Google Workspace in Gemini, Gemini can read the files in your Google Drive, not only the spreadsheet.
- The Gemini help page says that Gemini does not train its models directly on your Drive files.
- The same page says that Google trains its models on the summaries and excerpts of your files that Gemini uses for its answers. For a short file, the summary can be the full file.
- Human reviewers can read some of this data. The page tells you not to connect apps that contain confidential data.
The Gemini help pages gave these rules on November 16, 2026. The rules can change. You can disconnect Google Workspace in Customize › Connectors. The spreadsheet stays in your Google Drive.
If there is a problem
If Gemini cannot connect to Google Workspace
Keep Activity is off, or a setting in Gmail stops the connection.
- In Gemini, make sure that Keep Activity is on.
- In your Gmail settings, set Smart features in other Google products to on.
- Open Gemini again.
- Connect Google Workspace again.
For a work or school account, the Google Workspace administrator must let Gemini connect to apps.
If Gemini does not find the spreadsheet
Gemini did not use Google Drive for your prompt.
- Type
@, then select Google Drive. - In your prompt, type the name of the spreadsheet, WalletFeed Transactions.
- If Gemini still does not find it, add it with Add files › Add from Drive.
If the answers do not include your new transactions
The spreadsheet does not have the new transaction, or Gemini did not read the file again.
- Open the spreadsheet WalletFeed Transactions in Google Sheets. Look for the new transaction.
- If the transaction is in the spreadsheet, start a new chat in Gemini. Gemini then reads the file again.
- In the new chat, paste the prompt again, then ask again.
- If the transaction is not in the spreadsheet, open WalletFeed on your iPhone. WalletFeed sends the new transactions.
- Look in the spreadsheet again.
FAQ
Does WalletFeed send my transactions to Gemini?
No. WalletFeed sends your transactions only to the spreadsheet in your Google Drive. Gemini reads the spreadsheet when you ask about it.
Do Gemini and WalletFeed have the same access to my Google Drive?
No. Gemini and WalletFeed can use the same Google Account, but they have different access. WalletFeed can open only the spreadsheets that it makes. Gemini can read the files in your Google Drive.
Does Gemini get my new transactions?
Yes, when WalletFeed updates the spreadsheet. When WalletFeed is not open, iOS decides when WalletFeed runs. Expect the change in about 1 hour or less. If Background Sync is on, WalletFeed then sends the change.
Related
Updated November 16, 2026