Automate Your Room-Preference Form in Minutes with n8n + Airtable

Description:

A step-by-step Hashnode tutorial on how to capture form submissions with n8n’s built-in trigger and push them straight into Airtable—no code required.

🚀 Introduction

Whether you’re running a hotel booking form, collecting event RSVPs, or just experimenting with no-code tools, n8n makes it trivial to:

1. Host a form

2. Listen for each new submission

3. Save the data into Airtable (or any other API)

In this guide, we’ll build a “Room Preference” form, wire it up in n8n, and create new Airtable records automatically whenever someone hits Submit.

---

🔧 Prerequisites

1. n8n installed (locally or cloud)

2. An Airtable base with a table named Room Requests having columns:

   • Name (Single line text)

   • Room Type (Single select)

   • Submitted At (Date / Time)

3. Your Airtable API Key & Base ID

---

1️⃣ Build & Test Your Form in n8n

1. Create a new n8n workflow named Room Preference → Airtable.

2. Add the On Form Submission trigger node.

3. In Parameters:

   • Click Test URL → copy the link

   • Set Form Title to Room

   • Set Form Description to What room do you like?

   • Under Form Elements, add a Dropdown List with options:

     • standard room

     • deluxe room

     • suite

4. Click Test step → fill out your form → Submit.

5. Watch the node fire and pin its JSON output for reference.

---

2️⃣ Wire in Airtable

1. Add an Airtable node and connect it after your Form trigger.

2. Under Credentials, select your Airtable API key.

3. Configure the node:

   • Operation: Create

   • Base ID: your Base ID

   • Table: Room Requests

4. Map your form fields to Airtable columns:

   | Airtable Field | Value | | --- | --- | | Name | {{$json["body"]["Your name?"]}} | | Room Type | {{$json["body"]["What room do you like?"]}} | | Submitted At | {{$now}} (n8n’s current timestamp) |

5. Execute the Airtable node → confirm a new record appears in your base.

   

---

3️⃣ Activate & Go Live

• Toggle your workflow Active.

• Use the Production URL from the Form node for real users.

• Every new form submission will now automatically create an Airtable record!

• 

---

💡 Next-Level Tips

• Validation: Insert an IF node to enforce one-choice only.

• Error Handling: Add an Email or Slack node to notify on failures.

• Audit Trail: Duplicate your payload into Google Sheets for a backup.

• Branding: Customize your form’s look in the Form node Settings.

---

🎉 Done! You’ve just built a powerful, zero-code pipeline: from form → to database → ready for reporting or downstream automations.