Smart Planner Support

Smart Planner is an Optivise planning service provided by Shanghai Youluyi Technology Co., Ltd. It is available through Google Sheets and, where enabled, remote MCP connections for approved agent platforms. Use the links below to jump to each section.

Terms of Service

These Terms of Service (“Terms”) govern your use of Smart Planner, a Google Sheets add-on and hosted planning service provided by Shanghai Youluyi Technology Co., Ltd. (“we”, “us”, “our”). By installing or using Smart Planner, you agree to these Terms.

Description of Service

Smart Planner is an optimization assistant for Google Sheets and approved agent platforms. In Google Sheets mode it processes the active workbook you choose and writes results back to that workbook. In hosted MCP mode it receives the planning request and runs an asynchronous solver job on the hosted service.

Eligibility

You must have a valid Google account and comply with Google’s Terms of Service to use Smart Planner. If you install Smart Planner on behalf of an organization, you represent that you have authority to do so.

User Data Handling

Smart Planner processes:

  • the active Google Sheet you choose to work with
  • your chat instructions
  • optimization model configuration
  • solver results

Google Sheets workbook contents are processed only for the workbook action you authorize and are not retained as a general document store. Hosted MCP jobs use the retention and deletion rules described below.

We do store conversation history, including:

  • chat messages
  • instructions
  • model descriptions

This is stored solely to improve user experience, maintain continuity, and support troubleshooting.

We do not:

  • store spreadsheet contents
  • store solver inputs or outputs
  • train any models on your data
  • sell or share your data with third parties

We may store minimal operational metadata (e.g., request logs, error logs) for reliability and debugging.

Use of AI Code-Generation Services

Smart Planner may send portions of your conversation and model requirements to trusted AI code-generation services such as:

  • Cursor
  • OpenAI
  • Anthropic

This is done only to:

  • interpret your instructions
  • generate optimization code
  • assist with reasoning about your model

We do not send full spreadsheet contents unless necessary for model generation. These services act as sub-processors under our control.

Acceptable Use

You agree not to:

  • misuse Smart Planner to generate harmful or illegal content
  • attempt to reverse engineer our service
  • interfere with or disrupt our servers
  • use Smart Planner in ways that violate Google’s policies

We may suspend access if we detect abuse or security risks.

Service Availability

Smart Planner is provided “as is” and “as available.” We may update, modify, or discontinue features at any time. We do not guarantee uninterrupted service or error-free operation.

Limitation of Liability

To the maximum extent permitted by law, we are not liable for:

  • indirect, incidental, or consequential damages
  • loss of data
  • business interruption
  • errors in optimization results

Your use of Smart Planner is at your own risk.

Changes to Terms

We may update these Terms periodically. Continued use of Smart Planner constitutes acceptance of the updated Terms.

Contact

For questions or concerns, contact: support@optivise.cc

Hosted MCP retention and deletion

Hosted MCP uploads normally expire after 1 hour. Run records and result artifacts normally expire after 24 hours. OAuth authorization and browser session records expire on their own lifecycle. Security, billing, and audit records may be retained longer when required. To request deletion sooner, contact support@optivise.cc with the account and job identifiers; do not send passwords, private keys, OAuth tokens, or customer data.

Privacy Policy

This Privacy Policy explains how Shanghai Youluyi Technology Co., Ltd. (“we”, “us”, “our”) handles data when you use Smart Planner, a Google Sheets add-on or hosted MCP service.

Information We Access

Smart Planner only accesses:

  • the Google Sheet you actively open and choose to work with
  • your chat instructions
  • optimization model configuration
  • solver results

We do not access any other files in your Google Drive.

How We Use Your Data

We use your data to:

  • understand your spreadsheet structure
  • generate optimization models
  • run solver jobs
  • write results back into your sheet

Google Sheets workbook contents are processed for the workbook action you authorize and are not retained as a general document store. Hosted MCP jobs follow the separate retention lifecycle described below.

We do store conversation history, including:

  • chat messages
  • instructions
  • model descriptions

This is stored to:

  • maintain conversation continuity
  • improve user experience
  • support debugging and reliability

We do not:

  • store spreadsheet contents
  • store solver inputs or outputs
  • train any machine learning models on your data
  • sell or share your data with third parties

Google API Services User Data Policy and Limited Use

Smart Planner’s use and transfer to any other app of information received from Google APIs adheres to the Google API Services User Data Policy, including the Limited Use requirements.

Smart Planner uses Google Workspace data only to provide or improve user-facing planning and optimization features. Smart Planner does not use or transfer Google Workspace data for advertising, creditworthiness, lending, or to train or improve generalized AI or machine-learning models.

People may access Google Workspace data only when you give consent for support, when access is required to investigate abuse or a security issue, or when the law requires it. Smart Planner does not sell Google Workspace data.

Use of AI Code-Generation Services

Smart Planner may send portions of your conversation and model requirements to trusted AI code-generation services such as:

  • Cursor
  • OpenAI
  • Anthropic

This is done solely to:

  • interpret your instructions
  • generate optimization code
  • assist with reasoning about your model

These services act as sub-processors and do not use your data for training or resale.

Hosted MCP retention and deletion

For the hosted MCP service, uploaded request material normally expires after 1 hour, while run records and result artifacts normally expire after 24 hours. OAuth authorization and browser-session records use their own expiry and cleanup lifecycle. Security, billing, and audit records may be retained longer when required by law or for service protection. Contact support@optivise.cc to request deletion of account, job, artifact, or audit data.

Data Storage

Smart Planner does not persist:

  • spreadsheet data
  • solver inputs
  • solver outputs

We do persist:

  • conversation history
  • model descriptions
  • minimal operational metadata (e.g., request logs)

Data Security

All communication between Smart Planner, Google Sheets, and our backend is encrypted using HTTPS. OAuth tokens are never stored and are used only for the duration of a request.

Data Deletion

Users may request deletion of:

  • conversation history
  • model descriptions
  • operational metadata associated with their account

Deletion requests can be made via email.

Spreadsheet data does not require deletion because it is never stored.

Third-Party Services

Smart Planner uses:

  • Google Cloud (hosting)
  • Cursor, OpenAI, Anthropic (AI code generation)

All services operate under strict security and privacy controls.

Changes to Privacy Policy

We may update this Privacy Policy periodically. Continued use of Smart Planner constitutes acceptance of the updated policy.

Contact

For privacy questions or data deletion requests, contact: support@optivise.cc

ChatGPT Apps and MCP

Smart Planner can be connected to ChatGPT Apps through a remote MCP service. The service receives only the prompts, planning data, constraints, model configuration, and tool requests that you authorize. It validates models, runs optimization jobs, and returns status, explanations, and results.

The initial global MCP service runs on Google Cloud in the United States. Google Cloud Run hosts the MCP and OAuth service; Cloud SQL, Cloud Tasks, and Google Cloud Storage may be used for authentication state, job state, asynchronous execution, and result artifacts. The Beijing website server is not in this request path. ChatGPT/OpenAI remains a separate platform with its own account, conversation, retention, and privacy controls.

OAuth uses scoped authorization. Do not send passwords, private keys, API keys, or other secrets as planning data. To disconnect the service or request deletion of Smart Planner account, job, artifact, or audit data, contact support@optivise.cc. Provider-side ChatGPT records must be managed through OpenAI.

Quick Start

Post-install tips to get up and running with Smart Planner in your spreadsheet.

Open the sidebar

  • In your spreadsheet, use Smart Planner → Open Smart Planner from the top menu bar (same row as File, Edit, View).
  • Or open the add-on from the Extensions panel if your org installed it that way.

First time only: allow access

  • Google will show the permissions Smart Planner uses to run its sidebar, connect to its backend, and read or write Google Sheets data.
  • Smart Planner uses these permissions on the workbook you open and ask it to process.
  • You only need to do this once (unless permissions change).

Chat with the planner

  • Type questions in plain language — e.g. “What does the Input tab mean?”, “Help me set up a production schedule”, “Why did this cell show an error?”
  • The assistant reads your sheet automatically; you usually don’t need to copy-paste data.
  • Attach a screenshot (⋯ menu → Attach image) for layout or error messages.
  • Use New chat for a fresh topic; History to return to past conversations.

Run optimization

  • At the top of the sidebar you’ll see your models (planning setups for this spreadsheet).
  • Click Solve on a model to run it. A progress bar appears; results are posted in the chat and written to the sheet (often an Output tab).
  • No models yet? Ask in chat: “Set up an optimization model for this spreadsheet.”
  • More (⋯) on a model: Info (details), Update (start a change request in chat), Config (time limit / workers), Delete.

Tips for better answers

  • Say what you want to optimize (e.g. minimize cost, maximize throughput) and which tab matters if there are several.
  • After Solve, check the chat summary and the Output (or other) tabs for updated numbers.
  • If a run takes a long time, wait for the progress bar to finish — large models can take a few minutes.

If something looks wrong

  • No Smart Planner menu? Refresh the spreadsheet or close and reopen it.
  • Sidebar won’t load or chat stays on “Thinking…” — wait a minute and try again; start a New chat if it’s stuck.
  • Permission errors — run Open Smart Planner again and click Allow.
  • Still stuck? Contact support@optivise.cc

Support

Welcome to the Smart Planner support page. This guide explains how to use the Google Sheets planning assistant and review its results.

Getting Started

Smart Planner helps you:

  • describe your planning or optimization problem
  • build a planning model from your data and rules
  • calculate options that respect the rules you provide
  • write results directly back into your sheet

All without coding.

Common Topics

Installation

Open the Smart Planner product page for the current Google Workspace installation link, then open Google Sheets → Extensions → Smart Planner. The installation link is kept on the product page so it can be updated when a marketplace listing URL changes.

Opening the Sidebar

Go to Extensions → Smart Planner → Open Sidebar. The chat interface will appear on the right side of your sheet.

Building a Model

Describe your problem in natural language. Smart Planner will:

  • analyze your sheet
  • generate a model
  • show you a preview
  • wait for your confirmation

Solving

Click Solve to run the optimization. Results will be written back into your sheet.

Data Privacy

In Google Sheets mode, Smart Planner:

  • does not store your sheet data
  • does not store solver inputs or outputs
  • does store conversation history
  • does not train models on your data
  • does not sell or share your data
  • processes workbook data only for the action you authorize

For the hosted MCP mode, request uploads normally expire after 1 hour and run records/result artifacts normally expire after 24 hours. See the Privacy Policy and Data deletion pages for the complete deletion process.

Troubleshooting

If something doesn’t work:

  • refresh the sidebar
  • check your internet connection
  • ensure you have permission to edit the sheet
  • simplify your instructions

If issues persist, contact us.

Contact Support

Email: support@optivise.cc
We typically respond within 1–2 business days.

Documentation

Coming soon:

  • planning examples
  • model templates
  • best practices
  • troubleshooting guides