Get spreadsheet data
warning This BLOCK is currently in beta. The beta version will become unusable after the official version is released.
Some functions may not work properly during the beta. We appreciate your feedback regarding bugs or ways to improve MAGELLAN BLOCKS.
warning Self-Service Plan users (including trial version users) must enable the Google Sheets API. For more information on enabling the API, please refer to Enabling Google APIs.
This BLOCK loads data from a spreadsheet in Google Drive into a variable.
The data stored into the variable is the same format as the data used with the Create spreadsheet BLOCK. For details, refer to the Create spreadsheet BLOCK reference page.
info_outline All data is handled as strings regardless of the data type in the cell.
info_outline To target files that already exist in Google Drive (i.e. not created/saved using G Suite BLOCKS), you must share the files with the email address for your GCP service account. You can view the email address of your GCP service account in the “GCP service account” section of “Board settings”.
|BLOCK name||Configure the name displayed on this BLOCK.|
|GCP service account||Select the GCP service account to use with this BLOCK.|
Designate the name of the spreadsheet containing the data that will be loaded into a variable.
If there are multiple files with the same name, the BLOCK will load data from the first file it finds.
You can also enter the URL of the file. You can use the sharing link or the URL from the address bar of the file.
You can use expanded variables in this property.
|Output variable||Designate the variable that will store the data from the spreadsheet.|
|BLOCK memos||Make notes about this BLOCK.|
|Parent folder||Designate name of folder that contains the target spreadsheet. Use this property when spreadsheets with the same file name exist in multiple folders and you want data from a specific file.|
Designate the worksheet that contains the target data. If left blank, data will be loaded from the first worksheet.
|Starting cell (A1 notation||Designate the starting cell (A1 notation) for reading data from the spreadsheet. If left blank, data will be read starting from cell A1.|