Google sheets integration, filter data by many conditions and unify datetime formats
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.
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.
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.
Shopify integration, writing to PostgreSQL and update to the aggregate transform
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.
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.
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.
Quickbase integration, data visualizations and better error reporting
The Quickbase integration is now up and running! You can pull your data from various tables, then filter it to create custom tables.
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.
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.