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 Chatbots 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" node and connect your Google account; select the Google Sheet, and select the specific tab you wish for the data to update on
  2. Once the flow is created Go back and select the “Keyword Action” option from the left menu 
  3. 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. 

Make sure to add the same variables here as the ones you created in your button

How did we do?

Orders page to display Catalog orders

How to use Sync button for Catalog feature

Contact