---
title: "How to save Ecwid orders in Google Sheets"
description: "Tracking eCommerce orders in a Google Sheet can make it easier to share order info across teams and backup your sales data. Here's how to connect Ecwid and Google Sheets automatically."
image: "https://images.ctfassets.net/lzny33ho1g45/68OTKGLtG1io7sO2xD1hBp/e61f7ee886be90b2ba904fb270e79d47/save-ecwid-orders-in-google-sheets-00-hero.jpg"
---

# How to save Ecwid orders in Google Sheets

Tracking eCommerce orders in a Google Sheet can make it easier to share order info across teams and backup your sales data. Here's how to connect Ecwid and Google Sheets automatically.

If you run an eCommerce business, a lot of different people and teams might work behind the scenes to fulfill a single order. One team might deal with preparing invoices, while another might take care of fulfillment. Making sure everyone gets all the information they need to get the job done is essential.

That means you may rely on the humble spreadsheet to keep track of order information for different teams and purposes. But copying and pasting order data is asking for trouble—it's too easy to paste in the wrong information or forget to drop in an order altogether. 

Fortunately, you can use a Zap—Zapier's automated workflows—to automatically add all new [Ecwid](https://zapier.com/apps/ecwid/integrations) orders to a [Google Sheet](https://zapier.com/apps/google-sheets/integrations). Here's how.

## Before you begin

Note that you'll need a paid Ecwid account to use their Zapier integration.

If you haven't set up your Ecwid store, you'll need to do so before setting up this workflow. Make sure you also have at least one order added to your store. That will be used to set up your Zap.

You'll also need to set up your spreadsheet to track your orders. For the Zap to work correctly, you'll need to make sure your Google Sheet has a header row with columns that match the info you want to collect in your spreadsheet from your Ecwid order.

In our example, we'll add columns for **Order ID**, **Item Name**, and **Price**. But add columns for whatever details you want to collect.

## How to save new Ecwid orders to Google Sheets rows

Zapier lets you create automated workflows called Zaps, which send your information from one app to another. You [can create your own Zap](https://zapier.com/editor) from scratch without any coding knowledge, but we also offer quick templates to get you started. 

If you'd like to start with a template, click on the Zap template to go to the Zap editor. You'll need to create a Zapier account if you don't already have one. Then, follow the directions below to set up your Zap.

### Set up your Ecwid trigger

First, set up your trigger—the event that starts your Zap. If you're using the Zap template, the trigger app and event will already be selected for you. Otherwise, search for and select **Ecwid by Lightspeed** as the trigger app and **New Order** as the trigger event. Click **Continue**.

Next, connect your Ecwid account, if you haven't already, then click **Continue**.

Now it's time to customize your trigger step. 

If you want to only trigger this Zap for orders that meet certain requirements, you can set those filters in the _Payment Status_ and _Fulfillment Status_ fields. For example, you may only want to collect details on _Paid_ orders (which you can set in the _Payment Status_ field) or orders _Awaiting Processing_ (which you can set in the _Fulfillment Status_ field).

When you're done customizing your trigger step, click **Continue**.

Now it's time to test your trigger step. Before testing, make sure you have at least one order in your Ecwid account. Once you have at least one order, click **Test trigger**. Zapier will show you your most recent orders. Pick an order to use in your test, then click **Continue with Selected Record**. 

### Set up your Google Sheets action

Now it's time to set up the action—the event your Zap will perform once it's triggered. If you're using the Zap template, these will already be selected for you. Otherwise, search for and select **Google Sheets** as your action app and **Create Spreadsheet Row** as your action event. Click **Continue**.

Connect your Google Sheets account, if you haven't already, then click **Continue**. 

Now, it's time to customize your action step. First, select the drive where your Google Sheet is stored in the _Drive_ field. Then, select the spreadsheet you created in the _Spreadsheet_ field. And finally, choose the appropriate _Worksheet_ (by default, it's "Sheet1").

Once you've selected the right sheet and worksheet, Zapier will load fields that match with the column headings you added to your Google Sheet. Now you can add the corresponding data from your Ecwid order to those fields.

To add data from your Ecwid order, just click in the field you'd like to customize and select the data from the dropdown. In our example, we've added the **Order Number**, **Items Name**, and **Items Price** to the appropriate columns. 

Once you're happy with the setup, click **Continue**. 

Next, click **Test step** to test your Zap. Zapier will send the sample data to your Google Sheets spreadsheet. Open the spreadsheet to check if everything looks good. Here's what ours looked like:

Looks like a win to us! If everything showed up correctly in the Google Sheets spreadsheet, then you're ready to use your Zap. Now, every time you get a new order in Ecwid, all the details will show up in your Google Sheets spreadsheet, just like that!