You can only do that via Copy/Paste from ingame Assets Window or use the external API known as ESI (EVE Swagger Interface). In specific to Google spreadsheets you have GESI, which is an add-on created by Blacksmoke16 and you can find his forum thread here
Blacksmoke16’s Github page contains instructions for installation, so if you follow those you should be good to begin.