Zapier: Save Ecwid Orders to Google Sheets

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

NOTE: 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





Was this article helpful?
0 out of 0 found this helpful
Questions?
Get help
  • Forums

    Join the Ecwid community. Discuss support topics and store ideas with other Ecwid users.

  • Contact us

    Still have questions about Ecwid? Let us know! We will be glad to help you with your Ecwid store.

  • Status Monitor

    Get real time status updates on Ecwid services here, 24/7