One option is to write some code to submit your responses to Google Sheets via the Sheets API. Setting this up is not necessarily simple. It firstly requires you to configure a Google sheet to accept API calls, which can be surprisingly tricky to get right. You will also need some Javascript expertise and knowledge of the Google Sheets API to post the data. A quick Google search reveals a lot of sites that have recipes you can implement if you feel up to it. But be careful when you make your selection. Not all of these scripts are up to date and when Google decides to change things on their end your script might stop working.

A third option is to use a service that specifically caters to the submission of custom, self-hosted html forms to Google Sheets. I found a few sites that provide this service and decided to give them a test run. I was looking for a way that I could host my own form and have complete control over how it works and looks. I also wanted the integration with the forms engine to be super simple and easy to implement. Lastly, I did not want to pay anything and wanted all of this for free.

Unfortunately, I did not find such a service and all the sites I found disappointed me in some way. While most of them have a free tier, this tier always comes with limitations. Some restrict the number of forms you can use, others the number of submissions they allow.

I found a forms service that gives users everything I was looking for. And everything was working perfectly with the tool form2channel.com

Features

• Stores form submissions in Google Sheets
• Unlimited submissions
• No coding required
• Support for 5 channels
• Multiple recipients
• Custom thank you pages
• File uploads supported
• Check out all features

Here's all you need to do to start using it:

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">

When site visitors submit the form you will get a link to the sheet via email. That’s all. In the background, is a simple PHP script that collects the form fields and submits them to a REST API. That API adds the responses to the Google Sheet and sends the link to the email in the hidden tag. Here is the documentation for Form2Channel.

You can add multiple forms to a website and multiple recipients to a form. You can create your form any way you like and use any form field HTML supports, including files. You can send your forms to Google Sheets and also via Email, Slack or Telegram. You can create your own thank you page and your visitors will never have to know you are even using Form2Channel. You get all of this for free and you don’t even have to sign up with Form2Channel to use it.

Example

<!-- Form tag with action and method. Add enctype for file uploads -->

<form action="https://form2channel.com/?form=sample" method="POST" enctype="multipart/form-data"> 

<!-- Recipients for the form info -->

<input type="hidden" name="formto_googlesheets" value="me@email.address,me2@email.address">

<input type="hidden" name="formto_email" value="me@email.address,me2@email.address">

<input type="hidden" name="formto_slack" value="Slack Channel Webhook URL">

<input type="hidden" name="formto_telegram" value="The chat ID the Form2Channel bot sent you">

<input type="hidden" name="formto_http" value="Address of the receiving webhook or api">

<!-- Custom redirects -->

<input type="hidden" name="formto_redirect" value="Thank you page to redirect visitors to">

<input type="hidden" name="formto_error" value="Page to redirect visitors to when something goes wrong">

<!-- All form fields need name and value attributes -->

TextField:

<input type="text" name="TextField" value="TextValue">

TextArea:

<textarea name="TextArea">TextArea Text</textarea>

DropDown:

<select name="DropDown1">

<option value="SelectedOptionVal">SelectedOption</option>

</select>

<select name="DropDown2">

<option>OptionText</option>

</select>

<select name="DropDown3">

<option></option>

<option>Option</option>

</select>

Multiselect DropDown:

<select name="DropDown_multiselect[]" size="3">

<option value="SelectedOptionVal1">SelectedOption1</option>

<option value="SelectedOptionVal2">SelectedOption2</option>

<option value="SelectedOptionVal3">SelectedOption3</option>

</select>

Checkboxes:

<label>CheckBox1: <input name="CheckBox1" type="checkbox" value="checked" checked></label>

<label>CheckBox2: <input name="CheckBox2" type="checkbox"></label>

<label>CheckBox3: <input name="CheckBox3" type="checkbox" checked></label>

RadioButton:

<label><input name="RadioButton" type="radio" value="RadioButton_a" checked> Checked</label>

<label><input name="RadioButton" type="radio" value="RadioButton_b"> Unchecked</label>

Single File: <!-- NOTE: Form tag must contain enctype="multipart/form-data" -->

<input type="file" name="file_single">

Multiple Files:

<input type="file" name="file_multiple[]" multiple>

<button type="Submit">Send</button>

</form>

Add a little css and you will have a beautiful HTML form like DEMO here

If you feel the content is useful. Thank for me with a coffee 😊