http://simonwillison.net/2017-11-03T04:13:22+00:00Simon Willison2017-11-03T04:13:22+00:002017-11-03T04:13:22+00:00https://simonwillison.net/2017/Nov/3/connecting-to-google-sheets-with-python/#atom-tag

<p><strong><a href="http://tinaja.computer/2017/10/27/gspread.html">Connecting to Google Sheets with Python</a></strong></p> Useful guide to interacting with Google Sheets via the gspread python library, including how to work with Google’s unintuitive “service account keys”. <p>Tags: <a href="https://simonwillison.net/tags/googlespreadsheet">googlespreadsheet</a>, <a href="https://simonwillison.net/tags/python">python</a></p>

2008-10-16T14:37:33+00:002008-10-16T14:37:33+00:00https://simonwillison.net/2008/Oct/16/data/#atom-tag

<p><strong><a href="http://ouseful.wordpress.com/2008/10/14/data-scraping-wikipedia-with-google-spreadsheets/">Data Scraping Wikipedia with Google Spreadsheets</a></strong></p> I hadn’t played with =importHTML in Google spreadsheets, which lets you suck in data from an HTML table or list somewhere on the web. This tutorial takes it further, bringing Wikipedia, Yahoo! Pipes and KML in to the mix. <p>Tags: <a href="https://simonwillison.net/tags/google-docs">google-docs</a>, <a href="https://simonwillison.net/tags/googlespreadsheet">googlespreadsheet</a>, <a href="https://simonwillison.net/tags/importhtml">importhtml</a>, <a href="https://simonwillison.net/tags/kml">kml</a>, <a href="https://simonwillison.net/tags/mashups">mashups</a>, <a href="https://simonwillison.net/tags/scraping">scraping</a>, <a href="https://simonwillison.net/tags/wikipedia">wikipedia</a>, <a href="https://simonwillison.net/tags/yahoo-pipes">yahoo-pipes</a></p>