Google Sheets + Shopify
Add sold Shopify products to Google Sheets for review
When a new order is placed in Shopify, this Zap retrieves custom order data from metafields and logs the information into a Google Sheet. This automation ensures accurate record-keeping and helps streamline your order management process, so you can create detailed reports of the kinds of products that are selling.
When a new order is placed in Shopify, this Zap retrieves custom order data from metafields and logs the information into a Google Sheet. This automation ensures accurate record-keeping and helps streamline your order management process, so you can create detailed reports of the kinds of products that are selling.
- When this happens...
New OrderTriggers when an order is created (with line item support).
TriggerInstantThis event starts a Zap instantly. - automatically do this...Find Metafields
Searches for Metafields data for a given resource (example order Metafields).
ActionSearchFind existing data in your app - then do this!
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 Blog
Triggers when a new blog is added to your Shopify store.
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 added to your Shopify account.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Cancelled Order
Triggers whenever an order is cancelled (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Fulfilled Order
Triggers when an order is fulfilled (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Paid Order
Triggers when an order is paid (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Product
Triggers when a product is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Customer
Triggers when a customer's information is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Order
Triggers when an order is updated (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Tag in Order
Triggers when a tag has either been added or removed from an order.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.CustomerRequired
TagsRequired
Overwrite existing tags?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
External Id
A note about the company
Company Contact
Contact Email
Contact First Name
Contact Last Name
Contact Phone
Contact Title
Contact Locale
Location
Billing same as shipping address?
Company Shipping Address
Shipping Address Line 1
Shipping Address Line 2
Shipping Address City
Shipping Address Country Code
Shipping First Name
Shipping Last Name
Shipping Address Phone
Shipping Address Recipient
Shipping Address Zip
Shipping Address Zone Code
Location External ID
Location Locale
Location Name
Location Note
Location Phone
Tax Registration Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
Email AddressRequired
Customer Phone
Company Name
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Address Phone
Tags
Note
Accepts Marketing
Tax Exempt
Tax Exemptions
Send E-Mail Invite
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Fulfillment Order IDRequired
Notify Customer
Address Line 1
Address Line 2
City
Country Code
Province Code
Zip Code
Tracking Company
Tracking Number
Tracking URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Product
Product Variant
SKU
Product Quantity
Product Title
Product Price
Weight in Grams
Price
Rate
Title
Note
Discount - Type
Discount - Amount
Discount - Code
Additional Details
Tags
Buyer Accepts Marketing?
Shipping Address Instructions
Shipping Address - First name
Shipping Address - Last name
Shipping Address - Company
Shipping Address - Phone
Shipping Address - Address
Shipping Address - Address con't
Shipping Address - City
Shipping Address - Country
Shipping Address - Country Code
Shipping Address - State/Province/Region
Shipping Address - State/Province/Region Code
Shipping Address - Postal/Zip code
Billing Address Instructions
Billing Address - First name
Billing Address - Last name
Billing Address - Company
Billing Address - Phone
Billing Address - Address
Billing Address - Address con't
Billing Address - City
Billing Address - Country
Billing Address - Country Code
Billing Address - State/Province/Region
Billing Address - State/Province/Region Code
Billing Address - Postal/Zip code
Send Receipt
Send Fulfillment Receipt
Location
Inventory Behaviour
Financial Status
Fulfillment Status
Code
Title
Price
Discounted Price
Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Channel IDRequired
Publish Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrderRequired
Amount
Currency
Type
Parent Transaction
Warning
Gateway
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Email
Notes
Phone
Buyer Accepts Marketing?
Remove Customer from Order?
Tags
Additional Details
Shipping Address - Line 1
Shipping Address - Line 2
Shipping Address - City
Shipping Address - Company
Shipping Address - Country
Shipping Address - First Name
Shipping Address - Last Name
Shipping Address - Latitude
Shipping Address - Longitude
Shipping Address - Name
Shipping Address - Phone
Shipping Address - Province
Shipping Address - Province Code
Shipping Address - ZIP
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Title
Product Type
Vendor
Product Status
Product Description
Tags
Category
Collections to Join
Collections to Leave
Handle
Redirect Handle?
Alt Text
Media Content Type
Original Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IDRequired
Include Closed Fulfillment Orders
ActionThis is an event a Zap performs.SearchFind existing data in your appOwner ResourceRequired
Owner IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appIdsRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCopy
Product Title / HandleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct Variant SKURequired
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Email AddressRequired
First Name
Last Name
Customer Phone
Company Name
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Address Phone
Tags
Note
Accepts Marketing
Tax Exempt
Tax Exemptions
Send E-Mail Invite
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProduct IDRequired
Product Variant TitleRequired
Add New Image - File
Add New Image - Alt Text
Choose Existing Image
Price
Compare-at Price
Charge Tax On This Variant?
Cost Per Item
SKU (Stock Keeping Unit)
Barcode (ISBN, UPC, GTIN, etc.)
Track Quantity?
Continue Selling When Out of Stock?
This Is a Physical Product
Weight
Weight Unit
Country/Region of Origin
Harmonized System (HS) code
Position
Requires Components
Tax Code
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
BlogRequired
Blog Entry Status
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCustomer Account Enabled
Triggers when a customer account is enabled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Abandoned Cart Age (Hours)Required
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Draft Order
Triggers when a new draft order is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Order
Triggers when an order is created (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Refund
Triggers when a refund or partial refund occurs.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Tag Added to Customer
Triggers when a new tag is added to a customer.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Product
Triggers when a Product is updated, ordered or when a variant is added, removed, or updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order IDRequired
Type of Line Item to AddRequired
Reason for Edit
Notify the Customer?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BlogRequired
TitleRequired
Author NameRequired
ContentRequired
Featured Image URL
Excerpt/Summary
Tags
Is Published?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Add New Image - File
Add New Image - Alt Text
Choose Existing Image
Price
Compare-at Price
Charge Tax On This Variant?
Cost Per Item
SKU (Stock Keeping Unit)
Barcode (ISBN, UPC, GTIN, etc.)
Track Quantity?
Continue Selling When Out of Stock?
This Is a Physical Product
Weight
Weight Unit
Country/Region of Origin
Harmonized System (HS) code
Position
Requires Components
Tax Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Product
Product Variant
Product Quantity
Product Title
Product Price
Weight in Grams
Note
Discount - Type
Discount - Amount
Discount - Code
Additional Details
Tags
Shipping Address Instructions
Shipping Address - First name
Shipping Address - Last name
Shipping Address - Company
Shipping Address - Phone
Shipping Address - Address
Shipping Address - Address con't
Shipping Address - City
Shipping Address - Country
Shipping Address - State/Province/Region
Shipping Address - Postal/Zip code
Billing Address Instructions
Billing Address - First name
Billing Address - Last name
Billing Address - Company
Billing Address - Phone
Billing Address - Address
Billing Address - Address con't
Billing Address - City
Billing Address - Country
Billing Address - State/Province/Region
Billing Address - Postal/Zip code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Adjust or Set quantity?Required
The name of quantities to be changedRequired
The reason for the quantity changesRequired
LocationRequired
Product
Product VariantRequired
Quantity to Set or Adjust
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Product Type
Vendor
Product Status
Product Description
Tags
Collection ID
Handle
Note
First Product Option
Values for First Product Option
Second Product Option
Values for Second Product Option
Third Product Option
Values for Third Product Option
Category
Alt Text
Media Content Type
Original Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
TagsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
First Name
Last Name
Email Address
Company Name
Default Address
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Tags
Phone Number
Note
Tax Exempt
Tax Exemptions
Accepts Marketing
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
Product VariantRequired
Price
Compare at Price
SKU
Barcode
Tax Code
Is taxable?
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
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Query - Name
Query - Confirmation Number
Query - Email
Query - Customer ID
Query - Location ID
Query - SKU
Query - Order ID
Sort Key
Reverse?
Raw Query
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct TitlesRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct Variant TitlesRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProductRequired
Product Variant TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCopy
Product Title / HandleRequired
Product Type
Vendor
Product Status
Product Description
Tags
Collection ID
Handle
Note
First Product Option
Values for First Product Option
Second Product Option
Values for Second Product Option
Third Product Option
Values for Third Product Option
Category
Alt Text
Media Content Type
Original Source
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 Google Sheets
Related categories
About Shopify
Related categories
Related Zap Templates
- Add new paid Shopify orders to Google Sheets rows
- Add new Shopify customers to Google Ads Custom Lists
- Share new paid orders from Shopify to Slack
- Add new Shopify paid orders to Google Sheets rows
- Add transactions in Wave for new Shopify sales
- Send new paid orders in Shopify to Facebook conversions as purchase events
- Add new Facebook Lead Ads leads as Shopify customers
- Add newly-abandoned carts in Shopify to Google Sheets rows
- Create Shopify customers from new Jotform submissions
- Add new Shopify customers to Google Ads Customer Lists
- Add new Shopify customers to ActiveCampaign
- Create new Shopify customers from new Facebook Lead Ads leads
- Add new Shopify customers to Mailchimp
- Enroll users in Teachable courses with new paid Shopify orders
- Create Xero invoices for new Shopify paid orders
- Create Trello cards from new Shopify orders
- Add new Shopify customers as EmailOctopus subscribers
- Post on Facebook about new blog entries on Shopify
- Create Shopify orders from new Typeform entries
- Record Google Ads offline conversions for newly-paid orders in Shopify
- Add new paid orders in Shopify to Track-POD
- Create Trainerize clients for new paid Shopify orders
- Add contacts to a Google Ads customer list for new abandoned carts on Shopify
- Send Gmail emails for new paid Shopify orders
- Send funnel events to Facebook Conversions from Shopify
- Create new beehiiv subscribers from new Shopify customers
- Trigger offline conversions in Google Ads for new paid orders in Shopify
- Grant access to Kajabi offers when new Shopify orders are created
- Add people to Google Ads Custom Lists for newly-paid Shopify orders
- Create Salesforce contacts from new Shopify customers
- Create Airtable records for new paid orders in Shopify
- Send Slack channel messages for new abandoned carts in Shopify
- Add Shopify customers from new POWr Form Builder form submissions
- Log emails in Facebook Custom Audiences with new paid orders in Shopify
- Create Trustpilot invitations from new Shopify orders
- Subscribe new Shopify customers to a list in iContact
- Send Slack channel messages for new updated orders in Shopify
- Enroll users into LearnDash courses with new paid orders in Shopify
- Enroll Shopify users with new paid orders in LearnWorlds products
- Add new Shopify customers to Keap as new contacts
- Add new Shopify customers to Google Ads customer lists
- Send digests of new Shopify orders via Gmail
- Update inventory quantities in Shopify when new or updated spreadsheet rows occur in Google Sheets
- Create Trello cards for new paid orders in Shopify
- Create Aweber subscribers from new paid orders in Shopify
- Add Klaviyo subscribers with new Shopify customers
- Welcome new Shopify customers with personalized emails from Gmail
- Add contacts to a Google Ads customer list for updated customers on Shopify
- Add new Shopify abandoned carts as Flodesk subscribers
- Add new paid Shopify orders to Spektrix customer records
- Create Shopify customers from new leads in TikTok Lead Generation
- Add new paid Shopify orders to Microsoft Excel rows
- Create people and sales invoices in Bexio from new paid orders in Shopify
- Create Kajabi form submissions for new Shopify customers
- Add people to Google Ads Customer Lists for newly-paid Shopify orders
- Add new Shopify customers to a SimpleTexting list
- Create consent agreements in iubenda for new Shopify customers
- Send Thanks.io postcards for new paid Shopify orders
- Create ActiveCampaign contacts from new paid orders in Shopify
- Generate tickets in Zendesk from newly-paid orders in Shopify
- Create QuickBooks Online invoices for new Shopify orders
- Add new Shopify customers to HubSpot as contacts
- Add new Shopify customers to a Moosend mailing list
- Add New Shopify Customers to Flodesk Subscribers
- Create Shopify orders for new Stripe subscriptions
- Add new Shopify customers to Mailjet
- Update Google Ads contacts list with updated customers from Shopify
- Update Shopify customers when new Stripe checkout sessions are completed
- Send emails for new paid Shopify orders
- Add new Shopify customers to Laposta
- Send EditionGuard eBook download links via email when new eBooks are purchased in Shopify
- Track updated Shopify inventory in Google Sheets
- Add new Shopify orders to Notion as database items
- Create Google Sheet rows for new abandoned carts in Shopify
- Create new Shopify customers from new Leadpages form submissions
- Subscribe new Shopify customers to a list in Robly
- Send messages in WhatsApp Notifications for new customers in Shopify
- Add new Shopify customers as active Trainerize clients
- Add new Shopify customers to Zendesk as users
- Add new Shopify orders as subscribers in beehiiv
- Create income tickets in Quipu from new orders paid in Shopify
- Create or update HubSpot contacts from new paid orders on Shopify
- Add Contact to Customer List With Email in Google Ads for New Abandoned Cart in Shopify
- Create events in Klaviyo for new paid orders in Shopify
- Generate sales receipts in QuickBooks Online for new orders in Shopify
- Create Google Sheets rows for new customers in Shopify
- Subscribe users to sequence in Manychat when new abandoned carts are detected in Shopify
- Send Gmail emails with new abandoned carts in Shopify
- Add/update Mailchimp subscribers for new paid orders in Shopify
- Add new Shopify customers to Mailchimp
- Create new Teachable users from new paid Shopify orders
- Create tasks in Asana for new orders from Shopify
- Create tasks in Bonjoro with new Shopify customers
- Send messages through WhatsApp Notifications for new paid Shopify orders
- Add new Shopify customers to a Google Ads customer list automatically
- Create contacts in OnePageCRM for new customers in Shopify
- Create or update Ontraport contacts for new paid Shopify orders
- Create new Shopify orders from new Jotform submissions
- Update Shopify inventory after purchase in Chatfuel
- Create purchase events in Facebook Conversions from new paid orders in Shopify
Related Zap Templates
- Add new paid Shopify orders to Google Sheets rows
- Add new Shopify paid orders to Google Sheets rows
- Add new Facebook Lead Ads leads as Shopify customers
- Add new Shopify customers to Google Ads Customer Lists
- Add new Shopify customers to Mailchimp
- Create Trello cards from new Shopify orders
- Create Shopify orders from new Typeform entries
- Create Trainerize clients for new paid Shopify orders
- Send funnel events to Facebook Conversions from Shopify
- Grant access to Kajabi offers when new Shopify orders are created
- Create Airtable records for new paid orders in Shopify
- Log emails in Facebook Custom Audiences with new paid orders in Shopify
- Send Slack channel messages for new updated orders in Shopify
- Add new Shopify customers to Keap as new contacts
- Update inventory quantities in Shopify when new or updated spreadsheet rows occur in Google Sheets
- Add Klaviyo subscribers with new Shopify customers
- Add new Shopify abandoned carts as Flodesk subscribers
- Add new paid Shopify orders to Microsoft Excel rows
- Add people to Google Ads Customer Lists for newly-paid Shopify orders
- Send Thanks.io postcards for new paid Shopify orders
- Create QuickBooks Online invoices for new Shopify orders
- Add New Shopify Customers to Flodesk Subscribers
- Update Google Ads contacts list with updated customers from Shopify
- Add new Shopify customers to Laposta
- Add new Shopify orders to Notion as database items
- Subscribe new Shopify customers to a list in Robly
- Add new Shopify customers to Zendesk as users
- Create or update HubSpot contacts from new paid orders on Shopify
- Generate sales receipts in QuickBooks Online for new orders in Shopify
- Send Gmail emails with new abandoned carts in Shopify
- Create new Teachable users from new paid Shopify orders
- Send messages through WhatsApp Notifications for new paid Shopify orders
- Create or update Ontraport contacts for new paid Shopify orders
- Create purchase events in Facebook Conversions from new paid orders in Shopify
- Add new Shopify customers to Google Ads Custom Lists
- Add transactions in Wave for new Shopify sales
- Add newly-abandoned carts in Shopify to Google Sheets rows
- Add new Shopify customers to ActiveCampaign
- Enroll users in Teachable courses with new paid Shopify orders
- Add new Shopify customers as EmailOctopus subscribers
- Record Google Ads offline conversions for newly-paid orders in Shopify
- Add contacts to a Google Ads customer list for new abandoned carts on Shopify
- Create new beehiiv subscribers from new Shopify customers
- Add people to Google Ads Custom Lists for newly-paid Shopify orders
- Send Slack channel messages for new abandoned carts in Shopify
- Create Trustpilot invitations from new Shopify orders
- Enroll users into LearnDash courses with new paid orders in Shopify
- Add new Shopify customers to Google Ads customer lists
- Create Trello cards for new paid orders in Shopify
- Welcome new Shopify customers with personalized emails from Gmail
- Add new paid Shopify orders to Spektrix customer records
- Create people and sales invoices in Bexio from new paid orders in Shopify
- Add new Shopify customers to a SimpleTexting list
- Create ActiveCampaign contacts from new paid orders in Shopify
- Add new Shopify customers to HubSpot as contacts
- Create Shopify orders for new Stripe subscriptions
- Update Shopify customers when new Stripe checkout sessions are completed
- Send EditionGuard eBook download links via email when new eBooks are purchased in Shopify
- Create Google Sheet rows for new abandoned carts in Shopify
- Send messages in WhatsApp Notifications for new customers in Shopify
- Add new Shopify orders as subscribers in beehiiv
- Add Contact to Customer List With Email in Google Ads for New Abandoned Cart in Shopify
- Create Google Sheets rows for new customers in Shopify
- Add/update Mailchimp subscribers for new paid orders in Shopify
- Create tasks in Asana for new orders from Shopify
- Add new Shopify customers to a Google Ads customer list automatically
- Create new Shopify orders from new Jotform submissions
- Share new paid orders from Shopify to Slack
- Send new paid orders in Shopify to Facebook conversions as purchase events
- Create Shopify customers from new Jotform submissions
- Create new Shopify customers from new Facebook Lead Ads leads
- Create Xero invoices for new Shopify paid orders
- Post on Facebook about new blog entries on Shopify
- Add new paid orders in Shopify to Track-POD
- Send Gmail emails for new paid Shopify orders
- Trigger offline conversions in Google Ads for new paid orders in Shopify
- Create Salesforce contacts from new Shopify customers
- Add Shopify customers from new POWr Form Builder form submissions
- Subscribe new Shopify customers to a list in iContact
- Enroll Shopify users with new paid orders in LearnWorlds products
- Send digests of new Shopify orders via Gmail
- Create Aweber subscribers from new paid orders in Shopify
- Add contacts to a Google Ads customer list for updated customers on Shopify
- Create Shopify customers from new leads in TikTok Lead Generation
- Create Kajabi form submissions for new Shopify customers
- Create consent agreements in iubenda for new Shopify customers
- Generate tickets in Zendesk from newly-paid orders in Shopify
- Add new Shopify customers to a Moosend mailing list
- Add new Shopify customers to Mailjet
- Send emails for new paid Shopify orders
- Track updated Shopify inventory in Google Sheets
- Create new Shopify customers from new Leadpages form submissions
- Add new Shopify customers as active Trainerize clients
- Create income tickets in Quipu from new orders paid in Shopify
- Create events in Klaviyo for new paid orders in Shopify
- Subscribe users to sequence in Manychat when new abandoned carts are detected in Shopify
- Add new Shopify customers to Mailchimp
- Create tasks in Bonjoro with new Shopify customers
- Create contacts in OnePageCRM for new customers in Shopify
- Update Shopify inventory after purchase in Chatfuel