Query from a spreadsheet by ID

Returns data from a specific spreadsheet and tab by ID. Supply the spreadsheet ID in the WITH clause and reference the tab name as a table.

SELECT * FROM [My sheet]
WITH(
  SpreadSheetId='1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms'
)