Sheetgo has a native QuickBooks integration that lets you import data from QuickBooks directly into Google Sheets without any manual API setup.
Step 1: Select QuickBooks as your source
When creating a new automation, go to Select source and choose QuickBooks under the Apps & Services section.
Step 2: Connect your QuickBooks account
Click Connect account. You will be redirected to QuickBooks to authorize the connection.
Note: QuickBooks' OAuth 2.0 access token expires after 60 minutes. Read this documentation for more information:
Step 3: Configure your report parameters
After connecting your account, select a report endpoint — such as Profit & Loss, Balance Sheet, or Account List. Sheetgo automatically displays only the parameters that apply to the report you chose, so you never see irrelevant fields or have to guess what to fill in.
Dynamic form fields
Each report type has its own configuration. The form renders only the inputs that QuickBooks requires or accepts for that specific endpoint — date pickers, accounting method dropdowns, sorting options, and so on. Fields that do not apply to the selected report are not shown.
Report | Example parameters shown |
Profit & Loss | Date range, accounting method, columns |
Balance Sheet | Date range, accounting method |
Account List | Account type filter, sort order |
Smart validation
Required fields are marked with an asterisk (*). You cannot advance to the next step until all required parameters are filled in correctly. If a required field is missing or invalid, an inline error message explains what needs to be fixed before you can continue.
Conflict prevention
When you select a predefined date macro — such as This Month, Last Quarter, or This Year — Sheetgo automatically clears and disables any custom date fields. This prevents contradictory date parameters from being sent to QuickBooks, which would cause the report to return incorrect or no data.
Example: If you select Last Quarter as the date macro, the Start date and End date fields are cleared and locked. To enter custom dates, deselect the macro first.
Language support
All parameter labels, field descriptions, and error messages are available in English, Spanish, French, and Portuguese. The language displayed follows your Sheetgo account language setting.