This post is based upon a nicely presented blog entry at blog.ouseful.info
In short: Google provides a thorough API for querying Google spreadsheets. This syntax can be triggered by a Tableau "URL Action". You are going to need to download this workbook and reverse engineer the google API and URL syntax, because as I have repeatedly said before, I am quite lazy sometimes...