SQL examples for ODBC

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Google Sheets.

• Execute sheet actions (delete rows / columns)
• Insert a row into a sheet
• Insert multiple rows into a sheet from a CSV file
• Query from a custom cell range
• Query from a spreadsheet by ID
• Query from the default spreadsheet
• Update multiple rows in a sheet from a CSV file
• Update values vertically (column mode)
• Write a row to a custom cell range
• Write values vertically (column mode)