With GoogleDataLink you can write data and formulas into spreadsheet cells/ranges, read data from spreadsheet cells/ranges, get a list of contributors and their emails, see when the last edits to the spreadsheet were made, bulk-upload and retrieve data in a tabular structures, query/update/delete tabular data in the spreadsheet in a SQL query-like manner, add rows and columns, add/rename/delete worksheets, to name just a few features. Here are some examples:
GDLGetList returns a list of the column labels and the data matrix.
GDLListQuery returns a list of the column labels and the data matrix, filtered by the query.
GDLListUpdateByQuery updates the data that is filtered by the query in the worksheet (this can affect more than one row). This function should be used with extreme care as the existing data will be overwritten without asking for confirmation.
GDLListUpdateByRowIndex does the same as GDLListUpdateByQuery, but uses a row index instead of a query to identify the row in which to update data. Unlike GDLListUpdateByQuery this can affect only one row. This function should also be used with extreme care as the existing data will be overwritten without asking for confirmation.
GDLListDeleteByRowIndex deletes the row with the specified row index.
GDLListAddRow adds the line at the bottom of the list.
GDLListAddRows adds the lines at the bottom of the list.
The function GDLAddWorksheet[<name>,<rows>,<columns>] adds a new worksheet to the active spreadsheet with the specified number of rows and columns.