I had this same problem, here is some some python code to get the worksheet id:
def getwkshtid(gd_client, key, wsname):
# get worksheet id from a worksheet name
feed = gd_client.GetWorksheetsFeed(key)
list=feed2list(feed)
local=list.index(wsname)+1
return feed.entry[local].id.text.rsplit('/',1)[1]
def feed2list(feed):
for i, entry in enumerate(feed.entry):
try:
list.append(entry.title.text)
except:
list=[entry.title.text]
return list
