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.

I am looking to create as many Zaps as needed to make sure this can happen!

Business Background: We are a YOUTH SPORTS PROGRAM with different age groups for each sport, in different locations and on different days. This zap will be duplicated across multiple sports and the different locations and age groups.

TRIGGER: When a specific SKUs are in the WooCommerce order 

ACTION: The information associated with that line item (the athlete’s name, age & jersey size) will be added to the correct spreadsheet workbook. 

ISSUE: I am having is that some parents will order 3 different children’s sport program in the same order example:

Child A: SKU = FFCV6to8011225 for Abby Hines, Age 6 & Size S

Child B: SKU = FFCV9to10011225 for Brock Hines, Age 9 & Size L

Child C: SKU = FFCV11to13011225 for Sophia Hines, Age 11 & Size M

Do I make ONE ZAP to do this or do I make individual zaps?

 

Hi @RisingStarsDL 

Here’s perhaps a better/different approach...use Airtable instead of GSheets.

Why?

Airtable has Views, which are segments of data. (sort, filter, group, show/hide fields, reorder fields)

Help for Airtable Views: https://support.airtable.com/docs/getting-started-with-airtable-views

Concept is to add all the data to the same Table in the Airtable Base, then create Views as needed with the desired Filter conditions.

 

Zap Steps

  1. Trigger: WooCommerce - Line Item in an Order
  2. Action: Airtable - Create Record

Hey ​@RisingStarsDL 👋

I can see that you reached out to our Support team about this but it doesn’t look like they had a reply to their latest message, so I’m not sure whether their reply helped you to get it solved? Were you since able to get things working on your own or did you switch to Troy’s suggestion of using Airtables instead of Google Sheets?

We’d love it if you could share some quick details on what the solution was as this would be super helpful to others in the Community that might stumble across here in future! 🙏

And if not and you’re having some trouble on this please do let us know—happy to lend if you’re stuck at all! 🙂

Reply


Terms & Conditions