Extensions

A lot of buttons share the same parameters, which are going to be skipped in the Buttons section.

SpreadsheetID

You can either fill it out manually for each button or set up spreadsheetID variable in your INIT button if you intend to use a single Spreadsheet.

Spreadsheet ID can be retrieved by going to your spreadsheet in the browser and copying it from the URL: https://docs.google.com/spreadsheets/d/YOURSPREADSHEETID/edit?usp=sharing

SheetName

Name of the particular Sheet you want to Get or Edit data in.

Range
Range you wish to Get or Edit data in, such as A1:B10.

Dimension
Major dimension to Get or Edit data in.

For example, if you use the Get Data command and set the range to A1:B10 and your dimension to ROWS, it will return 10 stacks, each containing one row (first stack will be A1-B1 values, second one A2-B2 values, etc.).

If you change your dimension to COLUMNS, it will return 2 stacks, each containing 1 column (first stack will be A1-A10 values and second stack will have B1-B10 values).

Values (applies to Append Data, Update Data and Batch Update commands)

You can send values to the extension in two different ways:

1. A string of values separated by | marking individual cells. For example, if you want to insert values in A1:A7 range (make sure dimension is COLUMNS), you can enter them like this: Monday|Tuesday|Wednesday|Thursday|Friday|Saturday|Sunday.
2. A stringified array. All values from the array will be inserted into the selected range, starting from position 0 and ending with the last position.
   1. Create an array with some entries.
   2. Use Stringify Array command.
   3. Insert the stringified array variable in the Values field.

Append by value/array
Appends values to a spreadsheet, either by a single variable or an array. Must be either a single column or single row.

Update Data
Same as Append Data command, except it will update (=overwrite) data in the selected range instead of appending them.

Batch Update
This is a very important button to understand if you want to perform update data batch requests. Instead of sending multiple single requests, use Batch Update command instead.

Please remember that you share write request quota with all other users using the extension, so try your best to group up your Update Data requests.

1. Send ‘Google Sheets Batch Update’ command and specify the amount of requests.
2. Send all your following Update Data requests as you normally would.
3. The extension will queue up the requests and wait for the last request to send them all at once. If you fail to supply all requests within the next 10 seconds, the queue will be deleted and resetted. Simply said, either all requests are sent or none.

Get Data
Retrieves data based on the range and dimension, and saves them into an object.

Find Data
Matches a string/value to a cell in a single column or row and returns its coordinates + related values. Must be an exact match. Finds the first occurence only.

Create SpreadSheet
Creates a new SpreadSheet. The extension can only modify spreadsheets specifically created with this command.

There will be a hidden sheet added to every spreadsheet you create. This sheet serves as sort of a look up sheet for Find Data command. Please don’t delete or rename it.

Duplicate Sheet
Duplicates an existing sheet.

Add Sheet
Adds a new sheet to the selected SfalsedSheet

Copy Paste
Copies data from the source to the destination

Auto Fill
Fills in more data based on existing data.

Find Replace
Finds and replaces data in cells over a selected rfalse.

Split Text
Splits a column of text into multiple columns, based on a delimiter in each cell.

Sort Range
Sorts data in rows based on a sort order per column.

Randomize
Randomizes the order of the rows in a selected rfalse.

Merge Cells
Merges cells for row or column.

Unmerge Cells
Unmerges previously merged cells.

Clear Data
Clears all data in the selected rfalse.

Insert Range
Inserts cells into a range, shifting the existing cells over or down.

Delete Range
Deletes a range.

Delete Duplicates
Removes rows within this range that contain values in the specified columns that are duplicates of values in any previous row. Removes duplicates with different letter cases, formatting, or formulas.