Write Product Descriptions for FTP CSV Supplier Feeds with Claude

3 min setup
No coding required
Runs automatically

Supplier feeds on FTP usually arrive with a SKU, a terse title, and a line of specs, which is nowhere near ready for a product page. This workflow watches a CSV file on your FTP server, and for every new row it has Claude turn the supplier's raw fields into a clear, customer-friendly product description. The finished copy is written back to a CSV on the same FTP server, matched by SKU, ready to import into your store.

ftp icon
FTP Fetch CSV File Row Created (Trigger)
Claude Create Message
ftp icon
FTP Add or Update Rows in CSV

How it works

3 steps to turn raw FTP supplier CSV rows into ready-to-use product descriptions with Claude

ftp icon

FTP Fetch CSV File Row Created (Trigger)

App connector: FTP • Time to complete: 1 minute

Check the supplier's CSV file on the FTP server on a recurring interval and run once for each new row. Each row provides columns such as SKU, supplier title, specs, materials, and dimensions.

Claude Create Message

App connector: Claude • Time to complete: 1 minute

Send Claude the row's supplier title, specs, materials, and dimensions. Ask for a product title under 70 characters and a description of 80 to 120 words that leads with the main benefit, lists key specs as short bullet points, and uses only facts from the row. Return the title and description as separate fields.

ftp icon

FTP Add or Update Rows in CSV

App connector: FTP • Time to complete: 1 minute

Write the SKU, Claude's title, and Claude's description to an output CSV on the FTP server, updating the existing row when the SKU is already there so reruns never create duplicates.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to turn raw FTP supplier CSV rows into ready-to-use product descriptions with Claude

Get setup in 3 minutes.

Use this template →

FAQs

Will Claude make up product details that are not in the feed?

The prompt tells Claude to use only facts from the CSV row. It is still worth spot-checking the first batch, especially for sizing, materials, and care instructions.

Why write the descriptions to a CSV instead of straight to my store?

A CSV keeps the workflow to just these two apps and gives you a file you can review and bulk import. You can also add a step that updates the matching product in your store by SKU instead.

What happens if the supplier re-uploads the same file?

The trigger only runs for rows it has not seen before, and the final step updates rows by SKU, so repeated uploads do not create duplicate descriptions.

Personalize this template

Customize this workflow even further:

Match your brand voice
Paste two or three of your best existing product descriptions into the Claude prompt as examples so new copy sounds like the rest of your catalog.
Add SEO fields
Ask Claude for a meta title and meta description too, and add them as extra columns in the output CSV.

You're in good company

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

turn raw FTP supplier CSV rows into ready-to-use product descriptions with Claude

3 min setup • Fully supported if you need help