Airtable

Create, update or delete single or multiple records in your bases.

Using our official Airtable integration

Create any tasks possible with the Airtable API.

Use io.runTask() and the official SDK or fetch.

Example code using Airtable

Below are some working code examples of how you can use Airtable with Trigger.dev. These samples are open source and maintained by the community, you can copy and paste them into your own projects.

Update Airtable when a new subscription is added to Stripe.Add a new record to Airtable when a Typeform response is submitted.Update Airtable database when there is a sale in Stripe.

1
import { TriggerClient } from "@trigger.dev/sdk";
2
import { Stripe } from "@trigger.dev/stripe";
3
import { Airtable } from "@trigger.dev/airtable";
4
const stripe = new Stripe({
5
  id: "stripe",
6
  apiKey: process.env.STRIPE_API_KEY!,
7
});
8

9
const airtable = new Airtable({
10
  id: "airtable",
11
  token: process.env.AIRTABLE_TOKEN!,
12
});
13

14
//this is the type definition for the table
15
type SubscribedUsers = {
16
  id: string;
17
  interval: string;
18
  currency: string;
19
  unitAmount?: number;
20
};
21

22
// This job populates an Airtable table when a new customer subscription is created in Stripe
23
client.defineJob({
24
  id: "stripe-new-subscription-update-airtable",
25
  name: "On new Stripe subscription update Airtable",
26
  version: "1.0.0",
27
  integrations: {
28
    stripe,
29
    airtable,
30
  },
31
  trigger: stripe.onCustomerSubscription(),
32
  run: async (payload, io, ctx) => {
33
    // Adding the type to table<YourTableType>("<your table name>")
34
    // gives you nice type inference and errors.
35
    // You can leave it out as well table("<your table name>")
36
    const table = io.airtable
37
      .base("<your base id>")
38
      .table<SubscribedUsers>("<your table name>");
39

40
    //create a new record
41
    const newRecords = await table.createRecords("create records", [
42
      {
43
        // Check the Stripe documents for object info: https://stripe.com/docs/api/subscriptions/object
44
        fields: {
45
          id: payload.id,
46
          interval: payload.items.data[0].price.recurring?.interval,
47
          currency: payload.items.data[0].price.currency,
48
          // The unit amount in pence to be charged, represented as a whole integer if possible.
49
          unitAmount: payload.items.data[0].price.unit_amount ?? undefined,
50
        },
51
      },
52
    ]);
53

54
    await io.logger.info("A new subscription was created.");
55
  },
56
});