← Twilio SendGrid + Airtable integrations

Create Multiple Records with Airtable API on New Events (Instant) from Twilio SendGrid API

Pipedream makes it easy to connect APIs for Airtable, Twilio SendGrid and 1000+ other apps remarkably fast.

Trigger workflow on
New Events (Instant) from the Twilio SendGrid API
Next, do this
Create Multiple Records with the Airtable API
No credit card required
Into to Pipedream
Watch us build a workflow
Watch us build a workflow
7 min
Watch now ➜
Trusted by 250,000+ developers from startups to Fortune 500 companies:
Trusted by 250,000+ developers from startups to Fortune 500 companies

Developers Pipedream

Getting Started

This integration creates a workflow with a Twilio SendGrid trigger and Airtable action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

  1. Select this integration
  2. Configure the New Events (Instant) trigger
    1. Connect your Twilio SendGrid account
    2. Select one or more Event Types
  3. Configure the Create Multiple Records action
    1. Connect your Airtable account
    2. Select a Base
    3. Select a Table
    4. Configure Records
    5. Configure Typecast
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. Turn on the trigger

Details

This integration uses pre-built, open source components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger

Description:Emit new event when any of the specified SendGrid events is received
Version:0.0.3
Key:sendgrid-events

Twilio SendGrid Overview

With the Twilio SendGrid API, you can build a number of features into your
application to manage your SendGrid account and send emails. For example, you
can use the API to:

  • Create and manage SendGrid accounts
  • Send emails through SendGrid
  • Manage email templates
  • Get statistics on email sends
  • And more!

Trigger Code

import common from "../common/http-based.mjs";
import deliveryEventTypes from "./delivery-event-types.mjs";
import engagementEventTypes from "./engagement-event-types.mjs";

export default {
  ...common,
  key: "sendgrid-events",
  name: "New Events (Instant)",
  description: "Emit new event when any of the specified SendGrid events is received",
  version: "0.0.3",
  type: "source",
  dedupe: "unique",
  props: {
    ...common.props,
    eventTypes: {
      type: "string[]",
      label: "Event Types",
      description: "The type of events to listen to",
      options(context) {
        const { page } = context;
        if (page !== 0) {
          return {
            options: [],
          };
        }

        const options = [
          ...deliveryEventTypes,
          ...engagementEventTypes,
        ];
        return {
          options,
        };
      },
    },
  },
  methods: {
    ...common.methods,
    baseWebhookSettings() {
      // The list of events that a webhook can listen to. This method returns an
      // exhaustive list of all such flags disabled, and each event source can
      // then override the flags that are relevant to the event they handle.
      //
      // See the docs for more information:
      // https://sendgrid.com/docs/api-reference/
      const eventTypesData = [
        ...deliveryEventTypes,
        ...engagementEventTypes,
      ];
      return eventTypesData.reduce((accum, eventTypeData) => ({
        ...accum,
        [eventTypeData.value]: false,
      }), {});
    },
    webhookEventFlags() {
      return this.eventTypes.reduce((accum, eventType) => ({
        ...accum,
        [eventType]: true,
      }), {});
    },
    generateMeta(data) {
      const {
        event: eventType,
        sg_event_id: id,
        timestamp: ts,
      } = data;
      const summary = `New event: ${eventType}`;
      return {
        id,
        summary,
        ts,
      };
    },
  },
};

Trigger Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.
LabelPropTypeDescription
N/Adb$.service.dbThis component uses $.service.db to maintain state between component invocations.
Twilio SendGridsendgridappThis component uses the Twilio SendGrid app.
N/Ahttp$.interface.httpThis component uses $.interface.http to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the run() method of the component.
Event TypeseventTypesstring[]Select a value from the drop down menu.

Trigger Authentication

Twilio SendGrid uses API keys for authentication. When you connect your Twilio SendGrid account, Pipedream securely stores the keys so you can easily authenticate to Twilio SendGrid APIs in both code and no-code steps.

Enter your Sendgrid API key below

About Twilio SendGrid

Delivering your transactional and marketing emails through the world's largest cloud-based email delivery platform. Send with confidence.

Action

Description:Create one or more records in a table by passing an array of objects containing field names and values as key/value pairs.
Version:0.2.0
Key:airtable-create-multiple-records

Airtable Overview

Using the Airtable API, you can build applications that can:

  • Create and manage databases
  • Add, update, and delete records
  • Search for records
  • Sort and filter records
  • Display records in a variety of ways
  • Import and export data

Action Code

import chunk from "lodash.chunk";
import airtable from "../../airtable.app.mjs";
import common from "../common.mjs";

const BATCH_SIZE = 10; // The Airtable API allows us to update up to 10 rows per request.

export default {
  key: "airtable-create-multiple-records",
  name: "Create Multiple Records",
  description: "Create one or more records in a table by passing an array of objects containing field names and values as key/value pairs.",
  version: "0.2.0",
  type: "action",
  props: {
    ...common.props,
    records: {
      propDefinition: [
        airtable,
        "records",
      ],
    },
    typecast: {
      propDefinition: [
        airtable,
        "typecast",
      ],
    },
  },
  async run({ $ }) {
    const baseId = this.baseId?.value ?? this.baseId;
    const tableId = this.tableId?.value ?? this.tableId;

    const table = this.airtable.base(baseId)(tableId);

    let data = this.records;
    if (!Array.isArray(data)) {
      data = JSON.parse(data);
    }
    data = data.map((fields) => ({
      fields,
    }));
    if (!data.length) {
      throw new Error("No Airtable record data passed to step. Please pass at least one record");
    }

    const params = {
      typecast: this.typecast,
    };

    const responses = [];
    for (const c of chunk(data, BATCH_SIZE)) {
      try {
        responses.push(...(await table.create(c, params)));
      } catch (err) {
        this.airtable.throwFormattedError(err);
      }
    }

    const l = responses.length;
    $.export("$summary", `Added ${l} record${l === 1
      ? ""
      : "s"} to ${this.baseId?.label || baseId}: [${this.tableId?.label || tableId}](https://airtable.com/${baseId}/${tableId})`);

    return responses;
  },
};

Action Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

LabelPropTypeDescription
AirtableairtableappThis component uses the Airtable app.
BasebaseIdstringSelect a value from the drop down menu.
TabletableIdstringSelect a value from the drop down menu.
Recordsrecordsstring

Provide an array of objects. Each object should represent a new record with the column name as the key and the data to insert as the corresponding value (e.g., passing [{"foo":"bar","id":123},{"foo":"baz","id":456}] will create two records and with values added to the fields foo and id). The most common pattern is to reference an array of objects exported by a previous step (e.g., {{steps.foo.$return_value}}). You may also enter or construct a string that will JSON.parse() to an array of objects.

Typecasttypecastboolean

The Airtable API will perform best-effort automatic data conversion from string values if the typecast parameter is True. Automatic conversion is disabled by default to ensure data integrity, but it may be helpful for integrating with 3rd party data sources.

Action Authentication

Airtable uses API keys for authentication. When you connect your Airtable account, Pipedream securely stores the keys so you can easily authenticate to Airtable APIs in both code and no-code steps.

Visit your account settings, copy your API key, and enter it below. If you only need to read data from Airtable, and not modify it, you can generate a read-only API key.


get airtable api key

About Airtable

Looks like a spreadsheet, acts like a database.

More Ways to Connect Airtable + Twilio SendGrid

Delete Record with Airtable API on Events (Instant) from Twilio SendGrid API
Twilio SendGrid + Airtable
 
Try it
Get Record with Airtable API on Events (Instant) from Twilio SendGrid API
Twilio SendGrid + Airtable
 
Try it
List Records in View with Airtable API on Events (Instant) from Twilio SendGrid API
Twilio SendGrid + Airtable
 
Try it
List Records with Airtable API on Events (Instant) from Twilio SendGrid API
Twilio SendGrid + Airtable
 
Try it
Update record with Airtable API on Events (Instant) from Twilio SendGrid API
Twilio SendGrid + Airtable
 
Try it
New Contact from the Twilio SendGrid API

Emit new event when a new contact is created

 
Try it
New Events (Instant) from the Twilio SendGrid API

Emit new event when any of the specified SendGrid events is received

 
Try it
New or Modified Records from the Airtable API

Emit an event for each new or modified record in a table

 
Try it
New or Modified Records in View from the Airtable API

Emit an event for each new or modified record in a view

 
Try it
New Records from the Airtable API

Emit an event for each new record in a table

 
Try it
Add Email to Global Suppression with the Twilio SendGrid API

Allows you to add one or more email addresses to the global suppressions group. See the docs here

 
Try it
Add or Update Contact with the Twilio SendGrid API

Adds or updates a contact. See the docs here

 
Try it
Create Contact List with the Twilio SendGrid API

Allows you to create a new contact list. See the docs here

 
Try it
Delete Blocks with the Twilio SendGrid API

Allows you to delete all email addresses on your blocks list. See the docs here

 
Try it
Delete Bounces with the Twilio SendGrid API

Allows you to delete all emails on your bounces list. See the docs here

 
Try it