Google Sheets + Shopkit
Create Shopkit customers from new Google Sheets rows
Managing client data manually between spreadsheets and your store can be inefficient and error-prone. This Zap can help, automatically creating a customer in Shopkit whenever a new row is added to a Google Sheets spreadsheet. It streamlines your data entry process and keeps your customer records consistent and up to date.
Managing client data manually between spreadsheets and your store can be inefficient and error-prone. This Zap can help, automatically creating a customer in Shopkit whenever a new row is added to a Google Sheets spreadsheet. It streamlines your data entry process and keeps your customer records consistent and up to date.
- 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 ClientCreates a new client in Shopkit.
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
Cart Abandoned
Triggers when a client abandons a cart in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Client Deleted
Triggers when a client account is removed from Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Client Updated
Triggers when client details are updated in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Client Wholesale Requested
Triggers when a client requests wholesale status in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Newsletter Subscribed
Triggers when a client subscribes to Shopkit’s newsletter.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Canceled
Triggers when an order gets canceled in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Change Status
Triggers when an order’s status is updated in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Deleted
Triggers when an order is removed from Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Invoiced
Triggers when an invoice is generated for an order in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Payment Failed
Triggers when a payment attempt for an order fails in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Returned
Triggers when an order is marked as returned in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Tag Added
Triggers when a tag is added to an order in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Waiting Shipment
Triggers when an order is awaiting shipment in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product Deleted
Triggers when a product is removed from Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product Update Stock
Triggers when a product’s stock level is updated in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.TitleRequired
ActiveRequired
Description
Handle
Image URL
Position
Meta Description
Meta Tags
Page Title
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
EmailRequired
Password
Company
Fiscal ID
Accepts Marketing
Wholesale
Internal Notes
Delivery name
Delivery phone
Delivery address
Delivery address extra
Delivery zip code
Delivery city
Delivery country code
Billing name
Billing phone
Billing address
Billing address extra
Billing zip code
Billing city
Billing country code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Media URL
File
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
PriceRequired
CategoriesRequired
Brand
Handle
SKU
Barcode
Price promo
Promo show percentage
Price on request
Wholesale
Price wholesale
Wholesale_exclusive
Status
Shipping
Shipping alone
Featured
New
Promotion
Description
Excerpt
Video URL
File
Tax
Taxable
Reduced rate
Meta description
Meta tags
Page title
Weight
Origin Country
Harmonized code
Images
Tags
Stock enabled
Stock quantity
Stock backorder
Stock show
Stock sold single
Stock notify
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.URLRequired
EventRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Category IDRequired
TitleRequired
Active
Parent ID
Description
Handle
Image URL
Position
Meta Description
Meta Tags
Page Title
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Status
Paid
New order
Invoice URL
Invoice File
Tracking URL
Tracking Code
Tracking Carrier
Shipping URL
AT Code
Pickup Code
Tags
Order Note
Client Note
Notify Client
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Option IDRequired
Price
Price promo
Price on request
Price wholesale
Stock
Shipping
Weight
SKU
Barcode
Image URL
Active
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MetricRequired
Date From
Date To
ActionThis is an event a Zap performs.SearchFind existing data in your appCategory ID
Handle
Active
Parent
Page
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appCoupon ID
Coupon code
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder ID
Order IDs
Status Alias
Paid
New
Shipped
Invoice
Date Filter
Date from
Date to
Date type
Client email
Client hash
Coupon code
Query
Page
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct IDRequired
Option Group ID
ActionThis is an event a Zap performs.SearchFind existing data in your appSKURequired
ActionThis is an event a Zap performs.SearchFind existing data in your appMeta Field
ActionThis is an event a Zap performs.SearchFind existing data in your appMeta Field
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 foundClient Created
Triggers when a new client is added to Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Client Tag Added
Triggers when a tag is added to a client in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Client Wholesale Accepted
Triggers when a client’s wholesale request is approved in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Client Wholesale Revoked
Triggers when a client’s wholesale status is revoked in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Newsletter Unsubscribed
Triggers when a client unsubscribes from Shopkit’s newsletter.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Change Payment
Triggers when an order’s payment method is changed in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Created
Triggers when a new order is placed in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Delivered
Triggers when an order is marked as delivered in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Paid
Triggers when an order payment is completed in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Pickup Available
Triggers when an order is ready for pickup in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Sent
Triggers when an order is shipped in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Updated
Triggers when order details are modified in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product Created
Triggers when a new product is added in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product Updated
Triggers when product details are modified in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Shipping Expedited
Triggers when an order’s shipping is expedited in Shopkit.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.TitleRequired
Active
Parent ID
Description
Handle
Image URL
Position
Meta Description
Meta Tags
Page Title
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CodeRequired
LimitRequired
ValueRequired
TypeRequired
Applies toRequired
Orders Over
Category
Product
Date from
Date to
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
TitleRequired
OptionsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Brand IDRequired
TitleRequired
Active
Description
Handle
Image URL
Position
Meta Description
Meta Tags
Page Title
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client IDRequired
Name
Email
Password
company
Fiscal ID
Accepts marketing
Wholesale
Internal notes
Delivery name
Delivery phone
Delivery address
Delivery address extra
Delivery zip code
Delivery city
Delivery country code
Billing name
Billing phone
Billing address
Billing address extra
Billing zip code
Billing city
Billing country code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Title
Price
Categories
Brand
Handle
Reference
Barcode
Price promo
Promo show percentage
Price on request
Wholesale
Price wholesale
Wholesale exclusive
Status
Shipping
Shipping alone
Featured
New
Promotion
Description
Excerpt
Video URL
File
Tax
Taxable
Reduced Rate
Meta description
Meta Tags
Page title
Weight
Origin Country
Harmonized code
Images
Tags
Stock enabled
Stock quantity
Stock backorder
Stock show
Stock sold single
Stock notify
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Option group IDRequired
TitleRequired
OptionsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Brand ID
Handle
Active
Page
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appHash
Registered
Cart
Wishlist
Accepts Marketing
Banned
Wholesale
Tags
Query
Page
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appMedia ID
Checksum
Type
Query
Page
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct ID
Product IDs
Handle
Category
Status
Status alias
SKU
Featured
New
Query
Page
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appproduct IDRequired
Option ID
ActionThis is an event a Zap performs.SearchFind existing data in your appQueryRequired
Fields
Page
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appTracking code
Carrier
Paid
Status
Date From
Date to
Query
Page
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appCountry CodeRequired
Weight
Value
ActionThis is an event a Zap performs.SearchFind existing data in your appWebhook ID
Active
Event
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google Sheets
Related categories
