Baserow Campaign Database to Shopify with Image Upload and Dynamic Template Update

This n8n workflow automates the process of creating or updating Shopify products based on data from a Baserow campaign database, including image uploads and dynamic template adjustments.

Description

This workflow acts as a bridge between your Baserow campaign management and your Shopify store. It listens for updates or new entries in a Baserow database, processes the product information, dynamically uploads images to Shopify if needed, and then either creates a new product or updates an existing one on your Shopify store, even allowing for dynamic template assignment.

What it does

1. Triggers on Baserow Webhook: The workflow starts when a webhook is received, likely from a Baserow database indicating a new or updated campaign entry.
2. Processes Baserow Data: It receives the data from Baserow, which should contain product details, image URLs, and potentially Shopify template information.
3. Prepares Product Data: An "Edit Fields (Set)" node likely transforms and formats the incoming Baserow data into the structure expected by Shopify, extracting relevant fields like product title, description, price, tags, and image URLs.
4. Checks for Existing Product (HTTP Request): A generic HTTP Request node is used to query Shopify to determine if a product with a matching identifier (e.g., SKU or handle) already exists.
5. Conditional Logic (If): An "If" node evaluates the result of the Shopify product check.
   • If Product Exists: It proceeds down a path to update the existing Shopify product.
   • If Product Does Not Exist: It proceeds down a path to create a new Shopify product.
6. Uploads Images to Shopify (HTTP Request): For new or updated products, another HTTP Request node handles the image upload process to Shopify, likely fetching images from the provided URLs in Baserow.
7. Creates/Updates Shopify Product (GraphQL): A GraphQL node is used to interact with the Shopify Admin API.
   • Create Product: If the product doesn't exist, this node creates a new product with all the processed details and uploaded images.
   • Update Product: If the product exists, this node updates its details, including images and potentially the assigned template.
8. Handles Template Updates (HTTP Request): A final HTTP Request node might be used to dynamically update the Shopify product template based on data from Baserow, if applicable.
9. No Operation: A "No Operation, do nothing" node is present, likely as a placeholder or to terminate a branch of the workflow cleanly.
10. Sticky Note: A sticky note is included, likely for documentation or internal notes within the workflow.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Baserow Account: Access to a Baserow database with campaign/product data.
• Shopify Account: An active Shopify store with API access enabled.
• Shopify Admin API Credentials: API Key and Access Token for your Shopify store.
• Webhook URL: A webhook configured in Baserow to send data to this n8n workflow's Webhook trigger.
• Image Hosting: Images referenced in Baserow should be publicly accessible via URL for n8n to fetch and upload to Shopify.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Shopify API: Set up your Shopify API credentials in n8n. These will be used by the HTTP Request and GraphQL nodes.
   • Baserow Webhook: The "Webhook" trigger node will generate a unique URL. Copy this URL.
3. Configure Baserow Webhook: In your Baserow database, set up a webhook that triggers on row creation or update and sends the relevant product data to the n8n Webhook URL you copied.
4. Configure Nodes:
   • Edit Fields (Set): Adjust the expressions in this node to correctly map your Baserow field names to the desired Shopify product properties (e.g., title, body_html, variants[0].price, images[0].src, template_suffix).
   • HTTP Request (Check Existing Product): Update the Shopify API endpoint and query parameters to correctly search for existing products based on a unique identifier from your Baserow data.
   • HTTP Request (Upload Images): Ensure the image upload logic (method, headers, body) is correctly configured for the Shopify API.
   • GraphQL (Create/Update Product): Modify the GraphQL mutations to match your specific Shopify product creation and update requirements, including mapping all necessary fields from the Baserow data.
   • HTTP Request (Update Template): If dynamically updating templates, ensure this node's API call is correctly configured.
5. Activate the Workflow: Once configured, activate the workflow in n8n.

Now, whenever a new product campaign entry is added or updated in your Baserow database, this workflow will automatically handle its creation or update on your Shopify store.