Integrate Google Sheets via Metrics

Eliminate the need to go back and forth between Cascade and one hundred spreadsheets. Keep your data consolidated in a single location to enhance efficiency by providing a centralized view and improving data management with real-time updates.


Establishing the connection between Google Sheets and Cascade

To bring in data from Google Sheets, you will need to import these values through Metrics. Refer to Import your Metrics from Google Sheets article for detailed information on this import function.

Once the data is imported into the Metrics Library, data changes are displayed in real time as your spreadsheet is updated. To learn more on Metrics, refer to the What are Metrics article. 

As Metrics consolidate the data into a single plane - they are not time-bound nor have a target. To gather trends on how they may impact your goals, simply connect the metric to any measure in your plan. Refer to Connect your Metrics to Measures article to set this up.

Important to note: Only numerical data will be supported for the integration