Key Benefits of Analyzing Google Sheets Data in Toric
Access your dataflows from your browser in our cloud based software.
Cleanup and transform your data in a non-destructive way
Reuse your data transformations for new versions and projects with reusable dataflows.
Create interactive dashboards or "Data Apps" using your Google Sheets data.
Blend your Google Sheets data with other sources with a few clicks.
Export your transformed Google Sheets data to use with other programs.
How to Import Google Sheets to Toric
It's simple to connect or import your data from Google Sheets:
Use the Get Data button to select the Google Sheets option
Sign in with your Google email and password
Click the option to see all Google Drive files then click Continue
Add any XLSX or Google Sheet from the Sources tab in the dataflow workspaces
Build reports and dashboards using a variety of visualizations (ie. Pie Charts, Bar Charts, and much more). For example, put together a quick report showing the revenue trends of your company by wrapping up overall profit in a scorecard, show distribution of sales by product name, or track profit over time with an area chart. Add text to contextualize your data visualizations and better communicate your analysis to your team.
Drill through your data with interactive charts - click through pie slices and bars to see all values update to show the summary of data based on selection.
How to Export Data from Toric
Once data is transformed, you could use the Export node to create a new Excel or CSV file. If databases are your thing, you may export to Amazon S3, or your could 'Save As Source' in Toric.
Explore this simple template built with Google Sheets which shows the profit trends using scorecard, pie chart and bar chart. Feel free to download the template and make it your own.
Sign up for the beta
Save as source
Login to your Google account using Toric to access your spreadsheets directly and watch your reports and dashboards update instantly.