Control Google Sheets with Node.js / JavaScript (2021)

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-sheets-node
Google API Console: https://console.cloud.google.com
Request a Tutorial! https://videorequest.jgrimshaw.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/chrome/
Terminal (iTerm, Mac only): https://iterm2.com/
MDN (where I reference JavaScript documentation): https://developer.mozilla.org/en-US/docs/Web/JavaScript

----------------------------------------------------------
🔗 My Links
----------------------------------------------------------
GitHub: https://github.com/jrgrimshaw/
Instagram: https://instagram.com/jrgrimshaw
LinkedIn: https://linkedin.com/in/jrgrimshaw
Personal site: https://jgrimshaw.com
#jamesgrimshaw #nodejs #googlesheets

Видео Control Google Sheets with Node.js / JavaScript (2021) канала James Grimshaw