# 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.

Go to [Get Started with Linx and Google API's](https://docs.linx.software/reference/plugins/googledrive) for a quick start guide on integration to Google API's.

### Functions <a href="#functions" id="functions"></a>

**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 <a href="#types" id="types"></a>

* *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.

### Links <a href="#links" id="links"></a>

[How to get started with Linx and Google API's](https://docs.linx.software/reference/plugins/googledrive)\
[Linx Community: Linx/Google Drive Integration](https://community.linx.software/t/linx-google-drive-integration/431)\
[About Google Sheets](https://www.google.com/sheets/about/)\
[Google Developer: Introduction to the Google Sheets API](https://developers.google.com/sheets/api/guides/concepts)\
[Google Developer: A1 Notation](https://developers.google.com/sheets/api/guides/concepts#a1_notation)\
[Google Developer: How to Authorize Requests](https://developers.google.com/sheets/api/guides/authorizing)\
[Google Sheets License](https://docs.linx.software/reference/plugins/googlesheets/license)