This workflow follows the Airtable → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "SMS 18:45 + SMS 9:00",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9,
"triggerAtMinute": 2
},
{
"triggerAtHour": 18,
"triggerAtMinute": 47
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
0,
96
],
"id": "f3148393-455a-45fe-8d81-8ff8cdb0757d",
"name": "Odpal co godzin\u0119"
},
{
"parameters": {
"operation": "search",
"base": {
"__rl": true,
"value": "YOUR_AIRTABLE_BASE_ID",
"mode": "list",
"cachedResultName": "Nowy klient",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID"
},
"table": {
"__rl": true,
"value": "YOUR_AIRTABLE_TABLE_ID",
"mode": "list",
"cachedResultName": "Table 1",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID/YOUR_AIRTABLE_TABLE_ID"
},
"filterByFormula": "=AND(\n IS_SAME(SET_TIMEZONE(NOW(), 'Europe/Warsaw'), {Czas stworzenia}, 'day'),\n TIMESTR(SET_TIMEZONE(NOW(), 'Europe/Warsaw')) >= '18:45:00',\n {Sms 1845} = 0\n)",
"options": {}
},
"type": "n8n-nodes-base.airtable",
"typeVersion": 2.1,
"position": [
208,
0
],
"id": "9a58b385-1318-4266-9d66-92aae561d4e9",
"name": "Czy SMS 1845",
"executeOnce": true,
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "update",
"base": {
"__rl": true,
"value": "YOUR_AIRTABLE_BASE_ID",
"mode": "list",
"cachedResultName": "Nowy klient",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID"
},
"table": {
"__rl": true,
"value": "YOUR_AIRTABLE_TABLE_ID",
"mode": "list",
"cachedResultName": "Table 1",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID/YOUR_AIRTABLE_TABLE_ID"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Sms 1845": true,
"id": "={{ $('Czy SMS 1845').item.json.id }}"
},
"matchingColumns": [
"id"
],
"schema": [
{
"id": "id",
"displayName": "id",
"required": false,
"defaultMatch": true,
"display": true,
"type": "string",
"readOnly": true,
"removed": false
},
{
"id": "Imie",
"displayName": "Imie",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Numer telefonu",
"displayName": "Numer telefonu",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Adres",
"displayName": "Adres",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Mail Agenta",
"displayName": "Mail Agenta",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Data",
"displayName": "Data",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "dateTime",
"readOnly": false,
"removed": true
},
{
"id": "Czas stworzenia",
"displayName": "Czas stworzenia",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": true,
"removed": true
},
{
"id": "Sms 1845",
"displayName": "Sms 1845",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "boolean",
"readOnly": false,
"removed": false
},
{
"id": "Sms 900",
"displayName": "Sms 900",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "boolean",
"readOnly": false,
"removed": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.airtable",
"typeVersion": 2.1,
"position": [
608,
0
],
"id": "7db6afab-65a3-4b64-8fdc-49de9c169710",
"name": "Zaznacz checkbox 1",
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "update",
"base": {
"__rl": true,
"value": "YOUR_AIRTABLE_BASE_ID",
"mode": "list",
"cachedResultName": "Nowy klient",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID"
},
"table": {
"__rl": true,
"value": "YOUR_AIRTABLE_TABLE_ID",
"mode": "list",
"cachedResultName": "Table 1",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID/YOUR_AIRTABLE_TABLE_ID"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Sms 900": true,
"id": "={{ $('Czy SMS 900').item.json.id }}"
},
"matchingColumns": [
"id"
],
"schema": [
{
"id": "id",
"displayName": "id",
"required": false,
"defaultMatch": true,
"display": true,
"type": "string",
"readOnly": true,
"removed": false
},
{
"id": "Imie",
"displayName": "Imie",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Numer telefonu",
"displayName": "Numer telefonu",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Adres",
"displayName": "Adres",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Mail Agenta",
"displayName": "Mail Agenta",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": true
},
{
"id": "Data",
"displayName": "Data",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "dateTime",
"readOnly": false,
"removed": true
},
{
"id": "Czas stworzenia",
"displayName": "Czas stworzenia",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": true,
"removed": true
},
{
"id": "Sms 1845",
"displayName": "Sms 1845",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "boolean",
"readOnly": false,
"removed": true
},
{
"id": "Sms 900",
"displayName": "Sms 900",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "boolean",
"readOnly": false,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.airtable",
"typeVersion": 2.1,
"position": [
832,
176
],
"id": "1393873e-f2ef-4b08-96ed-5dc5166a9141",
"name": "Zaznacz checkbox 2",
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "search",
"base": {
"__rl": true,
"value": "YOUR_AIRTABLE_BASE_ID",
"mode": "list",
"cachedResultName": "Nowy klient",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID"
},
"table": {
"__rl": true,
"value": "YOUR_AIRTABLE_TABLE_ID",
"mode": "list",
"cachedResultName": "Table 1",
"cachedResultUrl": "https://airtable.com/YOUR_AIRTABLE_BASE_ID/YOUR_AIRTABLE_TABLE_ID"
},
"filterByFormula": "=AND(\n IS_SAME(SET_TIMEZONE(NOW(), 'Europe/Warsaw'), {Data}, 'day'),\n TIMESTR(SET_TIMEZONE(NOW(), 'Europe/Warsaw')) >= '09:00:00',\n {Sms 900} = 0\n)",
"options": {}
},
"type": "n8n-nodes-base.airtable",
"typeVersion": 2.1,
"position": [
192,
176
],
"id": "8f2aa5a6-ad53-4bf7-a743-a3dd3e6c778e",
"name": "Czy SMS 900",
"executeOnce": true,
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"url": "https://app.sms8.io/services/send.php",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "key",
"value": "YOUR_SMS8_API_KEY"
},
{
"name": "number",
"value": "={{ $json['Numer telefonu'] }}"
},
{
"name": "message",
"value": "=Nie wspomnia\u0142em wcze\u015bniej -\nhttps://www.instagram.com/agentszymonzygmunt - tutaj mo\u017cna znale\u017a\u0107 przyk\u0142ady mojej codziennej pracy w nieruchomo\u015bciach, warto zerkn\u0105\u0107 przed spotkaniem;) \n"
},
{
"name": "devices",
"value": "YOUR_DEVICE_ID"
},
{
"name": "type",
"value": "sms"
},
{
"name": "prioritize",
"value": "0"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
416,
0
],
"id": "de1d4deb-3441-4c8f-b02f-deb440c3be12",
"name": "SMS nr2"
},
{
"parameters": {
"url": "https://app.sms8.io/services/send.php",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "key",
"value": "YOUR_SMS8_API_KEY"
},
{
"name": "number",
"value": "={{ $('Czy SMS 900').item.json['Numer telefonu'] }}"
},
{
"name": "message",
"value": "=Przypominam o naszym spotkaniu dzi\u015b o {{ $('Date & Time').item.json.godzinaDATA }}:{{ $json.minDATA }} pod adresem {{ $('Czy SMS 900').item.json.Adres }}.\nDo zobaczenia!"
},
{
"name": "devices",
"value": "YOUR_DEVICE_ID"
},
{
"name": "type",
"value": "sms"
},
{
"name": "prioritize",
"value": "0"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
672,
176
],
"id": "11882e02-2a67-49e4-9f8f-455b80891e37",
"name": "SMS nr3"
},
{
"parameters": {
"operation": "extractDate",
"date": "={{ $json.Data }}",
"part": "hour",
"outputFieldName": "godzinaDATA",
"options": {}
},
"type": "n8n-nodes-base.dateTime",
"typeVersion": 2,
"position": [
368,
176
],
"id": "3a4a7211-ed88-4f35-b477-affe8a7aee3a",
"name": "Date & Time",
"executeOnce": false
},
{
"parameters": {
"operation": "extractDate",
"date": "={{ $('Czy SMS 900').item.json.Data }}",
"part": "minute",
"outputFieldName": "minDATA",
"options": {}
},
"type": "n8n-nodes-base.dateTime",
"typeVersion": 2,
"position": [
512,
176
],
"id": "4077ee22-6fc1-42c1-a7bd-739166a91e10",
"name": "Date & Time1",
"executeOnce": false
}
],
"connections": {
"Odpal co godzin\u0119": {
"main": [
[
{
"node": "Czy SMS 1845",
"type": "main",
"index": 0
},
{
"node": "Czy SMS 900",
"type": "main",
"index": 0
}
]
]
},
"Czy SMS 1845": {
"main": [
[
{
"node": "SMS nr2",
"type": "main",
"index": 0
}
]
]
},
"Zaznacz checkbox 1": {
"main": [
[]
]
},
"Czy SMS 900": {
"main": [
[
{
"node": "Date & Time",
"type": "main",
"index": 0
}
]
]
},
"SMS nr2": {
"main": [
[
{
"node": "Zaznacz checkbox 1",
"type": "main",
"index": 0
}
]
]
},
"SMS nr3": {
"main": [
[
{
"node": "Zaznacz checkbox 2",
"type": "main",
"index": 0
}
]
]
},
"Date & Time": {
"main": [
[
{
"node": "Date & Time1",
"type": "main",
"index": 0
}
]
]
},
"Date & Time1": {
"main": [
[
{
"node": "SMS nr3",
"type": "main",
"index": 0
}
]
]
}
},
"active": true,
"settings": {
"executionOrder": "v1"
},
"versionId": "410ebc3c-aaff-445b-ad3f-96127544cb60",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "FzgFU2hykB5fqFut",
"tags": []
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
airtableTokenApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
SMS 18:45 + SMS 9:00. Uses airtable, httpRequest. Scheduled trigger; 9 nodes.
Source: https://github.com/czub-w/real-estate-crm-n8n/blob/a964a3c25472525a2cc3a3252d0e4c6d50013abb/SMS_workflow_PUBLIC.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
I prepared a detailed guide that showed the whole process of integrating the Binance API and storing data in Airtable to manage funding statements associated with tokens in a wallet.
Crypto, HTTP Request, Airtable
Stop wasting hours on manual dialing and listening to ringtones. This workflow transforms your Airtable into a high-velocity AI Call Center using Vapi AI**.
Airtable, HTTP Request
Reel-Analysis-Of-Favourite-Content-Creator. Uses httpRequest, airtable. Scheduled trigger; 26 nodes.
HTTP Request, Airtable
Link-By-Reel-Analysis. Uses httpRequest, airtable. Scheduled trigger; 24 nodes.
HTTP Request, Airtable
> Transform your content strategy with automated competitor intelligence
HTTP Request, Airtable, Notion +2