Form Builder Generator | Google Sheets Form Creator

Build Your Form

Form Name This will be used to name your Google Sheet

Add Form Fields

Your Form Fields

No fields added yet. Add fields above to get started.

Generated Code

Generating your form code...

Deployment Steps

Create Google Apps Script

Go to script.google.com and create a new project.

Paste the generated Google Apps Script code into the editor.

// 1. Click "New Project"
// 2. Delete default code
// 3. Paste the generated code
// 4. Click Save (Ctrl+S)

Create Google Sheet

Create a new Google Sheet at sheets.google.com

Copy the Sheet ID from the URL (it's the long string after /d/)

URL: https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit
Copy: YOUR_SHEET_ID

Update Script with Sheet ID

In the Apps Script code, replace 'YOUR_SHEET_ID_HERE' with your actual Sheet ID.

// Find this line in the code:
const SHEET_ID = 'YOUR_SHEET_ID_HERE';

// Replace with your actual Sheet ID:
const SHEET_ID = '1DDAaRWCqvxFAnB5P6gKe5HffkpcCoYRU...';

Deploy as Web App

Click "Deploy" → "New deployment" → Select "Web app" → Configure:

Execute as: Me
Who has access: Anyone (or "Anyone with Google account")
Click "Deploy"

Copy the generated Web App URL - you'll need this for your JavaScript code.

Integrate with Your Website

Add the generated HTML form to your webpage.

Update the JavaScript code with your Web App URL:

// In the JavaScript code, replace this URL:
const GOOGLE_SCRIPT_URL = 'YOUR_DEPLOYED_SCRIPT_URL';

// With your actual Web App URL
const GOOGLE_SCRIPT_URL = 'https://script.google.com/macros/s/.../exec';

Form Builder