How to pull data from google spreadsheet to a website?

Question

There is a publicly shared google spreadsheet with price data.

There is a query language and we can pull specific data from it, e.g. putting this query into browser address field. In such a way we get the price of the first item.

Which are the possible no big fuss ways to insert it in the definite place of definite webpages?

Is it true that only javascript/jquery can make this work?

There has came an answer which suits me best: to insert it through iframe. http://jsfiddle.net/Usermane/6v4xp46u/ But how to make it look better: put it in the center of some area of the webpage, change font, change cell background color etc. I don't want to make any scripts: PHP, Python etc. — Andrew Anderson, Aug 31 '15 at 10:54

score 2 · Answer 1 · answered Aug 28 '15 at 14:40

Using Tabletop library https://github.com/jsoma/tabletop you can do:

<script type="text/javascript">
  window.onload = function() { init() };

  var public_spreadsheet_url = 'https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0AmYzu_s7QHsmdDNZUzRlYldnWTZCLXdrMXlYQzVxSFE&output=html';

  function init() {
    Tabletop.init( { key: public_spreadsheet_url,
                     callback: showInfo,
                     simpleSheet: true } )
  }

  function showInfo(data, tabletop) {
    alert("Successfully processed!")
    console.log(data);
  }
</script>

score 1 · Answer 2 · answered Aug 28 '15 at 14:38

1

Export the content to excel and import it into a SQL database.

You could do it with any language. PHP for example.

answered Aug 28 '15 at 14:38

score 0 · Answer 3 · edited May 23 '17 at 11:58

0

If you are working in Python, there is a library called Copytext that allows you to turn a spreadsheet into a native python object. You'd first have to fetch the spreadsheet, pass it to copytext, extract data of interest, then finally render it to your web page.

But this question has also been addressed here.

edited May 23 '17 at 11:58

Community

1
1

answered Aug 28 '15 at 14:47

scuerda

525
3
12

How to pull data from google spreadsheet to a website?

3 Answers3