How to collect customer order details from Catalog cart messages in a Google Sheet

Sophia Updated by Sophia

This article will show how to collect your orders from Catalog.

  1. Select “Automation” from top menu and then choose Flows from the left menu. Next click on “Add Flow” button and create a new flow by giving a name for the flow
  2. Choose the "Ask a Question" node and then click the "Buttons"

Fill in the Buttons with "Yes" and "No"

  1. Fill in the "Question" node with further options; for the example we'll create a "name" variable, remember to link the "yes" with these questions
  1. Select another "Question" node, for the example we'll create an "address" variable, remember to link the "yes" with this question
  1. Select another "Question" node, for the example we'll create a "number" variable, remember to link the "yes" with this question

  1. Select a "Button" node, for the example we'll create a "payment method" variable, remember to link the "yes" with this node

  1. Select "Google Sheets" and connect your Google account; select the Google Sheet, and select the specific tab you wish for the data to update on

Make sure to add the same variables here as the ones you created in your button
  1. Link all your payment methods to the Google Sheet node

  1. Add a message if users don't wish to proceed with the order too

  1. Once the flow is created Go back and select the “Keyword Action” option from the left menu 
  2. Next click the button “Add keyword action” and then click the button “Add keyword” and enter this particular keyword “ #trigger_view_cart ” and then click the next button and select the flow you just created as the reply action and click save.

Now when any customer sends you the Catalog cart message with the products added in the cart, the flow you created will get triggered and collect all order details in the Google spreadsheet. 

How did we do?

How to use Sync button for Catalog feature

Contact