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.

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!

@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.

@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?

@hbweb 

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

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

@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!

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

Terms & Conditions