No video
Convert your Google Sheets into REST APIs in 6 Minutes 😱 (and Make Projects)
Рет қаралды 205,732
Күн бұрын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
@keshavsharma5678 2 жыл бұрын
Your editing skills are getting mind boggling day by day 🔥
@AnujBhaiya 2 жыл бұрын
Just trying our best to deliver the best quality content.
@kingcoder31aug 2 жыл бұрын
Yes , editing of this video is just awesome
@InsidersPK 2 жыл бұрын
@@AnujBhaiya Ab Badalna Mat Har Course apk isi trha sy chyee. Love from PK
@kamalkumar1729 2 жыл бұрын
@@AnujBhaiya Are you typing that fast or using some kind of tool ? It doesn't seem natural typing.
@GauravGohil 4 ай бұрын
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
@VidishArvind 2 жыл бұрын
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.
@shivamraiofficial 2 жыл бұрын
Yess right
@parthsachan3140 2 жыл бұрын
Really helpful content!! Thanks!
@niranjanbaur3088 2 жыл бұрын
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 ❤️❤️
@AnujBhaiya 2 жыл бұрын
Sure, will try to make one video on this 👐
@sachinahuja9640 14 күн бұрын
@@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
@amanagarwal8887 2 жыл бұрын
Wow! this is really an informative and useful video. Thanks a lot.
@vishalkumarshaw9208 2 жыл бұрын
Power of real knowledge will always get more respect that power of business mindset and attractive argumens... 🙏
@Vishalraj_1 2 жыл бұрын
Editing level is super awesome 🔥
@pr.c9941 2 жыл бұрын
This is the amazing skill video of your channel. I found it very helpful, keep posting
@thecodegod3852 2 жыл бұрын
Amazing video bhaiya...it will definitely help us in next hackathon 🔥🔥🔥
@sakshididwania4151 2 жыл бұрын
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
@guddupandit6786 2 жыл бұрын
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
@kaushikmitra28 2 жыл бұрын
@@guddupandit6786 ye bhi theek hai
@prashantdahiya711 2 жыл бұрын
Brilliant Editing, It's looking more professional now.
@faisalzubair5065 2 жыл бұрын
Anuj is it possible that we may update spreadsheet data by using API? if yes then let us know how.
@abhishekbhosale3628 2 жыл бұрын
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
@AnonymousM4 2 жыл бұрын
Really next level ..👌
@Shashikantzz 10 ай бұрын
Thanks so much I was looking for this for long 😊
@NileshAkhade 2 жыл бұрын
I already knew this... but bhaai, your explanation skills are awesome. Speed and details you explain are very easy to consume.
@AnujBhaiya 2 жыл бұрын
Glad you liked it🤗
@sir3520 2 жыл бұрын
Love you bhaiya... I met you at TED X BITD🙌
@user-vp9yz1wg3u Жыл бұрын
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
@yashkalia2311 5 ай бұрын
did the error solve?
@niravkpatel282 5 ай бұрын
No when the sheet is access protected this will not work
@amitavaghosh7201 2 жыл бұрын
You have got a good editor...
@aaman4901 2 жыл бұрын
bro editing 🔥🔥🔥👏🏻👏🏻👏🏻
@amitbindra873 2 жыл бұрын
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.
@ruchithachowdarykothapalli8008 6 ай бұрын
when i paste web app url i got error it asking authorisation is required is there any way to solve that error
@KHDGAMERPubg 2 жыл бұрын
are bhai bhai op editing 🔥
@shubhamnamdeo2084 2 жыл бұрын
Bhot dino bad kuch achaa dekaa maja aa gaya
@prajapati_omkar 2 жыл бұрын
Thanks for sharing 🙂🙌
@nufrankz Жыл бұрын
Thanks! Works perfectly. Saludos desde Chile amigo!
@mimanshakunj 2 жыл бұрын
This is awesome stuff !
@mayank2473 9 ай бұрын
Extremely thank u. This helped me very much
@0_0-0_0. 2 жыл бұрын
Video editing OP 🔥🔥
@SudarshanSawantFriends 2 жыл бұрын
Superb yaar this is something new to me thanks 🙏🙏🙏
@soumyajitdutta9884 2 жыл бұрын
Editing and content Bhaiyaa ❤️🔥
@abdulshaikz 2 жыл бұрын
Hi Anuj Bhai , aap freelancing bhi karte ho?
@priyanshuaggarwal5318 2 жыл бұрын
Can we create these small apis for small web app?
@PoulavBiswas Жыл бұрын
Thank you so much for this. It is really helpful.
@RAOmOUg 4 ай бұрын
Sir you used string filter But I want to use ineger number filtering How can I do it ?
@AmanKumar-ec6bz 2 жыл бұрын
Day by day improve your editing 👍
@abhinavjungshahi1gmailcom 4 ай бұрын
Thank you brother. Your saved my failing project.
@etcode Жыл бұрын
Amazing content!! In the beginning I thought this video was recorded in 2x 🤯
@mitrajitchandra 2 жыл бұрын
Great editing
@maityamit2003 2 жыл бұрын
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 😿😿
@AnujBhaiya 2 жыл бұрын
If you have data that is already in a JSON file format then it's all right.
@maityamit2003 2 жыл бұрын
@@AnujBhaiya Thanks 😃
@akashaher1001 2 жыл бұрын
Can we filter data there?
@KhanStan 2 жыл бұрын
Tech people can update json data.. but not non techi guys... So this we can use in that scenario
@comicalgamer7820 2 жыл бұрын
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 🙂🙂
@harshmore8869 2 жыл бұрын
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
@comicalgamer7820 2 жыл бұрын
@@harshmore8869 I want to talk to you instagram message me 🙂🙂🙂
@subscribeinsteadlike2768 2 жыл бұрын
Bhai aapka editor bhari h 🔥
@abidkhan.10 2 жыл бұрын
Bhaiya aap ke pdhane ka takira muje bahut accha lagta hai 👌
@rp2804 2 жыл бұрын
Subbed and noti on 🔥❤️
@parassharma7762 2 жыл бұрын
Mind blowing intresting 👍
@FaridGhori Жыл бұрын
Very good video and style!
@tophindimovie7157 2 жыл бұрын
Bhaiya please make projects videos. your videos are so helpful for us.
@gabrielvitor123 11 ай бұрын
Funcionou, obrigado!
@alevelsos 2 жыл бұрын
Maja agaya bhai thank you so much
@mauromsilva2 5 ай бұрын
Thank you my friend!
@somalis9812 2 жыл бұрын
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..
@idk6070 2 жыл бұрын
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....
@priyanshu3658 2 жыл бұрын
Bina attendance wala collg lo off campus crack kro, dhang ke dost bnao or shuru ho jao first sem se. All the best
@akbar55555shaikh 2 жыл бұрын
@anuj I have received an offer from Walmart and gojek, Which is good to join in this current situation? Please suggest.
@AzadKumar-zi5lm 2 жыл бұрын
Amazing content 😃😃😃
@flutterwithnas Жыл бұрын
damn good trick man.. Love from bangladesh..
@harshrathore8200 2 жыл бұрын
authorize access nahi ho raha he bhaiya
@AnujBhaiya 2 жыл бұрын
Try adding the top three lines present at 5:38
@asap5973 2 жыл бұрын
@@AnujBhaiya getDate() mei fail kar raha hai bhaiya
@sajalagrawal1430 2 жыл бұрын
Awesome video . Btw which editing software you use
@AnujBhaiya 2 жыл бұрын
It's Final cut pro
@harishlodha8794 2 жыл бұрын
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
@ashishjakhariya1523 2 жыл бұрын
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
@shuvo7919 8 ай бұрын
really great
@KhanStan 2 жыл бұрын
thanks! needed this
@AnujBhaiya 2 жыл бұрын
Happy to help!
@fahhdj535 2 жыл бұрын
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..
@akhileshshahare 2 жыл бұрын
Like for the awesome editing.
@AnupamMaity 4 ай бұрын
Thanks, Can you provide me the java code?
@ani68 2 жыл бұрын
Great
@FaisalKhan-oy4zz 2 жыл бұрын
Editing 🔥🔥🔥
@lordofperfection5528 2 жыл бұрын
That editingggg huuushhh 🔥🔥
@snjvthakur24 10 ай бұрын
Can i update data to sheet as well via appsctipt
@user-sn6xo2uj5m 9 ай бұрын
hi Sir we need to integrate our essl bio metric attendance with the google sheet can you provide or make the solution for it
@mohituniyal7 2 жыл бұрын
Editing 👍👍👍
@ParthShirawala 2 жыл бұрын
Another best database is firebase relational database
@parikannappan1580 10 ай бұрын
can we move this RestAPI to HTML tables?
@Ayush-cn7tq 7 ай бұрын
thank you very much
@anurupreddy4575 Жыл бұрын
If we edit the Google sheet can the API be automatically updated
@vishnusharda Жыл бұрын
yes it works!
@demonicmotivator314 2 жыл бұрын
Sir please make a stock live api i tried everything but unable to make please help 🥺🥺🥺🥺🥺🥺🥺🥺🥺🥺 🙏🙏🙏🙏🙏🙏🙏
@iamsantoshnayak 2 жыл бұрын
But while using in a real application it gives CORS issue. Any fixes for that?
@prayagcbose3862 2 жыл бұрын
Please make Video on Post request also.
@dubey_ji Жыл бұрын
anuj bhaiya master admi hai aap
@kartikkalia5672 2 жыл бұрын
very helpful thanks
@AdityaSingh-vf4de Жыл бұрын
Can I create an API key frome this ?
@amnnma9543 9 ай бұрын
Bro Please Make API Json Formate To Google Sheet.
@comicalgamer7820 2 жыл бұрын
Pls make a video Bsc Cs?
@hiroyukinumaguchi1984 11 ай бұрын
Great!!
@chandrabhatt 2 жыл бұрын
Good man 👍🏻👏🏼
@kamranahmad0054 2 жыл бұрын
Awesome editing..
@saurabhtiwari1554 Жыл бұрын
why deploy is not happening?
@TechnicalMobileServer 2 жыл бұрын
Can i build my own database like firebase...??
@prajnadeep 2 жыл бұрын
Cool
@dhruvpatel9282 2 жыл бұрын
Really awesome
@Ankitshah-gx9ct 2 жыл бұрын
Please make video in node full api
@manishworld5533 2 жыл бұрын
Nice edit
@abidkhan.10 2 жыл бұрын
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
@93dssagar 2 жыл бұрын
API rate limit?
@digitronix532 5 ай бұрын
How to change image into data
@sameergaikwad222 2 жыл бұрын
gmail automation ka video upload karna Sir 🙏🙏🙏
@mayankverma2127 16 күн бұрын
code is not working
@contextbreak 2 жыл бұрын
Can we implement POST api in this sheet?
@AnujBhaiya 2 жыл бұрын
Yes, doPost()
@debmalyapan53 2 жыл бұрын
editing op
@atifhussain5505 2 жыл бұрын
Main alreay bana chuka aisa API
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 189 М.
Harley Quinn with the Joker
Рет қаралды 14 МЛН
Unfold Data Science
Рет қаралды 190 М.
Sachin Gupta
Рет қаралды 21 М.
TechLever
Рет қаралды 69 М.
Harley Quinn with the Joker
Рет қаралды 14 МЛН