KGQuant Google Sheets Add-on

Use KGQuant from inside Google Sheets to build, run, and review discrete-event simulations from spreadsheet data.

Getting started

  1. Open a Google Sheet.
  2. Go to Extensions, choose KGQuant Simulator, then open the KGQuant Simulator sidebar.
  3. Sign in with your KGQuant account. If OAuth sign-in is unavailable for your deployment, use the API key option.
  4. Select a process project from the picker. The add-on restores the active project when you reopen the sidebar.
  5. Describe the process you want to model or analyze in the chat box.
  6. Optionally choose Use selected range to send the selected cells as model data.
  7. Click Run simulation when the process project is ready.

Results written to Google Sheets

When a run completes, the add-on creates or refreshes KGQuant result sheets in the spreadsheet.

  • KGQ - Dashboard: headline KPIs, bottlenecks, recommendations, and a link to the web dashboard.
  • KGQ - Process Detail: detailed KPI tables by process object type.
  • KGQ - Time Series: queue, utilization, and work-in-process series with embedded charts.
  • KGQ - Process Map: a process-map image with a legend and overlay key.

Rerunning a simulation refreshes these KGQuant sheets instead of creating duplicate copies.

Data and permissions

The add-on uses Google Apps Script to communicate with KGQuant and to read or write the current spreadsheet. It only reads selected spreadsheet data when you choose to send that range or upload data for a KGQuant project.

API keys and OAuth tokens are stored in user-scoped Apps Script properties for your Google account. They are not written into cells, document properties, logs, or the sidebar HTML.

Troubleshooting

  • Sign-in is unavailable: use the API key option or contact your KGQuant administrator to configure the Apps Script web-app redirect.
  • Project list is empty: create a process project in KGQuant or start a new conversation in the add-on.
  • Run button is disabled: select a process project and make sure the add-on has opened it successfully.
  • Results are missing: keep the spreadsheet open until the add-on finishes building the results sheets.
  • Rate limit or service unavailable: wait a few minutes and retry the request.

Support

For help, contact kunle.giwa@kgquant.com or visit KGQuant Support.