# Google Sheets (/docs/guides/destinations/google-sheets)



# Google Sheets [#google-sheets]

Automatically sync your bank transactions to Google Sheets. Ideal for custom budgets, financial reporting, and sharing data with family, partners, or accountants.

## Prerequisites [#prerequisites]

* A Google account
* At least one bank account connected in Lunch Flow

## Setup [#setup]

<Steps>
  <Step>
    **Add the destination**

    Go to **Destinations → Add Destination → Google Sheets**.
  </Step>

  <Step>
    **Choose a template**

    Select one of:

    * **Overview Template** - a pre-configured sheet ready to go
    * **Blank Sheet** - start from scratch
    * **Existing Spreadsheet** - connect a sheet you already have
  </Step>

  <Step>
    **Share access**

    Add the provided service account email as an **Editor** on your Google Sheet.
  </Step>

  <Step>
    **Connect the sheet**

    Paste your Google Sheet URL and confirm.
  </Step>

  <Step>
    **Configure sync**

    Select which accounts to sync and optionally enable **Transaction Enrichment**.
  </Step>
</Steps>

## Data structure [#data-structure]

Synced sheets include: Account, Date, Amount, Currency, Payee, Notes, Transaction ID, Raw Data.

When Transaction Enrichment is enabled, Merchant and Category columns are added automatically.

## Transaction enrichment [#transaction-enrichment]

An AI-powered feature that normalises merchant names and categorises transactions into 15+ categories including Food & Beverage, Transport, Shopping, and more.

## Sync behaviour [#sync-behaviour]

* Updates occur daily with new transactions appended
* Duplicates are prevented automatically
* Existing data is preserved

## Best practices [#best-practices]

* Add new columns to separate sheets rather than modifying the sync columns
* Keep raw data, analysis, and budgeting on separate sheets to avoid breaking the sync