Setup Steps
Get Your API Key
- Go to Airtable Account
- Click Generate API key or go to Developer hub
- Create a Personal Access Token with these scopes:
data.records:writeschema.bases:read
- Copy the token (starts with
pat)
Get Your Base ID
- Open your Airtable base
- Click Help → API documentation
- Find your Base ID in the URL or documentation
- It looks like:
appXXXXXXXXXXXXXX
Get Your Table ID
- In the API documentation, find your table
- The Table ID looks like:
tblXXXXXXXXXXXXXX - Or use the table name (e.g., “Submissions”)
Configure in Spike
- Go to your Spike Dashboard
- Select your form → Settings
- Scroll to Integrations → Airtable
- Enable the toggle
- Enter your API Key (Personal Access Token)
- Enter your Base ID
- Enter your Table ID or table name
- Save changes
Field Mapping
Spike automatically maps form fields to Airtable columns:| Form Field | Airtable Column |
|---|---|
name | Name |
email | |
message | Message |
| Any field | Matching column |
Setting Up Your Table
Create columns in Airtable that match your form fields:- Name - Single line text
- Email - Email field type
- Message - Long text
- Submitted At - Date field (auto-populated)
Troubleshooting
Records not created
Records not created
- Verify your API key has write permissions
- Check that Base ID and Table ID are correct
- Ensure column names match form field names
- Check Airtable’s API rate limits
Missing fields
Missing fields
- Column names must match form field names
- Create columns for all fields you want to capture
- Field names are case-insensitive
API key errors
API key errors
- Use a Personal Access Token, not the deprecated API key
- Ensure the token has
data.records:writescope - Check that the token hasn’t expired
Supported Field Types
| Airtable Type | Form Data |
|---|---|
| Single line text | Any text |
| Long text | Multi-line text |
| Email addresses | |
| Number | Numeric values |
| Checkbox | true/false |
| Date | ISO date strings |