Shopify logo
Google Sheets logo

Workflow template

Log new Shopify products in Google Sheets

Keep a Google Sheets log of products created in Shopify. The first event creates the spreadsheet and four headers; later events append rows to the same file.

How it works

From a new Shopify product to an activity-log row

1 Trigger · 2 Actions
Shopify1 · Trigger

Product Created

Receive products/create webhooks from your connected Shopify store. Draft creation counts too; a new row does not confirm storefront publication.

Google Sheets2 · Action

Create the Shopify product log once

Create a spreadsheet with four column headers on the first run. Later events reuse that file in this workflow copy.

Google Sheets3 · Action

Log the new Shopify product

Append the product ID, title, status and creation timestamp. RAW input keeps formula-like product titles as literal text.

The result

A running record of newly created products

Four columns are prepared automatically. The sheet records selected creation metadata without copying descriptions, images, variants, prices or customer data.

Fictional product data illustrating the four columns created by this workflow.
Product IDProduct titleStatusCreated at
1789581600381FICTIONAL Köln workshop kit — Grüßedraft2026-09-20T09:00:00Z

Illustrative data. The timestamp keeps Shopify’s source timezone offset. Review who can access the generated spreadsheet.

Before activation

Set up your workflow

  1. Connect Shopify

    Choose the store whose new products you want to log. The connection needs product read access. Use your development store for the first test.

  2. Connect Google Sheets

    Choose the Google account that will own the new activity log. No existing spreadsheet or manual header row is required.

  3. Create two fictional Draft products

    Activate and wait for the Shopify trigger connection to be ready. Create one fictional Draft product, open the generated spreadsheet, then create another to verify that it appends a row to the same file.

Details and limitations
  • Creation includes Draft products. A row records product creation, not storefront publication or stock availability. Existing products, edits, publication changes, stock changes and deletions are not synchronized.

  • Only four metadata fields. Product descriptions, images, variants, prices, inventory, customer data and other product fields are excluded. Readers can see the included metadata; opening the product in Shopify still requires their own store access.

  • One file per workflow copy. Testing the creation Action also creates the file. Later runs reuse it. Changing creation settings after its first run requires a new creation step, and a deleted spreadsheet is not silently replaced.

  • A creation log rather than synchronization. RAW input keeps formula-like titles as text. Manual reruns can append duplicate rows; later Shopify changes and spreadsheet edits are not synchronized in either direction.

Questions about this template

Do I need to prepare the spreadsheet and column headers?

No. The first event creates a spreadsheet with Product ID, Product title, Status and Created at columns. Subsequent events reuse it in the same workflow copy.

Will creating a Draft Shopify product add a row?

Yes. The trigger listens for products/create, including Draft creation. A row does not confirm that the product is published or available for sale.

Will edits or stock changes update an existing row?

No. This is a one-way creation log. Existing products, later edits, publication changes, stock changes and deletions are not synchronized. Manual reruns can append duplicate rows.

Which product fields leave Shopify?

Only product ID, title, status and creation timestamp. Product descriptions, images, variants, prices, inventory and customer data remain in Shopify. Review access to the generated file.