The latest updates from the Intersect Labs team. New features, fixes, upgrades, and more.

March 19, 2021

Google sheets integration, filter data by many conditions and unify datetime formats

New

Pull and Write data to Google Sheets

Most of your data is stored in Google Sheets, and you need an easier way to extract and analyze it? We have the solution for you: Google Sheet integration on Intersect!

You can now pull your data from your Google Sheets, and build custom notebooks. You can format your data, create beautiful charts, share it with the rest of the team and more. You can also use this integration to filter and organize your data, so you can send the new tables back to your spreadsheet.


New

Filter data based on multiple conditions

What if you have information about your customer that needs to be filtered not only by state, but also by zip code, browser, or a particular device type? We got you!

With the newest updates on Intersect, you can filter all your tables based on a variety of conditions using only one block. This block supports multiple filters that can be easily applied to the columns of your choice.

New

Unify date/time formats

Sometimes your tables will have date columns that contain a lot of different date and time formats. With the “Unify date/time format” option, you can select from nine format types to unify all your date columns, so that you can perform better analysis.

March 12, 2021

Shopify integration, writing to PostgreSQL and update to the aggregate transform

New

New Shopify integration

With the new Shopify integration, you can pull valuable data from your Shopify store and use it to create custom data apps. Manage inventory, track orders, or build custom sales reports - these are some data apps that you can start implementing today.


New

Writing to PostgreSQL

Two weeks ago, we announced the PostgreSQL integration, which allowed you to connect your Postgres database and pull data directly into your data apps. With Intersect's newest updates, you can now write back to your Postgres tables using a very easy-to-use custom data mapping option.


Improvement

Updated aggregate transform: Find first and last record

The aggregate transform has two new options "Find first and last record". Using these options, you can retrieve the first or the last record in a given column for a group.


March 5, 2021

Quickbase integration, data visualizations and better error reporting

New

Quickbase integration

The Quickbase integration is now up and running! You can pull your data from various tables, then filter it to create custom tables. 


New

New data visualization block

Want to create beautiful charts with your data? Done. We're excited to announce the new data visualization block! Now, you can easily visualize data using scatter plot, line graph, vertical bar chart, horizontal bar chart and pie chart.


Improvement

Better error reporting

With the latest update on Intersect, we deployed better error reporting, covering 86% of errors that might occur while building your data apps. From now on, if a step fails, you’ll see the exact error that caused the issue.