> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sourcedock.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets

> 2 min read · Copy your purchases and expenses to a Google Sheet in your own Drive that updates itself.

## In short

Say you record 12 Uno card games at \$8.00 each. A few minutes later, the same purchase is a row in a Google Sheet in your own Drive: date, store, ASIN, product, status, Qty, \$8.00, \$96.00, and its profit. You never copy anything by hand.

This is **Google Sheets sync**. It is part of Pro, and every trial has it. Find it in **Connections**, in the **Google Integrations** card, under **Sync purchases to Google Sheets**.

**1. Connect Google Sheets**

Click **Connect Google Sheets**. Google's page opens. Tick the Google Drive box so SourceDock can make your sheet.

**2. Wait a minute or two**

The card says **Making your sheet. This takes a minute or two.** SourceDock makes a new sheet called **SourceDock Purchases** in your Drive and writes your purchases into it. Then the card shows **Open sheet**.

## More details

> [accordion] How often it updates
>
> It updates by itself. SourceDock checks for changes every minute, so a purchase or expense you add, change, or delete shows in the sheet within a few minutes. The card says when it last synced.
>
> If Google stops SourceDock's access, the card asks you to **Connect again**. No changes are lost. They wait and go in once you connect.

> [accordion] What the sheet holds
>
> * **Summary**, the first tab: one row per year, with what you spent, the units you bought, your expected and current profit, and your expenses. Click a year to open its tab. Canada and Mexico purchases get their own rows and total, in their own money.
> * **Purchases 2026**, one tab per year: one row per purchase, with the same columns as the Purchases page. Canada and Mexico purchases go on their own tabs, like **Purchases 2026 (Canada)**. The numbers behind each profit sit in a folded group of columns after **Receipt**. Click **+** above the columns to open them.
> * **Expenses 2026**, one tab per year: one row per expense, a column for each month, and the year's total. Each store gets its own block, in its own money.
>
> Every total is a formula, so it updates when a row changes. SourceDock keeps its columns up to date, so change a purchase or an expense in SourceDock, not in the sheet. Columns you add to the right stay yours.

> [accordion] Stop syncing
>
> Click **Disconnect** to stop. The sheet stays in your Drive, and your purchases in SourceDock don't change.
>
> For a year of money in one file for your accountant, see the [Capital Recovery Report](https://docs.sourcedock.io/get-started/account-reports.md).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.