Idea Validation: HTML Form to Google Sheets
Hi IndieHackers I have been thinking for a while in this idea, and I am about to create a site for my father, and he asked me to have a custom form, but I was planning to use Jekyll or Gatsby to generate the site so I thought it would be great to have service like that.
Example:
I create an HTML form, and I set the POST action to be "sheetform.com/custom-form-123", so every time someone submits my form that will add a new row to a Google Spreadsheet I specified.
I appreciate any feedback, Thanks in advance.
Do you target your service for survey forms? Why don't just use google forms instead?
Can't see any other cases when users need to aggregate data in spreadsheets instead of directly processing it with a dedicated app like Mailchimp or Zapier
I am trying to have an embedded form, and Google forms do not allow that, can I do that with MailChimp or Zaiper for free?
Not sure actually. Maybe I'm wrong. I think the main question is who is your service for? If there are enough "ready to pay" people who need it?
Google forms can be used on a website. They use iframe though, so CSS cannot be used. If I am correct, Airtable can be seamlessly embedded. Mailchimp can also help, but there are limitations.
Haven't used, but you can check jotform.com also.
I had the same need some time ago, so I wrote a simple tool to convert any google form to an html form.
http://stefano.brilli.me/google-forms-html-exporter/
Hope it helps!
Two methods I have use are:
Or
Can I use Zapier with an embedded form?
I think you are lookin for this example which used webhooks and google sheets.
Zapier works with Forms
And these sheet tools:
This comment was deleted 8 years ago
This comment was deleted 4 years ago
That the purpose of the service, so you don't have to worry about coding that, especially if you are not technical.