Saving orders to Google Sheets with Zapier

Last updated

Sometimes it is necessary to have the orders from your store to be transferred to Google Sheets. This is a great instrument for managing your orders or creating reports. Now you can have your orders sent from Ecwid to Google Sheets automatically.

This can be done with the help of Zapier. Please see step-by-step instruction below.

In this article:

Getting started

You need just two things: paid account in Ecwid and an account in Zapier.

Connecting Ecwid to Zapier

  1. Make a new Zap

Make a new Zap

  1. Choose Ecwid as trigger app

Choose Ecwid as trigger app

  1. Select New Order

New Order

  1. Connect a new account

Connect a new account

  1. Login to your Ecwid account if prompted and grant permissions

Login to your Ecwid account

  1. Now your Ecwid account is connected

Now your Ecwid account is connected

  1. Select orders statuses that will evoke creating a new zap

Select orders statuses

  1. Test the first part of your zap

Test the first part of your zap

  1. Test successful!

Test successful!

Connecting Google Sheets to Zapier

  1. Login to your Google account, open a new tab and create a new spreadsheet (https://docs.google.com/spreadsheets/) for your orders from Ecwid, Zapier will add orders there as new lines.
  2. Return to your Zapier tab.
  3. Select Google Sheets on the apps list as action app

Select Google Sheets

  1. Select Create Spreadsheet row

Create Spreadsheet row

  1. Connect a new account

Connect a new account

  1. Grant permissions
  2. Select the spreadsheet you have created and a worksheet where your orders will be added

Select the spreadsheet you have created and a worksheet

  1. Select the desired Ecwid fields that you want to add to the spreadsheet

Select the desired Ecwid fields

Please see the full list of available fields here: https://developers.ecwid.com/api-documentation/orders#get-order-details If you do not see the field you need when creating a zap, create an order where this field is not empty, and it will appear on the list
  1. Click Create and Continue

Create and Continue

  1. Test successful!

Test successful!

=

Name your zap and turn it on

Name your zap and turn it on

Here is how the order automatically sent from Ecwid via our zap looks in Google Sheets

Here is how the order automatically sent

Back to top
Has the article answered your question?

Awesome! Thanks for your feedback!

Please send us that question. We will be happy to help by email.

Send a message