Orders

New order → Google Sheets

Appends a new row to a Google Sheet every time an order is placed.

When to use this template

This template is built for Shopify stores using the JsWorkflows app.

Use this template when you want a ready-made workflow for this use case: Appends a new row to a Google Sheet every time an order is placed.

It is designed for Shopify order operations and gives you a production-ready starting point instead of building the automation from scratch. It can work with Google as part of the workflow.

This workflow uses the Shopify webhook trigger model and starts from the "Order created" trigger. It includes setup fields for merchant-facing values, so you can configure the workflow before installing it.

Setup guide

Before you start

This template appends one row to Google Sheets for every new Shopify order using a saved Google OAuth connector.

Sheet columns written

The workflow appends these columns in order:

Order ID
Order Name
Email
Total Price
Currency
Financial Status
Created At

Configure in setup

Google OAuth handle: connector handle for the Google account used to access the spreadsheet
Spreadsheet ID: use the Google picker or paste an already-accessible spreadsheet ID
Sheet name: target tab name inside the spreadsheet

Notes

The connected Google account must already have access to the spreadsheet
The destination tab must already exist
Duplicate webhook deliveries for the same order are deduplicated automatically

Setup fields

Google OAuth handle

textRequiredconfig

OAuth handle for the Google connection that can access the selected spreadsheet.

Spreadsheet ID

google_drive_file_pickerRequiredconfig

Select the Google Sheet with the picker or paste an already-accessible spreadsheet ID.

Sheet name