How to connect WooCommerce + Magento + Google Sheets
Zapier lets you send info between WooCommerce and Magento and Google Sheets automatically—no code required. With 6,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with WooCommerce + Magento + Google Sheets
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with WooCommerce, Magento, and Google Sheets. And don’t forget that you can add more apps and actions to create complex workflows.
Update Coupon
Updates an existing Coupon.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Customer
Updates an existing Customer.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Order Note
Creates a new Order Note.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Product
Creates a new Product or Variation.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Product Stock Quantity
Manage the stock quantity and stock status of an existing Product or Variation by SKU or ID.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Subscription
Creates a new Subscription.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Subscription
Updates an existing Subscription.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update User Membership
Updates an existing User Membership.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find Coupon
Finds a Coupon by searching.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Membership Plan
Finds a Membership Plan by searching.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Order
Finds an Order by searching.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Subscription Note
Finds a Subscription Note by searching.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind User Membership
Finds a User Membership by searching.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind or Create Customer
Finds a Customer by searching.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Order
Finds an Order by searching.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Subscription Note
Finds a Subscription Note by searching.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create User Membership
Finds a User Membership by searching.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Customer
Triggers when Magento gets a new customer.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Order Invoice
Triggers when Magento gets a new sales order invoice (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Order
Triggers when Magento gets a new order.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Order Invoice
Triggers when Magento gets a new sales order invoice.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planParent Category IDRequired
NameRequired
Available Sort ByRequired
Default Sort ByRequired
Would you like to include in main menu?Required
Store View
Category Visibility
Position
Category Custom Design
Apply to all products
Custom Design Start Date
Custom Design End Date
Custom Layout Update
Description
Email
Email
Landing Page
Meta Description
Meta Keywords
Meta Title
Page Layout
URL Key
Price range
Inherit custom design
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
First Name
Last Name
Password
Website IDRequired
Store ID
Group ID
Prefix
Suffix
Date Of Birth
Tax or VAT number
Gender
Middle Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order StatusRequired
Order comment
Email
Optionally, include comments in email
Order Item IDRequired
Quantity
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Create Coupon
Creates a new Coupon.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Customer
Creates a new Customer.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Order
Creates a new Order.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Order
Updates an existing Order.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Product Price
Manage the regular price or sale price of an existing Product or Variation by SKU or ID.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Product
Updates an existing Product or Variation.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Subscription Note
Creates a new Subscription Note.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create User Membership
Creates a new User Membership.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find Customer
Finds a Customer by searching.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Order Note
Finds an Order Note by searching.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Product
Finds a Product or Variation by searching.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Subscription
Finds a Subscription by searching.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind or Create Coupon
Finds a Coupon by searching.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Order Note
Finds an Order Note by searching.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Product
Finds a Product or Variation by searching.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFind or Create Subscription
Finds a Subscription by searching.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Product
Triggers when a new product is created in Magento.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Order
Triggers when Magento gets a new order (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Order Shipment
Triggers when Magento gets a new sales order shipment (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Order Credit Memo
Triggers when Magento gets a new sales order credit memo.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Order Shipment
Triggers when Magento gets a new sales order shipment.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNameRequired
TypeRequired
Attribute SetRequired
Store ViewRequired
DescriptionRequired
Short DescriptionRequired
SKURequired
Categories
StatusRequired
VisibilityRequired
Price
Product Weight
Tax Class
URL Path
URL Key
Meta Description
Meta Keyword
Meta Title
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order Increment IDRequired
Order Status
Order comment
Notification Flag
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How WooCommerce + Magento + Google Sheets Integrations Work
- Step 1: Authenticate WooCommerce, Magento, and Google Sheets.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
Related categories
Other WooCommerce + Magento Integrations
Other WooCommerce + Google Sheets Integrations
- webhook
- trello
- schedule
- hubspot
- sendinblue
- keap-max-classic
- google-drive
- facebook-offline-conversions
- twilio
- salesforce
- leadconnector
- alegra
- smoove
- xero
- stripe
- signaturit
- rd-station
- quickbooks
- manychat
- mailjet
- looping
- gravity-forms
- google-docs
- google-contacts
- google-calendar
- getresponse
- excel
- discord
- zoom
- zoho-crm
- zoho-creator
- zebracrm
- url-shortener
- textlocal
- textedly
- sql-server
- smtp
- sms
- simpletexting
- shopify
- shipday
- sharpspring
- sendowl
- sendgrid
- sendfox
- pushbullet
- podio
- pipedrive
- paypro
- ninjaforms
- moosend
- microsoft-outlook
- mautic
- mailigen
- mailerlite
- lob
- learndash
- landbot
- labsmobile
- knack
- klaviyo
- kirimemail
- keap
- kajabi
- jotform
- google-slides
- google-groups
- google-cloud-print
- google-ads
- freshbooks
- flodesk
- facebook-lead-ads
- facebook-custom-audiences
- facebook-conversions
- drip
- docusign
- cognito-forms
- clust
- closeio
- clicksend
- chatwork
- burst-sms
- autopilot
- asana
- antsroute
- analytic-call-tracking
- airtable
- activetrail