The moment it happens

Save incoming files to Drive and log them in a sheet

Files sent to your trigger link are saved in your Drive 'Inbox' folder and listed in a sheet with name, sender, date and link.

Runs: The moment it happens
Apps: Google Drive, Google Sheets
AI: Not needed
Access: Drive write; Sheets read+write

Send this to your assistant

Create a ClickRuntime automation: when a file is posted to my trigger link, save it to my Drive 'Inbox' folder and log the name, sender, date and link in my sheet.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Add to ChatGPT Add to Claude

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

A small architecture practice receives drawings and documents from contractors through a website upload form and a couple of other tools. Files end up in different inboxes and download folders, and nobody can say for certain whether the revised plans from last Tuesday were received.

This automation gives you one trigger link that any form or tool can send files to. Each file is saved in one Drive folder and logged in a sheet, so there is a single place to look and a record of everything that arrived.

What you get out of it

One place for every incoming file
Uploads from forms, tools and partners all land in the same Drive folder instead of scattered inboxes and laptops.
A record of what arrived and when
The sheet shows the name, sender, date and link for each file, which settles questions about whether something was received.
Easy to share with the team
Anyone with access to the folder and sheet can find a file without asking who downloaded it.
Works with tools you already use
Any form builder or service that can send a file to a web link can feed the same folder.

How it works

What happens, step by step

ClickRuntime starts each time a file is sent to your trigger link.
The file is saved in your Drive 'Inbox' folder under its original name.
A row with the file name, sender, date and Drive link is added to your sheet.

Before it runs live

Connect Google Drive
Connect your Google Sheets account and pick the spreadsheets it may use
Paste your automation's link into the other app's webhook settings

What you get

RunsThe moment it happens

Save incoming files to Drive and log them in a sheetjust nowSucceeded

Google Sheets · Filessite-plan-rev3.pdf · Acme Builders · 2026-10-19 10:42 · drive.google.com/file/d/…

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.

Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

Act only on the items that match your own rules, and skip the rest
Add an AI step, for example to summarize, sort or draft a reply
Add another app, for example also send it to Slack
Combine it with other Google Drive and Google Sheets steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.

incoming_files_saved_to_drive_and_logged.pyexample

import base64
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from googleapiclient.http import MediaInMemoryUpload
from clickruntime import on_event, credentials

INBOX_FOLDER, SHEET_ID = "your-inbox-folder-id", "your-spreadsheet-id"

@on_event
def handle(event):
    body = event.json or {}
    content = base64.b64decode(body["file_base64"])
    creds = Credentials(credentials.connection("google", "work"))
    drive = build("drive", "v3", credentials=creds, cache_discovery=False)
    saved = drive.files().create(body={"name": body.get("filename", "upload"), "parents": [INBOX_FOLDER]},
                                 media_body=MediaInMemoryUpload(content, mimetype=body.get("mime_type", "application/octet-stream")),
                                 fields="id,name,webViewLink").execute()
    row = [saved["name"], body.get("sender", "unknown"), event.received_at, saved["webViewLink"]]
    build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().append(
        spreadsheetId=SHEET_ID, range="Files!A:D", valueInputOption="USER_ENTERED", body={"values": [row]}).execute()
    return {"file": saved["id"]}

FAQ

Common questions

How big can files be?

Typical documents, images and PDFs work well. Very large files such as long videos are better shared as a link instead of uploaded.

How does it know who sent the file?

From the sender name or email included with the upload. Most form tools pass this along with the file.

Can files go into different folders?

Yes. A field sent with the file, such as a project name, can decide which subfolder it is saved in.

What permissions does it need?

Drive write; Sheets read+write. Nothing else in your accounts is used.

Does it need AI?

No. It runs without AI, so it doesn't use your plan's AI allowance.

How many runs does it use?

One run for each event the app sends.

Can I change how it works?

Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

The moment it happens