Google Sheets + Shift4Shop
Create new Shift4Shop products from new or updated Google Sheets rows
Streamline your e-commerce operations with this efficient workflow. Whenever there's a change or new input in your Google Sheets spreadsheet, it initiates a product creation process in Shift4Shop. This method ensures your online store stays up-to-date, eliminating the need for manual updates. Ideal for accurate inventory management, this solution minimizes errors and saves time.
Streamline your e-commerce operations with this efficient workflow. Whenever there's a change or new input in your Google Sheets spreadsheet, it initiates a product creation process in Shift4Shop. This method ensures your online store stays up-to-date, eliminating the need for manual updates. Ideal for accurate inventory management, this solution minimizes errors and saves time.
- 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 Product SimpleCreates a new product.
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 ZapPollingZapier 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.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.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
New Customer
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Status Change
Triggers when the status of an order is changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product Deleted
Triggers when a product is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product Stock Changed
Triggers when a product stock changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.OrderKeyRequired
ItemQuantity
CatalogIDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BypassOrderProcessing
BypassOrderEmail
InvoiceNumberPrefix
InvoiceNumber
CustomerID
OrderDate
OrderStatusID
AlternateOrderID
BillingFirstNameRequired
BillingLastNameRequired
BillingCompany
BillingAddressRequired
BillingAddress2
BillingCityRequired
BillingState
BillingZipCode
BillingCountryRequired
BillingPhoneNumberRequired
BillingEmail
BillingOnLinePayment
BillingPaymentMethodID
ShipmentOrderStatus
ShipmentAddressRequired
ShipmentAddress2
ShipmentCityRequired
ShipmentCompany
ShipmentCountryRequired
ShipmentEmail
ShipmentFirstNameRequired
ShipmentLastNameRequired
ShipmentMethodName
ShipmentShippedDate
ShipmentPhoneRequired
ShipmentStateRequired
ShipmentZipCodeRequired
ShipmentTax
ShipmentTrackingCode
ShipmentNumberRequired
CatalogIDRequired
ItemID
ItemShipmentID
ItemQuantity
ItemDescription
ItemUnitPrice
ItemWeight
ItemOptionPrice
ItemUnitCost
ItemUnitStock
OrderDiscount
SalesTax
OrderAmount
TransactionID
TransactionDateTime
TransactionType
TransactionMethod
TransactionAmount
TransactionApproval
TransactionReference
TransactionCVV2
TransactionAVS
TransactionResponseText
TransactionResponseCode
TransactionCaptured
Referer
Ip
CustomerComments
InternalComments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sku
NameRequired
Cost
PriceRequired
RetailPrice
SalePrice
OnSale
Stock
ShortDescription
Gtin
Weight
Height
Width
Depth
Description
Keywords
MainImageFile
MainImageCaption
ThumbnailFile
AdditionalImageFile2
AdditionalImageCaption2
AdditionalImageFile3
AdditionalImageCaption3
AdditionalImageFile4
AdditionalImageCaption4
Title
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrderKeyRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoicePrefix
InvoiceNumber
OrderStatus
BillingEmail
DateStart
DateEnd
LastUpdateStart
LastUpdateEnd
ActionThis is an event a Zap performs.SearchFind existing data 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 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 foundNew Order
Triggers when a new order is placed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product Changed
Triggers when a product changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product New
Triggers when a new product is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.CustomerId
BillingFirstName
BillingLastName
BillingCompany
BillingAddress
BillingAddress2
BillingCity
BillingState
BillingZipCode
BillingCountry
BillingPhoneNumber
BillingEmail
ShipmentFirstName
ShipmentLastName
ShipmentCompany
ShipmentAddress
ShipmentAddress2
ShipmentCity
ShipmentState
ShipmentZipCode
ShipmentCountry
ShipmentPhone
ShipmentEmail
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
PasswordRequired
BillingCompany
BillingFirstName
BillingLastName
BillingAddress1
BillingAddress2
BillingCity
BillingState
BillingZipCode
BillingCountry
BillingPhoneNumber
BillingTaxID
ShippingCompany
ShippingFirstName
ShippingLastName
ShippingAddress1
ShippingAddress2
ShippingCity
ShippingState
ShippingZipCode
ShippingCountry
ShippingPhoneNumber
ShippingAddressType
CustomerGroupID
Enabled
MailList
NonTaxable
DisableBillingSameAsShipping
Comments
AdditionalField1
AdditionalField2
AdditionalField3
TotalStoreCredit
ResetPassword
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sku
NameRequired
Cost
PriceRequired
RetailPrice
SalePrice
OnSale
Stock
Mfgid
ShortDescription
Gtin
NonTaxable
NotForSale
Hide
GiftCertificate
HomeSpecial
CategorySpecial
NonSearchable
ShipCost
Weight
Height
Width
Depth
SelfShip
FreeShipping
RewardPoints
RedeemPoints
DisableRewards
StockAlert
ReorderQuantity
InStockMessage
OutOfStockMessage
BackOrderMessage
InventoryControl
Description
Keywords
ExtraField1
ExtraField2
ExtraField3
ExtraField4
ExtraField5
ExtraField6
ExtraField7
ExtraField8
ExtraField9
ExtraField10
ExtraField11
ExtraField12
ExtraField13
FeatureTitle
FeatureDescription
MainImageFile
MainImageCaption
ThumbnailFile
AdditionalImageFile2
AdditionalImageCaption2
AdditionalImageFile3
AdditionalImageCaption3
AdditionalImageFile4
AdditionalImageCaption4
ImageGalleryFile
ImageGalleryCaption
ImageGallerySorting
CanonicalUrl
PriceLevel2
PriceLevel2Hide
PriceLevel3
PriceLevel3Hide
PriceLevel4
PriceLevel4Hide
PriceLevel5
PriceLevel5Hide
PriceLevel6
PriceLevel6Hide
PriceLevel7
PriceLevel7Hide
PriceLevel8
PriceLevel8Hide
PriceLevel9
PriceLevel9Hide
PriceLevel10
PriceLevel10Hide
Title
CustomFileName
MetaTags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrderID
OrderStatusID
InternalComments
CustomerID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
First Name
Last Name
Country
State
City
Phone
ActionThis is an event a Zap performs.SearchFind existing data in your appSku
Name
Cost
Price
Stock
Hide
Free Shipping
On Sale
Non Tax
Not for Sale
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google Sheets
Related categories
About Shift4Shop
Related categories
Related Zap Templates
- Log new Shift4Shop orders in Google Sheets
- Add new Shift4Shop orders to Google Sheets as rows
- Create spreadsheet rows in Google Sheets for new customers in Shift4Shop
- Create multiple rows in Google Sheets when new products are added in Shift4Shop
- Track updated Shift4Shop products by creating new rows in Google Sheets