Baserow campaign database to Shopify with image upload & dynamic template update

Description

Automating your marketing campaign management process can streamline your workflow and save you valuable time. With the combination of Baserow and n8n, you can efficiently handle your campaign data and seamlessly publish content to your Shopify store.

In this workflow template, I demonstrate how to leverage Baserow as a centralized platform for organizing your marketing campaign assets, including copy and images. By utilizing n8n, we automate the process of fetching images and campaign descriptions from Baserow and uploading them directly to your Shopify store.

With this automated solution, you can expedite the publishing process, ensuring that your campaigns are launched swiftly across your sales channels. Additionally, this workflow serves as a foundational step towards further automation in campaign management, allowing you to dynamically generate and upload content to your Shopify store with ease.

This template will help you:

Use n8n to get images for marketing campaigns from Baserow and upload them to your Shopify media library
Dynamically inject data from Baserow into a template file
Upload a template file to your Shopify theme

This template will demonstrate the follwing concepts in n8n:

use the Webhook node
use the IF node to control the execution flow of the workflow
do time calculation using expressions and javascript
use the GraphQL node to upload images to your Shopify media files
create a dynamic template file for your Shopify theme
use the HTTP Reqest node to upload your template file to your Shopify store

How to get started?

Create a custom app in Shopify get the credentials needed to connect n8n to Shopify
This is needed for the Shopify Trigger
Create Shopify Acces Token API credentials n n8n for the Shopify trigger node
Create Header Auth credentials:
Use X-Shopify-Access-Token as the name and the Acces-Token from the Shopify App you created as the value.
The Header Auth is neccessary for the GraphQL nodes.
You will need a running Baserow instance for this. You can also sign up for a free account at https://baserow.io/

Please make sure to read the notes in the template.

For a detailed explanation please check the corresponding video: https://youtu.be/Ky-dYlljGiY