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

Published: 24 February 2021
on channel: James Grimshaw

121,600

2.9k

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: https://github.com/jrgrimshaw/google-...
Google API Console: https://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): https://code.visualstudio.com/ Theme: Synthwave '84
Web Browser (Back on Chrome!): https://www.google.com/intl/en_uk/chr...
Terminal (iTerm, Mac only): https://iterm2.com/
MDN (where I reference JavaScript documentation): https://developer.mozilla.org/en-US/d...

----------------------------------------------------------
🔗 My Links
----------------------------------------------------------
GitHub: https://github.com/jrgrimshaw/
Instagram: / jrgrimshaw
LinkedIn: / jrgrimshaw
Personal site: https://jgrimshaw.com

#jamesgrimshaw #nodejs #googlesheets

On this page of the site you can watch the video online Control Google Sheets with Node.js / JavaScript (v4 API) with a duration of hours minute second in good quality, which was uploaded by the user James Grimshaw 24 February 2021, share the link with friends and acquaintances, this video has already been watched 121,600 times on youtube and it was liked by 2.9 thousand viewers. Enjoy your viewing!