Exporting to Google Sheets
Export extracted data to Google Sheets
Exporting to Google Sheets
You can send your extracted data to Google Sheets automatically. When a document is processed, new rows are added to the sheet you choose. You map your parser fields (e.g. Invoice Number, Total Amount) to sheet columns so data lands in the right place.
Where to set it up
- Open your parser and go to Settings → Integrations.
- Under Available Integrations, click Google Sheets.
- It appears under Added Integrations. Expand it to configure.
How to configure
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
- Use an existing spreadsheet – Pick it from the list. Then choose which sheet (tab) inside it to use.
- Create a new one – Use Create new spreadsheet. Enter a name (e.g. “My Invoices – Extracted Data”). A new spreadsheet is created with a Data sheet.
Map fields to columns
Map each parser field (e.g. Invoice Number, Vendor Name, Total) to a column in that sheet. You can map some or all fields. Unmapped fields are not sent. Save your choices when done.
Save
Click Save Configuration. From then on, when a document is processed, a new row is added to the selected sheet with the extracted values in the mapped columns.
When data is sent
Data is sent when a document is processed (after extraction finishes). Each processed document becomes one new row.
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
- 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.
- If you change Fields & Tables, update the mapping so new or renamed fields are included.
Troubleshooting
- “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
- Integrations Overview – Other import and export options
- Exporting to Xero – Send data to Xero
- Managing Data → Exporting Data – File export (CSV, Excel, JSON)
How is this guide?