The moment it happens

Add rows to Excel from any tool

Data posted to your link is written as a new row in the table you choose.

Runs: The moment it happens
Apps: Microsoft Excel
AI: Not needed
Access: read+write (Files.ReadWrite)

Send this to your assistant

Create a ClickRuntime automation: give me a link that adds a row to my Leads table in Excel with the name, email, company and source fields I send.

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

Data that is born outside Excel often has to be typed into it by hand. A contact form on a website produces ten enquiries a day, a phone-booking tool logs appointments, a field team texts in site readings. Someone copies each one into the workbook at the end of the day, a few get missed, a date is mistyped, and the tracker that decisions depend on is quietly incomplete.

ClickRuntime gives you a web address for your tool to call. When it sends data to that link, a new row is added to the Excel table you chose, with each value placed in the matching column. It runs the moment data arrives, so the workbook is current at any time.

It is a practical way to keep a simple spreadsheet database going without writing code.

What you get out of it

No more end-of-day data entry
Staff stop copying details from emails and forms into the workbook. The hours they used to spend typing go to answering the enquiries themselves. Typing is the slowest and least rewarding part of anyone's day.
Records are complete
Every submission is added when it arrives, so nothing is lost because someone was off sick or forgot. Reports built from the table can be trusted to cover everything. Decisions made from the workbook are then based on complete data.
Fewer typing mistakes
A phone number or date passed straight from the source cannot be mistyped on the way. Cleaner data means fewer corrections and fewer awkward follow-ups with customers. Fixing mistakes later costs far more time than avoiding them.
The workbook is always up to date
Whoever opens the file sees the latest entries, with no waiting for a manual update. That helps sales and operations teams who make decisions throughout the day. That removes delays between entry and decision.
Works with almost any tool
If your form, app or device can send a web request, it can feed Excel. You do not need a vendor-built connector or a developer. That keeps the cost and effort of setup low.
Your existing formulas keep working
Rows are added to an Excel table, so totals, pivot tables and charts that read the table update automatically. Reports you built earlier continue to work as new data arrives.

How it works

What happens, step by step

When any tool, such as a website form, sends data to your trigger link, ClickRuntime picks it up straight away.
It lays out the time, name, email, company and message as one row.
The row is added to the end of your chosen Excel table.

Before it runs live

Connect Microsoft Excel
Paste your automation's link into the other app's webhook settings

What you get

RunsThe moment it happens

Add rows to Excel from any tooljust nowSucceeded

Excel · Leads2026-10-19T09:14:02+00:00 · Sam Lee · sam@northwind.com · Northwind · Wants a demo

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

append_rows_from_a_trigger_link.pyexample

from datetime import datetime, timezone
from clickruntime import on_event, credentials, http

TABLE = "https://graph.microsoft.com/v1.0/me/drive/items/01ABCDEF.../workbook/tables/Leads"

@on_event
def handle(event):
    d = event.json
    row = [datetime.now(timezone.utc).isoformat(timespec="seconds"), d.get("name", ""), d.get("email", ""), d.get("company", ""), d.get("message", "")]
    http.post(f"{TABLE}/rows/add", headers={"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"},
              json={"values": [row]}).raise_for_status()
    return {"added": True}

FAQ

Common questions

Does the Excel file need to be closed?

The workbook is updated through Microsoft's cloud services, so it should be stored on OneDrive or SharePoint. Other people can usually keep it open while rows are added, though a lock held by a desktop session can delay an update.

What happens if a value does not match the column?

Excel will store the value as sent. If you need strict formats, the setup can check values first, for example rejecting an invalid email. Any rejected submission is shown as a failed run in the ClickRuntime dashboard.

Can I add columns later?

Yes. If you add a column to the Excel table, ask your AI assistant to map a new field to it and approve the change. Existing rows stay as they are, and new rows include the extra value.

What permissions does it need?

read+write (Files.ReadWrite). 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.

Daily