Hi,
I need help setting up a Zapier workflow to automate updates in a Google Sheet. Here’s what I’m trying to achieve:
1. Trigger: Process all rows with non-empty Manufacturer-Part-Number (MPN) values.
2. Action: Use OpenAI to generate:
• Title: Format as Brand - MPN - Product Description.
• Description, Brand Name, and Weight (leave blank if unavailable).
3. Category ID: Match the title/description to a Category Mapping Sheet. If no match is found, assign a default Category ID (36802).
4. Output: Write Title, Description, Brand, Weight, and Category ID back to the corresponding rows in Google Sheets.
5. Schedule: Run hourly or daily and process all rows in one run.
What’s the best way to handle this in Zapier, especially for processing multiple rows and using a Category Mapping Sheet?
Thanks in advance for your guidance!