How it works

Follow these 3 simple steps to start sending new Shopify product variants to your Notion database automatically

Shopify logo icon

Product Created

App connector: Shopify • Time to complete: 0 minutes (Auto-configured)
Why this matters: This trigger detects when you add a new product to your Shopify store and kicks off the entire workflow to organize that product data in Notion.

This step monitors your Shopify store for new products and automatically starts the workflow when you publish or create a product. The trigger captures all product details including title, description, vendor, product type, tags, and all associated variants with their pricing and inventory information. No configuration is needed - it connects directly to your Shopify store and runs every time you add a new product. The product data then flows to the next step for processing.

Loop: Get Product Variants

App connector: Loop • Time to complete: 0 minutes (Auto-configured)
Why this matters: This step processes each product variant individually, ensuring every size, color, or variation gets its own dedicated page in your Notion database rather than lumping everything together.

The Loop step takes the product variants from your new Shopify product and iterates through each one separately. If your product has multiple variants (like different sizes or colors), this step ensures each variant gets processed individually rather than as a group. It automatically extracts variant-specific details like title, price, compare-at price, SKU, barcode, and inventory item ID for each iteration. The loop runs automatically without any configuration needed and passes each variant's data to the Notion step one at a time.

notion logo icon

Add Page to Database

App connector: Notion • Time to complete: 2 minutes
Why this matters: This action creates the actual Notion database pages where your product variant information gets stored and organized for easy access and management.

This step creates a new page in your Notion database for each product variant processed by the loop. You'll configure which Notion page should house your new database by selecting from a dropdown or searching by name. You'll name your database (like "Product Inventory" or "Shopify Products") and choose which product properties to include as database columns - options include Product Title, Product ID, Description, Vendor, Product Type, Tags, and variant-specific details like Variant Title, Price, SKU, and Barcode. All selected properties become columns in your database, with each variant creating a new row with the corresponding data.

Make it your own

Customize this workflow even further:

Filter products by type or vendor
Add conditional logic to only send certain products to Notion, such as products from specific vendors or product types that match your criteria.
Sync inventory levels automatically
Connect additional steps to monitor inventory changes and update your Notion database whenever stock levels change for tracked products.
Generate product reports
Schedule weekly or monthly workflows that analyze your Notion product data and send summary reports to Slack or email with top performers and low stock alerts.
Create product launch workflows
Extend this template to automatically notify your team in Discord, create marketing tasks in project management tools, or update pricing in other platforms when new products go live.

Frequently asked questions

Will this create separate database entries for each product variant?
Yes, the Loop step processes each variant individually, so a product with 3 sizes will create 3 separate pages in your Notion database - one for each variant with its specific price, SKU, and inventory details.
Can I add custom properties to my Notion database after the workflow creates it?
Absolutely. Once MESA creates your database, you can manually add new properties in Notion like custom tags, notes, or calculated fields. The workflow will continue adding new products to the existing database structure.
What happens if I change the database name or move it to a different Notion page?
The workflow will continue using the original database location and name you configured. If you want to redirect new products to a different database, you'll need to edit the workflow settings and select the new location.
What is a template?
Templates are pre-made workflows by our team of experts. Instead of building a workflow from scratch, these have all the steps needed to complete the task.
Can I personalize a template?
Yes! Every step can be customized to meet your exact requirements. Additionally, you can even add more steps and make it more sophisticated.
Are templates free?
Yes! Our entire library containing hundreds of templates are free to use and customize to your exact needs.

Ready to start sending new Shopify product variants to your Notion database automatically?

Join thousands who've automated their work and saved an average of 3.5 hours every week.

Start with this template — It's free
7-day free trial • 4 min setup • Cancel anytime