QuickBooks Google Sheets Integration: Difference between revisions

Latest revision as of 06:00, 23 July 2025

This project extracts values from a QuickBooks Desktop Enterprise accounting system and injects those values into targeted tabs and cells in Google Sheets. This allows an automated update of documents that may be used for planning or working purposes.

The system uses a Google Script function and a Windows Rust program.

You can read a Medium article I wrote that describes it at this link.

This project is hosted on github.com. The project is entitled QB Projects

@@ Line 1: / Line 1: @@
-This project converts the installer provided by [https://hallowelt.com/en/ Hallo Welt!] into a system that can install multiple [https://bluespice.com/ BlueSpice] wikis on the same host. The original installation system used a file-based mechanism which allowed an administrator to install multiple wikis on one host; but in 2025 Hallo Welt! changed to a containerized installation using Docker which assumed one wiki per machine. In response I created this project to make the installation system more robust.
+This project extracts values from a QuickBooks Desktop Enterprise accounting system and injects those values into targeted tabs and cells in Google Sheets. This allows an automated update of documents that may be used for planning or working purposes.
-I started with the installers provided by Hallo Welt from the Blue Spice Installer page, and then working with the [https://www.warp.dev/warp-ai Warp AI] client I built a system that separated the installation into a group of shared services that would be installed once, and wiki systems that would be installed for each wiki.
+The system uses a Google Script function and a Windows Rust program.
-The system now does important things like ensure that each wiki is isolated and has its own database users and directories which are mapped from the host inside the container for the wiki.
+You can read a Medium article I wrote that describes it [https://rsdancey.medium.com/extracting-data-from-quickbooks-desktop-and-injecting-data-into-google-sheets-f8005594c44e at this link].
-I also did a quality of life improvement by creating a sendTestEmail maintenance script that can be used to ensure the SMTP settings are working, and a script called mediawiki_backup.sh which can be used to back up a wiki in a form that can then be imported during the BlueSpice initialization process.
+This project is hosted on github.com. The project is entitled [https://github.com/alderacgit/QBProjects QB Projects]
-This project is hosted on github.com. The project is entitled [https://github.com/rsdancey/BlueSpice-Multiwiki-Install BlueSpice-Multiwiki-Install]
 [[Category:Projects]]