How to Add Order Details of Swell to Google Sheets Using Pabbly Connect

Learn how to automate adding order details from Swell to Google Sheets using Pabbly Connect. Follow our step-by-step tutorial for seamless integration. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Integration

To begin automating the process of adding order details from Swell to Google Sheets, you need to access Pabbly Connect. You can sign up for a free account by clicking the link provided in the description below. Once you have signed up, navigate to your dashboard.

From your Pabbly Connect dashboard, click on the ‘Create Workflow’ button. Here, you can name your workflow something like ‘Swell to Google Sheets’ and click on ‘Create’ to start the integration process. This is where you will set up the trigger and action for the automation.

2. Setting Up the Trigger from Swell

In this step, you will configure the trigger in Pabbly Connect to capture new orders from your Swell store. In the trigger window, search for and select the Swell application. Choose the trigger event as ‘Order Created’ to capture when a new order is placed.

• Select ‘Swell’ as the application.
• Choose ‘Order Created’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

Next, go to your Swell store’s homepage, navigate to the ‘Developer’ section, and click on ‘Webhooks’. Here, you can add a new webhook using the URL copied from Pabbly Connect. Select the event ‘Order Created’ and save the changes. This connects your Swell store with Pabbly Connect, allowing it to receive order data automatically.

3. Placing a Test Order

To verify that the integration is working, you will need to place a test order in your Swell store. This involves adding a product to your cart and proceeding to checkout. Enter all necessary details, such as customer name, address, and payment information.

Once the order is placed, return to Pabbly Connect to see if the order details have been captured. You should see the order ID, customer information, and product details populated in the Pabbly Connect workflow, confirming that the integration is successful.

4. Adding Order Details to Google Sheets

Now that you have successfully captured order details in Pabbly Connect, the next step is to send this data to Google Sheets. In the action window of your workflow, search for and select Google Sheets as the application, and choose the action event ‘Add New Row’.

• Connect your Google Sheets account with Pabbly Connect.
• Select the spreadsheet where you want to store order details.
• Map the fields from the Swell order data to the corresponding columns in Google Sheets.

Ensure that you map each relevant field, such as order ID, customer name, product name, quantity, and total cost. Once all fields are mapped, send a test request to confirm that the data is being added correctly to your Google Sheet.

5. Testing the Automation

After setting up the integration, it’s crucial to test it to ensure everything works seamlessly. Place another test order in your Swell store, following the same steps as before. Once the order is completed, check your Google Sheets to see if the new order details appear as a new row. using Pabbly Connect

If everything is configured correctly, you should see the order details populated in Google Sheets, including customer name, order ID, product details, and total amount. This confirms that your automation is functioning as intended, allowing for efficient order management.

Conclusion

By using Pabbly Connect, you can effortlessly automate the process of adding order details from your Swell store to Google Sheets. This integration streamlines your workflow, ensuring that every new order is logged in real-time, enhancing your business efficiency.