Connect QuickBooks to Google Sheets to Flag Overdue Invoice Risk with AI

Here's the FREE template: https://automationforgrowth.com/?dl=27 If you're still exporting QuickBooks invoices and payments by hand just to see what's been paid, what's overdue, and what needs follow-up first, this workflow fixes that. In this video, I connect QuickBooks to Google Sheets with Apps Script so invoices and payments sync automatically into one report. Then I add an AI layer that flags overdue invoice risk, sets follow-up priority, recommends the next action, and drafts a follow-up message for each overdue account. This workflow gives you: one sheet to review paid, open, and overdue invoices faster cash flow visibility without manual exports AI priority and risk fields for collections review draft follow-up messages your team can use right away Miscellaneous Timestamps 00:00 Intro 00:37 Final result 02:08 Why this matters 03:10 Apps Script setup 03:48 QuickBooks tokens 05:04 QuickBooks app setup 09:00 Production setup 15:20 Credentials and redirect URL 17:40 Refresh token 19:24 Final config 23:05 AI rules 24:05 Run the workflow 24:21 Review the report Thanks for watching!