Skip to content
ClickRuntime

Connect Google Sheets to QuickBooks

Many small businesses keep billing lists, timesheets and expense logs in Google Sheets while the books live in QuickBooks. Connecting the two removes the retyping: rows become invoices and expenses, and invoice status flows back into a sheet anyone can read.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and QuickBooks

Invoices, bills, expenses and customer lists kept in step between your sheets and QuickBooks. These are ready-made starting points. Anything else you can describe works too.
On a schedule

Keep a Google Sheet of every QuickBooks invoice

Your sheet always lists every QuickBooks invoice with its customer, amount, due date and balance, updated every hour.

See how it works
On a schedule

Turn rows in a billing sheet into QuickBooks invoices

Each new row in your billing sheet becomes a QuickBooks invoice, and the invoice number is written back into the row.

See how it works
Every 15 min + polling the sheetAI

Log emailed supplier invoices in a sheet and create bills once approved

Supplier invoices from your inbox are logged as rows in your payables sheet, and each one becomes a QuickBooks bill when you mark it Approved.

See how it works
On a schedule

Remind customers about overdue invoices and log each chase

Every weekday, customers with overdue QuickBooks invoices get a reminder, each chase is logged in your sheet, and you get a summary email.

See how it works
On a schedule

Add expenses from a sheet into QuickBooks

Expenses your team lists in a Google Sheet are added to QuickBooks within the hour and marked as uploaded.

See how it works
On a schedule

Welcome every new QuickBooks customer by email

Each customer you add to QuickBooks gets a welcome email from your Gmail, and is logged in a sheet so nobody is welcomed twice.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and QuickBooks, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and QuickBooks automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and QuickBooks in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Only create invoices from rows where "approved" is yes and the customer exists in QuickBooks; otherwise write the error to the row.

Each month, write a summary tab with revenue by customer and the change from the previous month.

Use cases

Why people connect Google Sheets and QuickBooks

How the two apps work together

  • A schedule or a check every few minutes reads QuickBooks Online invoices, payments or reports.
  • The script writes rows to Google Sheets with the fields you choose.
  • Rows marked ready in the sheet create invoices, customers or bills in QuickBooks.

  • Bookkeepers reviewing invoices

    Open invoices with customer, amount and due date are copied to a sheet. Ageing is easy to sort.

  • Small businesses invoicing from a sheet

    Rows for billable work become QuickBooks invoices. Invoicing takes less time.

  • Owners building their own reports

    Profit and loss lines are written to a sheet monthly. Charts and forecasts use real numbers.

  • Accountants checking expenses

    Expenses are listed by vendor and category for review. Errors are found before closing.

More apps

Google Sheets, QuickBooks and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Payment received alerts

When a QuickBooks invoice is paid, update my sheet and post the amount to #finance.

Overdue list by email

Every Monday, update my invoices sheet and email me a list of invoices over 30 days overdue.

Match Stripe payouts

Each day, add Stripe payouts to my sheet next to QuickBooks deposits and flag ones that do not match.

Setup

Connect Google Sheets and QuickBooks once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

QuickBooks

Accounting

  1. At developer.intuit.com, create an app for QuickBooks Online and Payments with the com.intuit.quickbooks.accounting scope.
  2. Under Keys and credentials, open Production, fill in the app details (EULA and privacy URLs, host domain) and finish the Compliance questionnaire, which takes roughly 20 to 40 minutes.
  3. Add https://clickruntime.com/oauth/callback as a redirect URI.
  4. In the ClickRuntime dashboard, open Connections, choose QuickBooks and enter the production Client ID and Secret, then approve access to your company.

FAQ

Questions about connecting Google Sheets and QuickBooks

Does it work with QuickBooks Online?
Yes. It uses the QuickBooks Online accounting API through your own connected Intuit account. QuickBooks Desktop is not supported.
Will it create duplicate invoices?
No. Each row is marked with the QuickBooks invoice or expense number once it's created, and rows that already have one are skipped.
Can my accountant still see everything in QuickBooks?
Yes. Everything is created as normal QuickBooks records, so reports, reconciliation and your accountant's access are unchanged.
Which sheet layout do I need?
Any layout with a header row works. Tell your AI assistant which columns hold the customer, amount and date, and the script reads those.
Can it create customers?
Yes. If a customer does not exist, the script can create them before the invoice.
Can it read reports like profit and loss?
Yes. QuickBooks Online report data can be written to the sheet.
Does it work with multiple QuickBooks companies?
Yes. Connect each company and tell the script which one to use.

Related pages

Keep exploring

Tell your assistant what Google Sheets and QuickBooks should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude