How to Manage New Products and Inventory on Wix Directly via Google Sheets

If you manage an online store on Wix, keeping your product catalog and inventory current is ongoing work — adding new items, tracking stock levels, and reflecting each sale before the next order comes in.

Doing this manually across your store and spreadsheet risks missed updates and inventory errors.

Albato takes care of that. Whenever a new row is added to a Google Sheets spreadsheet, a product is created in your Wix store — and whenever a Wix order is placed, the inventory count in the sheet updates automatically.

How to connect the apps

The first step before creating your automation is to make sure that both applications we will use in the automation are connected to Albato.

To do this, if you haven’t created the connection yet, simply go to the apps tab and then click on Add a Connection:

First, search for the Google Sheets app and follow the instructions that will appear. Once you finish this step, repeat the process with Wix.

Once the applications are connected, we will be ready to create the automations.

How to create the automations

To maintain an optimized flow and ensure that the Wix store and the Google spreadsheet are always up to date, we will create two main automations.

Automation 1: Add new products to Wix from a Google Sheets spreadsheet

To get started, go to the automations tab and click on Create new automation:

Click on the first step to add a trigger:

Here we will select the New row created event in the Google Sheets spreadsheet:

Please, note: We recommend using a completely new spreadsheet. Name the columns according to the information you will need to create the product on Wix, such as: name, description, stock, price, and any other important information.

If you created your spreadsheet after the Albato connection was created and it still does not appear in the list, simply click to refresh the list.

Next, we will add the Wix step:

Select the option Create product:

Once you select the new product event, you will see a series of fields that need to be filled in to ensure the product is created correctly on Wix.

Click on each Wix field and select which spreadsheet column this value will come from, for example:

After filling in all fields, click Save.

This way, the first automation will have been created successfully.

Whenever you add a new row to this spreadsheet, a product will be automatically created on Wix.

Automation 2: Updating inventory in Google Sheets when there is a sale on Wix

To keep product inventory always up to date, it will be necessary to create an inventory update automation.

We will repeat the initial process by going to the automations tab and clicking Create new automation. However, this time, in the initial automation step (trigger), we will select the New Wix order event:

Next, we will click here to add a tool step called Iterator:

This step will help us access the product name information that Wix sends when a new order is received. To do this, select the following parameter:

Now we will add the Google Sheets action, with the goal of locating in the spreadsheet which row contains the data of the product that had a sale.

Select the following action:

After selecting the same spreadsheet we used in the previous automation, we will configure Albato to search in the product name column, using the product name value that we will have access to from the Iterator step:

Please, note: the product column name may vary. This will depend on how you saved this name in your spreadsheet. Now we will use a Math Operation step to calculate the new stock after the product sale. To do this, repeat the process to add a tool, but this time choose the Mathematical Operation tool:

Now we will configure this step as follows. First, we will use the value from the Stock column that the search row step provides, then we will add the minus sign (-), and then the quantity of this product that was sold, available from the Iterator step. Like this:

This way, this step will provide us with the new available stock, which we can use in the next step, which will be precisely the step to update the Google Sheets row with the new stock for this product.

To do this, click to add a new action and select the option Update a row by number:

In the fields that appear, in the row number, we will use the value that the Search row step from Google Sheets provides:

Leave all other fields blank. The only additional field we will fill in, besides the row number, is Stock. In this field, we will use the value provided by the Math Operation step. Like this:

Now this other automation will also be ready for use.

Activate this one and the previous automation we created, and you will have a complete flow to add new products and manage inventory on Wix directly via Google Sheets.

Now you can manage new products and keep your Wix store inventory up to date directly from Google Sheets. If you have any questions, contact our support via chat.