Google Sheets

Google Sheets is a platform for storing and updating structured spreadsheet data in ecommerce workflows.

Key features include:

Row-based data storage
Spreadsheet searching by column value
Row creation
Row updates

This scenario syncs ShopWired product updates to Google Sheets. It checks whether the product SKU already exists in the sheet, then adds a new row or updates the existing row.

This scenario allows:

Triggering when a product is updated in ShopWired
Searching for an existing row by SKU
Adding a new row when no matching SKU is found
Updating an existing row when a matching SKU is found

ShopWired can only provide support for the scenario as provided in this guide. Any customisations or changes made to the scenario are supported by Make.

Prerequisites

A Make account
A Google Sheets account

Scenario blueprint

A blueprint is provided for this scenario.

Public scenario link: Sync ShopWired product updates to Google Sheets

Modules used in this scenario:

ShopWired product updated
Filter rows
Add row
Update row

This scenario uses:

A webhook trigger
Google Sheetsmodules
A router
No HTTP modules

Scenario setup steps

Select the scenario blueprint provided with this guide
Open it in Make
Create a new scenario from the blueprint
Replace any placeholder values if required
Connect required accounts
Turn the scenario on
Trigger the relevant event in ShopWired

ShopWired webhook data

Event: product.updated

{
  "event": {
    "topic": "product.updated",
    "subjectType": "product",
    "subjectId": 12345,
    "data": {
      "object": {
        "sku": "SKU-123",
        "title": "Example product",
        "stock": "25",
        "price": "19.99",
        "weight": "0.50",
        "updatedAt": "2026-04-13 10:00:00"
      }
    }
  }
}

Required user inputs

Field	Description
Webhook URL	The webhook URL generated by Make to be added to ShopWired
Google Sheets connection	The connected account used by the sheet modules
Spreadsheet	The target spreadsheet
Sheet name	The target sheet tab

Recommendations

Ensure the target sheet contains headers in row 1
Ensure SKU values are stored in column A
The scenario writes SKU, title, stock, price, weight, and updated date
The scenario adds a row when no matching SKU is found
The scenario updates a row when a matching SKU is found
Test the webhook by updating a product in ShopWired
Keep the sheet structure aligned with the mapped columns