Free Upload File to Google Drive & Insert Data in Sheets

R21 is the small piece a lot of projects turn out to need: a form that accepts a file and a set of details together, drops the file into your Google Drive and writes the details into your spreadsheet in the same submission.

The record and the file stay together

Handled separately, these two drift apart. Files land in a Drive folder with names nobody can trace, and the sheet ends up with rows that reference documents nobody can find. Doing both in one submission is what keeps a row and its attachment connected — a CV with its application, a receipt with its claim, an ID scan with its registration.

Everything stays in your account

The file goes to a Drive folder you nominate and the data goes to your own spreadsheet. There is no third-party storage in the middle, no upload service to pay for and nothing about the submission leaving your Google account.

A short setup

Make a copy of the sheet and the code is already inside it under Extensions. The only change to make is pasting in your own ID where the code expects it, then save, run it once to authorise, and create a new deployment as a web app. The URL that comes back is the form. The source is also published on GitHub if you would rather read it there before running anything.

Where it fits

Treat it as a building block rather than a finished application. It is the upload half of a bigger build — pair it with one of the login files here to control who can submit, or with a table file to display what has been collected.