Scrape Shoe Products To Shopify
Reads shoe URLs from a sheet, scrapes details via BrowserAct, creates products with variants in Shopify, and notifies you on Slack.
What it does
Get shoe products from external websites into your Shopify store automatically by reading target URLs from Google Sheets. The agent uses BrowserAct to scrape details like prices and images, processes the data with Code nodes, creates products with variants in Shopify, and sends you a confirmation on Slack.
Step by step
- Configure the Google Sheets node to listen for new rows or specific column updates as the initial trigger.
- Map the scraped JSON fields from BrowserAct directly into the Code node's input payload structure.
- Use the Shopify API endpoint POST /admin/api/2023-10/products.json with the authenticated access token.
Where the LLM does the work
- Generate robust error-handling logic in the Code node to gracefully skip malformed product data without breaking the entire workflow.
- Write a script to normalize inconsistent price formats and currency symbols extracted from diverse external websites.
- Create dynamic variant mapping logic that correctly pairs color and size attributes based on varying HTML structures.
Watch out for
BrowserAct may fail if the target site uses heavy anti-bot protections, add a retry mechanism with random delays to handle transient blocks.
Image URLs from external sites might be relative paths, ensure your code converts them to absolute HTTPS links before sending to Shopify.
Variant creation can fail if attributes like size are missing or null, validate all required fields in the Code node before calling the API.
Tools that fit
BrowserAct Service Scrape product details and images
Code API Transform scraped data to JSON
The agent brief
Everything your agent needs, including the gotchas. Copy it and go.
You are helping me build the following AI agent workflow. ## Goal Scrape Shoe Products To Shopify: Reads shoe URLs from a sheet, scrapes details via BrowserAct, creates products with variants in Shopify, and notifies you on Slack. ## Specification - What it does: Get shoe products from external websites into your Shopify store automatically by reading target URLs from Google Sheets. The agent uses BrowserAct to scrape details like prices and images, processes the data with Code nodes, creates products with variants in Shopify, and sends you a confirmation on Slack. - Trigger: Run manually (Manual · on demand) - Autonomy: Fully hands-off - Expected setup effort: about an afternoon - Tools/services involved: - Google Sheets: Input product URLs and names - BrowserAct: Scrape product details and images - Code: Transform scraped data to JSON - Shopify: Create products and variants - Slack: Send processing notifications ## Known pitfalls, handle each one explicitly in your implementation 1. BrowserAct may fail if the target site uses heavy anti-bot protections, add a retry mechanism with random delays to handle transient blocks. 2. Image URLs from external sites might be relative paths, ensure your code converts them to absolute HTTPS links before sending to Shopify. 3. Variant creation can fail if attributes like size are missing or null, validate all required fields in the Code node before calling the API. ## Reference implementation https://n8n.io/workflows/9946 (workflow template) Fetch and inspect this before building. If it matches my stack, adapt it; if not, rebuild the pattern with my tools. ## Process requirements 1. Before building: ask me which of the listed tools I actually use and what my platform is (n8n / Make / code / other). Do not assume. 2. Adapt the pattern to my answers; do not force the reference stack. 3. Address every pitfall above; tell me how you handled each. 4. Provide a test plan I can run before letting this touch real data. 5. Ask before any step that sends messages, modifies data, or spends money. Source: https://usecasesforagents.com/use-case/scrape-shoe-products-to-shopify/ via usecasesforagents.com
Frequently asked questions
Can I use a different Spreadsheet than Google Sheets?
Yes. Google Sheets is only the example spreadsheet in this recipe. The same flow works with Airtable, Baserow and Excel. Swap the spreadsheet connection and keep the rest of the setup as written.
Want this running in your business?
This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.
Who it's for
Also fits E-commerce Operator.