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.
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
When someone submits your form, the form sends the answers to your ClickRuntime trigger link.
ClickRuntime adds a new record to your Leads table in Airtable with each answer in its own column.
It posts the person's name, email and message in your #leads Slack channel.
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
Build your own
Need it to work differently?
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
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?
What if I add a question to the form later?
Can it skip spam submissions?
What permissions does it need?
Does it need AI?
How many runs does it use?
Can I change how it works?
Related
You might also like
Log failed store orders in Airtable and alert Slack
Every failed order from your store is recorded in Airtable and #ops hears about it straight away, with a louder alert when failures pile up.
See how it worksScore product reviews for sentiment and log them in Airtable
Every new product review is scored for sentiment, flagged if it looks fake, and saved to Airtable, with a weekly roundup in Slack.
See how it worksRecreate recurring Airtable tasks when they are done
When a recurring task is marked done in Airtable, the next one is created with the right due date and its owner hears about it in Slack.
See how it worksKeep exploring
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.