TKCN

GetSheetValues()

Info

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

⁠

Connect to Google Sheets

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.