Google Sheets - Order logging

Google Sheets is a cloud-based spreadsheet platform for storing, organising, and analysing data in real time.
Key features include:

Structured data storage in rows and columns
Real-time collaboration
Automated data entry via integrations
Built-in formulas and data processing tools

This scenario sends ShopWired order data to Google Sheets using Make.

This scenario allows:

Send ShopWired order finalised data to Google Sheets

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

An account for Google Sheets

A Make account

Scenario blueprint

Open the scenario blueprint in Make

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 (if present)

Event: order finalised

{
  "event": {
    "topic": "order.finalized",
    "data": {
      "object": {
        "id": "1000123",
        "created": "2026-01-01",
        "total": "59.99",
        "status": {
          "type": "completed"
        },
        "shippingAddress": {
          "name": "John Smith",
          "emailAddress": "customer@example.com"
        }
      }
    }
  }
}

Required user inputs

Input	Description
Google Account Connection	Authorised Google account connection
Spreadsheet	Target Google Sheets file
Sheet Name	Worksheet where data will be added
Webhook URL	Generated webhook URL from Make

Recommendations

Ensure the Google Sheets file contains matching column headers
Test using a real ShopWired order
Verify data appears in the correct columns
Monitor scenario execution logs in Make
Keep column names unchanged to maintain mapping
Only order finalised events will trigger the scenario