Тёмный

How to build a Contact Form in Node.js and Google Sheets? 

Max Programming
Подписаться 4,7 тыс.
Просмотров 6 тыс.
50% 1

Hello, my friends and fellow developers!
In this video, we cover how you can build a contact form that integrates with Google Sheets and all the details are stored in the sheet once the form is submitted! We will use Node.js, Express and Google Sheets API to make it work.
Let me know in the comments below if you want more Node.js content or something else.
This tutorial is heavily inspired by ‪@Fireship‬. His video on using Google Sheets as a database helped me build this and many other cool projects.
Links mentioned in the video:
Google Dev Console - console.cloud.google.com/apis...
GitHub Repo - github.com/max-programming/co...
Fireship's video - • Google Sheets… Your Ne...
🔥 Timestamps Start 🔥
00:00 - Intro & Demo
01:23 - Creating the project
02:17 - Installing dependencies
03:32 - package.json changes
03:54 - Set up Google Sheets API
07:08 - Download key file
08:09 - Create and configure the sheet
09:32 - Back-end coding starts
16:17 - Set up sheet client in code
22:15 - Appending test data to sheet
26:49 - Adding user's info to sheet
30:49 - Front-end coding starts
36:24 - Outro
🔥 Timestamps End 🔥
Other Tutorials:
⚛️ React and Material UI Todo App: bit.ly/reactmattodo
🟨 Other JavaScript videos: bit.ly/jstutorials
📘 Visual Studio Code videos: bit.ly/vscodevids
🔋 Build a Battery App in JS: • 🔋 Build a Battery Info...
Connect 🔗 :
Twitter: / maxprogramming1
Facebook: / max-programming-103081...
GitHub: github.com/max-programming/
VS Code Theme used: Default Dark+
Font used: Cascadia Code
Suggest, ask doubts in the comments and share these videos to help!
Thanks for Watching!
#nodejs #javascript #programming

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

 

4 авг 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 24   
@adgancodes
@adgancodes Год назад
This is what I was looking for! Thanks!
@MaxProgramming
@MaxProgramming Год назад
Hope you understand it well 😀
@eurekaadvisor1944
@eurekaadvisor1944 Год назад
great. i am not a back end person and I am not either a front end developer, but you video has changed my life :) well done Usman. I hope I can see more videos like this one in the same direction
@user-gk8hn3xd6q
@user-gk8hn3xd6q Год назад
This worked!, Thanks
@jonathaniheme7167
@jonathaniheme7167 10 месяцев назад
works, thank you
@shivangsharma2562
@shivangsharma2562 Год назад
Nice video 🔥🔥🔥
@MaxProgramming
@MaxProgramming Год назад
Thank you very much 🙂
@conaticus
@conaticus Год назад
keep it up :)
@MaxProgramming
@MaxProgramming Год назад
Thank you very much 😊
@mdhasninesheak792
@mdhasninesheak792 Год назад
Thanks Brother Make some videos on Next js 13.
@MaxProgramming
@MaxProgramming Год назад
Sure! Thank you 🙂🙂
@Abdulazizweb
@Abdulazizweb 10 месяцев назад
Amazing Brother, can we retrieve data through excel to nodeJs and then show data using any frontend framework.
@MaxProgramming
@MaxProgramming 10 месяцев назад
Yep. You can make an API with Node and fetch data from Excel there. Then you can fetch data from the Node API in your frontend framework
@Abdulazizweb
@Abdulazizweb 10 месяцев назад
@@MaxProgramming it would be great for us if you make a video on this. Thanks a lot!
@MaxProgramming
@MaxProgramming 10 месяцев назад
@@Abdulazizweb Thank you. I'd love to do that. Thanks for the suggestion
@joaquincardillo
@joaquincardillo Год назад
I've not been able to run the server. Localhost:5000 returns a white screen wwith a message that reads 'Cannot GET /'. I swear I've followed you step by step
@MaxProgramming
@MaxProgramming Год назад
Hey come over to my discord. Let's fix your problem there. usmans.me/discord
@dianadata3626
@dianadata3626 6 месяцев назад
How to deploy the app to Netlify?
@MaxProgramming
@MaxProgramming 6 месяцев назад
You can't deploy a nodejs app to Netlify. You'd have to deploy it to a node server provider like Railway, Render, Fly, Heroku Or else you can use Netlify serverless functions (that is nodejs code Netlify can run - check the documentation), the code might be a little bit different but it's possible and free as well Here's a short tutorial on Netlify serverless functions: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NZRZJqChwa8.html
@dianadata3626
@dianadata3626 6 месяцев назад
@@MaxProgramming Ah, got it! Its straightforward to deploy with Heroku , though due to Google auth library with Node v18 issues, process.env.PRIVATE_KEY should be process.env.PRIVATE_KEY .replace(/\ /g, ' ')
@DMC888
@DMC888 9 месяцев назад
Just a small thing. You can skip putting the values in const values, just use the body object. requestBody: { values: [[body.name, body.email, body.message]],
@MaxProgramming
@MaxProgramming 9 месяцев назад
Yeah that works too. Thanks for sharing 😄
Далее
🔴Ютуб закрывают... Пока?
00:39
Просмотров 1,8 млн
Google Sheets & NextJS
30:52
Просмотров 18 тыс.
Accessing Google Sheets from Next.JS
13:20
Просмотров 6 тыс.
Why I don't use React-Query and tRPC in Next.js
18:58
Creating a Flutter App with a Google Sheets Database
16:34
Build a productivity web app that's NOT a todo list
18:55
🔴Ютуб закрывают... Пока?
00:39
Просмотров 1,8 млн