Sheets ETL is a private tool for our own business. Every day it copies invoices from our QuickBooks Online company into our Google Sheet, so we can track open balances. It only reads data from QuickBooks and never changes it.Â
Effective November 3, 2026
This End User License Agreement ("Agreement") governs use of Sheets ETL (the "App"), software developed and operated by USA Lock and Key, LLC ("we", "us"). By connecting the App to a QuickBooks Online company or using it, you agree to this Agreement.
The App is a private integration built for our own business. It copies invoice data from our QuickBooks Online company into our Google Sheets spreadsheet. It is not sold, licensed or offered to any other business or to the public.
We grant our employees and authorized contractors a limited, non-exclusive, non-transferable, revocable license to use the App solely for our internal business purposes. No other right or license is granted.
You may not copy, distribute, sell, sublicense or provide the App to anyone outside our business; connect it to any QuickBooks company other than ours; reverse engineer it except as permitted by law; or use it in violation of the Intuit Developer Terms of Service, Google's terms or any applicable law.
The App reads invoice data from QuickBooks Online and does not modify it. How that data is handled is described in our Privacy Policy, which is part of this Agreement.
The App depends on QuickBooks Online (Intuit), Google Sheets (Google) and Amazon Web Services. Those services are provided by their owners under their own terms, and we are not responsible for their availability or changes. QuickBooks and Intuit are trademarks of Intuit Inc.; the App is not made, endorsed or supported by Intuit.
We own the App and all rights to it. Data in our QuickBooks company and spreadsheet remains ours.
THE APP IS PROVIDED "AS IS" AND "AS AVAILABLE", WITHOUT WARRANTIES OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NON-INFRINGEMENT. We do not warrant that the App will be uninterrupted or error-free or that the copied data will always be complete or current. QuickBooks Online remains the system of record.
TO THE MAXIMUM EXTENT PERMITTED BY LAW, WE ARE NOT LIABLE FOR ANY INDIRECT, INCIDENTAL, SPECIAL, CONSEQUENTIAL OR PUNITIVE DAMAGES, OR FOR LOSS OF DATA, PROFITS OR BUSINESS, ARISING FROM USE OF OR INABILITY TO USE THE APP.
We may suspend or end use of the App at any time. Access can also be ended by disconnecting the App in QuickBooks Online (Settings, Apps, Connected apps). Sections 6 through 10 survive termination.
This Agreement is governed by the laws of the State of NC, without regard to its conflict of law rules.
We may update this Agreement. The effective date above shows when it was last updated, and continued use means acceptance of the updated version.
support@usalockandkey.com
Effective November 3, 2026
This Privacy Policy explains how USA Lock and Key, LLC ("we", "us") handles data accessed by Sheets ETL (the "App"), an internal integration that copies invoice data from our own QuickBooks Online company into our own Google Sheets spreadsheet. The App is used only by us, for our own business. It is not offered, sold or made available to any other business or to the public.
With our authorization through Intuit's OAuth 2.0 sign-in, the App reads invoices from our QuickBooks Online company. From each invoice it uses only:
Invoice ID and number, transaction date, due date, total amount, balance and last-updated time
The customer's display name
The values of our "Customer PO" and "Payment Type" custom fields
The App reads data only. It does not create, change or delete anything in QuickBooks Online. It does not access bank accounts, payment card data, payroll, employee records or customer contact details such as addresses, email addresses or phone numbers.
The data is used only to keep an "Invoices" tab in our company spreadsheet current, so our staff can track open balances and due dates. We do not use it for advertising, profiling or any purpose unrelated to our own bookkeeping, and we do not use it to train machine learning models.
Google Sheets: the invoice rows are written to a spreadsheet in our own Google Workspace account, shared only with our staff and with the App's Google service account.
Amazon Web Services (United States): the App runs on AWS Lambda in the US East (Ohio) region. Before each update it saves a CSV backup of the previous spreadsheet contents to a private Amazon S3 bucket. Run logs are kept in Amazon CloudWatch Logs.
Credentials: the QuickBooks OAuth tokens and the App's Google sign-in configuration are stored in AWS Secrets Manager, encrypted at rest, and are never written to the spreadsheet, logs or source code.
S3 backups and CloudWatch logs are deleted automatically after 30 days. The spreadsheet is replaced with current data on every run. If we stop using the App, we revoke its QuickBooks connection and delete its stored credentials, backups and logs.
We do not sell, rent or share this data with anyone. The only third parties that process it are the service providers that host it on our behalf: Amazon Web Services and Google. Each processes the data under its own terms and security practices. We may disclose data if required by law.
Access to the AWS account, Google account and QuickBooks company is limited to authorized personnel. All connections to QuickBooks, Google and AWS use HTTPS/TLS. The App signs in to Google through short-lived credentials rather than a stored long-term key, and access tokens are refreshed and rotated as Intuit requires.
The App's access can be revoked at any time from QuickBooks Online (Settings, Apps, Connected apps, then disconnect the App). After disconnecting, the App can no longer read any QuickBooks data.
We may update this policy if the App changes. The effective date above shows when it was last updated.
support@usalockandkey.com