Integrate ECW ID Orders to Google Sheets Automatically with Pabbly Connect

Learn how to save new ECW ID orders to Google Sheets automatically using Pabbly Connect. Step-by-step guide with exact processes and UI elements. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect to Start Integration

To save new ECW ID orders to Google Sheets automatically, you first need to access Pabbly Connect. This platform allows seamless integration between different applications without the need for coding skills.

Open your browser and navigate to the Pabbly website. From the homepage, select the ‘Connect’ option under the product section. If you don’t have an account, you can sign up for free in just a few minutes. Once registered, log in to access the dashboard.

2. Create a Workflow in Pabbly Connect

After logging in to Pabbly Connect, you need to create a new workflow to connect your ECW ID store with Google Sheets. Click on the ‘Create Workflow’ button, and give your workflow a name, such as ‘ECW ID Store to Google Sheets’.

In this workflow, you will set up two main components: a trigger and an action. The trigger will be a new order in your ECW ID store, and the action will be to send that data to Google Sheets. Click on the trigger option, select ECW ID as your app, and choose the trigger event as ‘New Order’.

• Select ‘New Order’ as the trigger event.
• Connect your ECW ID account by clicking on ‘Connect’.
• Authorize the connection to complete the setup.

Once you successfully connect your ECW ID account, you can proceed to the next step of collecting customer data.

3. Collect Data from ECW ID Store

Now that you have set up the trigger in Pabbly Connect, it’s time to collect data from your ECW ID store. To do this, you will need to place a test order in your ECW ID store.

Go to your ECW ID storefront, select a product, and complete the checkout process. Fill in customer details such as name and email. For this example, you can use the name ‘Zakir Khan’ and an email address of your choice. Once the order is placed, return to Pabbly Connect and click on ‘Save and Send Test Request’ to capture the order details.

• Place a test order in your ECW ID store.
• Return to Pabbly Connect to test the data collection.
• Verify that the order details are received successfully.

Once the data is collected successfully, you can move on to the final step of sending this information to Google Sheets.

4. Send Data to Google Sheets

Your last step involves sending the collected data from Pabbly Connect to Google Sheets. In your workflow, select Google Sheets as the action app and choose the action event as ‘Add Row’.

Next, you will need to map the data fields from the ECW ID order to the corresponding columns in your Google Sheets. Select your spreadsheet, which should be titled ‘ECW ID Orders’, and specify the sheet number. Then, map the order ID, product name, amount, customer name, email, and payment method from the data collected earlier.

Select your Google Sheets file and sheet. Map the fields accurately to ensure data is entered correctly. Click on ‘Save and Send Test Request’ to finalize the integration.

After completing this step, check your Google Sheets to confirm that the new order data has been added automatically.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the process of saving new ECW ID orders to Google Sheets. By following the steps outlined, you can streamline your order management and enhance customer communication effectively.

Utilizing Pabbly Connect not only saves time but also reduces manual errors, making your e-commerce operations more efficient. Start automating today!