Auto-Optimize Zendrop Product Descriptions with ChatGPT for Higher Shopify SEO Rankings
Pulls raw product descriptions from Zendrop via HTTP, sends them to ChatGPT for SEO-optimized rewrites, and pushes the polished copy directly to your Shopify store. Save hours of manual copywriting while boosting organic traffic.
- 1
Trigger: Fetch a Zendrop Product on Schedule
Add a
Schedule Triggernode and set it to run every hour (or daily). This kicks off the workflow automatically. In theIntervalfield chooseHoursand set the value to1. You can also trigger it manually while testing by clickingExecute Workflow. - 2
Fetch Product from Zendrop API
Add an
HTTP Requestnode. SetMethodtoGETandURLtohttps://api.zendrop.com/api/v1/products. Add a headerAuthorizationwith valueBearer YOUR_ZENDROP_API_KEY. In the nodeNotesfield paste your API key placeholder. The response returns a list of products withtitle,description, andidfields. - 3
Build the SEO Prompt with Set Node
Add a
Setnode to construct the prompt string. Create a field calledpromptand set its value to a plain text expression such as:Rewrite the following product description for SEO. Include primary keywords naturally, write a compelling meta-friendly opening sentence, use bullet points for features, and keep it under 300 words. Product title:followed by{{$json["data"][0]["title"]}}and thenDescription:followed by{{$json["data"][0]["description"]}}. Also captureproduct_idfrom{{$json["data"][0]["id"]}}as a separate field. - 4
Send Prompt to ChatGPT for SEO Rewrite
Add an
OpenAInode. SetResourcetoTextandOperationtoComplete(orMessageif using Chat model). Select modelgpt-4o. In thePromptfield reference{{$json["prompt"]}}from the previous Set node. Add your OpenAI credential underCredentials. The node returns a fieldtext(ormessage.content) containing the optimized description. - 5
Push Optimized Description to Shopify
Add an
HTTP Requestnode configured asPUTtohttps://YOUR-STORE.myshopify.com/admin/api/2024-01/products/PRODUCT_ID.json. ReplacePRODUCT_IDwith{{$json["product_id"]}}mapped from the Set node using$node["Set"].json["product_id"]. SetAuthenticationtoHeader Authwith headerX-Shopify-Access-Tokenand your Shopify Admin API token. InBodyuse JSON mode and pass{"product": {"id": "{{$node["Set"].json["product_id"]}}", "body_html": "{{$json["text"]}}"}}. Save and activate the workflow.
Frequently asked questions
How do I get my Zendrop API key?
Log in to your Zendrop account, go to Settings > API, and generate a new API key. Copy it and paste it into the Authorization header of the first HTTP Request node.
Can I target specific keywords in the ChatGPT prompt?
Yes. In the Set node where you build the prompt, append a sentence like 'Target these keywords: [keyword1, keyword2]' to the prompt string. ChatGPT will naturally incorporate them into the rewritten description.
What happens if Zendrop returns multiple products at once?
The current workflow processes the first product in the array. To handle multiple products, add a `Split In Batches` node after the HTTP Request node so each product is processed individually through the ChatGPT and Shopify steps.