Finance & Accountingfree

Sync QuickBooks chart of accounts to Google BigQuery

by Fahmi FahrezaUpdated Aug 2026

Requires

BigQuery

1/5

STEPS · 4

Runs on a schedule

On a schedule, fetches the QuickBooks chart of accounts via API and loads it into Google BigQuery.

Shopify Refunds to Sheets + Slack

Daily, scans recent Shopify orders for refunds and logs them to a Sheet while alerting finance in Slack.

Daily, finds overdue Xero invoices and emails each customer a polite reminder while flagging the total in Slack.

On a schedule, pulls records from QuickBooks and writes them to Google Sheets.