The moment it happens

Add form entries to a sheet as they arrive

Anything sent to your link, from a form, a website or another tool, appears as a new row.

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

Send this to your assistant

Create a ClickRuntime automation: give me a link my website form can send to, and add each submission as a new row in my Signups sheet with name, email and date.

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 business collects information in many places: a contact form on the website, a booking widget, a payment notification, a script on another server. Each stores data in its own system with its own export, so answering a question like how many inquiries came from the pricing page last month means logging in to three places and merging files. Data is also lost when a tool changes plans or deletes old entries.

ClickRuntime gives you a private link. Whatever is posted to it, from a form, a website or another tool, is received, its fields are matched to the columns in your Google Sheet, and a new row is appended. If you like, an email tells you each time a row arrives.

It is a simple way to give tools that can send a webhook a spreadsheet as their destination.

What you get out of it

Everything in one table
Data from forms, widgets and scripts ends up in one sheet, in the same columns. Filtering, sorting and charting work across sources without any merging of exports. A monthly question becomes a quick filter.
No separate database to run
A Google Sheet is a database that most people can already use. You get storage, search and sharing without setting up or paying for anything extra. Sharing it with a colleague takes one click.
Records survive changes in other tools
When a form builder deletes old submissions or changes its plan, your rows are still in the sheet. You keep a copy under your own control. That protects you if a vendor closes or changes plan.
Fields land in the right columns
Mapping each incoming field to a named column keeps the data tidy. Anyone opening the sheet sees a structured table and not a pile of raw text. Analysis begins straight away instead of after a cleanup.
New sources are quick to add
Connecting another tool means giving it the link and mapping its fields. A new campaign page or a partner's form can start logging in minutes. Growth in tools does not mean growth in manual work.

How it works

What happens, step by step

When someone submits your form, ClickRuntime receives the answers straight away.
It takes the name and email and adds the date and time.
A new row is added to your Google Sheet, so every entry is logged in one place.

Before it runs live

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

Add form entries to a sheet as they arrivejust nowSucceeded

Google Sheets · SignupsJamie Ortiz | jamie@northwind.example | 2026-10-19 14:02

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 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.

log_incoming_form_or_webhook_data_as_rows.pyexample

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from datetime import datetime, timezone
from clickruntime import on_event, credentials

SHEET_ID = "your-spreadsheet-id"

@on_event
def handle(event):
    form = event.json or {}
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    row = [form.get("name", ""), form.get("email", ""), datetime.now(timezone.utc).strftime("%Y-%m-%d %H:%M")]
    sheets.values().append(spreadsheetId=SHEET_ID, range="Signups!A:C", valueInputOption="USER_ENTERED",
                           insertDataOption="INSERT_ROWS", body={"values": [row]}).execute()
    return {"logged": form.get("email")}

FAQ

Common questions

What can post to the link?

Anything that can send an HTTP request with data: most form builders, booking tools, payment systems, and your own scripts. The data can be sent as JSON or as a standard form post. The link is private and not listed anywhere.

What happens if a field is missing or new?

A missing field leaves its cell blank, so the row is still saved. A new field that has no matching column is ignored unless you add a column for it. Mention it to your AI assistant when you want it captured.

Is it safe to send personal data to the link?

The link is a secret known only to you and the senders you give it to, and it uses an encrypted connection. Keep the sheet's sharing restricted, and collect only the fields you need, especially for personal information.

What permissions does it need?

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 happensAI