How to Automatically Add New Shopify Orders to Airtable Using Pabbly Connect

Learn how to automate adding new Shopify orders to Airtable using Pabbly Connect. Follow this detailed tutorial for seamless integration. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Shopify and Airtable Integration

To start automating the process of adding new Shopify orders to Airtable, first, access Pabbly Connect. Open your web browser and navigate to Pabbly.com Connect. This platform enables seamless integration between various applications, including Shopify and Airtable.

Once on the Pabbly Connect homepage, you have the option to sign up for a free account or log in if you are an existing user. After logging in, you will be directed to the Pabbly Connect dashboard, where you can create a new workflow.

2. Creating a New Workflow in Pabbly Connect

In this section, you will create a new workflow to integrate Shopify and Airtable using Pabbly Connect. Click on the ‘Create Workflow’ button located at the top right corner of the dashboard. This action will prompt you to name your workflow; enter a relevant name such as ‘Add New Shopify Orders to Airtable Automatically’.

• Click on the ‘Create’ button after naming your workflow.
• Select ‘Shopify’ as your trigger application.
• Choose the ‘New Order’ event to trigger the workflow.

After selecting the trigger application and event, click on the ‘Connect’ button to establish the connection between Pabbly Connect and your Shopify account. This integration will allow Pabbly to capture new order details automatically.

3. Setting Up Webhooks in Shopify

To enable real-time order tracking, you need to set up webhooks in your Shopify account using Pabbly Connect. Copy the webhook URL provided by Pabbly Connect after setting up your trigger. Next, log into your Shopify account and navigate to the ‘Settings’ section.

• Under the ‘Settings’ menu, select ‘Notifications’.
• Scroll down to the ‘Webhooks’ section and click on ‘Create Webhook’.
• Set the event to ‘Order Creation’ and paste the copied URL from Pabbly Connect.

Save the changes, and your Shopify account will now send order details to Pabbly Connect whenever a new order is placed. This step is crucial for ensuring that your Airtable database is updated automatically.

4. Configuring Airtable as the Action Application

Now that Shopify is set up, it’s time to configure Airtable as the action application in Pabbly Connect. Click on the ‘Add Action’ button in your workflow and select ‘Airtable’ from the list of applications. Next, choose the ‘Create Record’ action event.

After selecting Airtable, you will need to connect your Airtable account to Pabbly Connect. Click on the ‘Connect’ button and authorize the access. Once connected, select the base and table where you want the order details to be stored.

5. Mapping Data from Shopify to Airtable

The final step is to map the data from Shopify to Airtable using Pabbly Connect. In this section, you will see fields for mapping the data such as name, email, city, amount, order number, and item name. This mapping ensures that the correct data is transferred to the right fields in Airtable.

Map the customer name from the Shopify order details to the corresponding field in Airtable. Continue mapping other fields like email, city, amount, order number, and item name accordingly.

After mapping all required fields, click on the ‘Save’ button to finalize the setup. Your integration is now complete, and new Shopify orders will automatically be added to Airtable as new records.

Conclusion

By following this detailed tutorial, you have successfully integrated Shopify with Airtable using Pabbly Connect. This automation allows you to manage your orders efficiently, ensuring that your inventory tracking and reporting are always up to date without manual effort.