What's New

New 

MongoDB Source

New 

Grouparoo can now import data from MongoDB!

The @grouparoo/mongo plugin can be added to your project to import Profiles and Properties from your MongoDB application database. MongoDB is the first NoSQL database supported by Grouparoo, and all of the same Source features available for relational databases are available for MongoDB - including aggregation Properties, query Properties, and scheduled imports.

Learn how to install plugins by visiting the Grouparoo documentation.

Tutorial Docs

New 

New Doc Section: Tutorials

New 

Grouparoo has launched a new section in our documentation: Tutorials!

This new section will be focused on providing you with real-world, step-by-step examples that you can follow to become more familiar with Grouparoo.

We currently have a single tutorial on Declarative Sync, which walks through a basic e-commerce example that syncs data between a SQLite product database Source and Mailchimp as the Destination.

Tutorial Docs

New 

SQLite Plugin

New 

Grouparoo has a new plugin: SQLite!

SQLite is a lightweight database that holds its data in a single .sqlite file on disk. Up until now, Grouparoo has supported SQLite as its application database, but not as a Source or Destination for your customer data.

With this addition, you can now use SQLite as a Source — to import your customer data — or a Destination – to export your Grouparoo Profiles and Groups.

This new plugin will make it easier to get up and running with real-world examples, as we'll demonstrate in future tutorials and blog posts. Stay tuned!

SQLite Plugin

Improvement 

Faster Installs with Precompiled UI Packages

Improvement 

The Grouparoo UI packages, @grouparoo/ui-community and @grouparoo/ui-enterprise now install faster and require fewer dependencies on your machines!

Previously, we were shipping the raw Typescript/Javascript files for our React frontend to our customers, and every time you ran npm install, you were also building the webpack bundle. Now, we do this all for you on our build servers. This leads to larger download sizes, but a faster overall install experience as there is no "build" step. Under the hood, we rely on next.js to build and package our UIs.


Improvement 

Error Level: Info

Improvement 

There are many variations of things that could go "wrong" when working with the many destinations that Grouparoo supports. For example, there a recoverable errors like rate limiting. However, there is sometimes expected behavior that is still interesting to note. For these cases, we have added an info error level.

For example, the Salesforce destination has an "Enrich" mode. This means that it should only update users that are already in the system. In these cases, the plugin returns an info error. This is useful for observability in that it helps the user debug what happened.

Salesforce info error level

Improvement 

Facebook Custom Audiences Destination

Improvement 

Facebook custom audiences can now be a Grouparoo destination. This means that you can sync your customer information to Facebook in order to target ads or exclude them from campaigns.

A common use case is to automate teaching Facebook about your high-value users. This custom audience can be then used to create a lookalike audience for similar users.


Improvement 

Query Source Schedules

Improvement 

Grouparoo now allows users of a Query Source (Postgres, MySQL, Redshift, BigQuery, etc) to provide a custom query to determine which profiles to import. Just provide the query that returns the Profiles to be updated, and let Grouparoo know which Property the query refers to.

Naively, SELECT id FROM users would work, and all Profiles would be updated. However, you can often be smarter with your Schedule to keep things fast. For example, if your custom query to calculate LTV would only update when a purchase is made, you might SELECT DISTINCT(user_id) FROM purchases where MAX(created_at) > (NOW() - interval 2 day) GROUP BY user_id to only re-import Profiles which have had a recent purchase.


New 

Sendgrid Destination

New 

We have added Sendgrid as a destination. Sendgrid is a very popular transactional email tool in the developer community, and they're starting to build more CRM-esque features into their offering. Our integration allows you to easily connect your product database (Postgres, MySQL) or data warehouse (Snowflake) to Sendgrid with just a few clicks or lines of code.

Sendgrid List populated by Grouparoo

New 

Code Config Generators

New 

Last month we launched an exciting new feature, Declarative Sync. This feature revolves around the use of our CLI tool, specifically the generate command.

The generate command uses your input to write a configuration file to your file system. You can then use this file to configure the various objects in Grouparoo, like Apps, Sources, or Destinations.

These templates are then read and processed by Grouparoo when the server starts. This makes it trivial to import and export data from your various data sources and destinations by just writing a few lines of JSON.

You can work the way you are already working. You check your config files into Git. And you can even run tests to ensure your data is moving around as you'd expect.

See the docs for more information on how to configure your Grouparoo project using code config files. Or check out our video to see an overview on how it all fits together.


New 

Iterable Destination

New 

We have added Iterable as a destination. You can now create Iterable Users and Lists dynamically with Grouparoo. Iterable is one of the more popular marketing automation tools out there, so we're excited to be able to help our users connect with Iterable.

Iterable Audience generated by Grouparoo