Question

Shopify to google sheet or email

  • 3 November 2020
  • 2 replies
  • 47 views

Hi, I am trying to get custom notifications to my fulfillment center when a new paid order comes in.

I find it really hard as the products come all together, same as the quantities and the skus.

So I would like to achieve an email like this:

1x Product name, SKU XXX
3x Product name, SKU XXX
1x Product name, SKU XXX
1x Product name, SKU XXX

Or a google sheet where the products cell looks like this:

1x Product name SKU XXX, 3x Product name SKU XXX, 1x Product name SKU XXX, 1x Product name SKU XXX

All I am achieving now is a cell with all the products, a cell with all the quantities and a cell with all the SKU which will be extremely messy and confusing.

How can I create something tidier?

Thanks


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +11

Hi @kecco!

I covered something similar in this recent article. It’s not quite the same workflow, but the same principles should apply:

Can you take a look at that and see if it helps you crack this one? 

Userlevel 7
Badge +12

Hi @kecco!

 

Did @nicksimard’s article help you with this? Let us know if you need any more help finding a workflow that will do what you need 🙂