Connect Google Sheets and Shopify

Use Google Sheets and Shopify in the same FlowMattic workflow. Below are the triggers and actions both integrations offer; pick one of each to see how the two connect.

Try FlowMattic free See triggers and actions

85 triggers 44 actions 1 ready-made template Unlimited runs

Try a pairing

When this happens in Google Sheets6 triggers

Do this in Shopify25 actions

1. TriggerNew Spreadsheet Row

2. ActionCreate Customer

When Google Sheets fires New Spreadsheet Row, FlowMattic runs Create Customer in Shopify with the data from that event.

You build this in the FlowMattic workflow builder on your own site.

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Shopify

Integration page

Triggers (79)

Cart CreationTriggers when a new cart is created.
Cart UpdateTriggers when a cart is updated.
Checkout CreationTriggers when a new checkout is created.
Checkout DeletionTriggers when a checkout is deleted.
Checkout UpdateTriggers when a checkout is updated.
Collection CreationTriggers when a new collection is created.
Collection DeletionTriggers when a collection is deleted.
Collection UpdateTriggers when a collection is updated.
Customer SMS Marketing Consent UpdateTriggers when a customer SMS marketing consent is updated.
Customer Account Settings UpdateTriggers when customer account settings are updated.
Customer CreationTriggers when a new customer is created.
Customer DeletionTriggers when a customer is deleted.
Customer DisableTriggers when a customer is disabled.
Customer Email Marketing Consent UpdateTriggers when a customer email marketing consent is updated.
Customer EnableTriggers when a customer is enabled.
Customer Group CreationTriggers when a new customer group is created.
Customer Group DeletionTriggers when a customer group is deleted.
Customer Group UpdateTriggers when a customer group is updated.
Customer Purchasing SummaryTriggers when a customer purchasing summary is generated.
Customer Tags AddedTriggers when tags are added to a customer.
Customer Tags RemovedTriggers when tags are removed from a customer.
Customer UpdateTriggers when a customer is updated.
Discount CreationTriggers when a new discount is created.
Discount DeletionTriggers when a discount is deleted.
Discount UpdateTriggers when a discount is updated.
Draft Order CreationTriggers when a new draft order is created.
Draft Order DeletionTriggers when a draft order is deleted.
Draft Order UpdateTriggers when a draft order is updated.
Fulfillment CreationTriggers when a new fulfillment is created.
Fulfillment Hold AddedTriggers when a fulfillment hold is added to a fulfillment order.
Fulfillment Hold ReleasedTriggers when a fulfillment hold is released from a fulfillment order.
Fulfillment Service Failed to CompleteTriggers when a fulfillment order cannot be completed by fulfillment service.
Line Items Prepared for PickupTriggers when fulfillment order line items are prepared for pickup.
Fulfillment Order MovedTriggers when a fulfillment order is moved.
Fulfillment Order RescheduledTriggers when a fulfillment order is rescheduled.
Scheduled Fulfillment Order ReadyTriggers when a fulfillment order that was scheduled becomes due.
Fulfillment Order Placed on HoldTriggers when a fulfillment order transitions to the "On hold" status.
Fulfillment Order Hold ReleasedTriggers when a fulfillment order is released and is no longer on hold.
Order Routing CompleteTriggers when fulfillment order's order routing is complete.
Fulfillment Orders CancelledTriggers when fulfillment orders are cancelled.
Cancellation Request AcceptedTriggers when fulfillment orders cancellation request is accepted.
Cancellation Request RejectedTriggers when fulfillment orders cancellation request is rejected.
Cancellation Request SubmittedTriggers when fulfillment orders cancellation request is submitted.
Fulfillment Request AcceptedTriggers when fulfillment orders fulfillment request is accepted.
Fulfillment Request RejectedTriggers when fulfillment orders fulfillment request is rejected.
Fulfillment Request SubmittedTriggers when fulfillment orders fulfillment request is submitted.
Line Items Prepared for Local DeliveryTriggers when fulfillment orders line items are prepared for local delivery.
Fulfillment Orders MergedTriggers when fulfillment orders are merged.
Fulfillment Orders SplitTriggers when fulfillment orders are split.
Fulfillment UpdateTriggers when a fulfillment is updated.
Inventory Item CreationTriggers when a new inventory item is created.
Inventory Item DeletionTriggers when an inventory item is deleted.
Inventory Item UpdateTriggers when an inventory item is updated.
Inventory Level ConnectTriggers when an inventory level is connected.
Inventory Level DisconnectTriggers when an inventory level is disconnected.
Inventory Level UpdateTriggers when an inventory level is updated.
Location ActivationTriggers when a location is activated.
Location CreationTriggers when a new location is created.
Location DeactivationTriggers when a location is deactivated.
Location DeletionTriggers when a location is deleted.
Location UpdateTriggers when a location is updated.
Market CreationTriggers when a new market is created.
Market DeletionTriggers when a market is deleted.
Market UpdateTriggers when a market is updated.
Order CancellationTriggers when an order is cancelled.
Order CreationTriggers when a new order is created.
Order DeletionTriggers when an order is deleted.
Order EditTriggers when an order is edited.
Order FulfillmentTriggers when an order is fulfilled.
Order PaymentTriggers when an order is paid.
Order Risk Assessment ChangedTriggers when an order risk assessment is changed.
Order UpdateTriggers when an order is updated.
Product CreationTriggers when a new product is created.
Product DeletionTriggers when a product is deleted.
Product UpdateTriggers when a product is updated.
Refund CreateTriggers when a new refund is created.
Shop UpdateTriggers when the shop is updated.
Tender Transaction CreationTriggers when a new tender transaction is created.
Transaction CreationTriggers when a new transaction is created.