Before you use Google Sheets V2 Connector, you must complete the following prerequisite tasks:
1Ensure you have a Google service account to access Google Sheets.
2Ensure you have the OAuth 2.0 client ID, client secret, and refresh token values for the project. You require these details when you create a Google Sheets V2 connection in Data Integration.
For more information about generating the OAuth 2.0 client ID, client secret, and refresh token, see the Google Sheets documentation.
3Ensure that you have enabled the Google Sheets API and Google Drive API for your project. Google Sheets V2 Connector uses the Google APIs to integrate with Google Sheets.