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.
 |
 |
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.
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.
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 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 new sheet in your spreadsheet project.
sheetName - Enter new sheet name.
sheetName - It's return the name of sheet.
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.
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.
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.
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.
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.
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.
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.
com.jewel.spreadsheets.aix (123 KB)
⚙️ Version: 10.0.1
💰 Price: $15 USD (Premium Edition) - [Speed and validity is encreased. Unlocked all of functions but plan upgrade limitation remain. Recommend for mid budget users.]
💰 Price: $20 USD (Platinum Edition) - [Speed and validity is more extended. Remain upgrade limitation. Recommend for all.]
💰 Price: $25 USD (Flash Edition) - [More validity and no speed limitations & updates are totally free! Tested with 1M rows! Recommend for higher end budget only.]
💰 Price: $30 USD (Speedster Edition) - [Everything is unlocked and premium. No limitations & lifetime support! Tested with 2M rows! Recommend for higher end budget only.]
💰 Price: $50 USD (🛃 Custom Edition) - [More 🔐 secure and you can order me to customize the extension for your need.]
🌎 Last amendment: 09 February 2023
⚖️ License: Terms & Conditions
🤝 Supported builder: Kodular, Niotron, AppZard, AndroidBuilder, App Inventor and it's other distributions.