Commerce Layer + Google Sheets
Add Google Sheets rows for newly placed Commerce Layer orders
Looking for an automated record-keeping system working for you 24/7 to archive your orders without wasting any precious time? Set up this Commerce Layer-Google Sheets integration, and Zapier will watch for new orders placed in Commerce Layer and add a corresponding row to your Google Sheets spreadsheet for each one it detects.
Looking for an automated record-keeping system working for you 24/7 to archive your orders without wasting any precious time? Set up this Commerce Layer-Google Sheets integration, and Zapier will watch for new orders placed in Commerce Layer and add a corresponding row to your Google Sheets spreadsheet for each one it detects.
- When this happens...
New Order EventTriggers when a given order event (one of pending, place, approve, cancel, pay, start_fulfilling, fulfill is fired).
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Attachment
Triggers when a new Attachment is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Customer
Triggers when a new Customer is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCustomer Subscription eventRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Gift Card eventRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order eventRequired
Webhook name
Include resources
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Parcel Event
Triggers when a new parcel is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Price Import
Triggers when a new Price import is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planRefund eventRequired
Include resources
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Shipment eventRequired
Include resources
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New SKU
Triggers when a new SKU is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Stock Item
Triggers when a new Stock Item is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Stock Location
Triggers when a new Stock Location is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planIdRequired
Action
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Balance Change CentsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Currency CodeRequired
Balance centsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Price ListRequired
Sku CodeRequired
Amount CentsRequired
Compare At Amount Cents
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Currency CodeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InputsRequired
Cleanup RecordsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stock LocationRequired
InputsRequired
Cleanup RecordsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
ActionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Reference
Metadata
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appID or ReferenceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPrice List IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCodeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appStock LocationRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appID or ReferenceRequired
EmailRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundID or ReferenceRequired
Market IDRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundStatusRequired
Price ListRequired
InputsRequired
Cleanup RecordsRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundStatusRequired
InputsRequired
Cleanup RecordsRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundStatusRequired
Stock LocationRequired
InputsRequired
Cleanup RecordsRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
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
Customer eventRequired
Include resources
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Address eventRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer password reset eventRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Gift Card
Triggers when a new Gift Card is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Order
Triggers when a new Order is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Price
Triggers when a new Price is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Price List
Triggers when a new Price List is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Shipping Category
Triggers when a Shipping Category is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew SKU Import
Triggers when a new SKU import is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Stock Item Import
Triggers when a new Stock Item import is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planStock Transfer eventRequired
Include resources
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Attachable TypeRequired
Attachable IdRequired
NameRequired
Description
UrlRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Market IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Price ListRequired
InputsRequired
Cleanup RecordsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Action
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CodeRequired
NameRequired
Shipping CategoryRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stock LocationRequired
Sku CodeRequired
QuantityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Address IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer IDRequired
Reference
Reference Origin
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
CodeRequired
NameRequired
Shipping CategoryRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID or ReferenceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appID or ReferenceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appStatusRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appStatusRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appStatusRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Attachable TypeRequired
Attachable IdRequired
Description
UrlRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundID or ReferenceRequired
Currency CodeRequired
Balance centsRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundPrice ListRequired
Sku CodeRequired
Amount CentsRequired
Compare At Amount Cents
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
Currency CodeRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCodeRequired
NameRequired
Shipping CategoryRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundStock LocationRequired
Sku CodeRequired
QuantityRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
Address IdRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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 Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Search from last row
Row count
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
Search from last row
Row count
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
About Commerce Layer
Related categories
