Your Goolge Drive folder can be used as your image hosting. Here is how you can display images from Google Drive in your website:

  1. Create a folder in a Google Drive
  2. Upload all of your images there.
  3. Click on the folder and select Get Link
  4. Change the permission to Anyone with a link can view
  5. Done

Nice! Your folder is ready. Now let's get a link to a specific image and put into the spreadsheet:

  1. Right click on the image. Get link
  2. Copy the link. It should looks like this:
  3. Done
  4. Paste it to the spreadsheet