The GetSheetValues() function is a convenient way to get punctual information from Google Sheets and it’s not necessary to set up a Sync Table.
Parameters
SpreadsheetId: The unique id associated with your spreadsheet. The ID can be found in the URL of the spreadsheet. This value will autocomplete by searching for the docs name.
Example: https://docs.google.com/spreadsheets/d/1k9leEZ2IrrMi-O_J2rhB6Ch8QHYaqHaVG4Zqt81ohSM/edit#gid=0
SheetId: The unique id of the ‘tab’ within the spreadsheet. The first sheet is always 0 . The value will be availble for autocompletion after the SpreadsheetId is filled out.
Example: https://docs.google.com/spreadsheets/d/1k9leEZ2IrrMi-O_J2rhB6Ch8QHYaqHaVG4Zqt81ohSM/edit#gid=120526743
Range: the range of cells in typical A1Notation. If you want to select a single cell, just give the coordinate, such as B3 . Default is blank , meaning all the cells of the selected tab - if provided - or the first one.
👉 Note: the formula always returns an array for each row even if you provided a single cell. In that case, to have the only value of the array, you might want to add First() to the formula:
GetSheetValues([account-name], "1k9leEZ2IrrMi-O_J2rhB6Ch8QHYaqHaVG4Zqt81ohSM", 0 , "B3").First()
Example
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (