How to Automatically Add Shopify Products from Airtable Using Pabbly Connect

Learn how to seamlessly integrate Airtable and Shopify using Pabbly Connect for automated product management. Step-by-step guide included. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Connecting Pabbly Connect to Airtable and Shopify

To start automating the addition of Shopify products from Airtable, first, access Pabbly Connect. This platform allows you to create workflows that connect different applications seamlessly. Sign in to your existing account or create a new one at Pabbly.com/connect. Once logged in, click on the ‘Create Workflow’ button to begin.

Next, name your workflow something descriptive, such as ‘When Product is Added in Airtable, Create Product in Shopify’. After naming your workflow, you will see two boxes for setting up the trigger and action. The trigger will be Airtable, and the action will be Shopify. This setup allows Pabbly Connect to listen for new records added in Airtable and create corresponding products in Shopify.

2. Setting Up the Airtable Trigger in Pabbly Connect

In this step, select Airtable as your trigger application. Choose the trigger event as ‘New Record’. This means every time a new product entry is made in Airtable, it will initiate the workflow in Pabbly Connect. You will need to connect your Airtable account by providing the API token.

• Copy your Airtable API token from your Airtable account settings.
• Paste the token into the Pabbly Connect setup to establish the connection.
• Select the base and table where your product data is stored.

After setting up the trigger, you will need to create a field in Airtable to capture the creation time. This field is essential for tracking when new records are added. Once you have configured these settings, click on ‘Save and Send Test Request’ to verify that Pabbly Connect can pull data from Airtable correctly.

3. Adding a Filter Condition for Product Creation

Once the Airtable trigger is successfully set up, the next step is to add a filter condition. This condition will check if the inventory update field in Airtable is marked as ‘Yes’. If it is, only then will Pabbly Connect proceed to create the product in Shopify.

• Select the filter option in Pabbly Connect and set the condition.
• Specify that the inventory update field must equal ‘Yes’ to proceed.
• Save the filter settings to ensure the workflow only runs under the correct conditions.

This filter ensures that products are only created in Shopify when you intend to update the inventory, preventing unnecessary entries. With this condition in place, you can now proceed to set up the action step.

4. Configuring the Shopify Action in Pabbly Connect

The next step is to set Shopify as the action application in Pabbly Connect. Choose the action event as ‘Create Product’. This setup allows Pabbly Connect to take the product details from Airtable and push them into Shopify automatically.

To connect Shopify, you will need to provide your Shopify store’s subdomain and API token. These can be obtained from your Shopify admin settings by creating a new app and granting it the necessary permissions to manage products.

After connecting Shopify, map the fields from Airtable to the corresponding fields in Shopify. This includes product title, description, price, quantity, and image URL. Mapping ensures that the correct data is transferred when a new product is added in Airtable.

5. Testing and Activating the Integration

After configuring all settings, it’s time to test the integration. Click on ‘Save and Send Test Request’ in Pabbly Connect to create a test product in Shopify. If everything is set up correctly, you should see the new product appear in your Shopify store.

Once the test is successful, your integration is complete. Now, every time you add a new product in Airtable, Pabbly Connect will automatically create the product in Shopify every 10 minutes. This automation saves time and reduces manual entry errors.

With Pabbly Connect, you can sit back and relax, knowing that your product data is synced effortlessly between Airtable and Shopify. This powerful automation can help streamline your eCommerce operations significantly.

Conclusion

Using Pabbly Connect, you can easily automate the process of adding Shopify products from Airtable. This integration not only saves time but also enhances accuracy in product management. By following the steps outlined in this tutorial, you can set up a seamless workflow that keeps your Shopify store updated automatically.