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
 |
 |
Requirements
Using this blocks you can get all rows from your sheet.
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.
response Content - It’s return the Json string.
Using this blocks you can get any column from your sheet. Set 0 on max to get all values from column.
column Name - Enter column name.
max - Enter limit to get values.
column Name - It’s return the name of column.
values - It’s return the list of values.
length - It’s return the length of given column.
Using this blocks you can get single cell from your sheet.
columnName - Enter column name.
row Number - Enter row number.
column Name - It’s return given column name.
row Number - It’s return given row number.
value - It’s return cell value.
Search
Using this blocks you can get single column by filtering.
column Name - Enter Column name to search data.
keyword - Enter search text to filter data.
column Name - It’s return the given column name.
keyword - It’s return the given keyword.
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.
Using this blocks you can get filtered data by search from two columns.
byColumn - Enter column name to search.
keyword - Enter search text.
fromColumn - Enter column name to fetch data.
byColumn - It’s return byColumn name.
keyword - It’s return search text.
fromColumn - It’s return fromColumn name.
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.
Using this blocks you can get values of any row.
row Number - Enter row number to get values.
row Number - It’s return the row number.
values - It’s return the list of values.
column Names - It’s return the list of column names.
Using this blocks you can get list of your sheets.
sheetNames - It’s return the list of sheet names.
gidIds - It’s return the list of gid ids.
length - It’s return the length of sheet list.
Using this blocks you can get names of all columns.
column Names - It’s return the list of column names.
length - It’s return the length of list.
Using this blocks you can get your spreadsheet project name.
spreadsheetName - It’s return the name of your spreadsheet project.
Using this block you can get total number of all rows.
Create Column With
Using this blocks you can create new column with new values.
column Name - Enter column name to create a new column into sheet.
values - Enter column values as list.
column Name - It’s return the column name.
Using this blocks you can create multiple column in single request with new values for every column. Watch tutorial 
videos for better understanding.
column Names - Enter multiple column names as list.
values - Enter values as nested list for every column.
column Names - It’s return the names or columns as list.
Using this blocks you can create new column in your sheet.
column Name - Enter new name to create column.
column Name - It’s return the new name.
columnPosition - It’s return the position of new column.
Using this blocks you can add new values to exciting column.
column Name - Enter column name as string.
values - Enter values as list.
column Name - It’s return the name of column.
Using this blocks you can create single cell in you sheet.
column Name - Enter the column name where need to create row.
value - Enter cell value to create row.
row Number - It’s return the number of row.
column Name - It’s return the name of column.
value - It’s return the value.
Using this blocks you can create new row with multiple cells.
values - Enter values as list to create new row.
response - It’s return the response string.
Using this blocks you can create multiple new rows in a single request.
values - Enter new values as nested list for every single row.
response - It’s return the response message as string.
Using this blocks you can create new sheet in your spreadsheet project.
sheetName - Enter new sheet name.
sheetName - It’s return the name of sheet.
Update Cell
Using this blocks you can update any cell.
column Name - Enter column name.
row Number - Enter row number.
value - Enter new value.
column Name - It’s return the name of column.
row Number - It’s return the row number.
value - It’s return the value.
Using this blocks you can update any row values.
row Number - Enter row number.
column Names - Enter column names as list…
values - Enter values as list.
row Number - It’s return the number of row.
Delete Row
Using this blocks you can delete any row by row number.
row Number - Enter row number.
row Number - It’s return the number of row.
Using this blocks you can delete any column from your sheet.
column Name - Enter column name to delete.
column Name - It’s return the name of column.
position - It’s return the position of column.
Using this blocks you can delete any sheet from your spreadsheet project.
sheetName - Enter sheet name to delete.
sheetName - It’s return the name of sheet.
Rename Sheet
Using this blocks you can rename any sheet from your project.
oldName - Enter old name of sheet.
new Name - Enter new name to rename sheet.
new Name - It’s return the new name of sheet.
oldName - It’s return the old name.
Using this blocks you can rename your project name.
name - Enter new name to rename spreadsheet project name.
name - It’s return the new name of your project.
Replace All
Using this function you can replace all matching text from active sheet with new value.
text - Enter text to replace with new value.
replaceWith - Enter new value to replace with old value.
text - It’s return the old value.
replaceWith - It’s return the new value.
Using this function you can replace all matching text from column with new value.
columnName - Enter column name where you want to replace values.
text - Enter text to replace with new value.
replaceWith - Enter new value to replace with old value.
columnName - It’s return the column name.
text - It’s return the old value.
replaceWith - It’s return the new value.
Using this function you can replace all matching text from row with new value.
rowNumber - Enter row number where you want to replace values.
text - Enter text to replace with new value.
replaceWith - Enter new value to replace with old value.
rowNumber - It’s return the row number.
text - It’s return the old value.
replaceWith - It’s return the new value.
Using this function you can replace all matching text from all sheets with new value.
text - Enter text to replace with new value.
replaceWith - Enter new value to replace with old value.
text - It’s return the old value.
replaceWith - It’s return the new value.
Refresh Data
Using this blocks you can refresh data manually if you disabled Auto Refresh. Otherwise no need to refresh data manually.
function Name - It’s return the function name which function refresh data automatically.
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.
response Content - It’s return the Json string.
Failed
It’s rises when the extension got any error.
function Name - It’s return the function name which function got error.
error Message - It’s return the error message as 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 ↷
(CreateColumnWith, CreateMultipleColumnWith, AddValuesToColumn, CreateMultipleRows)
Testing Video ↓
GitHub Repository ↓
Extension Specifications:
Size: 135 KB
Version: 11.0.0 (Latest)
Released On: 26 February 2021 (GMT+06:00)
Updated On: 18 February 2023 (GMT+06:00)
GitHub Repository: SpreadSheets
Payment methods: Binance | Skrill | Wise | Pyypl | Xoom | Pay2Me | Paypal
Launched V9.0.0 and extension size compressed to 97.9 KB only!