Synerise integration with Google Sheets

We are always moving forward and evolving, offering our users new integrations that improve their ability to manage and analyze data.?

Today we are pleased to announce our new integration with Google Sheets, an online spreadsheet tool that provides users with a flexible and collaborative data management platform.?

What opportunities does this integration create???

Our integration with Google Sheets opens up many new opportunities. Here are just a few of the benefits of this integration:??

• Quick and easy export of various types of data collected in Synerise directly to Google Sheets,??
• Seamless data sharing between Google Sheets and other Google tools, providing users with a comprehensive view of all data stored on other platforms, leading to more effective decision-making,??
• The ability to combine data from Synerise with information from other sources and platforms, providing a complete picture of all customer activities and interactions, leading to more comprehensive business insights.?

What data can be exported??

With this integration, you can export various data types, from metric scores, aggregates, expressions, and reports, to event data, customer information, and more.??

This integration provides you the flexibility and control to design the best data management processes for your business. ?

How to perform this export??

We have created a dedicated “Upload data to a spreadsheet” node to push data from Synerise?to add it in a row or a column form to a spreadsheet.?

During the node’s configuration, you can use Jinjava inserts, which let you dynamically refer to the profile attributes and event parameters in the workflow.

The process of creating an export is straightforward, allowing you to do everything you need in a simple way. To build a workflow, you must select a trigger and establish a connection between Synerise and Google Sheets. This involves selecting the appropriate Google account with access to the spreadsheet to which you want to send data (the account has to have editing permission). Then fill out a simple form in the "Upload data to a spreadsheet" node to send data from Synerise to a table in Google Sheets.?

For more detailed information about prerequisites and the complete configuration process of the "Upload data to a spreadsheet" node, please refer to our User Guide.??

Check out the latest use case??

We encourage you to take a look at our new use case, which explains an example scenario of this integration in action. This scenario describes the process of exporting transaction count information to Google Sheets, enriching this data with details of the date from which this information was collected.?

Go to Use Case

If you need to send data from Google Sheets to Synerise, we have another helpful use case that explains how to set up an automated workflow for sending the data.?

Go to Use Case

We hope this integration will open new horizons for your business operations, enabling you to leverage your data in the most efficient and effective manner!?

Klaudia Pociecha, Product Owner

Kateryna Tkachuk, Product Marketing Specialist