Google Drive – How to Store Form Data

databaseemailgoogle sheets

I have a webpage where i am having a textbox preferbaly for storing email address.

I need to create an email intake database where i need a simple database built to store emails of users “signing up” .

One of the ways i am thinking this is using an excel document on Google docs other being a standalone DB.

Can anyone share links/pointers/tutorials regarding same.

Best Answer

Try using the Forms functionality that is already provided by Google: http://support.google.com/docs/bin/answer.py?hl=en&answer=87809

This help article shows you how to set up a form, and the form responses go to a Google Spreadsheet with all of the data. You could create a simple form that asks users to enter an email address and hit "Submit"

The easiest way to create a form is:

  • Create a Google Spreadsheet
  • Click Form > Create Form
  • Add your question(s) and edit your question types

Once the form is created:

  • Click Form > Embed Form in a Webpage

You can then use the <iframe> to embed the form onto your site.