Commerce Layer + Google Sheets
Create Commerce Layer prices from new or updated Google Sheets rows
Effortlessly manage your product pricing with this seamless workflow between Google Sheets and Commerce Layer. Whenever a new or updated row is detected in your spreadsheet, the corresponding price will be created in Commerce Layer, ensuring your e-commerce system stays up-to-date with the latest information. Keep your pricing data organized and maintain accurate records with this easy-to-use automation.
Effortlessly manage your product pricing with this seamless workflow between Google Sheets and Commerce Layer. Whenever a new or updated row is detected in your spreadsheet, the corresponding price will be created in Commerce Layer, ensuring your e-commerce system stays up-to-date with the latest information. Keep your pricing data organized and maintain accurate records with this easy-to-use automation.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create PriceCreates a new Price.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
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.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
Search from last row
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCustomer 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 ZapScheduledZapier 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 ZapScheduledZapier 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 ZapScheduledZapier 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 ZapScheduledZapier 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 ZapScheduledZapier 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 ZapScheduledZapier 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 ZapScheduledZapier 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 found
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 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
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
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
ColumnsRequired
Row CountRequired
First Row
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 foundNew Attachment
Triggers when a new Attachment is created.
Try ItTriggerThis is the start of your ZapScheduledZapier 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 ZapScheduledZapier 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
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 ZapScheduledZapier 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 ZapScheduledZapier 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 ZapScheduledZapier 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 ZapScheduledZapier 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 found
About Commerce Layer
Related categories
