Currently there is no connection profile in Designer for creating a google spreadsheet source. The only way to create the datasource in Designer (that I know of) is to launch Teiid Connection Importer and create it on the first page of the wizard. However even that is not working currently (see linked jira).