Generate a WordPress plugin that syncs form submissions to Airtable
Airtable is the shared spreadsheet for teams that outgrew a spreadsheet but are not ready for a full database or CRM. Non-technical teams love editing records there, and every team I have seen eventually wants WordPress submissions to land in Airtable automatically. The Airtable API is forgiving but strict about field types: a link to another table expects record IDs, an attachment expects a URL Airtable can fetch, and a select needs the exact option label.
A generated plugin for Airtable sync handles the quirks of each field type. We use the v0 API with a Personal Access Token (Airtable deprecated the legacy API key in 2024), respect the 5-requests-per-second-per-base limit, and send each submission through a queue so form posts never wait on Airtable.
Why generate it instead of installing an existing plugin?
Airtable themselves partnered with Make (formerly Integromat) as the official automation recommendation, plus Zapier and Pipedream. Those are all great for interactive flows. Fully automated WordPress → Airtable sync through any of them costs €20-50/month as volume grows, and every submission round-trips through the connector's servers.
A direct plugin is 200 lines of PHP. You pay only for WP hosting, you own the logs, and the payload shape is exactly what your Airtable base expects. No connector intermediary that occasionally pushes unrelated test records when they release a new feature.
Airtable attachments are a common gotcha. The API needs a publicly reachable URL to download the file. A plugin that saves form uploads to your WordPress uploads folder and passes the public URL to Airtable Just Works. Connectors often complicate this step.
Example prompt
This is the kind of description that generates this plugin. You can start from it and tweak whatever you need before hitting generate.
Plugin name: Acme Airtable Sync
API: Airtable v0 with Personal Access Token (PAT).
Mapping:
- Form "Project brief" (Fluent Forms form ID 7) → base "Client Projects" (appXXX), table "Inbound".
- Name (Single line text) ← field "name"
- Email (Email) ← field "email"
- Company (Single line text) ← field "company"
- Budget (Single select: "<5k", "5-20k", ">20k") ← field "budget" (match exact labels)
- Needs (Multiple select) ← field "needs" (checkboxes)
- Attachments (Attachment) ← field "brief_file" (uploaded via Fluent Forms, stored in /uploads/)
- Source (Single select) ← hard-coded "Website form"
- Created (Date) ← current timestamp
On each submission:
1. Store the file in /uploads/acme-airtable/ with a random filename.
2. POST to https://api.airtable.com/v0/appXXX/Inbound with the record, passing the public file URL for the attachment.
3. On success log the Airtable record ID in WP log.
Rate limiting: max 5 req/s per base.
Admin: PAT, base ID, table name, field mapping UI.
No DB tables needed.What the generated plugin typically includes
- Airtable v0 client using wp_remote_post with Bearer auth
- Field type-aware converter (text, number, select, multi-select, attachment, date, checkbox)
- Attachment handler that stores uploaded files publicly and passes the URL to Airtable
- Rate limiter respecting 5 req/s per base
- Idempotent upsert via an external_id field if you want to avoid duplicates
- Log of last 50 syncs with Airtable record IDs
- Admin mapping UI validating select option labels against the live Airtable schema
Linked records, formula field awareness, per-row user-specific views — all doable. Describe the schema and the plugin respects it.
Frequently asked questions
What about the rate limit?
Airtable allows 5 requests/second per base. The plugin queues bursts and drains them at that rate. For occasional form submissions you will never hit the limit.
How are attachments handled?
Attachments stored in your /uploads/ folder and Airtable is given the public URL. Airtable downloads the file asynchronously. If your site is behind a firewall, Airtable cannot reach it — in that case upload to S3 and pass the S3 URL.
Can I sync existing submissions retroactively?
Yes. The plugin ships a WP-CLI command that walks form submissions from a start date and replays them into Airtable. Safe to re-run (idempotent).
Does it work with any form plugin?
Out of the box we support Contact Form 7, WPForms, Gravity Forms, Fluent Forms. For any other form, pass us the "after submission" hook name and the plugin wires up to it.