About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I automate Ecwid orders to a Google Sheet for printing lab fulfillment using a free Zapier plan?
Question

How do I automate Ecwid orders to a Google Sheet for printing lab fulfillment using a free Zapier plan?

  • 26 March 2024
  • 7 replies
  • 34 views
W

Hi,

I emailed Zappier about this but haven’t gotten a response.  

 

I’m setting up an Ecwid store on my photography website to sell prints.  I have a severe chronic illness and need it to be all automated, so the orders go to my professional printing lab and they print and frame if the customer chooses a frame in the order, and the lab ships to the customer.  

 

I can either integrate with the printing lab’s own system which is Shipstation and pay a monthly fee to add me as a new user so I have a username and password to give to Ecwid, or Ecwid said I could set up a Zap with Zappier to send all of my order info to a google sheet.  

 

My question is which account would I need to have a zap do this?  Because if it is a paid account, setting up a Gogole sheet is way more complicated than just integrating directly with the lab’s system.  

 

I would need all customer and order info sent to the google sheet so that the lab has everything they need to make the print and ship to the customer.  

 

I won’t be selling more than 100 prints per month, so it should be under 100 zaps.

 

Thanks for any help!

7 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Winterludes 

Help article about how Zapier tasks are counted: https://help.zapier.com/hc/en-us/articles/8496196837261-How-is-usage-measured-in-Zapier

Zapier plans/pricing/features: https://zapier.com/app/pricing?blockRedirectToPlanbuilder=true

Zaps with 3+ steps require a Zapier paid plan.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
W

Does this zap require more than 2 steps?  I don't know.  I’m just trying to avoid a huge investment in figuring this out since the whole point is to avoid a monthly fee.  If I’m going to end up needing to pay a monthly fee anyways it would be much simpler and more elegant to just have an account with the printing lab’s shipstation.  

 

Thank you!

Troy Tessalone
Userlevel 7
Badge +14

@Winterludes 

The number of Zap steps will depend on your Zap logic.

Zaps use 2 steps at a minimum.

 

Zap app triggers/actions

Ecwid: https://zapier.com/apps/ecwid/integrations#triggers-and-actions

GSheets: https://zapier.com/apps/google-calendar/integrations#triggers-and-actions

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
W

@Winterludes

The number of Zap steps will depend on your Zap logic.

Zaps use 2 steps at a minimum.

 

Zap app triggers/actions

Ecwid: https://zapier.com/apps/ecwid/integrations#triggers-and-actions

GSheets: https://zapier.com/apps/google-calendar/integrations#triggers-and-actions

 

thank you Troy.  Is there any way you can tell me if what I’m doing will require more than 2 zaps?  I’m sorry but I’m dealign with a lot of health issues and getting this store up is already more than I can really do, it seems to figure out how many zaps what I need will require will involve setting the whole zap system up and learning it and I would really like to avoid doing that if it’s going to require more than 2 zaps anyways and I then just don’t use it because direct integration with my print lab is so much easier and equally expensive.  

 

For example, do I need 1 zap to create a new row, then a zap to add data to each column in that new row?  I’m guessing this is how it works.  

 

thank you for any help. 

ken.a
Userlevel 7
Badge +6

Hi @Winterludes,

I’m jumping in to see if I can help!

If you're looking to integrate Ecwid with Google Sheets to create a new row every time there's a new Ecwid order, then you can use a free plan for this Zap. Here's how to set up the Zap if this workflow applies to you:

  1. Trigger: Ecwid - New Order
  2. Action: Google Sheets - Create Spreadsheet Row

 

Also, please keep in mind that Google Sheets requires you to set up your Spreadsheet with a header on the first row. This is needed for the Zap to work properly. You can find more information about this here: https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps

Hopefully, this helps!

W

Hi @ken.a 

i understand this much and have it set up.  
 

but doesn’t filling in all my order information into that new row require a 3rd zap?  Or possibly many zaps?  
 

im still not sure how Zappier knows what order information to put in which column on the new row despite reading all the tutorials and watching videos.  I assume I need to give them specific names so zapier knows which order information to put in which column.  But I can’t find what that would be.  
 

and there is no available zap for adding order information to a Google sheet.  
 

so I’m still not sure how to figure this out.  I’ve emailed zapier but they have not responded.  
 

thank you for any help! 

ken.a
Userlevel 7
Badge +6

Hi @Winterludes,

Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Also, please share a screenshot of the “Action” section of your Google Sheets action step that shows all of its fields. Like so:

46dd6c0979e3d815d621b8da43084ef1.png
(view larger)

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks!

Reply


Terms & Conditions