Shopify and Google Sheets automations
Set up an automation: when product updated in Shopify, update spreadsheet row in Google Sheets
Build it50agents builds it as an automation, and asks before anything goes outside.
Shopify and Google Sheets in practice
Used for
Every Shopify order adds a row to Google Sheets for a running, shareable list.
Best template
“New Order” in Shopify, then “Add New Row to Sheet” in Google Sheets. Every sale becomes one row at once, and a sheet takes your own columns.
Watch out
Sending “New Customer” and “New Order” into one sheet mixes orders with customers, so use separate sheets.
Shopify and Google Sheets templates
Pick one and Captain builds it with you.


When product updated in Shopify, update spreadsheet row in Google Sheets
Build this

When new customer in Shopify, update spreadsheet row in Google Sheets
Build this

When new order in Shopify, add new row to sheet in Google Sheets
Build this

When new customer in Shopify, add new row to sheet in Google Sheets
Build this
Shopify and Google Sheets triggers and actions
Every one of both apps. A trigger starts the work; actions are the steps.
Triggers
23- New customerTriggers when a new customer is created to Shopify account
- New orderTriggers when a new order is created.
- New productTriggers when a new product is created to Shopify account.
- Order deletedTriggers when a order is deleted in Shopify account.
- Order cancelledTriggers when a order is cancelled in Shopify account.
- Order paidTriggers when a order is paid in Shopify account.
- Customer updatedTriggers when a customer is updated in Shopify account.
- Product updatedTriggers when a product is updated in Shopify account.
- New collectionTriggers when a new collection is created in Shopify account.
- Collection updatedTriggers when a collection is updated in Shopify account.
- New segmentTriggers when a new segment is created in Shopify account.
- Segment updatedTriggers when a segment is updated in Shopify account.
- New companyTriggers when a new company is created in Shopify account.
- Company updatedTriggers when a company is updated in Shopify account.
- New locationTriggers when a new location is created in Shopify account.
- Location updatedTriggers when a location is updated in Shopify account.
- Location deactivatedTriggers when a location is diactivated in Shopify account.
- Watch productTriggers when a product is created or updated.
- Abandoned checkoutTriggers when a customer adds items to checkout, enters their email/phone, and abandons without completing the purchase.
- Order line items are editedRuns when items on an order are edited.
- New blog articleRuns when new blog article is published.
- When an order is marked as deliveredRuns the workflow automatically whenever an order is marked as delivered.
- New form submissionRuns when a Shopify Forms submission is forwarded through Shopify Flow.
No triggers match.
Actions
24- Create customerCreates a new Shopify customer with contact info, optional addresses, tax settings, tags, and marketing consents.
- Find customersFinds customers by name, email, phone, or other filters and returns matching customer details.
- Create orderCreate a Shopify order with variant line items, optional title/price overrides, discount codes, shipping/billing addresses, and fulfillment status.
- Create productCreates a new product in your store.
- Update customerUpdate a customer's profile, contact details, addresses, tags, and tax settings.
- Update orderUpdate an order's email, note, tags, custom note attributes, and shipping address using an Order ID or Order Name.
- Create fulfillmentCreate a fulfillment for selected items on an order.
- Find ordersFind orders by name, email, phone, ID, or filters and return matching order details.
- Find productsFind products in your Shopify store using titles, tags, vendors, price, or date filters.
- Get order statusGet the latest status of a specific order.
- Create draft orderCreate a draft order for a customer with specified product variants and quantities, plus optional discounts, shipping, tags, and addresses.
- Add discount code to draft orderAdds a discount code to a draft order.
- Remove discount codeRemove an existing discount code.
- Get all discount coupon codesGet an all existing discount coupon code.
- Add tag to an orderAdds one or more tags to an order.
- Cancel orderCancel an order, refund via the original payment or store credit, and optionally restock items and notify the customer.
- Update productUpdate an existing product's details, tags, collections, status, SEO, and media.
- Adjust inventory quantitySet or adjust the inventory count for a product variant at a specific Shopify location, including a reason and optional comparison quantity for auditing.
- Create blog articleCreate a new article in a selected blog.
- Delete productDelete a product from your store.
- List markets and currenciesLists markets with their currency settings, locales, and regions.
- Create navigation menuCreate a navigation menu with a title, handle, and items linking to products, collections, pages, or custom URLs.
- Find blogsFind blogs in your Shopify store using filters such as ID, handle, title, or other search criteria.
- Find draft ordersSearch and retrieve draft orders from your Shopify store based on the specified criteria.
No actions match.
Triggers
1- Row added or updatedRuns when row added or updated
No triggers match.
Actions
23- Update spreadsheet rowUpdate columns in sheet row
- List rows in sheetGet rows from a sheet tab as objects with row numbers. Supports an optional header row, offset/limit paging, and fetching from the last row.
- Delete rowsDelete one or more rows from a specific sheet in a Google Spreadsheet using a row range or row numbers.
- Add new row to sheetRuns as a step in Google Sheets.
- Lookup spreadsheet rowsFind rows in a Google Sheet that match a column value or an advanced filter.
- Copy sheet to spreadsheetCopy a sheet to another file
- Add multiple rowsAdd one or more rows to a specific sheet in a Google Spreadsheet. Provide data column-by-column or paste a JSON array for bulk inserts. If the sheet has no headers, they will be auto-created from your JSON keys.
- Create subsheetAdd a new subsheet to a spreadsheet and optionally set its position and add column headers in the first row.
- Create sheet columnInsert a new column into the specified Google Sheets sheet at the given index (or append to the end) and optionally set its header.
- Get rows from rangeRetrieve rows from sheet range
- Create a spreadsheetCreate a new spreadsheet.
- Find subsheetSearches a sheet in a spreadsheet by name and returns the sheet name, column titles, and number of rows.
- Get row detailsRetrieve values and metadata for a specific row in a spreadsheet sheet.
- Clear spreadsheet rowClears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
- Create spreadsheet from templateCreate sheet from template
- List spreadsheetsFetch all spreadsheets
- List spreadsheet tabsLists all tabs (sheets) in a spreadsheet and returns the total count.
- Batch update cell valuesUpdate multiple cells at once
- Format spreadsheet rowFormat row font and background
- Add conditional formatting ruleApply conditional formatting to cells in a Google Sheets spreadsheet based on their values
- Update sheet nameRenames an existing sheet (tab) within a Google Spreadsheet to a new name you specify.
- Update multiple rowsUpdate values in one or more rows of a Google Sheet.
- Permanently delete spreadsheetPermanently delete a spreadsheet from Google Drive, including files on shared drives.
No actions match.
Questions about Shopify and Google Sheets
What can start a Shopify and Google Sheets automation?
“Product updated”, “New customer” and “New order”.
Which other apps work with both Shopify and Google Sheets?
Slack, Notion, Stripe, Microsoft Outlook and WooCommerce. Each one has templates with Shopify and with Google Sheets, so a third app can join the same job.
All Shopify integrations · All Google Sheets integrations · Every app, A to Z
Connect Shopify and Google Sheets
Or pick another template above. Free to start.
Build it with Captain