Control Google Sheets with Node.js / JavaScript (v4 API)
117.6 هزار بار بازدید -
3 سال پیش
-
In this tutorial, we use
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: Instagram: jrgrimshaw
LinkedIn: LinkedIn: jrgrimshaw
Personal site: https://jgrimshaw.com
#jamesgrimshaw #nodejs #googlesheets
----------------------------------------------------------
👀 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: Instagram: jrgrimshaw
LinkedIn: LinkedIn: jrgrimshaw
Personal site: https://jgrimshaw.com
#jamesgrimshaw #nodejs #googlesheets
3 سال پیش
در تاریخ 1399/12/06 منتشر شده
است.
117,689
بـار بازدید شده