To make this connector work fully securely use this tutorial: http://www.skolenipowerbi.cz/l/google-drive-connector-kompletni-pruvodce/
If you need just an a quick way to connect to Google Drive, use this tutorial: http://www.skolenipowerbi.cz/l/google-drive-connector-compact-tutorial/
Hope you enjoy the Google Spreadsheets Connector.