How to Add Dukaan Order Details to Google Sheets Using Pabbly Connect

Learn how to automate adding Dukaan order details to Google Sheets using Pabbly Connect. Follow this step-by-step tutorial for seamless integration. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Dukaan Order Integration

To start automating the process of adding Dukaan order details to Google Sheets, you need to set up Pabbly Connect. First, sign up for a free account on Pabbly Connect and log into your dashboard. Once you are in, click on ‘Create Workflow’ to begin.

Next, name your workflow. For instance, you can name it ‘Dukaan to Google Sheets’. This workflow will manage the automation between Dukaan and Google Sheets, ensuring that every new order is recorded automatically.

2. Configuring the Trigger for New Orders in Dukaan

In this section, you will configure the trigger for capturing new orders from Dukaan using Pabbly Connect. In the trigger window, choose the app ‘Dukaan’ and select the event ‘New Order Received’. This action will initiate the workflow whenever a new order is placed.

• Select Dukaan as the trigger app.
• Choose ‘New Order Received’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

After this, you will need to connect your Dukaan store to Pabbly Connect. To do this, install the Webhook plugin in your Dukaan account. Then, navigate to the settings and create a new webhook by pasting the copied URL. This setup allows Pabbly Connect to capture order details automatically whenever a new order is placed.

3. Placing a Test Order to Capture Data

Once the webhook is set up, it’s time to test the integration by placing a test order. Visit your Dukaan store, select a product, and complete the purchase as a customer would. This step is crucial as it allows Pabbly Connect to receive the order details.

When placing the order, ensure to fill in all customer details accurately. This includes the name, mobile number, email address, and shipping address. After completing the order, return to Pabbly Connect to check if the order details have been captured successfully.

4. Adding Order Details to Google Sheets Using Pabbly Connect

Now that you have the order details captured in Pabbly Connect, the next step is to add these details to Google Sheets. In the action window, select ‘Google Sheets’ as the app and choose ‘Add New Row’ as the action event. This will enable you to input new order details directly into your designated Google Sheets file.

Connect your Google Sheets account by signing in and selecting the spreadsheet where you want to store the order details. Map the fields from the Dukaan order response to the corresponding columns in your Google Sheet. For example, map the order ID, customer name, email, and product details.

• Select the spreadsheet where order details will be stored.
• Map the order fields from Dukaan to the respective columns in Google Sheets.
• Test the connection to ensure data is added correctly.

After mapping, save your settings and send a test request to verify that the data is correctly added to your Google Sheets. This confirms that the integration is functioning as expected.

5. Testing the Complete Automation Workflow

With the integration set up, it’s essential to conduct a final test of the entire workflow. Place another order on your Dukaan store and observe if the order details are automatically populated in your Google Sheets. This step ensures that the automation is seamless and reliable.

If everything is configured correctly, you should see the new order details reflected in your Google Sheets shortly after placing the order. This real-time data transfer is the primary benefit of using Pabbly Connect.

In case of any issues, revisit each step to ensure that the trigger and action settings are correctly configured. Once verified, your automation will be fully functional, allowing for efficient order management.

Conclusion

In conclusion, integrating Dukaan with Google Sheets using Pabbly Connect streamlines your order management process. By following these steps, you can automate the addition of order details to your Google Sheets, ensuring accurate and timely record-keeping.