form-to-google-sheets | Store HTML form submissions in Google Sheets | Data Visualization library

I have a code that collect emails from my website when someone clicks subscribe to a google sheet. The process is based on these steps here: https://github.com/jamiewilson/form-to-google-sheets/blob/master/README.md However I want to send also an email to the person who subscribed to my website through the google script but I am not able to do so. Here is the code:

I have a simple email subscription form on a landing page that I managed to get working to save emails in a google sheet spreadsheet. I followed this post https://github.com/jamiewilson/form-to-google-sheets

The problem is nothing happens to indicate a successful submission. Looking for a solution to reset the field and potentially a Thank you message without leaving the page.

My Code:

I'm trying to send data to a google sheet with an HTML form. I followed this tutorial to do it : https://medium.com/@dmccoy/how-to-submit-an-html-form-to-google-sheets-without-google-forms-b833952cc175

I didn't used Google Form, because I needed specific javascript function. Google script app could do it, but it require users to log in to their google account to authorize it, and I don't want that.

So, in one hand, I have a google app project, with the code provided by the tutorial, who can received GET data, and write it in my Google Sheet. In the other hand, I have an html form who send the data to the google app script project.

But it seems that my poor knowledge in javascript and jquery made me fail something, even if almost all the code is already written. I think it come from AJAX, something is defintely wrong with that part. Here is the code (I have reduced the form because it's not really important, just wanted to show you that I'm not submitting the form with input type="submit" but with HTML5 validation, in case it would change something).

I am trying to submit a form to Google Sheets. This step is successful and I am getting all the numbers in the sheet. Now I want to display a success message after the form is submitted and the result from Google Sheets is ok. How do I do it?

I have tried various messages in javascript and ajax, but don't have much understanding about it. I have shown my code below so you can have a look at it.

I am new to Vue.js and to javascript. I am trying to send some data to a google sheet without success.

I have found some info on how to post data, but my data is not stored in a form. So I have appended an empty 'form' with the data I want to post without luck.

This is the source: https://github.com/jamiewilson/form-to-google-sheets and: Is it possible to send js variables to google sheets? (Not form data)

This is how I post the data:

The goal is to send with the form data in Google Sheets to be recorded in the appropriate fields. I used this article, but my script gives an error:

There are plenty of examples on how to use an apps script web app to connect HTML forms to google sheets. However all these refer to a scenario where the owner of the spreadsheet/form is the developer, such as this method. The owner/creator of the spreadsheet/form is not dynamic in these cases as far as I can see.

In my use case I want users to create their own HTML Forms based off data from a spreadsheet in their drive and receive responses in that sheet. So we are talking about multiple users creating their own spreadsheet in their own google account/drive instance and connecting that to my external web app to display the form to the users who have the link.

The flow is like this:

1. User1 creates Google SpreadSheet in their drive
2. User1 uses our add on to create the form/link
3. User1 sends the links out
4. Receiving Users go to the link which leads to my external web app to fill out the form and submit a response
5. User1 receives responses in another sheet in the same spreadsheet in their drive.

This is repeated for x amount of users.

I'm thinking this will be done through a sheet add on, but I'm not sure how to connect the add on to the external web app. In the link above it is done by creating an apps script web app, but I can't ask the user to do that/programmatically do it for them.

What options do I have? There needs to be a url to send data to, with a process listening for said data that I can then run a function on.

Hopefully there is some api for this, maybe for drive?

P.S In case anyone is suggesting that I use google forms for this, google forms is great but it is limited in UI options and to a question and answer format. I'm looking to include search/filter functionality for possibly hundreds of list items with a quantity field. So it can't be done in forms.

I have an interesting situation as I am making an HTML form outputting directly to a Google Sheet (more info here: https://github.com/jamiewilson/form-to-google-sheets). However, my form action will not redirect as the page simply stays the same when the submit button is clicked. The Google Sheet records the input, but not indication is made on the webpage. I would like to redirect to a completely different page.

I've noticed this is a common question, but all other answers either a) redirect and don't submit the user's response or b) submit the response but with no redirect.

Thanks in advance.

I found this site: https://medium.com/@dmccoy/how-to-submit-an-html-form-to-google-sheets-without-google-forms-b833952cc175

I am trying to create the form as they stipulated but I got undefined in the google sheets for the form fields. Here is my code