How to send your html form to Google Sheets for free

  • Stores form submissions in Google Sheets
  • Is completely free to use
  • Is super easy to set up / get started
  • Supports all HTML form fields — including files
  • Allows website designers and builders complete freedom in creating any form they wish
  1. Point your form action property at https://form2channel.com
    <form action=”https://form2channel.com" method=”POST”>
  2. Add a hidden tag with the sheet editor email
    <input type=”hidden” name=”formto_googlesheets” value=”me@email.address”>
  1. Sheetmonkey.io (https://sheetmonkey.io)
    This is a specialist in submissions to Google Sheets and their platform is full of well-documented features. Their free tier has a decent 5 forms and 500 submissions limit and they provide simple submissions counters on their platform.
    However, free tier users are not notified of form submissions when they occur and they don’t offer submissions to other channels on free accounts. So, you will need to remember to log into your sheet on occasion to check for new entries yourself. If response time is important to you, this may become somewhat cumbersome.
  2. Usebasin.com (https://usebasin.com)
    The free tier on this Service only allows for 1 form and it also uses integrations with Zapier or Integromat to submit forms to Google Sheets. The third-party integration makes the setup more complex, because you also need an account at the integration partner and configure the integration to get your form to end up in Google Sheets. You can export all submissions to Excel or CSV and they provide analytics for each form with submission rate and unique submission reports. You can also set up multiple notification emails per form.
    However, there are some confusing limitations on the free tier. Every form must contain an email field and the address added there is used to de-duplicate submissions. The reason for this limitation is difficult to understand and it makes the forms inbox somewhat confusing. You will also have to live with the standard usebasin thank you page, which can feel a bit like you are showing your visitors an advert.
  3. Formspree.io (https://formspree.io)
    This platform allows for unlimited forms on the free tier, notifications to two separate email addresses and form submissions are stored on the platform for 30 days. It also has a rich feature set and caters for submissions to Trello, Stripe, Discord and Slack on their free tier. The platform further comes with a set of templates that make setting up forms quick and easy.
    Disappointingly, an integration with Google Sheets is only available on one of the three paid tiers which start at $10/month and for some reason drop you back to only 10 forms. A custom thank you page also only comes with a paid tier, leaving you to advertise this platform to each visitor who decides to submit a form on your site.
  4. Formcarry.com (https://formcarry.com)
    Next to notifying an email address of a new submission, this service also allows for the setup of a webhook per form as an additional integration point. This essentially acts as an additional http channel and can be used to integrate the platform with other systems and API’s. Another special feature of this platform is that they provide the raw form submissions in Json via an API call.
    However, the platform also provides the Google Sheets integration only via Zapier and I found the setup somewhat complex and confusing. The free tier limit of 1 form and 100 submissions compares well with those of the other platforms, but for a custom thank you page a paid account is again needed.
  5. Formkeep.com (https://formkeep.com)
    The management application for this platform is possibly the most extensive of all the services reviewed there, but at the same time it is also the hardest and most confusing to use. When setting up forms it is frustrating to discover that few of the features the platform provides are available to free tier users. Unfortunately that includes the Google Sheets integration as well as the integration with all other channels on offer. The free tier limit of 50 submissions per month is on the lower end of all offerings, form submissions are only being stored on the platform for a limited time and there is no custom thank you page.
    On the plus side, the platform boasts a visual form builder and for paid accounts there seems to be a wide set of features available that include email campaigns, custom replies and a decent set of integrations.
  6. Form2Sheet (https://form2sheet.com)
    This site specialises only in form submissions to Google Sheets and their “no frills” service seems incredibly simple and easy to set up. Their free tier does, however, only allow for 1 form with 4 predefined fields, sends only branded emails and does not cater for a custom thank you page. There is no documentation either, leaving users to find out for themselves what to name their fields and that those names are case-sensitive.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store