> For the complete documentation index, see [llms.txt](https://doc.duaer.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.duaer.com/recipes/shopify-orders-to-google-sheets.md).

# Send new Shopify orders to Google Sheets with Duaer

In Duaer, every new Shopify order adds a row to Google Sheets with the order number, email, total, and items.
## Build the order sync in Duaer

1. Create a Google Sheet with headers in row one: order, email, total, currency, created, items.
2. In Duaer add [Shopify Trigger](/integrations/builtin/trigger-nodes/duaer-nodes-base.shopifytrigger.md), connect the [Shopify credential](/integrations/builtin/credentials/shopify.md), and set Trigger On to Order Created.
3. Add [Edit Fields](/build/edit-fields.md) with six fields: order = {{ $json.name }}, email = {{ $json.email }}, total = {{ $json.total_price }}, currency = {{ $json.currency }}, created = {{ $json.created_at }}, items = {{ $json.line_items.map(i => i.title + ' x' + i.quantity).join('; ') }}.
4. Add [Google Sheets](/build/google-sheets.md) with Operation Append Row, pick the sheet, and set Mapping Column Mode to Map Automatically. Matching names line up with the headers.
5. Publish the digital organization. Shopify Trigger registers its webhook in the store only after publishing.

## Test and common issues

- Place a test order in Shopify, then check the row in Duaer executions.
- To update one row per order instead of appending duplicates, use Append or Update Row matched on order.
- If order spikes hit the Google limit, refer to [Fix Google Sheets 429 in Duaer](/troubleshooting/google-sheets-429-quota-exceeded.md).
## Questions

### Can Duaer import past Shopify orders too?

Shopify Trigger receives only new events. For history, read orders once with the Shopify node Get Many operation in Duaer and write them to the same sheet.

### Does syncing Shopify orders in Duaer cost AI credits?

No. This Duaer flow calls no model.

## Related

- [Read rows with Google Sheets in Duaer](https://doc.duaer.com/build/google-sheets.md)
- [Set up Shopify credentials in Duaer](https://doc.duaer.com/integrations/builtin/credentials/shopify.md)
- [Fix Google Sheets 429 quota exceeded in Duaer](https://doc.duaer.com/troubleshooting/google-sheets-429-quota-exceeded.md)