You can use a drive ID parameter to specify a shared drive, or leave it blank to indicate the default MyDrive. You can also run ListFiles with a search query to find specific files on your Google Drive. To list all the files on your Google Drive, run the ListFiles table. Paste the gid value into the GID Override field in the GetWorksheetV2 table and run the table again. To solve this issue, open the spreadsheet in a web browser and copy the gid value. Information noteIf you have deleted or re-added a sheet to your Google spreadsheet, you might receive an error message when you try to load a worksheet. After you have run the table, copy the generated script from the Qlik Sense or QlikView tab and paste it into the Qlik Sense Data Load Editor or the QlikView Edit data dialog. Open the ListWorksheets table and paste the key into the Spreadsheet Key field, then run the table. Next, copy the unique key for the spreadsheet that contains the worksheets that you want to list. This will not return items from the trash bin. You can also type * (asterisk) to return data from all drives. The spreadsheets are listed under the Data preview tab and each spreadsheet is identified by a unique key. To list the available spreadsheets on your Google Drive, run the ListSpreadsheets table.

To work with a particular worksheet located on your Google Drive, you first need to identify the spreadsheet that contains it. Listing and accessing Google spreadsheets Once the authentication token has been saved, it will be used to run all tables. You do not need to enter a new authentication token to run a new table.

Download google sheets