Upload a file to google sheets cell

My code is on github here:

The main part of my learning was from here. This has a great youtube video you can watch.

And then took some snippets from Keith as well, who posted above. This gave me some additional code in the script that allows me to launch the form from within a drop down menu in sheets.

I had some problems when dealing with the form being called from inside google sheets drop down.  The form would always return an error.  I later figured out how to use the paragyte code and have the html form post to a hidden iframe.  But using these 2 blogs helped me so so muc.

Then I had to figure out how to write a terrible little progress bar so you could see the file uploading sort of.

This is a total hack job but it does everything I want.  I don't really need the email part but that is easy to comment out.

I will posted files on the github link above.  This will give you the gist but you should still watch the paragyte video.  I still have lots of work to do but after 2 days of struggling, glad to have something going that works.  It shouldn't have been so hard.

I can start in google sheets, click the new attach menu and choose file and then fill out the form and attach my file and my results go into drive and the link from drive gets copied into my excel along with the other fields from the form that I may also want to put on that spredsheet row.  Works great.  It also sends me an email. 

This was originally made as a form accepting resumes on the public web but that's not what I will be using it for.  For me its to keep track of my receipts and vendor invoices.

You will need to make sure you deploy as web app and update all the code with your specific webapp link and also you will need to put in your own google sheets id for your sheet .  It will connect to your default google drive account and create a folder called Demo for the uploads.  It makes lots of subfolders too, you can edit this out so it doesn't make the individual subfolders.  I'm just lazy right now, I'll edit that part later.

When you publish make sure you give access to "anyone, even anonymous".  It will be pretty hard for people to find your specific link unless you give it to them.

Your unique code will look something like this when you publish the app.

its important that you use your unique id.

The video from paragyte.com explains all this.

My code is on github here:

Here is a picture of the form and a picture of the attach drop down menu.

Oh yeah,

You need to put in the ID of your google sheet that you want it to write to in the code.gs.  You don't have to hard code it but I hardcoded the sheet ID anyway just for debug.

DropSpread add-on  Works really well once you figure out how to activate it.  Took me a bit.  It will probably do what most people want, which is attach a file to a cell.  

If you want to control your code more and have it do more things then you can use the code I posted in a previous post.  But this custom code is not for faint of heart.

Save Email pdf in Google Drive

Open pdf in GDrive and press share icon

   Copy link

paste link in cell in Google Sheets.