Airtable
Airtable is a cloud-based platform that combines the simplicity of a spreadsheet with the power of a relational database, allowing teams to organise, track and manage data in customisable tables.
Key features include:
- Customisable tables with rich field types including text, numbers, emails and long text
- Multiple views including grid, kanban, calendar and gallery
- Relational linking between tables
- Automations and integrations with third-party platforms
This guide describes how to automatically send ShopWired order data to Airtable using Make. When an order is finalised on a ShopWired store, the scenario creates a new record in an Airtable table with the order description, customer name, email, phone number, order ID and shipping address.
This scenario allows:
- Automatically creating a new record in Airtable when a ShopWired order is finalised
- Mapping order description, customer name, email and phone number to table fields
- Recording the full shipping address in a single field
- Storing the ShopWired order ID for reference
Prerequisites
Scenario blueprint
Open the scenario blueprint in Make
Scenario setup steps
- Select the scenario blueprint provided with this guide
- Open it in Make
- Create a new scenario from the blueprint
- Replace any placeholder values if required
- Connect required accounts
- Turn the scenario on
- Trigger the relevant event in ShopWired
ShopWired webhook data
This scenario is triggered by the order.finalized webhook event.
{
"timestamp": "2026-04-15T10:22:03+0000",
"event": {
"topic": "order.finalized",
"subjectType": "order",
"subjectId": 11630937,
"data": {
"object": {
"id": 11630937,
"products": [
{
"title": "Slow Masticating Juicer",
"sku": "SKU-001",
"total": 79
}
],
"shippingAddress": {
"name": "Jane Smith",
"emailAddress": "jane.smith@example.com",
"telephone": "07123456789",
"addressLine1": "59 Woodland Avenue",
"addressLine2": "",
"city": "Penryn",
"postcode": "TR108PG",
"country": "United Kingdom"
}
}
}
}
}
Required user inputs
| Input | Description |
|---|---|
| Airtable connection | Connect your Airtable account in Make using OAuth |
| Base | The destination base must be selected. The blueprint uses Untitled Base — update if using a different base |
| Table | The destination table is set to Customer Orders. Update if using a different table |
| Webhook | The ShopWired order.finalized webhook must be registered and available in the scenario |
Recommendations
- Test the scenario by placing a test order in ShopWired and confirming that a new record is created in Airtable
- Ensure the Airtable table has the following fields configured before running the scenario: Order Description (long text), Customer Name (single line text), Email (single line text), Phone Number (single line text), Order ID (number), Shipping Address (long text)
- Do not use the Email field type in Airtable for the email column — use Single line text to avoid validation errors
- The Base ID and Table ID in the blueprint are specific to the original base — update these if importing into a different Airtable workspace
- For orders with multiple products, the Order Description field will contain the title of the first product — consider extending the scenario if full product lists are required
