-
Go to Google Forms & Sign In
-
Create a new form
- Follow this exact template (you can choose whatever name for the form)
- Press the dropdown menu to the right of the "Send" button & press "Get Pre-Filled Link"
- Enter all forms with random data & press "Get Link", a popup will appear then press "Copy Link".
- Save / copy these values from your link for later
Google Link
Your google link will look something like this, save & copy it for later.
https://docs.google.com/forms/d/e/1FAIpQLSfdIbWTo8S9oS1cVD1EKnJ0DUBupWHb1nma0FdBvtnPuZauqw/viewform?usp=pp_url&entry.1321823232=a&entry.1709481087=a
Entry ID(s):
The "entry" value(s) after your form id, like so -
entry.1321823232, entry.1709481087
Save these for later.
- Go back to your Google Form, press on "Responses" & "Create spreadsheet"
- Under line 34 in the file
index.html
Put your Google Entry ID(s) & Google Form Link you collected from earlier to the corresponding variables.
1st entry ID is "Name", 2nd entry ID is "Email"
// Put your Google Entry Form ID Here
var Google_Entry_ID_Name="entry.39168894";
var Google_Entry_ID_Email="entry.39168894";
// Put your Google Form Link Here (Make sure to use correct link as documented)
var Google_Form_Link="https://docs.google.com/forms/d/e/1FAIpQLSfdIbWTo8S9oS1cVD1EKnJ0DUBupWHb1nma0FdBvtnPuZauqw/formResponse?"
- Deploy to your hosting provider! Github Pages etc.
Enjoy! :) All responses will be collected in your spreadsheet!