Sheet Monkey was designed to make it as simple as possible to send data from your website into a Google Sheet without any backend code and minimal configuration.
Every Sheet Monkey forms starts with a unique url (or a form action) where you can post your data. This url is available with every form you create in the Sheet Monkey dashboard. This form action is your connection to the Google Sheet.
Once you have your form action then you can follow three rules to send your data into the linked Google Sheet.
When building your HTML form the input names must match a column name in the linked Google Sheet.
<input type="text" name="Column 1" /><!-- In this example, anything submitted with this fieldwill be inserted beneath "Column 1" in the linked sheet -->
Each time the form is submitted, Sheet Monkey will append that submission to the bottom of the form as a new row.
When you submit a field with a name that Sheet Monkey doesn't recognize, it will automatically add it to the end of the spreadsheet.
<input type="text" name="Column 1" /><!-- Here's a field that doesn't exist in the spreadsheet --><input type="text" name="New Column" />
With this method, you can link your forms to a blank sheet and Sheet Monkey will automatically build the header fields for you the first time you submit the form.
Sheet Monkey was designed to give you as much control over appearance and validation as you want. Because of this all of our HTML is merely a suggestion. You can design your forms as creatively as you want and Sheet Monkey will accept the data and organize it in a sheet for you.
The best way to get familiar with how to use Sheet Monkey is to create a free account and build your first form.