Spreadsheet

Definition

Spreadsheet is a non-visible component for storing and receiving data from a Google Sheets document using the Google Sheets API.

In order to utilize this component, one must first have a Google Developer Account. Then, one must create a new project under that Google Developer Account, enable the Google Sheets API on that project, and finally create a Service Account for the Sheets API.

Instructions on how to create the Service Account, as well as where to find other relevant information for using the Google Sheets Component, can be found here.

Row and column numbers are 1-indexed.

Properties

ApplicationName

The name of your application, used when making API calls.

CredentialsJson

The JSON File with credentials for the Service Account

SpreadsheetID

The ID for the Google Sheets file you want to edit. You can find the spreadsheetID in the URL of the Google Sheets file.