Can I use n8n for iterating through an airtable list and sending bulk MMS through twilio?

Hi,

I’m evaluating n8n. Would appreciate if anyone has tried this and can comment on it.

I want to get a list of numbers from Airtable.
I want to send an MMS to all these numbers through Twilio.
I want to update the list from Airtable

Regards,
Ruchika

@ruchikaabbi welcome to the community.

Yes, this is posible. It should look something like this:

Workflow
{
      "nodes": [
        {
          "parameters": {},
          "name": "Start",
          "type": "n8n-nodes-base.start",
          "typeVersion": 1,
          "position": [
            250,
            300
          ]
        },
        {
          "parameters": {
            "operation": "list",
            "application": "appXK4YYl2hKGCNCJ",
            "table": "T1",
            "additionalOptions": {
              "view": "Grid 2"
            }
          },
          "name": "Airtable",
          "type": "n8n-nodes-base.airtable",
          "typeVersion": 1,
          "position": [
            550,
            300
          ],
          "credentials": {
            "airtableApi": "asasasa"
          }
        },
        {
          "parameters": {
            "from": "18058371815",
            "to": "={{$node[\"Airtable\"].json[\"fields\"][\"phone\"]}}",
            "message": "testing"
          },
          "name": "Twilio",
          "type": "n8n-nodes-base.twilio",
          "typeVersion": 1,
          "position": [
            810,
            300
          ],
          "credentials": {
            "twilioApi": "asasas"
          }
        },
        {
          "parameters": {
            "operation": "update",
            "application": "appXK4YYl2hKGCNCJ",
            "table": "T1",
            "id": "={{$node[\"Set\"].json[\"id\"]}}",
            "options": {
              "ignoreFields": "id"
            }
          },
          "name": "Airtable1",
          "type": "n8n-nodes-base.airtable",
          "typeVersion": 1,
          "position": [
            1420,
            610
          ],
          "credentials": {
            "airtableApi": "asasasa"
          }
        },
        {
          "parameters": {
            "mode": "passThrough",
            "output": "input2"
          },
          "name": "Merge",
          "type": "n8n-nodes-base.merge",
          "typeVersion": 1,
          "position": [
            950,
            610
          ]
        },
        {
          "parameters": {
            "keepOnlySet": true,
            "values": {
              "boolean": [],
              "string": [
                {
                  "name": "id",
                  "value": "={{$node[\"Merge\"].json[\"id\"]}}"
                },
                {
                  "name": "Message Was Sent",
                  "value": "true"
                }
              ]
            },
            "options": {}
          },
          "name": "Set",
          "type": "n8n-nodes-base.set",
          "typeVersion": 1,
          "position": [
            1180,
            610
          ]
        }
      ],
      "connections": {
        "Start": {
          "main": [
            [
              {
                "node": "Airtable",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "Airtable": {
          "main": [
            [
              {
                "node": "Twilio",
                "type": "main",
                "index": 0
              },
              {
                "node": "Merge",
                "type": "main",
                "index": 1
              }
            ]
          ]
        },
        "Twilio": {
          "main": [
            [
              {
                "node": "Merge",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "Merge": {
          "main": [
            [
              {
                "node": "Set",
                "type": "main",
                "index": 0
              }
            ]
          ]
        },
        "Set": {
          "main": [
            [
              {
                "node": "Airtable1",
                "type": "main",
                "index": 0
              }
            ]
          ]
        }
      }
    }

Airtable Table:

1 Like

Awesome! Thanks for the quick response. I’ll try this!