Google Sheets blocks allow you to perform various actions with tables — record, find, receive and delete data, add sheets. They can be used after Google Sheets integration according to the instructions.
The "Write data" block
Allows you to write data to a table.
1. In the "Table" field, select a table from the list that you have access to in the company settings in the "Integrations" section of your personal account, or specify a variable with the Table Id (for example, table_id).
2. In the "Sheet" field, select a sheet from the list or specify a variable. The name must match exactly with the name of the sheet in Google Sheets.
3. In the "Start cell" field, select the start cell. Data recording will begin from this cell (in A1, B3, A B C 455 format).
4. In the "Data" field, select data — a list of values to be written to the row, starting from the selected cell.
Supported: text, numbers, emoticons, variables, Google Sheets formulas, file links; If you leave the field empty, the previous value will be deleted in the table cell corresponding to this position in the list.; Google Sheets limit: no more than 50,000 characters per cell.
The "Add Sheet" block
Allows you to add a sheet to a table.
1. In the "Table" field, select a table from the list that you have access to in the Company Settings in the "Integrations" section of your Personal Account, or specify a variable with the Table Id (for example, table_id).
2. Specify the name of the sheet. Latin, Cyrillic, numbers, symbols, emojis, hieroglyphs, variables, and block results are acceptable.
The maximum length of a name is 100 characters.;
The name of the sheet must not match existing sheets (case-sensitive); If no name is specified, a name will be assigned according to the template "Sheet" + an ordinal number (for example, "Sheet 11");
Adding a sheet is not possible if the table exceeds the limit of 10 million cells.
The "Delete data" block
Allows you to delete data from the table.
1. In the "Table" field, select the desired table from the list that is available in the company settings in the "Integrations" section of your personal account, or specify a variable with the Table Id (for example, table_id).
2. In the "Function Selection" field, select the desired functions:
From Cells — deletes the contents of a cell at a specific address;
Cell list — specify a cell or a list of cells separated by commas in A1,A2,B3 format without spaces;
Offset row — deletes the row with an upward offset;
Line — specify the sequence number of the line or the range of lines;
Offset column — deletes the column with an offset to the left;
Column — specify the letter designation of the column or the range of columns.
3. In the "Sheet" field, select the desired sheet from the list or specify a variable. The name must match exactly with the name of the sheet in Google Sheets.
4. In the "List of cells" field, specify a cell or a list of cells.
The "Find data" block
Allows you to find data in a table.
I1. n the "Table" field, select a table from the list that you have access to in the Company Settings in the "Integrations" section of your Personal Account, or specify a variable with the Table Id (for example, table_id);
2. In the "Function Selection" field, select the desired function:
- All occurrences on the sheet — all matches for the key value on the sheet will be found.;
- All occurrences in the table — all matches for the key value in the table will be found. In the range and get the value from the specified column — specify the key value for column A – the value from column B of the same row will be returned.
3. In the "Sheet" field, select a sheet from the list or specify a variable. The name must match exactly with the name of the sheet in Google Sheets.
4. In the "Search method" field, select the desired search method: The keyword is an exact case—sensitive match of the text in the cell.;
Regular expression — allows you to flexibly search by template (for example, ^Product \d+). For "All occurrences in the sheet", "In range" and "Get the value from the specified column": Search text: Specify the value to be found in the specified range.; Cell Ranges:
Specify where to look for data — you can specify a single cell, row, column, or range.
You cannot specify a list.
Examples:
• A1 — one cell
• 10 — the entire line
• B — one column
• A1:Z20 — rectangular range
• A:AB — columns from A to AB
• 15:50 — rows from 15 to 50 Errors in the range format may result in an empty result or an error.
Column to return from: Specify the letter designation of the column from which you want to get the value on the same row where the key is found. Example: if the key is found in row 12 in column A, and "C" is specified, the value from cell C12 will be returned.
The "Retrieve data" block
Allows you to get data from a table.
1. In the "Table" field, select a table from the list that you have access to in the Company Settings in the "Integrations" section of your Personal Account, or specify a variable with the table ID (for example, the table_id value);
2. In the "Sheet" field, select a sheet from the list or specify a variable. The name is very easy to find using the list in Google Sheets.;
3. In the "Cell ranges" field, specify one or more cell ranges separated by commas without spaces.
Both alphanumeric and numeric designations of columns and rows are supported. The first records of the ratios are: 4,4:4; And, A:A ; A3:O 4,AA3:Bo4,D1:H5,I5:J5,D5:E7.