Introduction to Sheet Monkey
How to send data to Google Sheets with just a little HTML
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.
All these guides require that you have a free Sheet Monkey account. If you haven't registered your account, please do that before continuing.
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.
An example form action
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 field
will 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.
Last modified 3yr ago