Make an API With Google Sheets and Google Apps Script

Рет қаралды 61,004

3 жыл бұрын

In this video, we'll be making our own DIY API using Google Sheets and Google Apps Script. This is an easy way to make your own database without a backend server.
The link to my example API:
rb.gy/mxwbdw
An example search using my API:
rb.gy/mxwbdw?q=JK%20Rowling
The link to a website I made using this technique:
listenr.gq/
The link to my website:
cukmekerb.github.io/

Пікірлер: 61

@kevalsanghvi3045 2 жыл бұрын

Excellent video. It was very useful. Every other video on this topic showed this by third party websites and requests are very limited. And no one other then you showed this without using such websites and also explained the whole code beautifully. Thank You for sharing your knowledge. Keep making such informative videos.

@cesarantunes4004 Жыл бұрын

Excellent, it works perfect for me, thank you very much!

@mimocrocodile5069 Жыл бұрын

Perfect. Just in time i found this video

@learning9716 10 ай бұрын

Perfect ! It's working...

@rb8058 5 ай бұрын

Coming late to this video but appreciate the walk through! Is there a way to include the column header info as tags for each row of data? Or do you have another video where you get into how to do that?

@ssj7gokurpg 2 жыл бұрын

Excellent.

@cristcaballero Жыл бұрын

perfect , thanks

@maximilianogabrielfranchve7367 Жыл бұрын

Hi! Awesome video. That's what I was looking for. I was wondering if you could make a video for POST request, as I need to send information from a chatbot to google sheet.

@videosforyou4228 2 жыл бұрын

Is it possible to use the post request from Airtable and populate that website data into google sheets?

@sumitsarkar839 2 жыл бұрын

Thank you :-)

@peterberumen854 2 жыл бұрын

I see so many people with the same issue but not solution! TypeError: Cannot read property 'parameter' of undefined (line 2, file "Code") Whats the fix??

@rajkishan3690 3 ай бұрын

Great Video.

@alexanderbelikov9876 3 жыл бұрын

Hi!) Thank you for video! Could you be so kind to advice - how to run google script from php? Thank you

@ademcihan892 2 жыл бұрын

con you help me TypeError: Cannot read property 'parameter' of undefined (satır: 2, dosya: "Kod")

@BrodieTheAthlete 2 жыл бұрын

do you have the source code any where?

@josepalomarespalacios 3 жыл бұрын

ReferenceError: propertiesService is not defined (línea 5, archivo "apis") . Any help?

@irpcplebsection9677 3 жыл бұрын

what is empty array in last row ?

@Mohamed-shehata-2023 Жыл бұрын

thanks

@inf7549 8 ай бұрын

this is like playing the Gollum game but in tutorial form for developers

@tonmoitanvi1773 2 жыл бұрын

oh, it was easy though, do you think it's better than the Sheet Best API tool? what do you think? do you have any suggestions for that?

@cukmekerb 2 жыл бұрын

I haven't heard of that one before, but I have tried similar services and they have rate limits and they're really slow

@dorjeewangchuk7752 2 жыл бұрын

TypeError: Cannot read property 'getLastRow' of null (line 7, file "Code")

@flexible8ark 3 жыл бұрын

I followed your code, but the following message came out. The following script function (doGet) could not be found. Do you know what's wrong?

@cukmekerb 3 жыл бұрын

try saving it and redeploying. sometimes gas doesn't recognize a save

@dorjeewangchuk7752 2 жыл бұрын

TypeError: Cannot read property 'getLastRow' of null (line 7, file "Code")

@jeremray4620 3 жыл бұрын

very useful thanks a lot !! how can we have the result without double "[ " I mean this = {"data":["John Smith","Just some rando"],"error":false} instead of = {"data":[["John Smith","Just some rando"]],"error":false} many thanks again

@malliditarunreddy 3 жыл бұрын

just create another empty list and push the present list into it and return the new list and you are done ; )

2 жыл бұрын

Great video! I tried it but it's giving me an error. ReferenceError: sheet is not defined (line 7, file "Code") Any ideas how to fix it?

@Ryan-tr3gs Жыл бұрын

+1 Doesn't work

@Ryan-tr3gs Жыл бұрын

Did you get it to work?

@yes_daily_motivation 2 жыл бұрын

Can we make post request too using this api? If yes, please tell how?

@cukmekerb 2 жыл бұрын

yes, just replace doGet with doPost

@watchonlinemovies2919 3 жыл бұрын

TypeError: Cannot read property 'getId' of null code.gs:24 24: PropertiesService.getScriptProperties().setProperty("key", doc.getId()) i got this errer plz.help

@cukmekerb 3 жыл бұрын

Doc is undefined

@culturauniversalTV 3 жыл бұрын

PropertiesService.getScriptProperties().setProperty("key", doc.getId());

@thesumitsingh1234 2 жыл бұрын

are there any limits to using this? I mean any restrictions on the number of such requests that can be made using this method?

@cukmekerb 2 жыл бұрын

there are but they're very high

@hamzach933 3 жыл бұрын

From where i can this wallpaper like your desktop wallpaper? Thanks!

@cukmekerb 3 жыл бұрын

It was one of the builtin MacOS ones, but they got rid of it recently :(

@hamzach933 3 жыл бұрын

@@cukmekerb Version please?

@cukmekerb 3 жыл бұрын

It’s still in mojave and maybe catalina

@kfl-appsheet6167 9 ай бұрын

Exception: Login information disallowed: may i know reason while executing appscript

@karanjoshi12 3 жыл бұрын

Hey unknown parameter error is popping up any solution for this ?

@cukmekerb 3 жыл бұрын

What exactly does the error say?

@hossainabeer 2 жыл бұрын

Hi, I literally copied every code of yours without error, and after publishing it as web page, I copied the url then pasted it, and got the following message: "Exception: Cannot convert 'function () { [native code] }' to int. (line 9, file "Code")" . Note: my sheet contains only two column of data just like yours.

@hossainabeer 2 жыл бұрын

and running the script, I got the message in terminal: "TypeError: Cannot read property 'parameter' of undefined"

@hossainabeer 2 жыл бұрын

the code: function doGet(request){ var query = request.parameter.q; var parameters = 2; var sheetname = "Sheet1"; var doc = SpreadsheetApp.openById(PropertiesService.getScriptProperties().getProperty("key")); var sheet = doc.getSheetByName(sheetname); var lastrow = sheet.getLastRow; var rows = []; var range = sheet.getRange(2, 1, lastrow, parameters); var values = range.getValues(); for(var row in values){ rows.push([]); for(var col in values[row]){ rows[row].push(values[row][col]); } } if(query != null){ var rowstoreturn = rows.filter(a => a[0] == query); return ContentService.createTextOutput(JSON.stringify({"date":rowstoreturn, "error":false})).setMimeType(ContentService.MimeType.JSON); } return ContentService.createTextOutput(JSON.stringify({"date":rows, "error":false})).setMimeType(ContentService.MimeType.JSON); } function setup(){ var doc = SpreadsheetApp.getActiveSpreadsheet(); PropertiesService.getScriptProperties().setProperty("key", doc.getId()); }

@AdamBJohnson1 3 жыл бұрын

If anyone is looking for the Apps Script code from this video, I posted it here (plus a few additional comments): gist.github.com/adamjohnson/3d1e0d6349df8ba1ccf1e45c6d8da5d1 Google Apps Script recently updated their UI. FWIW, I couldn't get this code to work, but I was working with different data. Curious if anyone here can get it working? Let us know in the comments below.

@Mohamed-shehata-2023 Жыл бұрын

thanks

@learning9716 10 ай бұрын

It's working for me.

@avasworkshop6812 3 жыл бұрын

I loved the JK Rowing part lol! So true! Nice video!! +1 sub Can you do some videos on creating desktop apps (python or java?)

@cukmekerb 3 жыл бұрын

Hey, I just watched your animatronic tutorial, it was really cool! I don't know java, but python is a really great language that I wish I could cover more. If you have any ideas for a python video, lmk. Also, I just subscribed to your channel.

@KushEzio 3 жыл бұрын

@@cukmekerb Hi i was not able to use this link in postman.. how can i do that..?