Google Sheets

The Google Sheets Data Source

AbstractData allows for the transfer of data between other data sources and Google Sheets. The type in the scripting language is GoogleSheets and can be referenced like this:

>> # The Constructor Syntax
>> GoogleSheets sheets2 = new GoogleSheets(id ="<<see below>>", credPath = "<<see below>>", secretPath = "<<see below>>")

The only way to create a Google Sheets database reference is with the constructor syntax. There are too many variables needed to be used on a single line. It is therefore recommended to break this up into multiple Global variables. The description for each field is below.

• id = "<<The url or id of the sheet to edit>>"
  • This is the field that points to the sheet URL or just the id. The application can parse both shared URLs and regular URLS while editing
• credPath ="C:\the\path\to\the\credential\folder"
  • This is the path to the credential folder. It saves the login token for authentication with google. Once logged in, this token should be valid for a significant amount of time. If this variable changes, then the user will be prompted to login once again.
• secretPath = "C:\the\path\to\the\secret\client_secret.json"
  • This is the path to the client secret API key. This is obtained through the Google API Console. The steps for getting a client secret are in Step 1 here.