It’s possible to create a dynamic gallery from any Google Sheet you have created. This feature creates a ton of options that enable you to have the full power of Google Sheets available.

Connect your Google Sheets account

The first step is to connect your Google Sheets account if you haven’t already.  

Creating the Dynamic Gallery

In order to do so go to your flow builder and use the action Google sheets -> Generate Dynamic Gallery from any Google Sheet.

From here you connect your spreadsheet and the worksheet you want to use. You will then see a gallery card appear. From it you can customize your own gallery card.

As you can see it is a really visual way of creating your gallery card.

To populate the image URL, title, and subtitle, use the columns available in your Google Sheet. By pressing the curly bracket { or variable icon, you can easily see your columns by name, simplifying the selection process.

Click the Add button

You can select the correct columns very easily. Do make sure that when selecting the column for the image you have inserted a correct URL inside that column. Otherwise, you might get an error when trying to view the gallery card. You will also have access to all other variables if you want more customization or personalization.

Once you’ve selected your desired columns you can also add a button if you wish. When pressing the button you will have a few options to choose from just like when you create a normal button.

Those options are:

• Call number

• Start Step

• Start External 

• Start External Step

• Open Website

When you choose an option then you will also be able to perform additional actions. There are no restrictions to the amount of actions you can set up. But there is one limitation and that is set by Facebook, unfortunately. But we will get into that more later.

How to Provide Dynamic Information Based on Chosen Option

So far we have learned how to set up a dynamic gallery card. Now it is time to work on how to provide the following information and use additional actions to truly understand how easy but incredibly powerful this new integration is.

Let’s take a look at a sample sheet

We have two items here that display a Plain Frappuccino and Caramel Frappuccino. Depending on the choice the subscriber takes we want to show the detailed description matching that choice.

To set this up we need to press the more info button we set up on the gallery card in the Google sheet action. When pressed we can choose an additional action that is called the Set Custom field.

From here a pop-up window will appear and we will be able to set the custom field of our choice with a value. 

We will choose Column C (inserted as {{C}} as that provides the details we would like to display. 

Once done press the button save to complete the action. Then press save once again to exit the Gallery card set up.

So let’s see how this looks like in the backend so far.

It looks really basic right?

See how easy it is to show information that is stored in any column inside your Google Sheet? Just use the action set custom field and set the value to the column that will contain the information.

If you want to show multiple columns you can do so by just adding them after the first one.

So this would look like: {{A}}{{B}}

Additional actions examples

To show you how easy it is to use this new integration we are going to provide an example of the additional actions you could use to make it a really powerful combination.

Segmenting your audience

It is very easy to segment your audience based on their last view product or item in the dynamic gallery. 

To enable this we will insert another additional action set custom field. Now we will set a custom field called last_viewed_product to the value of the Product Name in the Google Sheet. 

Being the first column we only need to use the value {{A}}

Note that it is not advisable to use tags when segmenting subscribers. This is because these tags cannot be set up Dynamically like the action Set Custom Field can.

But this is possible in the next step. After the button press you could add a condition that checks a user's choice by using the last custom field action we set up.

That will be similar to this;

But as you know you can segment by custom fields as well as tags so the above set up may not apply to you. Segmenting your audience is important though since you can send personalized follow-ups that increase conversions and engagement.

Facebook limitation with additional actions

Facebook has a 1000 characters per custom field limitation. This is only a limitation if you store large data to a custom field. So you must factor that when setting a custom field with values inside your Google Sheet.