Export to Google Sheets
Connect Google Sheets and append each invoice as a 14-column row, with re-exports updating the existing row.
Export to Google Sheets
Admin+The Google Sheets export writes each document as a row in a spreadsheet, so you get a running ledger you can sort and filter. Connecting Google Sheets is an admin or owner action. Once it is connected, anyone with the member role and above can run an export.
Connect Google Sheets
Open Integrations
In the dashboard, open Settings, then the Integrations tab.
Connect Google Sheets
Find the Google Sheets card and click Connect. You go to Google's sign-in screen.
Approve access
Review the access Google asks for and click Allow. Google sends you back to the Integrations tab.
A spreadsheet is created for your organization the first time you export. If the spreadsheet is later deleted in Google Drive, the next export creates a fresh one.
The 14 columns
Each document becomes one row with these columns, in this order.
| # | Column | # | Column |
|---|---|---|---|
| 1 | Date | 8 | Discount |
| 2 | Type | 9 | Total |
| 3 | Vendor | 10 | Status |
| 4 | Number | 11 | Tags |
| 5 | Currency | 12 | Source |
| 6 | Subtotal | 13 | Filename |
| 7 | Tax | 14 | Document ID |
Export a document
Open Documents, open a row menu, and click Export to Sheets. To export several at once, select the documents and click Sheets in the batch bar.
Re-exporting a document does not duplicate it. Inbox Ledger finds the existing row by its Document ID and updates that row in place.
Automatic export
If you turn on the Google Sheets target as an auto-export, every new document is appended on its own as it is captured. A manual export you run by hand does not retry on failure.
Related
Exports overview
Compare every export target.
Export to Google Drive
Upload original PDFs into a folder.
Export failed
Fix a stalled or rejected export.
Ready to try this?
Inbox Ledger turns your inbox into clean accounting data. The free tier includes 10 credits, refilled every 30 days.
Start free