How do I access Google Sheets in a Shared Google Drive?

How do I access Google Sheets in a Shared Google Drive?

To access Google Sheets in a Shared Google Drive you have the following two options:

Option 1:
You should enter for "File Path" the Google Drive file's identifier.
You will find the file identifier in the Google Sheets URL. Please look at the screenshot below:



You should copy/paste and enter the file identifier value for FilePath parameter. This can be seen in the screenshot below:



Option 2:
You should enter for "FilePath" the whole file path with "@shared" at the front of the path.  The FilePath value should look the following way:
@shared/SharedDriveName/MainFolder/Subfolder1/Subfolder2/File_Name
For example: @shared/Cozyroc/TestFiles/Test_5
In the example above "Cozyroc" is my Shared Google Drive name , "TestFiles" is the name of the folder where the file is located and "Test_5" is the
name of the Google Sheets file I want to access. You can see how it should be configured in the screenshot below:




    • Related Articles

    • How to manually generate a Google Services Token?

      A token-based authentication system allows users to enter their username and password in order to obtain a token, which allows them to fetch a specific resource, without using their username and password. Once their token has been obtained, the user ...
    • How to upload an Excel file to Google Drive as a Google Spreadsheet

      In order to upload an Excel file to Google Drive as Google Spreadsheet you need to: Create a project in Visual Studio. To establish a Connection Manager to Google Drive, you need to use a Google Drive Connection (see Quick Start >> Establish ...
    • Where can I find the documentation for the Google Drive Connection?

      You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page.  Specific documentation for the Google Drive Connection can be found at the following link.  For many of the components you can find ...
    • Where can I find the documentation for the Google Sheets Connection?

      You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page.  Specific documentation for the Google Sheets Connection can be found at the following link.  For many of the components you can find ...
    • Where can I find the documentation for the Zoho Sheet Connection?

      You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page.  Specific documentation for the Zoho Sheet Connection can be found at the following link.  For many of the components you can find ...