SpreadSheets Extension - Read, write & modify data from sheets
An awesome extension to work with google spreadsheet. You can read, write and modify data from your sheets.
Google Spreadsheets Extension | Free & Fastest Database | Script-less extension. It’s 5x Faster Than Airtable. It also give you offline support once data is loaded. It’s very secure to protect your data from hackers. It can load huge amount of data. It’s very simple and easy to integrate this extension into your application. Read release notes for knowing about new features.
Extension Properties
 |
 |
Get All Rows
Using this blocks you can get all rows from your sheet. This method is mandatory before using any other blocks. You can use it in your splash screen then enjoy it’s features. No more need to use it again.
 |
totalRow - It's return the total number of rows.
totalColumn - It’s return the total number of columns. loadTime - It’s return the milliseconds of loading time. responseContent - It’s return the json string. contentSize - It’s return the size of your data. |
Get Cell
Using this blocks you can get single cell from your sheet.
 |
column - It's return the name of column.
row - It’s return the number of row. value - It’s return the value of given cell. |
Get Column
Using this blocks you can get any column from your sheet. Set 0 on max to get all values from column.
 |
column - It's return the name of column.
values - It’s return the list of values. length - It’s return the length of given column. |
Search In Column
Using this blocks you can get single column by filtering.
 |
columnName - Column name to search data.
keyword - The search text to filter data. values - It’s return the list of matching value. positions - It’s return the positions of filtered data. length - It’s return the length of filtered list. |
Advance Search
Using this blocks you can get filtered data by search from two columns.
 |
byColumn - In which column you need to search.
keyword - It’s return the search text. fromColumn - Data will be get from this column. values - It’s return the list of matching value. positions - It’s return the positions of filtered data. length - It’s return the length of filtered list. |
Get Row
Using this blocks you can get values of any row.
 |
row - It's return the number of row.
values - It’s return the list of values. columns - It’s return the list of columns. |
Get Sheet Names
Using this blocks you can get list of your sheets.
 |
sheetNames - It's return the list of sheet names.
gridIds - It’s return the list of gid ids. length - It’s return the length of sheet list. |
Get Column Names
Using this blocks you can get names of all columns.
 |
columns - It's return the list of names.
length - It’s return the length of list. |
Get Spreadsheet Name
Using this blocks you can get your spreadsheet project name.
 |
name - It's return the name of your spreadsheet project. |
Total Rows
Using this block you can get total number of all rows.
 |
It's return the total number of loaded row. |
Create Column
Using this blocks you can create new column in your sheet.
 |
columnName - It's return the name of column.
columnPosition - It’s return the position of new column. |
Create Row
Using this blocks you can create single cell in you sheet.
 |
row - It's return the number of row.
column - It’s return the name of column. value - It’s return the value. |
Create Rows
Using this blocks you can create new row with multiple cells.
 |
response - It's return the response string. |
Update Cell
Using this blocks you can update any cell.
 |
column - It's return the name of column.
row - It’s return the row number. value - It’s return the value. |
Update Rows
Using this blocks you can update any row values.
 |
row - It's return the number of row. |
Delete Row
Using this blocks you can delete any row by row number.
 |
row - It's return the number of row. |
Delete Column
Using this blocks you can delete any column from your sheet.
 |
column - It's return the name of column.
position - It’s return the position of column. |
Create Sheet
Using this blocks you can create new sheet in your spreadsheet project.
 |
sheetName - It's return the name of sheet. |
Delete Sheet
Using this blocks you can delete any sheet from your spreadsheet project.
 |
sheetName - It's return the name of sheet. |
Rename Sheet
Using this blocks you can rename any sheet from your project.
 |
newName - It's return the new name of sheet. |
Rename Spreadsheet
Using this blocks you can rename your project name.
 |
name - It's return the new name of your project. |
Refresh Data
Using this blocks you can refresh data manually if you disabled Auto Refresh. Otherwise no need to refresh data manually.
 |
functionName - It's return the function name, which is performed before data refreshed.
totalRow - It’s return the total number of rows. totalColumn - It’s return the total number of columns. loadTime - It’s return the milliseconds of loading time. responseContent - It’s return the json string. contentSize - It’s return the size of your data. |
Failed
It’s rises when this extension got or faced any error!
 |
functionName - It's return the function name which function got or faced error.
error - It’s return the error string. |
Encode Decode
Using this blocks you can protect your sheet ids and sheet name etc. Set level (1-100) and password length must be 5 or more.
➤ Release Notes ↷
Testing Video ↓
GitHub Repository ↓
Tutorial Videos ↓
Built using Rush. Used Java 8 features in source code.
Extension specifications:
Size: 110 KB
Version: 9.5.3
Last amendment: 18 January 2023
Launched V9.0.0 and extension size compressed to 97.9 KB only!