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.
Google SheetsQuickBooksXeroWorkflow AuditTrigger AuditLive Dashboard
What You Can Do
📋
Workflow Audit
Track all automated processes — statuses, run times, and errors in one place.
⏱
Trigger Audit
View Google Trigger statuses and execution times behind your workflows.
📊
Live Dashboard
Visual overview with direct spreadsheet links for instant error investigation.
Video Walkthrough
G-Accon Academy — Automation Audit Log
Interactive Demo — Try It Yourself
Interactive Walkthrough — step through at your own pace
Step-by-Step Instructions
1
Open the Automation Audit Log
In Google Sheets go to Extensions → G-Accon for QuickBooks (or G-Accon for Xero) → Tools → Automation Audit Log.
2
Enter a Spreadsheet Name
Type a name in the Spreadsheet name field. This becomes the name of the audit workbook that will be generated.
3
Enable Workflow Audit Log
Toggle on Workflow Audit Log to track all automated processes — statuses, run times, and any errors that occurred.
4
Enable Trigger Audit Log
Toggle on Trigger Audit Log to view the statuses of the Google Triggers running behind your automated workflows.
5
Generate the Dashboard
Click Save / Generate. A Dashboard spreadsheet is created showing all Google Triggers and Workflow statuses with direct spreadsheet links.
✓
Dashboard Live
Reports, trigger statuses, and linked spreadsheets now reflect live automation data — no manual checking required.
The Three Audit Tabs
After a few automation cycles run, three tabs appear in your audit spreadsheet:
📋 Tab 01
Workflow Audit Log
All active spreadsheets, run times, spreadsheet URLs, and whether any errors occurred during the refresh process.
⏱ Tab 02
Trigger Audit Log
All Google Triggers with associated spreadsheets, URLs, and the exact time each trigger was executed.
📊 Tab 03
Dashboard
Visual overview of running triggers and workflows. Problematic spreadsheets are linked for quick investigation. A second graph shows the most recently triggered worksheets.
Audit vs. No Audit
Without Automation Audit
With Automation Audit
Error visibility
Failures are silent
✓ Errors flagged with links
Run-time tracking
Manual logging only
✓ Automatic timestamps
Trigger status
Unknown
✓ Live per-trigger view
Investigation speed
Open each sheet manually
✓ Click link in dashboard
Reset capability
Delete and recreate manually
✓ One-click Regenerate
💡 Need to reset? Open the Automation Audit Log dialog again and click Regenerate to rebuild all three tabs from scratch.
📌 Available for: G-Accon for QuickBooks Online and G-Accon for Xero. Requires an active G-Accon subscription.
🤝 Work Together with Your Team
Share your Automation Audit spreadsheet with colleagues so everyone can monitor workflow health, track trigger activity, and investigate errors — all in real time inside Google Sheets.
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.
