Class GoogleSheets

Provides an interface for syncing localization data to a Google Sheet.

Inheritance

object

GoogleSheets

Namespace: UnityEditor.Localization.Plugins.Google

Assembly: Unity.Localization.Editor.dll

Syntax

public class GoogleSheets

Constructors

Name	Description
GoogleSheets(IGoogleSheetsService)	Creates a new instance of a GoogleSheets connection.

Properties

Name	Description
SheetsService	The sheets provider is responsible for providing the SheetsService and configuring the type of access. SheetsServiceProvider.
SpreadSheetId	The Id of the Google Sheet. This can be found by examining the url: https://docs.google.com/spreadsheets/d/SpreadsheetId/edit#gid=SheetId Further information can be found here.
UsingApiKey	Is an API key being used or is it an OAuth?

Methods

Name	Description
AddSheet(string, NewSheetProperties)	Creates a new sheet within the Spreadsheet with the id SpreadSheetId.
CreateSpreadsheet(string, string, NewSheetProperties, ITaskReporter)	Creates a new Google Spreadsheet.
ExecuteRequestAsync<TResponse, TClientServiceRequest>(TClientServiceRequest)
ExecuteRequest<TResponse, TClientServiceRequest>(TClientServiceRequest)
GetColumnTitles(int)	Returns all the column titles(values from the first row) for the selected sheet inside of the Spreadsheet with id SpreadSheetId. This method requires the SheetsService to use OAuth authorization as it uses a data filter which reuires elevated authorization.
GetRowCount(int)	Returns the total number of rows in the sheet inside of the Spreadsheet with id SpreadSheetId. This method requires the SheetsService to use OAuth authorization as it uses a data filter which reuires elevated authorization.
GetRowCountAsync(int)	Asynchronous version of GetRowCount(int) Returns the total number of rows in the sheet inside of the Spreadsheet with id SpreadSheetId. This method requires the SheetsService to use OAuth authorization as it uses a data filter which reuires elevated authorization.
GetSheets()	Returns a list of all the sheets in the Spreadsheet with the id SpreadSheetId.
OpenSheetInBrowser(string)	Opens the spreadsheet in a browser.
OpenSheetInBrowser(string, int)	Opens the spreadsheet with the sheet selected in a browser.
PullIntoStringTableCollection(int, StringTableCollection, IList<SheetColumn>, bool, ITaskReporter, bool)	Pulls data from the Spreadsheet with id SpreadSheetId and uses columnMapping to populate the collection.
PushStringTableCollection(int, StringTableCollection, IList<SheetColumn>, ITaskReporter)	Extracts data from collection using columnMapping and sends it to the sheet inside of the Spreadsheet with id SpreadSheetId. This method requires the SheetsService to use OAuth authorization as an API Key does not have the ability to write to a sheet.
PushStringTableCollectionAsync(int, StringTableCollection, IList<SheetColumn>, ITaskReporter)	Asynchronous version of PushStringTableCollection(int, StringTableCollection, IList<SheetColumn>, ITaskReporter) Extracts data from collection using columnMapping and sends it to the sheet inside of the Spreadsheet with id SpreadSheetId. This method requires the SheetsService to use OAuth authorization as an API Key does not have the ability to write to a sheet.
SendBatchUpdateRequest(string, params Request[])
SendBatchUpdateRequest(string, IList<Request>)
SendBatchUpdateRequestAsync(string, IList<Request>)