Convert your Google Sheets into REST APIs in 6 Minutes 😱 (and Make Projects)

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/realanujbhaiya
Telegram group: telegram.me/dsa_one
🚀 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

[@amanagarwal8887]

Wow! this is really an informative and useful video.
Thanks a lot.

[@keshavsharma5678]

Your editing skills are getting mind boggling day by day 🔥

[@AnujBhaiya]

Just trying our best to deliver the best quality content.

[@kingcoder31aug]

Yes , editing of this video is just awesome

[@InsidersPK]

@@AnujBhaiya Ab Badalna Mat Har Course apk isi trha sy chyee.
Love from PK

[@kamalkumar1729]

@@AnujBhaiya
Are you typing that fast or using some kind of tool ?
It doesn't seem natural typing.

[@parthsachan3140]

Really helpful content!! Thanks!

[@vishalkumarshaw9208]

Power of real knowledge will always get more respect that power of business mindset and attractive argumens... 🙏

[@pr.c9941]

This is the amazing skill video of your channel. I found it very helpful, keep posting

[@nufrankz]

Thanks! Works perfectly. Saludos desde Chile amigo!

[@thecodegod3852]

Amazing video bhaiya...it will definitely help us in next hackathon 🔥🔥🔥

[@prashantdahiya711]

Brilliant Editing, It's looking more professional now.

[@Vishalraj_1]

Editing level is super awesome 🔥

[@SudarshanSawantFriends]

Superb yaar this is something new to me thanks 🙏🙏🙏

[@gabrielvitor123]

Funcionou, obrigado!

[@VidishArvind]

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]

Yess right

[@Shashikantzz]

Thanks so much I was looking for this for long 😊

[@GauravGohil]

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

[@AnonymousM4]

Really next level ..👌

[@mayank2473]

Extremely thank u. This helped me very much

[@faisalzubair5065]

Anuj is it possible that we may update spreadsheet data by using API? if yes then let us know how.

[@aaman4901]

bro editing 🔥🔥🔥👏🏻👏🏻👏🏻

[@alevelsos]

Maja agaya bhai thank you so much

[@KHDGAMERPubg]

are bhai bhai op editing 🔥

[@amitavaghosh7201]

You have got a good editor...

[@PoulavBiswas]

Thank you so much for this. It is really helpful.

[@abhishekbhosale3628]

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

[@shubhamnamdeo2084]

Bhot dino bad kuch achaa dekaa maja aa gaya

[@priyanshuaggarwal5318]

Can we create these small apis for small web app?

[@0_0-0_0.]

Video editing OP 🔥🔥

[@mimanshakunj]

This is awesome stuff !

[@niranjanbaur3088]

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]

Sure, will try to make one video on this 👐

[@FaridGhori]

Very good video and style!

[@abidkhan.10]

Bhaiya aap ke pdhane ka takira muje bahut accha lagta hai 👌

[@soumyajitdutta9884]

Editing and content Bhaiyaa ❤️🔥

[@user-sn6xo2uj5m]

hi Sir we need to integrate our essl bio metric attendance with the google sheet can you provide or make the solution for it

[@prajapati_omkar]

Thanks for sharing 🙂🙌

[@harishlodha8794]

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

[@lordofperfection5528]

That editingggg huuushhh 🔥🔥

[@abhinavjungshahi1gmailcom]

Thank you brother. Your saved my failing project.

[@parassharma7762]

Mind blowing intresting 👍

[@akbar55555shaikh]

@anuj
I have received an offer from Walmart and gojek, Which is good to join in this current situation? Please suggest.

[@ruchithachowdarykothapalli8008]

when i paste web app url i got error it asking authorisation is required
is there any way to solve that error

[@AzadKumar-zi5lm]

Amazing content 😃😃😃

[@kartikkalia5672]

very helpful thanks

[@chandrabhatt]

Good man 👍🏻👏🏼

[@etcode]

Amazing content!! In the beginning I thought this video was recorded in 2x 🤯

[@hiroyukinumaguchi1984]

Great!!

[@mitrajitchandra]

Great editing

[@tophindimovie7157]

Bhaiya please make projects videos. your videos are so helpful for us.

[@Ayush-cn7tq]

thank you very much

[@kamranahmad0054]

Awesome editing..

[@snjvthakur24]

Can i update data to sheet as well via appsctipt

[@mauromsilva2]

Thank you my friend!

[@flutterwithnas]

damn good trick man.. Love from bangladesh..

[@dhruvpatel9282]

Really awesome

[@iamsantoshnayak]

But while using in a real application it gives CORS issue. Any fixes for that?

[@shuvo7919]

really great

[@sir3520]

Love you bhaiya... I met you at TED X BITD🙌

[@AmanKumar-ec6bz]

Day by day improve your editing 👍

[@ashishjakhariya1523]

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

[@FaisalKhan-oy4zz]

Editing 🔥🔥🔥

[@ani68]

Great

[@TechnicalMobileServer]

Can i build my own database like firebase...??

[@parikannappan1580]

can we move this RestAPI to HTML tables?

[@dubey_ji]

anuj bhaiya master admi hai aap

[@RAOmOUg]

Sir you used string filter
But I want to use ineger number filtering
How can I do it ?

[@NileshAkhade]

I already knew this...
but bhaai, your explanation skills are awesome. Speed and details you explain are very easy to consume.

[@AnujBhaiya]

Glad you liked it🤗

[@subscribeinsteadlike2768]

Bhai aapka editor bhari h 🔥

[@prayagcbose3862]

Please make Video on Post request also.

[@rp2804]

Subbed and noti on 🔥❤️

[@KhanStan]

thanks! needed this

[@AnujBhaiya]

Happy to help!

[@akhileshshahare]

Like for the awesome editing.

[@manishworld5533]

Nice edit

[@ParthShirawala]

Another best database is firebase relational database

[@fahhdj535]

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..

[@amitbindra873]

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.

[@majidmahmood3721]

Awesome

[@Ankitshah-gx9ct]

Please make video in node full api

[@comicalgamer7820]

Pls make a video Bsc Cs?

[@prajnadeep]

Cool

[@abdulshaikz]

Hi Anuj Bhai , aap freelancing bhi karte ho?

[@AdityaSingh-vf4de]

Can I create an API key frome this ?

[@Anuragsaha02]

Editing 👌👌😎

[@AnupamMaity]

Thanks, Can you provide me the java code?

[@sakshididwania4151]

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]

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]

@@guddupandit6786 ye bhi theek hai

[@somalis9812]

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..

[@93dssagar]

API rate limit?

[@saurabhtiwari1554]

why deploy is not happening?

[@iamsunnymac]

You got new Subscriber 👍

[@debmalyapan53]

editing op

[@sameergaikwad222]

gmail automation ka video upload karna Sir 🙏🙏🙏

[@sajalagrawal1430]

Awesome video . Btw which editing software you use

[@AnujBhaiya]

It's Final cut pro

[@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]

did the error solve?

[@niravkpatel282]

No when the sheet is access protected this will not work

[@amnnma9543]

Bro Please Make API Json Formate To Google Sheet.

[@atifhussain5505]

Main alreay bana chuka aisa API

[@demonicmotivator314]

Sir please make a stock live api i tried everything but unable to make please help 🥺🥺🥺🥺🥺🥺🥺🥺🥺🥺 🙏🙏🙏🙏🙏🙏🙏

[@mohituniyal7]

Editing 👍👍👍

[@digitronix532]

How to change image into data

[@ankitrawat7660]

@AnujBhaiya why don't you teach javascript and React on ur channel.

[@abidkhan.10]

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

[@RobertonFaustino]

not work for me

[@subhamdudheria9523]

parameter undefined aa raha hai

[@macros3798]

Script kam nahi kar raha, kuch changes ha ka? Pls😢🙏🙏🙏