This guide will show you how to import data from Google Spreadsheet as Hull User Events in order to create or update events on a User Timeline.
Make sure your Google Sheets Imported is installed and authorized by following the connector documentation.
In order to perform an import go to a spreadsheet which contains data you are interested in. Then open the add-on sidebar by going to top menu Add-ons > Hull Importer > Open Importer.
Right after opening, import button is inactive signaling that not all required settings are provided. Now let's go through them.
First we need to select the import type, since this sheet contains Events data and we want to capture columns information as User Events we select "User Events".
Next we need to tell how to identify users who should receive those events. If those users exist in Hull events will be added to their profiles, otherwise new users will be created at the same time.
Hull supports three different identifiers, so this section allows to define 3 columns where email, external_id and anonymous_id is stored. At least one identifier mapping must be done and every row in the sheet need to have at least one value present in order to be imported. Non-identifiable entities are not allowed in Hull.
In our case we have emails and product IDs coming from product database. We will map email to email and user_product_id to external_id which is meant for unique, leading identifier used across your all services.
We are almost there. In case of events we need to specify now 3 specific parameters:
The last section allows to map columns to events properties. By default we populate the name of attribute by transforming column name into lower underscore case. Name can be freely adjusted here, but we recommend using lower underscore case.
Let's map the rest of columns here:
Once all the required settings are present and valid the import button becomes active. Before hitting the button you need to select all rows you would like to import. Don't select the first row which contain column names though.
What is important it does not matter which columns are selected exactly. Once something on a row is selected the whole row will be taken into consideration during import.
Here is our selection, the button shows which rows will be imported
Now we can hit import and see progress and results bellow.
After every row is processed then the text below will be changed into done, showing number of rows imported.
You may notice that depending on your data number of imported rows is smaller than number of selected rows. This may be coming from the fact that some of the rows don't have any identifier present.
That's it, now you can use the same way to update or create users and attributes. In case of problems or questions feel free to reach out to us at email@example.com