Create Datasource. This will redirect to the config page, where scopes can be configured. You can create a Google Sheets data source with one of either of the two permission scopes listed below:
Read and Write: This scope allows you to use all the methods available within Appsmith's Google Sheets integration. You will be asked to provide read and write access to your Google Sheets as well as Google Drive.
Read Only: This scope allows limited access to methods that would list or read your Google Sheets. In order to use this scope, you must provide read access to both Google Sheets and Google Drive.