"Send file to Google Cloud Storage" node
The integration between Synerise and Google Cloud Storage opens up possibilities of exporting data collected in Synerise. By means of the Send file node, you can push data from Synerise to add it to a storage in your Google Cloud. You can use this connection in various scenarios such as exporting transactions, event data, customer information (such as marketing agreements), results of metrics, aggregates, expressions, reports, and many more to Google Cloud Storage.
- You must have a Google Cloud account.
- Familiarize with pricing connected with sending data to your storage in Google Cloud.
- Create a project in Google Cloud.
- Create a Cloud Storage bucket.
- Click Google Cloud Storage > Send file.
- Click Select connection.
- From the dropdown list, select the connection.
Create a connection
To allow the data exchange, establish a connection between Synerise and Google Cloud Storage.
- At the bottom of the Select connection dropdown list, click Add connection.
- On the pop-up, click Sign in with Google.
- Select a Google account which has write access to the dataset that contains your destination table.
Learn about required permissions.
- Follow the instructions on the interface.
- After authentication, click Next.
- In the Connection name field, enter the name of the connection.
It’s used to find the connection on the list.
- Click Apply.
Result: A connection is created and selected.
Define the integration settings
In this step, fill in the form that allows you to send a file with data from Synerise to a storage.
- In the Project ID field, enter the unique identifier of your project in Google Cloud.
You can learn how to find the project ID here.
- In the Bucket field, enter the name of the existing bucket (container) to which you will send a file with data.
- In the Path to directory field, enter the path to the existing bucket in which the file will be saved.
- In the File name field, enter the name of the file you want to send to the storage. If the file already exists, in such case, the contents of the file will be overwritten.
In this field, you can use Jinjava.
- From the File format dropdown list, select the format in which the file will be saved in the storage.
If you select the CSV [*.csv] option, follow the instructions below:
- From the Delimiter dropdown, select the character that marks the end of a column.
- From the Quotation mark dropdown list, select the characters that contain the text.
- From the Escape character dropdown lists, select the character changes the default interpretation of a character or a string followed by the character.
- From the Line ending dropdown list, select:
- Line feed - This option shifts the cursor to the next line vertically.
- Carriage return and line feed - This option points the cursor to the beginning of the line horizontally and shifts the cursor to the next line vertically.
- The No Byte Order Mark option is currently unused.
- To wrap the values with characters selected in the Quotation mark field when the delimiter occurs in the value, select the Quoting style only if required option. For example, for the following values:
The output with the enabled Quoting style only if required option will be as follows:
- Confirm by clicking Apply.
Example of use
As an example of use, you can create a workflow that is triggered one time in order to export the customer database (email addresses and newsletter agreement) to the storage.
As a prerequisite in this example, create a segmentation of customers who have email addresses and enabled newsletter agreement. This segmentation will be used in the Get Profiles node that will be a part of the workflow.
In the configuration of the workflow:
- Start the workflow with the Scheduled Run node. In the configuration of the node, set the Run trigger to one time. Select the Immediately tab.
- To retrieve customers data to the workflow, as the next node, select Synerise > Get Profiles. In the configuration of the node:
- Select a segmentation from which you want to extract customers’ data.
- Select the customer attributes to be exported. In this example, it’s an email address and email marketing agreement.
- To send the file with customers data, add Google Cloud Storage > Send file. Fill in the configuration form in the node.
- Add the End node.