Hi All,

I’m working in Google Apps Script (similar to Java) and Google Sheets building live reporting sheets that source the data from several other sheets and automatically calculate metrics live whenever the source data are updated. I was wondering if Numerics by Stata can be a built-in mathematical solution for Google Sheets, similar to what I currently have.

The process that takes place at the moment:
1) User opens a report sheet in Google Sheets
2) Report sheet automatically runs built-in Google Apps Script code on open
3) The code reads the data from several other sheets, computes metrics, and feeds them into the report sheet

I would like to have a better mathematical solution and replace parts of Google Apps Script code with Stata where it computes the metrics for the report. However, this will work only if there is a way for Google Apps Script to somehow invoke Stata procedures automatically without any user input.

What I would like to have is this:
1) User opens a report sheet in Google Sheets
2) Report sheet automatically runs built-in Google Apps Script code on open
3) The code reads the data from several other sheets and invokes Stata routines
4) Numerics by Stata computes metrics, and saves them as objects
5) Google Apps Script accesses the objects and feeds them into the reporting sheet

Is that possible?

Thank you!