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.

  1. Getting started
  2. Connecting Ecwid to Zapier
  3. Connecting Google Sheets to Zapier

Getting started

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

Connecting Ecwid to Zapier

Make a new Zap

Choose app

Select “New Order”

Connect a new account

Login to your Ecwid account if prompted and grant permissions

Now your Ecwid account is connected

Select orders statuses that will evoke creating a new zap

Test the first part of your zap

Test successful!

Connecting Google Sheets to Zapier

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.

Return to your Zapier tab.

Select Google Sheets on the apps list

Select “Create Spreadsheet row”

Connect a new account

Grant permissions

Select the spreadsheet you have created and a worksheet where your orders will be added

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

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

Click “Create and Continue”

Test successful!

Name your zap and turn it on

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

Back to top
Has the article answered your question?