Convert your Google Sheets into REST APIs in 6 Minutes 😱 (and Make Projects)
Вставка
- Опубліковано 7 вер 2024
- Register for the GeeksforGeeks Job-A-Thon Hiring challenge for Amazon Alexa: bit.ly/3RQwTOL
Hey guys, In this video, We're going to learn how to make REST APIs by using Google Sheets and App Script. API from excel sheet.
🥳 Join our Telegram Community:
Telegram channel: telegram.me/re...
Telegram group: telegram.me/ds...
🚀 Follow me on:
Instagram: / anuj.kumar.sharma
Linkedin: / sharma-kumar-anuj
Twitter: / realanujbhaiya
💸 Use coupon code ANUJBHAIYA on GeeksforGeeks to avail discounts on courses!
📚 Complete DSA Playlist: • DSA-One Course - The C...
Complete Android Development Playlist: • Android Development Tu...
Hashtags:
#appscript #api #googlsheets
Ignore these tags:
google sheet api
google sheets api
rest api project
rest api
api projects
how to create api
google sheet
create api
google sheets
api based projects
api project
google api
how to create an api
how to create api in java
how to make api
excel api
google drive api
api google sheets
free api
google sheet database
google sheets database
google docs api
google script
how to call api in react js
how to make an api
sheety
anuj bhaiya
api creation
apps script google sheets
google sheet app script
google sheets api javascript
how to create a api
make apis for you and me
api google sheet
api rest
api to google sheets
app script api
app script in hindi
apps script api
apps script google form
Your editing skills are getting mind boggling day by day 🔥
Just trying our best to deliver the best quality content.
Yes , editing of this video is just awesome
@@AnujBhaiya Ab Badalna Mat Har Course apk isi trha sy chyee.
Love from PK
@@AnujBhaiya
Are you typing that fast or using some kind of tool ?
It doesn't seem natural typing.
Just for other referance sample code is - this will save few times
function doGet(req) {
var doc = SpreadsheetApp.getActiveSpreadsheet();
var sheet = doc.getSheetByName('Quotes1');
var values = sheet.getDataRange().getValue();
var output=[];
for(var i =0; i
Bhaiya pls make more videos like these where you deal with api creation , data scraping and data engineering by making small projects! It'd be really helpful for us.
Yess right
Power of real knowledge will always get more respect that power of business mindset and attractive argumens... 🙏
Bhaiya ,
How to make only get request from this api?
i.e how to give only read access so that no one can edit the data of the gsheet using the api
Bhaiiyaa , yee Google sheet Api k uparr ak android development ka video banaoo naa!!!
Kysee ek sheet k andaarr data write karna heyy , sheet se kysee read karnaa hey and also update...
Love you bhaiyaaa ❤️ ❤️ You are my inspiration for Android development ❤️❤️
Sure, will try to make one video on this 👐
@@AnujBhaiya I have question related to if i want to make multiple api so because url is only one how to distinguish each url for each function
Really helpful content!! Thanks!
Love you bhaiya... I met you at TED X BITD🙌
Editing level is super awesome 🔥
Brilliant Editing, It's looking more professional now.
Wow! this is really an informative and useful video.
Thanks a lot.
bhaiya, hme aisha lagta hai ki aap me india ka best coding youtybe channel banaane ki kabiliyat hai.
aap kr sakte hai.
aap ke samjhane ka tarika baki sabhi youtube channel se kafi behtar aur revolutionary lagta hai. jaise dhruv rathi ke samjhane ka tarika hai. bas aap regular ho jao.
This is the amazing skill video of your channel. I found it very helpful, keep posting
when i paste web app url i got error it asking authorisation is required
is there any way to solve that error
Hello! I prepared for Amazon's interviews watching your videos solely..
I had a question. I gave my BR round with Amazon for SDE FTE I and I received an email today asking about my preferred work location. So does it mean that I am selected for the same? Please help it's really urgent
yrr ye ni bol pa rhi pr tm log to smjh rhe ho n.....to like kro......wow,congo comment kro.....and when she starts her YT channel to subscribe bhi kr dena
@@guddupandit6786 ye bhi theek hai
Day by day improve your editing 👍
Anuj is it possible that we may update spreadsheet data by using API? if yes then let us know how.
When i am usng this method. the FRONTEND app is running into CORS error. I am using a nextjs starter kit to GET from the particular API
did the error solve?
No when the sheet is access protected this will not work
bro editing 🔥🔥🔥👏🏻👏🏻👏🏻
You have got a good editor...
Thanks so much I was looking for this for long 😊
Sir you used string filter
But I want to use ineger number filtering
How can I do it ?
are bhai bhai op editing 🔥
Amazing video bhaiya...it will definitely help us in next hackathon 🔥🔥🔥
Amazing content!! In the beginning I thought this video was recorded in 2x 🤯
Really next level ..👌
I already knew this...
but bhaai, your explanation skills are awesome. Speed and details you explain are very easy to consume.
Glad you liked it🤗
Thank you brother. Your saved my failing project.
Bhot dino bad kuch achaa dekaa maja aa gaya
Video editing OP 🔥🔥
Thanks! Works perfectly. Saludos desde Chile amigo!
There is a column in which 200 products and 300 products are written. Now I have to find out from that how many times the product of 200 is written in it. How to know? in google sheets please reply..
Extremely thank u. This helped me very much
Bhai aapka editor bhari h 🔥
Can we create these small apis for small web app?
Thanks for sharing 🙂🙌
Great editing
If I host a JSON file in any where like GitHub then I use the url as a fetch data .. what's wrong about that ? I have no idea but I used that url as a fetch data in website or app . What's the issue ? Please say .. anyone 😿😿
If you have data that is already in a JSON file format then it's all right.
@@AnujBhaiya Thanks 😃
Can we filter data there?
Tech people can update json data.. but not non techi guys... So this we can use in that scenario
Superb yaar this is something new to me thanks 🙏🙏🙏
hi Sir we need to integrate our essl bio metric attendance with the google sheet can you provide or make the solution for it
Thanks, Can you provide me the java code?
This is awesome stuff !
Editing and content Bhaiyaa ❤️🔥
Enter video 0% ideas -> 6min -> 100% ideas Exit Video
This video is quite similar to machine learning 😂😂😂😂😂😂😂
Hum aye train hue now ab hum predict karenge kya kare spread sheet k sat
Hi Anuj Bhai , aap freelancing bhi karte ho?
Thank you so much for this. It is really helpful.
Bhaiya please make projects videos. your videos are so helpful for us.
Subbed and noti on 🔥❤️
Thank you my friend!
Bhaiya open University se BCA karke kya product based company me job mil skte hai pls make a video on this lots of comments I have putted on famous tech youtuber comments section but no one made it pls bhaiya make a video on this to solve my problem 🙂🙂
Bhai bass skill chaiye leetcode gese coding platform no. Of questions solve karle lo aur 2 acche project bana lo
Overall apke resume mai dam hona chahiye degree matter nahi karte
@@harshmore8869 I want to talk to you instagram message me 🙂🙂🙂
But while using in a real application it gives CORS issue. Any fixes for that?
Sir Google Play Store se beakground video recorder app se hum Jo video record karte hai
Kya vo video jo hum record karte hai vo app developer ke pass bhi save hota hai kya....
Please reply.....
Please reply
Please make a video on how to get high paying job in it industry or became software developer after 2-3 gap years after graduation... Share any strategy that could help for those have career gaps..
Can u make a video tutorial for flutter app to fetch this api?
And one more column for description which opens a new instance on clicking any college name
Bhaiya aap ke pdhane ka takira muje bahut accha lagta hai 👌
damn good trick man.. Love from bangladesh..
@anuj
I have received an offer from Walmart and gojek, Which is good to join in this current situation? Please suggest.
Like for the awesome editing.
Mind blowing intresting 👍
Very good video and style!
Amazing content 😃😃😃
really great
can we move this RestAPI to HTML tables?
Bro Please Make API Json Formate To Google Sheet.
Sir please make a stock live api i tried everything but unable to make please help 🥺🥺🥺🥺🥺🥺🥺🥺🥺🥺 🙏🙏🙏🙏🙏🙏🙏
Can i update data to sheet as well via appsctipt
Maja agaya bhai thank you so much
Can I create an API key frome this ?
Funcionou, obrigado!
thank you very much
Editing 🔥🔥🔥
sir great video...just need your opinion on this asap..please reply sir...please it would be of great help..sir mujhe ek college mein ECE mil rahi hai uski ranking 116 hain but waha 75% attendance hain and dusre college mein IT mil rahi hain but uski attendance mei koi issue nahi hai..toh which one should i opt for? please it would be of great help if you could reply sir....
Bina attendance wala collg lo off campus crack kro, dhang ke dost bnao or shuru ho jao first sem se. All the best
That editingggg huuushhh 🔥🔥
Can i build my own database like firebase...??
Please make Video on Post request also.
If we edit the Google sheet can the API be automatically updated
yes it works!
Another best database is firebase relational database
Great
Awesome editing..
Editing 👍👍👍
Nice edit
why deploy is not happening?
thanks! needed this
Happy to help!
Pls make a video Bsc Cs?
anuj bhaiya master admi hai aap
Good man 👍🏻👏🏼
very helpful thanks
Awesome video . Btw which editing software you use
It's Final cut pro
6:50 hey that's my college at 2nd 🥲
gmail automation ka video upload karna Sir 🙏🙏🙏
authorize access nahi ho raha he bhaiya
Try adding the top three lines present at 5:38
@@AnujBhaiya getDate() mei fail kar raha hai bhaiya
Please make video in node full api
Anuj bhaiya aap ek or placement course lekar aao please bhaiya muje aapke java DSA Placement Course ka bad me pata laga tha tab tak admission off ho gaye the
No entendí nada de lo que dijo pero explica tan bien que entendí lo que hizo 😂
How to change image into data
Really awesome
Cool
Great!!
@AnujBhaiya why don't you teach javascript and React on ur channel.
editing op