Post Etsy and Shopify products to Pinterest and Instagram with SocialRobot and OpenAI

Quick overview

This workflow runs daily (or manually) to pull products from Etsy (RSS or API) or Shopify, generate Pinterest and Instagram copy with OpenAI (optional), then publish a Pinterest pin and an Instagram photo via SocialRobot while tracking posted products in an n8n Data Table.

How it works

1. Runs on a daily schedule at 10:00 (or via manual trigger) and loads your catalog, posting, and copy settings.
2. Uses SocialRobot to identify the connected Pinterest account and select the target Pinterest board.
3. Fetches product listings from Etsy RSS, the Etsy API, or Shopify (based on your configuration) and normalizes them into a consistent product format with images and product links.
4. Checks an n8n Data Table to skip products that have already been posted and limits the run to the configured number of products.
5. If enabled, uses OpenAI to write Pinterest titles/descriptions and Instagram captions from the listing facts and falls back to template copy when AI output is unsuitable.
6. Publishes a Pinterest pin (via the SocialRobot API) and an Instagram photo (via SocialRobot), then records successful posts in the Data Table or stops with a readable error if nothing was posted.

Setup

1. Install the SocialRobot community node (@socialrobot-io/n8n-nodes-socialrobot) and add your SocialRobot API key credentials (SocialRobot node credential plus an HTTP Header Auth credential with x-api-key) for the SocialRobot API requests.
2. Connect your Pinterest and Instagram accounts in SocialRobot, and select the correct Instagram account in the Instagram posting step.
3. Configure a product source: set your Etsy shop name for RSS, add an Etsy API key (x-api-key) for the Etsy API option, or add Shopify access token credentials with read_products scope for the Shopify option.
4. Create an n8n Data Table named socialrobot_posted_products with the columns used for tracking (product_key, source, title, product_url, pinterest_post_id, instagram_post_id, posted_at).
5. Update Set Catalog Configuration with your source, shopify_store_url (if using Shopify), pinterest_board_name (and optionally account/board IDs), and any copy preferences such as language, tone, and hashtags.
6. Add an OpenAI credential for the OpenAI Chat Model node (or set use_openai to false), run the workflow once manually to verify output, then activate the schedule.