Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Best answer

Woocommerce Google sheets

H

Whenever I get a new order I would like to take line items from those orders and put them into certain cells on my Google spreadsheet. 

 

For example, if Customer A orders 1 meatball dish and 2 apple crisps, the spreadsheet row would update with their name and a quantity of 1 in the meatball column and a 2 in the apple crisp column.

 

If Customer B orders 3 pasta dish and 1 meatball dish, the spreadsheet would show 3 under pasta and 1 under meatball.

 

I’ve tried to use line items as output, but depending on the order line item 1 could be a meatball dish, an apple crisp, or a pasta dish. 

 

Is there a way to look at the order see that a line item contains a certain product and put that products quantity until the correct cell? Thanks!

Best answer by AndrewJDavison_LuhhuBest answer by AndrewJDavison_Luhhu

@hbweb 

You’re going to find this tough, but it might be possible.

First, your zap needs to post a new row with customer details (don’t worry about product details yet) to your main spreadsheet.

Then want to add a ‘Create Spreadsheet Row(s)’ action step, passing line item data - this will post each line item from the order to its own row (make a new spreadsheet tab for this).

Then you can create another zap that triggers on a new row in this new spreadsheet tav - then finds and updates the correct column on the corresponding order row on the main spreadsheet.

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

AndrewJDavison_Luhhu
Forum|alt.badge.img+10

@hbweb 

You’re going to find this tough, but it might be possible.

First, your zap needs to post a new row with customer details (don’t worry about product details yet) to your main spreadsheet.

Then want to add a ‘Create Spreadsheet Row(s)’ action step, passing line item data - this will post each line item from the order to its own row (make a new spreadsheet tab for this).

Then you can create another zap that triggers on a new row in this new spreadsheet tav - then finds and updates the correct column on the corresponding order row on the main spreadsheet.

We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
H
  • hbwebBeginner
  • Author
  • Beginner
  • 2 replies
  • April 30, 2020

@AndrewJDavison_Luhhu thanks I actually got something like that setup, but the zap is halting if it can't see data. Is there a way to keep going if data isnt there?

AndrewJDavison_Luhhu
Forum|alt.badge.img+10

@hbweb 

Why is it halting? It should be finding the order row.

Can you share some screengrabs of what you’ve setup?

We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
H
  • hbwebBeginner
  • Author
  • Beginner
  • 2 replies
  • May 1, 2020

@AndrewJDavison_Luhhu I got it working by making a zap for each product to search the temporary spreadsheet that lists all the line items then updates the main spreadsheet. Is there an easier way to do that? Thanks!

AndrewJDavison_Luhhu
Forum|alt.badge.img+10

@hbweb - I’d say this is probably the easiest way - but if you’ve got some screenshots of your setup I can advise better.

We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
Terms & Conditions