Control Google Sheets with Node.js / JavaScript (v4 API)

Подписаться 2,2 тыс.

Просмотров 119 тыс.

50% 1

In this tutorial, we use the Google Sheets API v4 with Node.js & Express to completely control Google Sheets (read & write) and at the end create a demo video request application! This API can help you create anything from a totally custom "Google Forms" replica, all the way to using Google Sheets as your database solution! I hope you enjoy and find this tutorial useful!
----------------------------------------------------------
👀 Tutorial Links:
----------------------------------------------------------
GitHub Repository: github.com/jrgrimshaw/google-...
Google API Console: console.cloud.google.com
----------------------------------------------------------
💻 Commands Used:
----------------------------------------------------------
npm init
npm install express ejs googleapis
npm install -D nodemon
nodemon index.js
----------------------------------------------------------
⏰ Timestamps:
----------------------------------------------------------
0:00 Introduction
0:30 Get Google API Credentials
4:39 Setup Node.js/Express Application
8:28 Use the Google Sheets API!
20:19 Optional Extra: Create a Video Requester Demo Application!
25:39 Outro
----------------------------------------------------------
📚 Resources
----------------------------------------------------------
Editor (Visual Studio Code): code.visualstudio.com/ Theme: Synthwave '84
Web Browser (Back on Chrome!): www.google.com/intl/en_uk/chr...
Terminal (iTerm, Mac only): iterm2.com/
MDN (where I reference JavaScript documentation): developer.mozilla.org/en-US/d...
----------------------------------------------------------
🔗 My Links
----------------------------------------------------------
GitHub: github.com/jrgrimshaw/
Instagram: / jrgrimshaw
LinkedIn: / jrgrimshaw
Personal site: jgrimshaw.com
#jamesgrimshaw #nodejs #googlesheets

Опубликовано:

4 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 240

@BrandonClapp 3 года назад

Thanks for sharing. I was thinking about doing this for my mailing list, where spinning up a PostgreSQL database just for this seemed overkill. I didn't expect it to be this involved, so I'm really glad you put this together.

@jamesgrimshaw 9 месяцев назад

Building something at the moment where I need to read from a Google Sheet... I'm back here reminding myself how to do it 😂

@AxelFerrer-sw4xs 7 месяцев назад

Hi James, if i update a cell, will it show in edit history of the individual cell? I'm looking for a way to edit a cell without it showing in the edit history.

@quinojuan2 5 месяцев назад

🤣

@TraumaMedia 3 года назад

Thank you for making this. My website was using v3 and it just got deprecated this month and I was totally lost with how to read a google sheet with the v4 api. This was a life saver. Thank you!

@t-damer 3 года назад

Oh thank you, man 🙏 I've been trying to do a similar thing for three days, almost gave up and tried googling for such a video, and there you, thanks again 💪

@dub161 2 года назад

Thank you, you are a savior. I was given a test related to google sheet connector for my first dev role interview process and successfully completed because of you. Thanks a lot for creating this.

@alanhunold7546 3 года назад

I have been looking for a tutorial on how to do this for a couple months. This is the best-explained one I have come across. Thank you! I have now subscribed :)

@jamesgrimshaw 3 года назад

Wow thanks so much! More videos coming soon :)

@kamenriderinfinity 2 года назад

bruh... literally what I was looking for. Thank you for making this complicated subject easy to understand.

@sauloferreiradossantos8158 3 года назад

Thanks a lot man, you saved me here, I was requested to do a simple database using sheets API but the google documentation is awful,your explanation is very good, congrats!

@jamesgrimshaw 3 года назад

Appreciate you watching! :)

@mehrosenasir9974 11 месяцев назад

Clean, Clear, and Concise. Bravo!

@LongVuDucIcake 3 года назад

I tried some tutorial on the internet and fail. Then I find yours :). Thank you so much!

@siriusFish1 2 года назад

Thanks for this! I was bouncing around reading the docs for way too long!

@mohammadyusuf37 3 года назад

Thank you for such a great, crisp tutorial. This should be the goto place instead of the docs.

@htmlfivedev 2 года назад

THANK YOU ... FINALLY, SOMEONE SPEAKING CLEAR ENGLISH HAS MADE A TUTORIAL ON THIS TOPIC THAT TRULY HELPS ... THANK YOU !!

@a.alharasis 3 года назад

Thanks for the great explanation, quick note: you don't need to use auth in the options every time you are using googleSheets, because you already pass it in the start (when you set google sheet version and auth)

@jamesgrimshaw 9 месяцев назад

Great point :)

@my_codingchannel7479 Год назад

You made this and the website it is about and haven't made a video since 😞...... you are a good teacher...

@MarcoS-bx5uk Год назад

This is great, James, it served me perfectly. Thank you.

@zyada9334 11 месяцев назад

Thank you so much for this tutorial. it's perfect for me because I'm working with express and google sheets API.

@segunthemarketer2195 Год назад

This is a very very beautiful tutorial! Very detailed… 🙏🏽

@LiquidMasti 3 года назад

great video and content. love the teaching style keep the good work up man.

@fabricio_zm 3 года назад

This was exactly what I needed Lol Thank you so much!! Great video!!

@jamesgrimshaw 3 года назад

So glad you found it useful! :)

@corychecketts 2 года назад

You are awesome. This was just what I was looking for!

@vietcuongquach636 3 года назад

u save my day!! that a really wonderful tutorial

@re_allyedge 2 года назад

Awesome video! Sad to see that you stopped making more videos.

@saulhiram2145 3 года назад

Good video, I was reading the Google Sheet API and I don't undertand but I can

@garikmelqonyan9130 Год назад

Thanks for this great tutorial, James.

@generalpompeyo 10 месяцев назад

Great tutorial, thanks ! Worth mentioning : googleapis ONLY works on the server side. This will not work in a client side application like React or Vue alone.

@techsamar 2 года назад

Beautifully Explained!! Thanks

@mfarhanarif7476 2 года назад

Thanks Sir, Really helpful and the way explained is awsome.

@akritworanithiphong 2 года назад

Thank you, the tutorial is nicely done. :D

@pitchyq2804 2 года назад

Great explanation, pretty much got all i need to know. Thanks :)

@osherezra8460 3 года назад

Just found out the channel, thank you keep it brother great content and flow cheers

@rizzbod 9 месяцев назад

Great tutorial on working with Google sheet api , that is get starter for everyone. Thnx

@samandaryusupov6134 5 месяцев назад

THANK YOU VEEEERRRRYYY MUCH. you are the best. i am so glad i found this vid

@paulclarke4099 Год назад

Great video, thanks for making this so simp😀le compared to most other videos available on RU-vid 👍

@cloudagnostic Год назад

Thank you! Very helpful and informative.

@zeeu 2 года назад

best explanation I've ever seen

@rogue1183 3 года назад

Wow, thanks for the tutorial!

@keithpowell6564 2 года назад

Thanks for the tutorial, James. There isn't a lot of solid tutorial content surrounding the Sheets API and Node.js but yours is spot on. Do you have the link to your blog in which you take a deeper dive into working with Google Sheets API? Also - ever think about teaching a Udemy course on the subject?

@jamesgrimshaw 9 месяцев назад

I never got around to writing a blog post on this! I want to make more videos and maybe courses in the future though

@hugopachy2036 2 года назад

Hey man! Insane tutorial thanks you ! Same a lot of time

@maratiot Год назад

That’s a great tutorial regarding Google Sheets API. Your explanation is decent and very detailed. Could you make a video how to sync Google sheets with Next.js?

@benny.6588 2 года назад

Thanks brother, this was useful for me.

@eltonleao3979 3 года назад

Thanks! Awesome explanation!

@toffotin Год назад

Thanks a lot! This seems like exactly what I've been trying to make. Just trying to figure out how to make it work on a website next. I guess at least I have to secure the credentials file somehow...

@SuboptimalEng 3 года назад

Neat idea! Imma take some notes 📖

@jamesgrimshaw 3 года назад

So cool isn’t it!!

@wibu8757 Год назад

This video is exactly what I needed, thaks )

@drvision-xz7ui Год назад

Best video. Working very well for me

@landenbrewer7319 Год назад

This actually saved me. Thanks bor.

@JuanCastro-uf6er 3 года назад

thnks a lot, this video is really helpful.

@user-qh4ht1yt5j 3 года назад

Very good tutorial! Thank you.

@basparshirkooh976 2 года назад

Perfect, you saved me. THANK YOU

@phutruong9687 2 года назад

thank you so much. it's very helpful

@jmpsoliz Год назад

Thanks a lot! Great video

@giwrgosiwannidis4684 2 года назад

Great tutorial!

@jacek0720 2 года назад

Thank You! Great job!

@user-gu5ts5nx8r 2 года назад

Very helpful, thank you.

@dasdunetechnologies1695 3 года назад

Very good video clear and sharp! A little question though , any idea how to delete a row with the API ? Thanks in advance.

@noeliapardo1605 Год назад

good job male, thanks!

@juanjoroba Год назад

Thank you so much, idol!!

@iBen-ry6pj 7 месяцев назад

Quite a handful of instructions. I think is a lot easier to just create a google app script to handle the CRUD operations on google sheets. That way you only need the deployment url in your nodejs to initiate reads and writes. Thanks though, it was very informative!

@user-eu3ok8dc8b 5 месяцев назад

great video.thanks!!

@HagbardCelineOnRust 3 года назад

gj creating a video on this. you saved me some time. ty sir

@jamesgrimshaw 3 года назад

Appreciate you watching! :)

@vazsa7387 2 года назад

this was so useful thanks

@PAA537 15 дней назад

Thanks a lot!

@patrickudeh5869 Год назад

Simple to the point... Do you have any tutorial on google fit api?...

@amthebeast-lolsupportplays599 2 года назад

Thank you for this video

@DivitKalem 2 года назад

Amazing. Thanks. 👏👏

@NeloReis71 2 года назад

thank you. there should be a free no-code app to recreate this particular scenario. Custo form submitted to google sheets and read from google sheets a render as HTML.. this would cover 90% of every small business needs.

@myworldbox 2 года назад

epic tutorials bro

@MarsFrom 3 года назад

Thanks buddy!

@brianyasierjacobofuentes1294 2 года назад

fantastic !

@matheuseli165 3 года назад

great video, thanks

@vipulpawaskar 3 года назад

Dotenv module will be helpful to hide credentials details. Very Helpful... Thanks for sharing

@melihkarakaya79 3 года назад

how to do that?

@Dtomper 2 года назад

Thank you so much bro

@blink11101 3 года назад

definitely a good video, thanks for sharing

@jamesgrimshaw 3 года назад

Really appreciate you watching! :-)

@dejo095 3 года назад

One tip for you, since you share tips with us :-) npm init -y will initialize project folder with default values for you

@jamesgrimshaw 3 года назад

Great tip!

@leonardomauricio3149 2 года назад

Thanks!

@streamcalter442 Год назад

Bro I am Missing your videos, I subscribed you with hope

@afp2003d 6 месяцев назад

helpful.. thanks

@leandromendoza9216 2 года назад

Thank you !!

@chirpieful 3 года назад

Great video!

@jamesgrimshaw 3 года назад

Thank you! :-)

@josebergues 3 года назад

Great Video!

@jamesgrimshaw 3 года назад

Appreciate you watching :)

@toyinatofarati5512 2 года назад

Thank you for this great content. Unfortunately I'm experiencing difficulties implementing this. I have a basic form set up with react and nodemailer which works fine but sending the data to Google sheets returned an error: invalid credentials. Pls how do I fix this

@itmoroz 2 года назад

thank you very much !!!

@altamirsantos6030 2 года назад

Thanks guy

@JumpingDaNieL1 2 года назад

Nice Video! Please tell me, how i can read the values in sheets and use with aplications to for example show in div?

@premkumar01 10 месяцев назад

Thanks for the video @James Can I get the details about integrating the same from react ?

@beccaadolph Год назад

Thank you. Wish you would have explained Express

@pomarpeggio 2 года назад

Thank you sir

@StratexMedia 3 года назад

please make something about passport js ur explanation is really top notch

@jamesgrimshaw 3 года назад

The next series will be an authentication series!

@hiroyukinumaguchi1984 5 месяцев назад

Great!!

@nemethricsi 2 года назад

Great tutorial, thank you! I’m wondering how to handle credentials.json? I guess you won’t commit it to the git so how would you provide this file for a deployment eg Heroku?

@dasdunetechnologies1695 3 года назад

Another question about namedrange, they are listed in your Metadata variable but how to create a new one from the API ?

@tonmoitanvi1773 2 года назад

Hey James, you always try to provide something useful. it's an awesome video. since I am using an API tool of Sheet Best which is easy and secure for me, I can't apply something new.

@davidjansen41 3 года назад

THANK YOU!!!

@jamesgrimshaw 3 года назад

Glad you enjoyed! 😄

@manuelrivera3646 2 года назад

Muchas gracias

@omarruder4129 8 месяцев назад

Real nice and concise tutorial! Thanks man. I was wondering however; how it is possible to make this more modular and make the spreadsheetId dependant on the user input - which ofcourse brings us to the following point; having the right read/write permissions on the spreadsheet.

@whatyoumissed9994 8 месяцев назад

yes check alternative video from neuralnine but in python

@LucXX36 2 года назад

This is so great. Thank you. As long as I know adding Reactjs to this should not be a big deal isn't it?

@jamesgrimshaw 9 месяцев назад

Convert the node.js app to an API, and then use fetch calls to integrate with a React.js app. Should be straightforward :)

@syedaffan2104 2 года назад

@James I want to append a json object with it's values to google sheet using append. How can I do that? The rest is working fine. The only issue is I want to pass the json values be pasted in seperate columns, right now whole json object is being written to only one row as a whole.