Overview of the Google Sheets plugin

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.

Go to Get Started with Linx and Google API's for a quick start guide on integration to Google API's.

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.


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
Google Sheets License