Question

Help Needed: Automating Google Sheets with OpenAI and Category Mapping

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!

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.

Sign up