Back/Operations/Goose
IntermediateOperationsGoose

How to Automatically Create an E-commerce Product Catalog from a CSV using an AI Agent

Connect the Goose AI agent to a Square dashboard using the Model Context Protocol (MCP) to automatically populate a product catalog from a CSV file and generate payment links with single prompts.

From How I AI

How I AI: Block's 3-Step Workflow for Data Analysis, E-commerce, and Custom AI Tools with Goose

with Claire Vo

How to Automatically Create an E-commerce Product Catalog from a CSV using an AI Agent

Tools Used

Goose

Open-source AI agent by Block for automating tasks

Step-by-Step Guide

1

Enable the Square MCP

Connect Goose to your Square account by enabling the pre-built Square Model Context Protocol (MCP). This gives the agent the 'arms and legs' to interact directly with your Square dashboard and services.

2

Prompt Goose to Populate the Product Catalog

Start with an empty Square dashboard. Provide Goose with your sales data CSV and a simple instruction.

Prompt:
Can you read through this data and use it to create items in my Square dashboard?
3

Verify the Automated Catalog Creation

Goose will read the CSV, understand the intent, and map the data (like item names and prices) to the required fields in the Square API via the MCP. Within minutes, your products will appear in the Square dashboard.

4

Generate a Payment Link on the Fly

With the catalog created, take the next step by asking Goose to create a checkout link for a specific order. Goose will use the MCP to generate a live, shareable payment link.

Prompt:
Okay, let's make a payment link for three pumpkins.

Become a 10x PM.
For just $5 / month.

We've made ChatPRD affordable so everyone from engineers to founders to Chief Product Officers can benefit from an AI PM.