DeanG Hi Dean,
Thanks for reaching out! :)
Sheetgo is a cloud-based tool that allows you to create connections that will copy-paste data between Google Sheets, compatible Excel files, CSV, and TSV documents stored online in OneDrive, SharePoint, Google Drive, or Dropbox. Sheetgo can also copy data from a BigQuery table into a spreadsheet, and generate emails, Google Docs, and PDFs.
After creating an account, you will allow Sheetgo to save files on your cloud storage and update them automatically — even when you’re offline or when the file is closed.
Sheetgo does not copy the content of your spreadsheets, and your files remain inside your cloud storage (Google Drive, OneDrive, SharePoint, or Dropbox).
All data transfers are made from one file to another via a secure connection. The content of your spreadsheets is never copied to another database — this means your data is as safe as the environment it is hosted in (Google Drive, OneDrive, SharePoint, or Dropbox).
Sheetgo servers are located in the US, in SOC 1, SOC 2, and ISO 27001-certified data centers. Transmission of all information between your device and our servers is protected using 256-bit TLS encryption.
In both cases, we use Google’s API to search for the information that will be transferred from one file to another but you don’t need to worry about it.
Please, let me know if I was able to help you! If not, please, feel free to reply to this message :)