{"id":675,"date":"2023-06-14T02:42:34","date_gmt":"2023-06-14T02:42:34","guid":{"rendered":"https:\/\/moceanapi.com\/blog\/?p=675"},"modified":"2025-10-03T06:31:03","modified_gmt":"2025-10-03T06:31:03","slug":"integrate-sms-in-airtable-via-zapier-in-4-steps","status":"publish","type":"post","link":"https:\/\/moceanapi.com\/blog\/integrate-sms-in-airtable-via-zapier-in-4-steps\/","title":{"rendered":"Integrate SMS in Airtable via Zapier in 4 steps"},"content":{"rendered":"\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#introduction\">Introduction<\/a><ul><li><a href=\"#overview-of-airtable-and-zapier\">Overview of Airtable and Zapier<\/a><\/li><\/ul><\/li><li><a href=\"#step-1-creating-a-zap-for-airtable-sms-integration\">Step 1: Creating a Zap for Airtable SMS Integration<\/a><\/li><li><a href=\"#step-2-connect-airtable-account\">Step 2: Connect Airtable Account<\/a><\/li><li><a href=\"#step-3-connect-mocean-api-account\">Step 3: Connect MoceanAPI Account<\/a><\/li><li><a href=\"#step-4-sending-test-sms\">Step 4: Sending Test SMS<\/a><\/li><li><a href=\"#use-cases-of-sms-integration-in-airtable\">Use cases of SMS integration in Airtable<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"introduction\">Introduction<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"overview-of-airtable-and-zapier\">Overview of Airtable and Zapier<\/h3>\n\n\n\n<p>Airtable is a versatile and powerful cloud-based collaboration platform that combines the best aspects of spreadsheets and databases. With its intuitive interface and customizable structure, Airtable allows users to organize, store, and analyze data in a visually appealing manner. Whether you&#8217;re managing projects, tracking inventory, or organizing customer information, Airtable offers a flexible solution that adapts to your unique needs. Its extensive range of features, including powerful filtering options, collaborative functionalities, and integration capabilities, make it a go-to tool for individuals, teams, and businesses of all sizes. By providing a user-friendly environment, Airtable empowers users to streamline their workflows, enhance productivity, and unlock new levels of efficiency.<\/p>\n\n\n\n<p>Zapier on the other hand, is an automation tool that connects different apps and services, enabling seamless data transfer and workflow automation. With Zapier, you can effortlessly integrate and automate tasks between various applications without any coding knowledge. By creating &#8220;Zaps,&#8221; which are automated workflows, you can connect trigger events from one app to perform actions in another. This allows for the automation of repetitive tasks, data synchronization, and real-time information sharing across multiple platforms. Zapier supports a vast number of popular apps and services, making it a versatile tool for improving productivity and efficiency. Whether you want to automate lead generation, streamline data entry, or sync information between apps, Zapier simplifies the process and empowers you to focus on what matters most \u2013 growing your business and achieving your goals.<\/p>\n\n\n\n<p>In this article, you will learn how to integrate SMS in Airtable via Zapier using MoceanAPI (SMS Gateway).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-1-creating-a-zap-for-airtable-sms-integration\">Step 1: Creating a Zap for Airtable SMS Integration<\/h2>\n\n\n\n<p>1. Login to Zapier and <strong>Create a Zap<\/strong><\/p>\n\n\n\n<p>Under <strong>Connect this app<\/strong>, select <strong>Airtable<\/strong><\/p>\n\n\n\n<p>Under <strong>with this one!<\/strong>, select <strong>Mocean API<\/strong><\/p>\n\n\n\n<p>2. Selecting the trigger and the action to be taken<\/p>\n\n\n\n<p>Under <strong>When this happens<\/strong>, select <strong>New or Updated Record<\/strong><\/p>\n\n\n\n<p>Under <strong>then do this!<\/strong>, select <strong>Send SMS<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"343\" src=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-41-1024x343.png\" alt=\"Make a zap of airtable and moceanapi\" class=\"wp-image-677\" srcset=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-41-1024x343.png 1024w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-41-300x101.png 300w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-41-768x258.png 768w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-41.png 1306w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-2-connect-airtable-account\">Step 2: Connect Airtable Account<\/h2>\n\n\n\n<p>1. Login to Zapier and click on <strong>Sign in<\/strong><\/p>\n\n\n\n<p>2. Grant Zapier access to Airtable<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"563\" src=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-42-1024x563.png\" alt=\"Connecting airtable account\" class=\"wp-image-680\" srcset=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-42-1024x563.png 1024w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-42-300x165.png 300w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-42-768x423.png 768w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-42.png 1432w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Configure the required parameters<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Base<\/strong> &#8211; The workspace you&#8217;re intending to use<\/li>\n\n\n\n<li><strong>Table<\/strong> &#8211; The table in the workspace you&#8217;re intending to use<\/li>\n\n\n\n<li><strong>Timestamp field<\/strong> &#8211; The it must be a <strong>Last Modified Time<\/strong> column type<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"955\" height=\"832\" src=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-43.png\" alt=\"configuring airtable required parameters \" class=\"wp-image-681\" srcset=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-43.png 955w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-43-300x261.png 300w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-43-768x669.png 768w\" sizes=\"(max-width: 955px) 100vw, 955px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-3-connect-mocean-api-account\">Step 3: Connect MoceanAPI Account<\/h2>\n\n\n\n<p>Login to your MoceanAPI Account, if you don&#8217;t already have one, you can register <a href=\"https:\/\/dashboard.moceanapi.com\/register?fr=zapier\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a> and get 20 free trial credits.<\/p>\n\n\n\n<p>Click on <strong>Sign in<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"978\" height=\"768\" src=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-68.png\" alt=\"\" class=\"wp-image-772\" srcset=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-68.png 978w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-68-300x236.png 300w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-68-768x603.png 768w\" sizes=\"(max-width: 978px) 100vw, 978px\" \/><\/figure>\n\n\n\n<p>Option 1: Enter your <strong>MoceanAPI Token<\/strong>, you can find it <a href=\"https:\/\/dashboard.moceanapi.com\/company\/apisetting\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a><\/p>\n\n\n\n<p>Option 2 (legacy): Enter your <strong>MoceanAPI Key<\/strong> and <strong>Secret<\/strong>, you can find it <a href=\"https:\/\/dashboard.moceanapi.com\/company\/apisetting\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a><\/p>\n\n\n\n<p>After you\u2019ve connected your MoceanAPI Account, you will need to enter the fields below:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Sender ID<\/strong>&nbsp;\u2013 Usually, it will be your business name.<\/li>\n\n\n\n<li><strong>Receiver Number<\/strong>&nbsp;\u2013 The phone number to send SMS to<\/li>\n\n\n\n<li><strong>Content<\/strong>&nbsp;\u2013 The SMS text message<\/li>\n<\/ul>\n\n\n\n<p>To get better engagement rate, personalize your SMS message that ties to your customer personally. For example, <em>Priority of <strong>{record name}<\/strong> is now <strong>{priority}<\/strong><\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1002\" height=\"897\" src=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-50.png\" alt=\"configure and map keyword fields to moceanapi configuration\" class=\"wp-image-689\" srcset=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-50.png 1002w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-50-300x269.png 300w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-50-768x688.png 768w\" sizes=\"(max-width: 1002px) 100vw, 1002px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-4-sending-test-sms\">Step 4: Sending Test SMS<\/h2>\n\n\n\n<p>Now you\u2019ve configured everything and it is time to test sending SMS reminder.<\/p>\n\n\n\n<p>If you\u2019ve followed everything we did so far, you know the trigger we used was&nbsp;<strong>New or Updated Record<\/strong>, so go ahead and update an existing record<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"291\" src=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-51-1024x291.png\" alt=\"Airtable base\" class=\"wp-image-690\" srcset=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-51-1024x291.png 1024w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-51-300x85.png 300w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-51-768x218.png 768w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-51.png 1373w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>You will receive an SMS to your configured phone column value. To verify, go to&nbsp;<a href=\"https:\/\/dashboard.moceanapi.com\/message\/transaction\">Mocean Dashboard<\/a>&nbsp;and enter the phone number of your configured phone column.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"219\" src=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-49-1024x219.png\" alt=\"Track SMS transactions\" class=\"wp-image-688\" srcset=\"https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-49-1024x219.png 1024w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-49-300x64.png 300w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-49-768x164.png 768w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-49-1536x328.png 1536w, https:\/\/moceanapi.com\/blog\/wp-content\/uploads\/2023\/06\/image-49-2048x437.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>You only need to configure this automation once and it will always repeat itself whenever the trigger activated.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"use-cases-of-sms-integration-in-airtable\">Use cases of SMS integration in Airtable<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Appointment Reminders<\/strong><br>By integrating SMS with Airtable, you can send automated appointment reminders to clients or customers. This helps reduce no-shows and improves overall scheduling efficiency.<br>Great for you, if you&#8217;re running a service-based business. Eg: Michelin Starred Restaurant.<\/li>\n\n\n\n<li><strong>Order Status Updates<\/strong><br>If you have an e-commerce business, you can leverage SMS integration in Airtable to provide real-time updates to customers about their order status. Sending SMS notifications for order confirmations, shipping updates, and delivery notifications enhances customer satisfaction and engagement.<\/li>\n\n\n\n<li><strong>Event Registrations and Confirmations<\/strong><br>With SMS integration, you can streamline event registrations and confirmations. Using Airtable, you can collect attendee information and automatically send SMS confirmations with event details, directions, and any other relevant information.<\/li>\n\n\n\n<li><strong>Customer Support and Helpdesk<\/strong><br>Integrating SMS with Airtable enables you to provide personalized customer support via text messages. You can create workflows in Airtable to manage incoming customer queries, assign them to support agents, and send timely SMS responses for quick issue resolution.<\/li>\n\n\n\n<li><strong>Marketing Campaigns and Promotions<\/strong><br>Airtable&#8217;s integration with SMS allows you to send targeted marketing messages and promotional offers directly to your customers&#8217; mobile devices. You can segment your audience in Airtable and use SMS to reach them with personalized marketing content, boosting engagement and conversion rates.<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Overview of Airtable and Zapier Airtable is a versatile and powerful cloud-based collaboration platform that combines the best aspects of spreadsheets and databases. With its intuitive interface and customizable structure, Airtable allows users to organize, store, and analyze data in a visually appealing manner. Whether you&#8217;re managing projects, tracking inventory, or organizing customer information,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":676,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[24],"tags":[],"class_list":["post-675","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-zapier"],"_links":{"self":[{"href":"https:\/\/moceanapi.com\/blog\/wp-json\/wp\/v2\/posts\/675"}],"collection":[{"href":"https:\/\/moceanapi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/moceanapi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/moceanapi.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/moceanapi.com\/blog\/wp-json\/wp\/v2\/comments?post=675"}],"version-history":[{"count":4,"href":"https:\/\/moceanapi.com\/blog\/wp-json\/wp\/v2\/posts\/675\/revisions"}],"predecessor-version":[{"id":774,"href":"https:\/\/moceanapi.com\/blog\/wp-json\/wp\/v2\/posts\/675\/revisions\/774"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/moceanapi.com\/blog\/wp-json\/wp\/v2\/media\/676"}],"wp:attachment":[{"href":"https:\/\/moceanapi.com\/blog\/wp-json\/wp\/v2\/media?parent=675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/moceanapi.com\/blog\/wp-json\/wp\/v2\/categories?post=675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/moceanapi.com\/blog\/wp-json\/wp\/v2\/tags?post=675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}