Eshopbox provides you pre-existing zap for adding a new entry in google sheet when the inventory level changes to 0 in Eshopbox. You just need to integrate the Eshpopbox and Google account on Zapier. This will help you to maintain a record of the inventory.

This article will help you to integrate your Eshopbox workspace with the Google account.

Before you start

Make sure:

Learn more about connecting apps to Eshopbox via Zapier.

Zapier integration

To get started with setting up the zap workflow, click here. You can also search for this zap on the Eshopbox integration page. Now, follow the below steps, to set up your zap:

Step I: Set up your zap trigger

When you first set up your Zap trigger, Zapier will attempt to find some sample data from your trigger app to use in the Zap. For example, if your trigger brings in the inventory data, Zapier will pull in the data. This can be used as test data in an action step later in the Zap.

The below steps will guide you to provide trigger details:

  • Choose app & event: It is a pre-filled column. The values are editable, so make sure the selected app is Eshopbox, and the event is inventory level change.

  • Choose account: Sign in to the Eshopbox workspace.

Click continue.

  • Customize inventories: Select the sales channel whose inventories you wish to receive.

Click continue.

  • Test trigger: Once you have completed the above step, click on test trigger. Testing your trigger will see if it pulls in the correct data. This will confirm that the right account is connected and your trigger is set up correctly.

Step II: Set up the filter

In this step, you need to test if the product in the inventory is out of stock. The below steps will help to set the filter.

  • Choose app & Event: It is a pre-filled column. The values are editable, so make sure the selected app is filter by Zapier, and the event is only continue if.

  • Filter setup & testing: It is a pre-filled column. The values are editable, so make sure they are the same as in the below screenshot.

Click continue.

Step III: Add the entry in google sheet

After you set up your zap trigger, you need to add an action to your zap. An action is a job your zap performs when your trigger event occurs. Follow the below steps to add action to zap:

  • Choose app & Event: It is a pre-filled column. The values are editable, so make sure the selected app is Google Sheet and In the event, choose to create spreadsheet row.

  • Choose account: Sign in with your Google account.

Click continue.

  • Customize spreadsheet row: Choose my Google drive in the drive column and select the spreadsheet and worksheet in which you want to record the inventory. Once you select these fields, worksheet columns will be loaded. You need to fill the same details as given in the screenshot below.

Click continue.

  • Send Data: Click test and review to send test data to the google sheet. Once the test is successful, click on continue.

  • Turn on ZAP: When you have shared all the necessary details. Finally, you can turn on the ZAP. This will make your ZAP live. Whenever any product stocks out a new entry will be created in google sheet.

Whenever you want to edit your zap, click here to understand the editing process.

Did this answer your question?