ai-agent

Form-to-Google-Sheets: Easy Form Data

Name: Form-to-Google-Sheets: Easy Form Data
Author: jamiewilson

Store HTML form submissions in Google Sheets. For founders needing simple form data management.

4,744 stars831 forksJavaScriptQuality 8/10Updated 1/17/2026100% free · open source

What it does

Stores HTML form submissions directly into a Google Sheets spreadsheet for easy data management and analysis.

Install / run

Clone the repository from https://github.com/jamiewilson/form-to-google-sheets

When to use it

•You need to collect simple data from users through a web form
•You want to track form submissions without building a custom backend
•You prefer to manage and analyze form data using Google Sheets

Quick start

1Create a new Google Sheets spreadsheet and note its ID
2Set up a Google Cloud Platform project and enable the Google Sheets API
3Create credentials for your project (OAuth client ID) and download the JSON key file
4Configure the form-to-google-sheets script by setting the SPREADSHEET_ID and CLIENT_SECRET_FILE environment variables
5Deploy the script to a server or use a service like Vercel or Netlify to handle form submissions

Ready-to-paste prompt

curl -X POST https://your-deployed-script.com/submit -H 'Content-Type: application/json' -d '{"name":"John Doe","email":"john@example.com"}'

Heads up: You must enable the Google Sheets API and set up a service account with the correct permissions to read and write to your Google Sheets spreadsheet, and also set the SPREADSHEET_ID and CLIENT_SECRET_FILE environment variables correctly

Saves to your device