Image 2 Drive and Cell. HTML-Form

Here’s a small code sample for selecting image from your computer, pasting it to Google Drive, and inserting an image of it in a cell.

Install:

1. Create new Google Spreadsheet
2. Go to menu Tools > Script editor
3. Paste HTML file named Image2Drive.html and script file Code.gs to your script editor
4. Save code and reload Spreadsheet.
5. Custom menu will appear
6. Authorize on the first run
7. The second run will open a form.