Google Sheets Form Automation

A Node.js automation project that collects data from a website contact form and automatically stores it in Google Sheets using the Google Sheets API.

This project demonstrates how websites can automate data collection and integrate with cloud services for real-time storage.

---

Features

• Website contact form for collecting user data • Node.js backend server using Express • Automatic data storage in Google Sheets • Google Sheets API integration • Clean and modern form UI • Real-time form submission handling

---

Technologies Used

• Node.js • Express.js • Google Sheets API • HTML / CSS / JavaScript

---

Project Structure

project │ ├── server.js ├── index.html ├── package.json ├── credentials.json └── .gitignore

---

Run the Project

1. Install dependencies

npm install

2. Start the server

node server.js

3. Open in browser

http://localhost:3000

---

What This Project Demonstrates

• Backend development with Node.js • Integration with external APIs • Form data automation • Cloud-based data storage using Google Sheets

---

Security Note

The file credentials.json contains sensitive API credentials and should not be uploaded to GitHub. It is included in .gitignore to keep it secure.

---

Author

Shalu Singh

GitHub: https://github.com/Shalusingh17