To authenticate with a service account, you will need to register an application to obtain the OAuth JWT values. OAuth also enables you to use a service account to connect on behalf of users in a Google Apps domain. To access Google APIs on behalf on individual users, you can use the embedded credentials or you can register your own OAuth app. Instead, use the OAuth 2.0 authentication standard. If you want to view a list of information about the spreadsheets in your Google Drive, execute a query to the Spreadsheets view after you authenticate.ĬlientLogin (username/password authentication) has been officially deprecated since Apand is now no longer available. You can connect to a spreadsheet by providing authentication to Google and then setting the Spreadsheet connection property to the name or feed link of the spreadsheet. If you have not already done so, create a new Google Sheets connection by clicking From Google Sheets on the ribbon. In this example, you will use the Orders table however, the same process will work for any table thatĬan be retrieved by the CData Excel Add-In. This technique is useful if you want to work on Google Sheets data in Excel and update changes, or if you have a whole spreadsheet you want to import into Google Sheets. This article explains how to transfer data from Excel to Google Sheets.
The CData Excel Add-In for Google Sheets enables you to edit and save Google Sheets data directly from Excel.
0 kommentar(er)
