Connecting Google Sheets
1
Navigate to Integrations
Go to Settings → Integrations in your dashboard.
2
Click Connect Google
Click the Connect button next to Google Sheets.
3
Authorize Access
Sign in to your Google account and grant VATextractpermission to create and edit spreadsheets.
4
Select or Create Sheet
Choose an existing spreadsheet or create a new one for your invoice data.
Exporting to Google Sheets
Manual Export
- Select invoices in your dashboard
- Click Bulk Actions → Export to Google Sheets
- Data is appended to your connected spreadsheet
Automatic Sync
Enable auto-sync in integration settings:- New invoices automatically added to your sheet
- Updates sync when invoice data is modified
Sheet Structure
VATextractcreates a structured spreadsheet:Column headers are automatically created on first export. You can rename columns without breaking the sync.
Sharing & Collaboration
Your connected Google Sheet can be shared with team members:- Open the spreadsheet in Google Sheets
- Click Share in the top right
- Add collaborators with view or edit access
Permissions
VATextractrequests the following Google permissions:Troubleshooting
Export fails with permission error?
Export fails with permission error?
Your Google token may have expired. Disconnect and reconnect the integration in Settings.
Data appearing in wrong sheet?
Data appearing in wrong sheet?
The integration uses the first sheet in your spreadsheet by default. Select a different sheet in the integration settings.