GoogleSheets

Google Sheets, which is a part of Google Drive, is a free web-based application for creating and editing spreadsheets.

The Linx GoogleSheets plugin contains the Functions and Types that enable users to programatically integrate with Google Sheets.

Functions

DeveloperMetadata

  • GetDeveloperMetadata: Returns the developer metadata for a specified spreadsheetId and metadataId.
  • SearchDeveloperMetadata: Returns all developer metadata matching the specified DataFilter values.

Speadsheets

  • BatchUpdateSpreadsheet: Applies one or more updates to a spreadsheet.
  • CreateSpreadsheet: Creates a spreadsheet, returning the newly created spreadsheet.
  • GetSpreadsheet: Returns the spreadsheet for the specified spreadsheetID.
  • GetSpreadsheetByDataFilter: Returns the subsets of spreadsheet data as per the provided dataFilters and spreadsheetID.

Sheets

  • CopySheetTo: Copies a single sheet from a spreadsheet to another spreadsheet.

Values

  • AppendValues: Appends values to a spreadsheet.
  • BatchClearValues: Clears one or more ranges of values from a spreadsheet.
  • BatchClearValuesByDataFilter: Clears one or more ranges of values from a spreadsheet.
  • BatchGetValues: Returns one or more ranges of values from a spreadsheet.
    Note: Use A1 Notation to specify the range, e.g. SheetName!A1:G100.
  • BatchGetValuesByDataFilter: Returns one or more ranges of values that match the specified data filters.
  • BatchUpdateValues: Sets values in one or more ranges of a spreadsheet.
  • BatchUpdateValuesByDataFilter: Sets values in one or more ranges of a spreadsheet.
  • ClearValues: Clears values from a spreadsheet.
  • GetValues: Returns a range of values from a spreadsheet.
    Note: Use A1 Notation to specify the range, e.g. SheetName!A1:G100.
  • UpdateValues: Sets values in a range of a spreadsheet.

Types

  • DataFilter: Filter that describes what data should be selected or returned from a request.
  • DataFilterValueRange: A range of values whose location is specified by a DataFilter.
  • SpreadsheetUpdateRequest: A single kind of update to apply to a spreadsheet.
  • Spreadsheet: Resource that represents a spreadsheet.
  • ValueRange: Data within a range of the spreadsheet.


Also see

How to get started with Linx and Google API's
Linx Community: Linx/Google Drive Integration
About Google Sheets
Google Developer: Introduction to the Google Sheets API
Google Developer: A1 Notation
Google Developer: How to Authorize Requests