Google Sheets and Shopify

Google Sheets

Triggers

• New row in a Google SheetRuns when a new row is added to a Google Sheets spreadsheet, with the row's cells by their column headings and the spreadsheet and tab it was added to, for a step that writes back to the row, such as Update cells in row.
• Row updated in a Google SheetRuns when someone changes a row of a Google Sheets spreadsheet, or only when one column of it changes, such as Status, with the row's cells by their column headings. Sorting or moving rows doesn't start it. It can also run for new rows. Rows already there when the workflow is turned on don't start it until they change; it watches the first 10,000 rows.

Actions

• Add rowAdd a row to the end of a tab.
• Create spreadsheetCreate a new spreadsheet.
• Delete spreadsheetMove a spreadsheet to the Google Drive trash. It can be restored from the trash for 30 days, after which Google deletes it for good.
• Overwrite rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update cells in row.
• Update cells in rowSet some cells of one row by column name, leaving the rest of the row as it is. Pair it with Read rows to write a result back to the row it came from (row.row_number). A column that doesn't exist yet is added to the header row.
• Clear rowEmpty a row's cells without deleting the row.

Shopify

Triggers

• New orderRuns when an order is placed in your store, paid or not. Use Order paid to run only once the money is in.
• Order paidRuns when an order in your store is fully paid, at checkout for most orders or later for one paid by invoice.
• Order shippedRuns when everything on an order in your store has shipped. An order shipped in parts runs it once, when the last part goes.
• New customerRuns when a customer is added to your store, whether they sign up, check out for the first time or are added by your team.
• New productRuns when a product is added to your store, whether it's published straight away or saved as a draft, with its title, price and stock.
• Order updatedRuns each time an order in your store changes, from being placed to being paid, edited, tagged, shipped, refunded or cancelled.

Actions

• List productsFind products in your store by words, status, type, vendor, tag or when they were added. With no filters, it lists the whole catalogue, most recently changed first.
• Get a productGet everything about one product: its description, status and price range, each of its variants with their stock, and the collections it is in.
• Create a productAdd a product to your store. It starts as a draft that shoppers can't see, unless you choose another status.
• Update a productChange a product's title, description, type, vendor, tags, web address or status. Only the fields you fill in change, and setting the status to Active puts a draft on sale.
• Delete a productDelete a product with its variants and images, for good. For a product that has been ordered, set its status to Archived with Update a product instead, so past orders still show it.
• List product variantsList the variants of one product, or search them across the store. A variant is one version of a product, such as a size or colour, with its own price, SKU and stock.