Chat & AI Agent

How the AI agent works

SheetEngine uses two AI modes:

• Planning (default) - Handles all your messages. It explains concepts, answers questions about Apps Script, and proposes automation plans.
• Building - Activated when you click or type Build This. The agent writes, edits, and manages your Apps Script files based on the plan.

Chatting in planning mode

Type your message and press Enter. The planning agent can:

• Help you design your automation logic step by step
• Explain how specific Apps Script features work
• Suggest approaches for complex workflows
• Answer questions about your existing code

Building code

When you're ready to implement, click or type Build This. The coding agent:

• Reads your existing project files to understand the context
• Writes new code or edits existing files
• Can create and delete files as needed
• Shows its progress in the editor in real time

After a build, you can continue chatting to request changes, fix issues, or add new features.

Tips for good results

• Be specific - "Add a logic that sends an email when column B changes to Approved" works better than "add email functionality"
• Iterate - Start with a basic version, then refine with follow-up messages
• Review the plan - Read the planning agent's proposal before clicking Build This
• Check the code - Always review generated code in the editor before deploying