Establishing a Connection
Connecting with the Google Spreadsheets Connection Manager
Adding a new Google Spreadsheets connection to the SSIS package is straightforward. Right-click within the Connection Manager window and select New Connection from the menu. Then, choose the Google Spreadsheets Connection Manager from the Add SSIS Connection Manager window.
Alternatively, you can create a new connection directly using the Google Spreadsheets Source or the Google Spreadsheets Destination. You can set the connection properties in the Google Spreadsheets Connection Manager window.
Google Spreadsheets uses the OAuth authentication standard. You can authorize the component to access Google APIs on behalf on individual users or on behalf of users in a domain. When you connect the component opens the OAuth endpoint in your default browser. Log in and grant permissions to the application. The component then completes the OAuth process.