ajax post/insert data/row into google spreadsheet

Question

How to post (or insert) data to google spreadsheet? I don't use form, but I have input fields. However, the data cannot be sent to my spreadsheet. If someone could help?

 <input id="name" type="text" />
 <input id="location" type="text" />

I'd like to use ajax to post entered data to google spreadsheet.

  $.ajax({
            type: 'post',
            url: 'https://docs.google.com/spreadsheet/ccc?key=8D84JF82FK23413',
            data: {
               name:  $('#name').val(),
               country: $('#location').val()
            },
            success: alert('PASS')
        });

Trent · Accepted Answer · 2013-01-09 02:43:52Z

4

I don't think it will be possible to insert a row just with an AJAX request. AJAX does not work across different domains.

There's a lot to learn, but you can start with the Google Speadsheet API...

https://developers.google.com/google-apps/spreadsheets

answered Jan 9, 2013 at 2:43

Trent

1,38111 silver badges12 bronze badges

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

2 Comments

olo Over a year ago

Thank you for your answer, then I dont waste my time on ajax :)

Dylan Valade Over a year ago

AJAX does work across domains when your JSON data is wrapped in a function (JSONP). Here is a way to push new data rows into a Google Sheet - it requires preparing your Sheet with Javascript that receives requests. stackoverflow.com/questions/19887737/…

Collectives™ on Stack Overflow

ajax post/insert data/row into google spreadsheet

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related