Need help with google-custom-form?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

197 Stars 55 Forks 12 Commits 17 Opened issues


Submit to a google spreadsheet using a form of your own design

Services available


Need anything else?

Contributors list

# 33,198
12 commits


Submit to a google spreadsheet using a form of your own design.

NOTE (8/4/2016):

I have updated this documentation to keep up with the changes Google has made to forms. The process now varies slightly from when this readme was originally published.


  • Build a google form with a question that you want to collect data for, and make sure it is public. View the form, and click on the "responses" tab. In the settings for the form (the 3 dots in the upper right) choose "select response destination" and make sure it logs to a new spreadsheet.

  • View the form by clicking the "eye" icon in the upper right at the top of the page.

  • On the live form page where you can submit responses, view the source of the page, and capture the URL in the

    attribute of the
    tag: ex:
    getting rid of everything after
  • Now search the source of the page for this:

and we've given our field an ID of
. You should change this to whatever information you are collecting in your form, and change the javascript so that JQuery is grabbing the right field's value. For example, if your form has an ID of
and your field has an ID of
input id="emailField"
your javascript should be changed to:
    var inputField = encodeURIComponent($('#emailField').val());
    $('#email').addClass('active').val('Thank You!');
  • Style your page how you like, put in any sort of behavior you want to have happen when someone submits an entry (we're just having the form field say 'Thank You!'), then put these files on a web server somewhere, and you should now be able to submit data to your custom form, and see it appear in your Google Spreadsheet.


Some people have asked about incorporating multiple questions, so I've included an

file which shows a form with two questions.

Essentially, you just need to make sure your submit URL looks like this:[YOURFORMID]/formResponse?entry.[YOURQUESTION1IDHERE]=[YOURQUESTION1ANSWERHERE]&entry.[YOURQUESTION2IDHERE]=[YOURQUESTION2ANSWERHERE]&submit=Submit

where you just keep separating each question and answer with an ampersand.



Good luck! I have put my own sample form online here and you can view the spreadsheet with the form responses here.

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.