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
Using this blocks you can get all rows from your sheet.
totalRow- Returns the total number of rows.totalColumn- Returns the total number of columns.loadTime- Returns the milliseconds of loading time.response Content- Returns 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- Returns the name of column.values- Returns the list of values.length- Returns 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- Returns given column name.row Number- Returns given row number.value- Returns cell value.
Search
Using this blocks you can get single column by filtering.
column Name- Enter Column name to search data.keyword- Enter text to filter data.isIgnoreCase- Set true if you want to ignore case during searching.condition- Set specific condition to apply search operation.
column Name- Returns the given column name.keyword- Returns the given keyword.values- Returns the list of matching value.positions- Returns the positions of filtered data.length- Returns the length of filtered list.condition- Returns the applied condition.
Using this blocks you can get filtered data by search from two columns.
swarchInColumn- Enter column name to search values in this column.keyword- Enter text to filter data.dataFromColumn- Enter column name to fetch data from this column.isIgnoreCase- Set true if you want to ignore case during searching.condition- Set specific condition to apply search operation.
searchInColumn- Returns given column name.keyword- Returns given text.dataFromColumn- Return given column name.values- Returns the list of matching values.positions- Returns the positions of filtered data.length- Returns the length of filtered list.condition- Returns the applied condition.
Sql Query
Use this block to run sql query operation to get filtered data from your sheet.
sql- Set sql query rules here to filter data.header- Set true if you want to get data with column names, otherwise false.
sql- Returns the given sql rules.totalRow- Returns the total row number of filtered data.totalColumn- Returns the total number of column.values- Returns filtered data in nested list format. No need to parse data. You can use in-built list component to read data.response- Returns the filtered data in csv format. You can parse them easily using in-build components.
Use this block to run query operation to get filtered data from your sheet. It’s support offline mode too.
columnsToSelect- Enter columns as list to retrieve data from selected columns.searchInColumn- Enter column name to run search operation with it’s values.keyword- Enter text to filter data.isIgnoreCase- Set true if you want to ignore case during searching.condition- Set specific condition to apply search operation.
keyword- Returns given keyword.totalRow- Returns the total amount of total rows.totalColumn- Returns the total amount of columns.values- Returns filtered values as nested list.positions- Returns all matches positions as list.searchInColumn- Returns given column name.columnsToSelect- Returns given columns as list.condition- Returns the applied condition.
Using this blocks you can get values of any row.
row Number- Enter row number to get values.
row Number- Returns the row number.values- Returns the list of values.column Names- Returns the list of column names.
Using this blocks you can get list of your sheets.
sheetNames- Returns the list of sheet names.gidIds- Returns the list of gid ids.length- Returns the length of sheet list.
Using this blocks you can get names of all columns.
column Names- Returns the list of column names.length- Returns the length of list.
Using this blocks you can get your spreadsheet project name.
spreadsheetName- Returns the name of your spreadsheet project.
Using this block you can get total amount of 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- Returns 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- Returns 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- Returns the new name.columnPosition- Returns 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- Returns 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.
column Name- Returns the name of column.value- Returns the value.row Number- Returns the number of row.
Using this blocks you can create new row with multiple cells.
values- Enter values as list to create new row.
response- Returns 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- Returns the response message as string.
Using this blocks you can create new sheet in your spreadsheet project.
sheetName- Enter new sheet name.
sheetName- Returns 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- Returns the name of column.row Number- Returns the row number.value- Returns 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- Returns the number of row.
Delete Row
Using this blocks you can delete any row by row number.
row Number- Enter row number.
row Number- Returns the number of row.
Using this blocks you can delete any column from your sheet.
column Name- Enter column name to delete.
column Name- Returns the name of column.position- Returns the position of column.
Using this blocks you can delete any sheet from your spreadsheet project.
sheetName- Enter sheet name to delete.
sheetName- Returns 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- Returns the new name of sheet.oldName- Returns the old name.
Using this blocks you can rename your project name.
name- Enter new name to rename spreadsheet project name.
name- Returns 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- Returns the old value.replaceWith- Returns 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- Returns the column name.text- Returns the old value.replaceWith- Returns 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- Returns the row number.text- Returns the old value.replaceWith- Returns 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- Returns the old value.replaceWith- Returns 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- Returns the function name which function refresh data automatically.totalRow- Returns the total number of rows.totalColumn- Returns the total number of columns.loadTime- Returns the milliseconds of loading time.response Content- Returns the Json string.
Failed
It’s rises when the extension got any error.
function Name- Returns the function name which function got error.error Message- Returns 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 ↷
○ Added AdvanceSqlQuery function.
○ Added new features in Search function.
○ Added new features in AdvanceSearch function.
○ Every search operation is now more powerful like sql.
○ I'll charge small amount for this major update.
○ Added super fast data reading features.
○ Smooth & faster data writing ability.
○ Added some new functions.
○ Available to get access in private sheet (Custom Edition).
○ Data will be encrypted with AES encryption for offline use.
○ Multi screen & multi component is now supported.
○ AES encryption & decryption functions available to protect credentials.
○ Smooth `AutoRefresh` functions.
○ Optimized `OfflineMode`.
○ New search functions with two conditions.
See more notes
(CreateColumnWith, CreateMultipleColumnWith, AddValuesToColumn, CreateMultipleRows)
Testing Video ↓
GitHub Repository ↓
Extension Specifications:
Size: 194 KB±
Version: 14.0.4 (Latest)
Released On: 26 February 2021 (GMT+06:00)
Updated On: 01 August 2024 (GMT+06:00)
GitHub Repository: SpreadSheets
Meet happy users: See post #6
Payment methods: Direct Download | PayPal | TransferWise (Wise) | Xoom | Binance | Crypto | Card Payment | UPI (
) | JazzCash (
) | Bkash (
)
Launched V9.0.0 and extension size compressed to 97.9 KB only!