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.

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

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

[@parthsachan3140]

Really helpful content!! Thanks!

[@thecodegod3852]

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

[@prashantdahiya711]

Brilliant Editing, It's looking more professional now.

[@nufrankz]

Thanks! Works perfectly. Saludos desde Chile amigo!

[@gabrielvitor123]

Funcionou, obrigado!

[@Vishalraj_1]

Editing level is super awesome 🔥

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

[@SudarshanSawantFriends]

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

[@abhinavjungshahi6174]

Thank you brother. Your saved my failing project.

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

[@Shashikantzz]

Thanks so much I was looking for this for long 😊

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

[@PoulavBiswas]

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

[@aaman4901]

bro editing 🔥🔥🔥👏🏻👏🏻👏🏻

[@hiroyukinumaguchi1984]

Great!!

[@AnonymousM4]

Really next level ..👌

[@amitavaghosh7201]

You have got a good editor...

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

[@soumyajitdutta9884]

Editing and content Bhaiyaa ❤️🔥

[@priyanshuaggarwal5318]

Can we create these small apis for small web app?

[@etcode]

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

[@0_0-0_0.]

Video editing OP 🔥🔥

[@parikannappan1580]

can we move this RestAPI to HTML tables?

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

[@alevelsos]

Maja agaya bhai thank you so much

[@mimanshakunj]

This is awesome stuff !

[@tophindimovie7157]

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

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

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

[@KHDGAMERPubg]

are bhai bhai op editing 🔥

[@abidkhan.10]

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

[@prajapati_omkar]

Thanks for sharing 🙂🙌

[@FaridGhori]

Very good video and style!

[@parassharma7762]

Mind blowing intresting 👍

[@ruchithachowdarykothapalli8008]

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

[@shubhamnamdeo2084]

Bhot dino bad kuch achaa dekaa maja aa gaya

[@akbar55555shaikh]

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

[@RAOmOUg]

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

[@lordofperfection5528]

That editingggg huuushhh 🔥🔥

[@DhananjayKumar-sl9fl]

Hi Anuj, I need your help to read Google sheets in my Maven project

[@snjvthakur24]

Can i update data to sheet as well via appsctipt

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

[@AmanKumar-ec6bz]

Day by day improve your editing 👍

[@AzadKumar-zi5lm]

Amazing content 😃😃😃

[@chandrabhatt]

Good man 👍🏻👏🏼

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

[@flutterwithnas]

damn good trick man.. Love from bangladesh..

[@FaisalKhan-oy4zz]

Editing 🔥🔥🔥

[@kamranahmad0054]

Awesome editing..

[@dubey_ji]

anuj bhaiya master admi hai aap

[@kartikkalia5672]

very helpful thanks

[@subscribeinsteadlike2768]

Bhai aapka editor bhari h 🔥

[@mitrajitchandra]

Great editing

[@sir3520]

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

[@mauromsilva2]

Thank you my friend!

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

[@Ayush-cn7tq]

thank you very much

[@iamsantoshnayak]

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

[@rp2804]

Subbed and noti on 🔥❤️

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

[@dhruvpatel9282]

Really awesome

[@prayagcbose3862]

Please make Video on Post request also.

[@ryadav3363]

Bhaiya please full stack web development ka course normal
Html css and js use karke
Plss

[@shuvo7919]

really great

[@TechnicalMobileServer]

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

[@comicalgamer7820]

Pls make a video Bsc Cs?

[@akhileshshahare]

Like for the awesome editing.

[@abdulshaikz]

Hi Anuj Bhai , aap freelancing bhi karte ho?

[@ParthShirawala]

Another best database is firebase relational database

[@KhanStan]

thanks! needed this

[@AnujBhaiya]

Happy to help!

[@Anuragsaha02]

Editing 👌👌😎

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

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

[@Ankitshah-gx9ct]

Please make video in node full api

[@ani68]

Great

[@AdityaSingh-vf4de]

Can I create an API key frome this ?

[@iamsunnymac]

You got new Subscriber 👍

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

[@manishworld5533]

Nice edit

[@93dssagar]

API rate limit?

[@debmalyapan53]

editing op

[@sajalagrawal1430]

Awesome video . Btw which editing software you use

[@AnujBhaiya]

It's Final cut pro

[@sameergaikwad222]

gmail automation ka video upload karna Sir 🙏🙏🙏

[@majidmahmood3721]

Awesome

[@demonicmotivator314]

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

[@atifhussain5505]

Main alreay bana chuka aisa API

[@EduVivaldi]

No entendí nada de lo que dijo pero explica tan bien que entendí lo que hizo 😂

[@ankitrawat7660]

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

[@macros3798]

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

[@amnnma9543]

Bro Please Make API Json Formate To Google Sheet.

[@saurabhtiwari1554]

why deploy is not happening?

[@AnupamMaity]

Thanks, Can you provide me the java code?

[@umeshkaushik710]

Low level design in java , Course lunch krdo bhaiya

[@prajnadeep]

Cool