When this happens...
Google SheetsNew Spreadsheet Row
Then do this...
Magento 2.XCreate Sales Order Invoice

When it comes to your eCommerce merchandise and orders, it's best to keep them all in one place. Sometimes, when you're at a tradeshow or promotional event, you may need to manage orders in a different application like a spreadsheet. Once activated, this integration will automatically create new Magento 2.X orders for rows added to a Google Sheets spreadsheet. Create orders for your list of customers without the hassle of manually adding them in Magento 2.X.

How this Google Sheets-Magento 2 integration works

  1. A new row is added to a Google Sheets spreadsheet
  2. Zapier creates an order in Magento 2

Apps involved

  • Google Sheets
  • Magento 2.X
Premium
Magento 2.X is a Premium integration on Zapier.

Why Zapier?

Free

Get started for free—14 day trial of premium features and apps.

Easy

No coding required—automate any of 1,000+ apps in minutes.

Secure

Enterprise-level security—connect mission-critical apps.

It's easy to connect Google Sheets + Magento 2.X and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
Google Sheets
New or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

Google Sheets
Create Spreadsheet Row

Create a new row in a specific spreadsheet.

Google Sheets
New Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

Google Sheets
Update Spreadsheet Row

Update a row in a specific spreadsheet.

Magento 2.X
New Customer

Triggers when a new customer is created.

Magento 2.X
Create Customer

Create a new customer

Magento 2.X
New Order

Triggers when a new order is created (with line item support).

Magento 2.X
Create Sales Order Invoice

Create a new sales order invoice

Magento 2.X
New Product

Triggers when a new product is created.

Google Sheets
Create Spreadsheet Row(s)

Create one or more new rows in a specific spreadsheet (with line item support).

Use our free platform to build a single Zapier integration and instantly connect your app with 1,000+ others.

Become a Zapier Integration Partner

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Magento 2.X is the premier open source e-commerce app used by millions of customers each and every day.