OK, we’ve tracked the source of problem (1). Google spreadsheets allow you to make a column of your spreadsheet into a hyperlink using the “Hyperlink()” spreadsheet function. But then it doesn’t export the hyperlink in the spreadsheet data feed, so all datapress sees is the text, not the url.
The solution, if you want to use urls in your datapress exhibit, is to make a separate spreadsheet column containing the url. Then you can edit the lens in datapress to make use of the url column.