# Exporting to Google Sheets

Source: https://www.digiparser.com/docs/guides/integrations/exporting-to-google-sheets

Integrations

# Exporting to Google Sheets

Export extracted data to Google Sheets

Copy MarkdownOpen

# [Exporting to Google Sheets](#exporting-to-google-sheets)

Feedback

You can **send extracted data to Google Sheets** automatically. Document fields and table rows can go to separate sheet tabs, which keeps values such as invoice details and line items organized.

## [Where to set it up](#where-to-set-it-up)

Feedback

1.  Open your parser and go to **Settings -> Integrations**.
2.  Under **Available Integrations**, click **Google Sheets**.
3.  It appears under **Added Integrations**. Expand it to configure.

app.digiparser.com![Integrations with Google Sheets added and expanded](https://documents.digiparser.com/docs/screenshots/2026-07-23/integrations-overview-clean-docs-account.png?sig=739d702bed6cdcf92c38388adecd42348042fb68e2b0c3d7f237582d0344309b)

## [How to configure](#how-to-configure)

### [Connect your Google account](#1-connect-your-google-account)

Click **Connect to Google** and sign in with the Google account that owns the spreadsheet you want to use. DigiParser will request access to view and edit your Sheets. Approve it to continue.

### [Choose or create a spreadsheet](#2-choose-or-create-a-spreadsheet)

*   **Use an existing spreadsheet** - Pick it from the list. Select each sheet tab you want to use and map its columns.
*   **Create a new one** - Use **Create new spreadsheet**. Enter a name (e.g. "My Invoices - Extracted Data"). DigiParser creates a **Fields** tab and one additional tab for each table in your parser.

### [Map each tab](#3-map-each-tab)

Select a sheet tab, click **Start mapping**, and match DigiParser fields to the destination columns. Repeat this for every tab you want DigiParser to update.

*   The **Fields** tab receives one row for each document.
*   A table tab receives one row for each extracted table row.
*   Unmapped fields and tabs are not sent.
*   When Markdown parsing is enabled, map **Markdown URL** to a sheet column to export the stored Markdown file link.

### [Save](#4-save)

Click **Save Configuration**. Future documents are added to every mapped tab.

## [Update an existing row with upsert](#update-an-existing-row-with-upsert)

Feedback

By default, every mapped tab uses **Append a new row**. This is unchanged for all existing integrations.

Feedback

To update one existing order or line item instead, select a tab and choose **Upsert an existing row** in the output method section.

Feedback

1.  Map the fields that DigiParser should write.
2.  Add one or more **match rules**. Each rule maps a parser field to a Google Sheet column. For example, map parser `PO Number` to sheet `Order Number`. For line items, add a second rule for a product code.
3.  Add status and enrichment values in parser post-processing, then map those parser fields to the sheet.
4.  Save the integration.

Feedback

During upsert, DigiParser compares trimmed, case-insensitive key values. It updates only mapped non-empty parser values. Empty extracted values do not clear a populated cell. Unmapped cells, formulas, formatting, and validation stay unchanged.

Feedback

By default, DigiParser stops the export when more than one destination row matches. Select **Update all matching rows** when one value must be applied to every matching row, such as every employee row for the same company. If a match key is empty, DigiParser always stops that tab export.

Feedback

This works well for staged order workflows. Add the status in post-processing so exports, CSV files, API responses, and Google Sheets all use the same value.

## [When data is sent](#when-data-is-sent)

Feedback

Data is sent after processing. A document adds one row to the mapped **Fields** tab. Each extracted table row adds one row to its mapped table tab.

Feedback

If you use **Reviews & Approvals** and a reviewer is assigned, exports wait until the document is **approved**. If no reviewer is assigned, exports run immediately after processing.

## [Tips](#tips)

Feedback

*   Use a **dedicated sheet** (or spreadsheet) for each parser so data stays organized.
*   **Column names** in the sheet don't have to match field names exactly; mapping defines where each value goes.
*   When you create a spreadsheet from DigiParser, its tabs and initial mappings are created for you.
*   If you change **Fields & Tables**, update the **mapping** so new or renamed fields are included.

## [Troubleshooting](#troubleshooting)

Feedback

*   **"Not connected"** - Connect your Google account again. If you revoke access in Google, you'll need to reconnect.
*   **"Failed to load spreadsheets"** - Check that you've granted Sheet access. Disconnect and reconnect if needed.
*   **Missing or wrong columns** - Review your **field mapping** and fix any unmapped or incorrect mappings.

## [Next steps](#next-steps)

Feedback

*   [Integrations Overview](/docs/guides/integrations/overview) - Other import and export options
*   [Exporting to Email](/docs/guides/integrations/exporting-to-email) - Send data by email
*   [Managing Data -> Exporting Data](/docs/guides/managing-data/exporting-data) - File export (CSV, Excel, JSON)

How is this guide?

GoodBad

[

Importing from Box

Connect Box and automatically process new files added to a selected folder

](/docs/guides/integrations/importing-from-box)[

Exporting to Teable

Create Teable records from extracted document fields and table rows

](/docs/guides/integrations/exporting-to-teable)