Insert data to Google sheets in javascript

Question

I'm trying to save a post request data to a google spreadsheet. However, the data is saved as undefined.

The original post uses a form and uses jquery. See the link below. But I'm trying to pass an array also without the use of jquery.

I'm using the following app script without using jquery - https://mashe.hawksey.info/2014/07/google-sheets-as-a-database-insert-with-apps-script-using-postget-methods-with-ajax-example/

I'm posting the code here.

function sendData(data) {
    var xmlhttp = new XMLHttpRequest();   // new HttpRequest instance 
    var theUrl = "spreadsheeturl";
    xmlhttp.open("post", theUrl);
    //xmlhttp.setRequestHeader("Content-Type", "application/x-www-form-urlencoded; charset=UTF-8");
    xmlhttp.send(JSON.stringify(data))
    }

rksh · Accepted Answer · 2019-04-11 01:51:00Z

1

I found the answer, you have to uncomment a block in the app script if you are passing JSON data.

answered Apr 11, 2019 at 1:51

rksh

4,05010 gold badges53 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert data to Google sheets in javascript

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related