Google Sheets
This page provides information for connecting Appsmith to Google Sheets and for reading and writing data in your applications.
Connection parameters

Permissions | Scope:
Options:
-
Read / Write / Delete | Selected Google Sheets: Your app has full access (read, write, and delete) only to the specific sheets you authorize. It can modify data, delete rows, remove sheets, and even delete entire spreadsheets, but only for the selected files.
-
Read / Write / Delete | All Google Sheets: Your app has full access to all spreadsheets in your Google account. This includes the ability to read and modify data, delete specific rows, remove entire sheets, and even delete entire spreadsheets.
-
Read / Write | All Google Sheets: Your app can read and modify all spreadsheets in your Google account but cannot delete entire sheets or spreadsheets. However, it can update cell values, modify rows, and clear data within sheets.
-
Read | All Google Sheets: Your app has read-only access to all spreadsheets in your Google account. It can fetch and display data but cannot make any modifications, including editing or deleting content.
Clicking Save and Authorize prompts you to log in to your Google account, where you can grant access and select the sheets your app can use.
Query Google Sheets
The following section is a reference guide that provides a complete description of all the parameters to connect to Google Sheets.

Fetch Details
This command fetches metadata for a given Spreadsheet entity. The following section lists all the fields available for the Fetch Details command.