Create Shopify Products from Google Sheets Rows

This polling trigger checks your spreadsheet hourly for new rows that weren't present during the previous check.

Setup: During initial setup, you'll:
(1) Name your spreadsheet (it will be created automatically in your Google Drive), and
(2) Select which columns to include from options like Title, Description (Body HTML), Vendor, Product Type, Tags, Variant Title, Variant Price, Variant Compare At Price, Variant Barcode, Variant Sku, and Variant Inventory Item ID.

The selected columns become the spreadsheet headers, and data from each row is accessible as {{googlesheets.data.ColumnName}}. The template automatically creates the spreadsheet with these columns ready for data entry.

Timing: You can adjust the polling frequency by modifying the poll schedule if hourly checks are too frequent or not frequent enough.

This filter checks if {{googlesheets.data.Title}} is not empty. If a title exists, the workflow proceeds to create the product. If the title column is blank, the workflow skips that row. Since title is required for Shopify products, this validation prevents API errors. You can add rows to the spreadsheet with partial information, and they won't be processed until you add a title.

This step creates a Shopify product using data from the spreadsheet row. It maps columns to product fields:

{{googlesheets.data.Title}} to title,
{{googlesheets.data["Description (Body HTML)"]}} to body_html (supports HTML formatting),
{{googlesheets.data.Vendor}} to vendor,
{{googlesheets.data["Product Type"]}} to product_type,
{{googlesheets.data.Tags}} to tags (comma-separated list), and creates a variant with {{googlesheets.data["Variant Title"]}} as option1,
{{googlesheets.data["Variant Price"]}} as price,
{{googlesheets.data["Variant Compare At Price"]}} as compare_at_price,
{{googlesheets.data["Variant Sku"]}} as sku,
{{googlesheets.data["Variant Barcode"]}} as barcode, and
{{googlesheets.data["Variant Inventory Item ID"]}} as inventory_item_id.

Column format guidelines:

Title: Required, plain text
Description (Body HTML): Accepts HTML tags for formatting
Tags: Comma-separated (e.g., "Summer, Sale, Featured")
Variant Price: Decimal number without currency symbol (e.g., "29.99")
Variant Compare At Price: Decimal number for strike-through pricing
Variant Sku: Alphanumeric identifier
Variant Barcode: Numeric barcode/UPC/EAN

Note: This template creates products with a single variant. For multi-variant products, you'll need to modify the workflow to support multiple variant rows or different data structures.