Skip to content

The moment it happens

Save form responses to Airtable and post them in Slack

Each form submission becomes an Airtable record and a message in your leads channel within seconds.

Runs
The moment it happens
Apps
Airtable, Slack
AI
Not needed
Access
Airtable write; Slack chat:write

Send this to your assistant

Create a ClickRuntime automation: when my Tally form is submitted, add the response to my Leads table in Airtable and post it in #leads.

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

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

Why use it

Why teams use this automation

A design studio has a contact form on its website. Responses land in an email inbox that two partners check when they have time. Some enquiries get a reply the same hour, others wait three days, and nobody can say how many leads came in last month.

Writing each response to Airtable and posting it in Slack gives the team one list of every enquiry and a prompt to reply while the person is still interested.

What you get out of it

  • Faster replies to new enquiries

    A message in the channel the team already watches means someone picks up the lead within minutes, not when the inbox gets checked.

  • One place for every lead

    Airtable holds every submission with its fields in columns, so you can sort, filter and add a status as each lead moves on.

  • No copying between tools

    Nobody pastes form answers into a spreadsheet. The record is created with the same fields every time.

  • Monthly numbers without counting

    Because each lead is a row with a date, you can see how many enquiries arrived in any month and where they came from.

How it works

What happens, step by step

  1. When someone submits your form, the form sends the answers to your ClickRuntime trigger link.

  2. ClickRuntime adds a new record to your Leads table in Airtable with each answer in its own column.

  3. It posts the person's name, email and message in your #leads Slack channel.

  4. If the same submission is sent twice, it is only saved once.

Before it runs live

  • Connect Airtable
  • Connect Slack, then invite the app to the channel (type /invite @ClickRuntime there)
  • Paste your automation's link into the other app's webhook settings

What you get

RunsThe moment it happens
Save form responses to Airtable and post them in Slackjust nowSucceeded
Slack · #leadsNew lead: Dana Ruiz (dana@northwind.example) Looking for a rebrand of our café chain, budget around 15k.

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 Google Sheets
  • Combine it with other Airtable and Slack 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.
form_submissions_into_airtable_with_slack_notice.pyexample
from clickruntime import on_event, credentials, state, notify, http

BASE, TABLE = "appXXXXXXXX", "Leads"

@on_event
def handle(event):
    if state.get(event.event_id):
        return {"skipped": "duplicate"}
    fields = {f["label"]: f["value"] for f in event.json["data"]["fields"]}
    http.post(f"https://api.airtable.com/v0/{BASE}/{TABLE}",
              headers={"Authorization": f"Bearer {credentials.secret('AIRTABLE_API_KEY')}"},
              json={"records": [{"fields": fields}]}, timeout=20).raise_for_status()
    name = fields.get("Name", "Someone")
    notify.slack(f"New lead: {name} ({fields.get('Email', '')})\n{fields.get('Message', '')}", channel="#leads")
    state.set(event.event_id, True)
    return {"saved": name}

FAQ

Common questions

Does it work with forms other than Tally?
Yes, as long as the form can send its responses to a link. Typeform, Jotform and most website builders can, and the field names are mapped once when you set it up.
What if I add a question to the form later?
Add a matching column in Airtable and the new answer is saved there. Answers without a matching column are still included in the Slack message.
Can it skip spam submissions?
It can ignore submissions with an empty email field or ones that match words you list. Anything that gets through is easy to delete from Airtable.
What permissions does it need?
Airtable write; Slack chat: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.

Set up “Save form responses to Airtable and post them in Slack” from your assistant

Copy the prompt above, or connect your assistant first. Free plan, no credit card.