Explore step-by-step guides, troubleshooting tips, and best practices to make the most of G-Accon. Whether you're setting up integrations, automating reports, or optimizing workflows, our help center has everything you need to succeed.
Wiki Menu
Event-Driven Refreshes
New FeatureG-Accon for QuickBooks Online
External G‑Accon API
Event-Driven Refreshes via External API
Automatically refresh reports, dashboards, and data pipelines in real time using G-Accon's External API. Trigger updates based on business events, transactions, or workflow actions — eliminating scheduled refreshes and ensuring users always have the most current data.
⚡
Real-Time
Updates on every business event
🔗
Open API
Trigger from any external system
🚫
No Schedules
Eliminate cron-based refreshes
✓ QuickBooks Online|✓ Google Sheets|✓ Custom Workflows|✓ Zapier / Make / n8n|✓ REST / Webhook
What is the External G‑Accon API?
G‑Accon's External API has been introduced for QuickBooks Online users. It allows you to trigger automations from outside the G‑Accon product — for example, directly from your own systems, CRMs, ERPs, or custom workflows.
Traditional data pipelines rely on scheduled refreshes — running every hour, every night, or at fixed intervals. The problem is that your data is already stale the moment something changes in QuickBooks. A new invoice, a payment received, a vendor bill posted — none of these trigger your Google Sheets to update.
With the External API, G-Accon flips this model. Instead of polling on a timer, your reports and dashboards refresh exactly when something happens — triggered by the event itself.
How Event-Driven Refreshes work
1
Business Event Occurs
Invoice paid, bill posted, transaction recorded in QuickBooks Online.
2
API Call Triggered
Your system, workflow tool, or webhook fires a POST request to the G-Accon External API.
3
G-Accon Executes
G-Accon pulls fresh data from QuickBooks and updates the target Google Spreadsheet instantly.
✓
Dashboard Updated
Reports, KPI dashboards, and data pipelines reflect the latest data — no waiting, no manual refresh.
Watch: External API in action
See how to set up and trigger an event-driven refresh using the G-Accon External API with QuickBooks Online.
Try it yourself — Interactive demo
It's an open API. Step through this short interactive walkthrough to see exactly how the External API call is structured and what it triggers inside G-Accon.
Common use cases
💸
Payment Received
When a customer pays an invoice in QuickBooks, trigger a refresh of your A/R dashboard and cash flow report automatically.
🧾
New Bill Posted
A vendor bill is created or approved — instantly update your A/P aging report and expense tracker in Google Sheets.
📦
Sales Order Closed
Sales order fulfilled in your CRM or ERP? Fire the API to refresh your revenue pipeline and P&L without lifting a finger.
🔁
Month-End Close
Trigger your full suite of financial reports — P&L, Balance Sheet, Cash Flow — the moment your accounting team marks month-end complete.
⚙️
Zapier / Make / n8n
Connect the External API as a step in any automation platform. No code required — use it alongside hundreds of other apps.
🖥️
Custom Application
Call the API directly from your internal tools, dashboards, or scripts — giving your team a "Refresh Now" button tied to live QuickBooks data.
What you can trigger from
Because it's an open REST API, you can call it from virtually any system that can make an HTTP POST request:
Automation platforms — Zapier, Make (Integromat), n8n, Power Automate
CRM and ERP systems — Salesforce, HubSpot, Pipedrive, and more
Custom code — Python, JavaScript, cURL, Postman
Webhooks — any platform that fires a webhook on an event
QuickBooks webhooks — chain directly from a QBO event notification
Internal dashboards and portals — add a "Refresh" button to your own tools
💡 The External API is designed to be simple — a single authenticated POST call is all it takes to trigger a full G-Accon refresh cycle for any spreadsheet connected to QuickBooks Online.
Scheduled vs. Event-Driven — why it matters
Scheduled Refresh
Event-Driven (External API)
Data freshness
Stale between runs
Always current
Trigger
Clock / cron
Business event
Unnecessary calls
Many (nothing changed)
Only when needed
Integration
G-Accon only
Any external system
Setup
Set-and-forget
One API call
Use with automation tools
Limited
Zapier, Make, n8n, custom
Get started
The External G-Accon API is now available for both QuickBooks Online and Xero users.
To get started, you'll need an active G-Accon Annual Subscription with the Plus add-on. The Plus license provides access to our External API, enabling you to integrate G-Accon with your own applications, workflows, and automation tools.
Use the interactive demo above to explore the available endpoints and see the exact API call structure.
You can connect the API to your preferred workflow platform or call it directly from your own systems to trigger report refreshes, automate data processing, and build event-driven integrations.
Questions? We're here to help.
Reach out to the G-Accon team or browse the documentation to learn more about the External API.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
