Using Google Spreadsheets - Far better than Airtable Database

thanks for the guide @Sain_SK

1 Like

Very Nice guide Thank you so much :smiling_face_with_three_hearts: :smiling_face_with_three_hearts: :smiling_face_with_three_hearts:

1 Like
  1. ā€œClick share and public the linkā€ - this is for your spreadsheet, your spreadsheet sharing option needs to be set to ā€œanyone with the link - can viewā€ as a minimum.
  2. You use HTTP GET in your app blocks, why do you have doPost() in your script ?
1 Like

please tell me how to make category and subcategory in google sheets please guide me

"doPost(e)" in the script is for storing values from our app to spreadsheet.

1 Like

The way is more fast, convenient and free in comparison with airtable. Thank you so much :smiling_face_with_three_hearts: :smiling_face_with_three_hearts: :smiling_face_with_three_hearts:

If we use doPost or doGet it should be free from category. If it exits then entry will be recorded.

Once you get data, you use formula in sheet 2 like what you want

3 Likes

Useful Guide, Keep Up The Work.

Else if we want to get a specific row from our spreadsheet, then you have to write the following script in your Script editor:-
function doGet(e) {
return ManageSheet(e);
}
function doPost(e) {
return ManageSheet(e);
}

function ManageSheet(e) {

//CREATE NEW RECORD
if (e.parameter.func == ā€œCreateā€) {

var ss = SpreadsheetApp.getActive();

var sh = ss.getSheets()[0];

var data =[e.parameter.Name, e.parameter.PhoneNumber,e.parameter.Gmail]; 

sh.appendRow(data);

return ContentService.createTextOutput("Success");

}

else if ( e.parameter.func == ā€œReadOneRecordā€) {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
var rg = sh.getDataRange().getValues();
var outString = ā€˜ā€™;
outString += rg[parseInt(e.parameter.id)].join(ā€™**ā€™);
return ContentService.createTextOutput(outString).setMimeType(ContentService.MimeType.TEXT);
}

}

And also we have to add some additional blocks in our app:

2 Likes

I am pleased you understand that :slight_smile:

2 Likes

@Sain_SK , TimAi2 is master in that script code and all

I found some great resources on web that you can use:

  1. http://gsx2json.com ā€“ you will get pure json from any google spreadsheet with only 1 minute of setup with absolute free.

  2. https://baserow.io --alternative to Airtable and google spreadsheet with full CRUD api online with unlimited rows/tableā€¦Also you can can host your own as itā€™s opensource.

  3. GitHub - Niotron/TinyWebDB-Google-App-Script ā€“ host use TinyDB web on google spreadsheet with free script.

All above is practically used by me and very usefull.

7 Likes

I like your guide. Will be of immense help for me. Thanks

1 Like

Is it fast as well?

Yes. I havenā€™t compared to other DB options which is available in kodular but sure performance is very good even in multiple web request simultaneously.

Do you know how ro use this website?
I want to know.

http://gsx2json.com/api?id=SPREADSHEET_ID&sheet=SHEET_NUMBER&q=QUERY
Call this using web component to get json format

3 Likes

i also have some issues please helped .

and your issues are ?

my data is not insert in google spreadsheet

. i upload the image please helped me