Saving orders to Google Sheets

You can automatically save orders from your Ecwid store to Google Sheets using a service called Zapier. You can use this spreadsheet for your accounting purposes, create reports based on it or just share the file with your staff who need to see order details.

Setting up a Google Sheet

First of all, you need to create a Google Sheet where you want to save the orders from your Ecwid store.

To create a new Google Sheet:

  1. Log into your Google account and open Google Sheets. If you don’t have a Google account yet, you can create it for free.
  2. Create a new Google Sheet by clicking on the plus icon.
  3. Name the spreadsheet, e.g. “My orders”. Remember this name as you will need to choose it later in Zapier.
  4. (Optional) Name the worksheet. A worksheet is a page within your Google Sheet. You can see it at the bottom of the page. By default, it’s called “Sheet1”. You can keep this name or set yours. Later you will need to choose this worksheet in Zapier settings.

Create Google Sheet for Ecwid orders

  1. Name columns in your worksheet. Decide what order info you are going to import to this worksheet and name the columns accordingly, e.g. “Order number”, “Payment status”, etc.:

Columns in google sheet for orders

Later you will see the names of these fields in Zapier settings.

Now when your Google Sheet is set up, proceed to set up Zapier.

Creating a Zap

Now you need to connect your Ecwid store and Google Sheets using Zapier. You will need to create a Zap that will pass new orders from your Ecwid store to your Google Sheet.

To create a Zap for your Ecwid orders:

  1. Log into your Zapier account and click Make a Zap!:

Make a zap for new orders

  1. In the “Choose App & Event” section, type “Ecwid” in the search field and click on the Ecwid icon to choose it.
  2. In the “Choose Trigger Event” drop-down, select New Order:

New order trigger event in zapier

  1. Click Continue.
  2. At the “Choose account” step, click Sign in to Ecwid and log into your Ecwid account:

Sign in to Ecwid in Zapier

  1. Give Zapier requested rights. After that, your Ecwid account will be connected to Zapier.
  2. Click Continue. You will get to the “Customize order” step.
  3. Select payment and fulfilment statuses — new orders that appear in your Ecwid control panel with these statuses will automatically get to your Google Sheet. For example, if you want to save new paid orders to Google Sheets, select “Paid” and “Awaiting processing” statuses:

Set order statuses in zapier

  1. Click Continue. On the next step, click Test & Review or Test & Continue to check what orders Zapier will find with the selected statuses in your Ecwid store.
  2. At the “Do this …” step, in the “Choose App & Event” section, click on Google Sheets:

Select Google Sheet in zapier

  1. In the "Choose Action Event" field select Create Spreadsheet row. Thus, each new order will appear on a new row in your Google Sheet.
  2. Click Continue.
  3. Log into your Google Sheets account and give required access to Zapier:

Add Google sheet account in zapier

  1. Click Continue.
  2. In the “Customize Spreadsheet Row” section, select the spreadsheet and the worksheet that you created above. After that, on this page, you will see the names of the columns from your worksheet.
  3. Select what order information you want to export to the columns in your worksheet:

Customize spreadsheet row in zapier

  1. Click Continue.
  2. Click Test & Review or Test & Continue to check how the zap works. A new row with order details will be sent to your worksheet. You can go to your Google Sheet and see your first order there.

Test your zap and send a spreadsheet row

  1. Click Done editing.
  2. Click Turn Zap on.

That’s it! Your Zap connecting Ecwid and Google Sheets is ready:

Ready Zap for saving Ecwid orders in Google Sheet

When a new order with the chosen statuses appears in your Ecwid control panel, it will also be automatically saved in your Google Sheet. Zapier will check your Ecwid account for new orders every 15 minutes.

If you want Zapier to check your Ecwid store for new orders every 5 minutes instead of 15, consider Zapier Professional or Professional Plus plans.
Was this article helpful?

Awesome! Thanks for your feedback!

Sorry about that! We are here to assist you by email or chat.

Contact support