Skip to main content
Glama

Выгрузка в Google Таблицы

manage_quiz_google_sheets
Destructive

Выгрузка ответов в Google Таблицы: что попадает в таблицу и как часто она обновляется. show — состояние: адрес и название таблицы, живой ли доступ, режим обновления, когда выгружали последний раз, какие вопросы исключены. Дальше: включить и выключить выгрузку, убрать интеграцию, задать состав вопросов, переключить метку времени и персональные данные, выбрать режим обновления (сразу, по расписанию в заданный час, вручную), дослать накопившееся и выгрузить все ответы заново. Подключение аккаунта Google и выбор таблицы делают в кабинете: там вход в аккаунт и окно Google Диска. Журнал синхронизаций — в get_quiz_integrations.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
actionYesЧто сделать: show, activate, deactivate, delete, save_widgets — состав вопросов, save_switchers — метка времени и персональные данные, set_sync_mode — режим обновления, sync_now — дослать накопившееся, export_all — выгрузить все ответы.
quiz_idYesID опроса.
sync_modeNoКогда обновлять таблицу: realtime — сразу после ответа, scheduled — раз в сутки в заданное время, manual — только по команде. Обязателен для action=set_sync_mode; при scheduled нужны ещё schedule_hour и schedule_minute.
export_modeNoКуда выгружать все ответы: new_file — в новый файл, new_sheet — на новый лист, replace — заменить текущий лист. Обязателен для action=export_all.
schedule_hourNoЧас обновления, 0–23. Обязателен для scheduled.
schedule_minuteNoМинута обновления, 0–59. Обязательна для scheduled.
enable_timestampNoДобавлять столбец со временем ответа.
hidden_widget_idsNoID вопросов, которые НЕ попадают в таблицу. Список задаётся целиком: чего в нём нет, то в таблицу вернётся. Взять из quiz://{id}/structure.
enable_personal_dataNoВыгружать персональные данные респондента.

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4.1/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare destructiveHint=true, openWorldHint=true, non-idempotent and non-read-only, so the safety profile is partly carried structurally. The description adds real context beyond that: what 'show' returns (table address/name, live access status, update mode, last export, excluded questions) and the three sync modes. It does not call out irreversibility of delete or overwrite semantics of export_all/replace, which a destructive multi-action tool would ideally state.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Purpose and the most important action ('show') are front-loaded before the enumeration of remaining actions. It is a single dense paragraph rather than a scannable list, which is a minor structural weakness, but every sentence carries information and none is padding.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a 9-parameter, 9-action tool with no output schema, the description covers purpose, action inventory, state-reading via 'show', prerequisites, and where logs are found, so an agent can invoke it correctly. What is missing is return/error behavior for the mutating actions and any warning about destructive outcomes, which keeps it below a 5.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100% and the schema itself already documents each enum value, cross-field dependencies (sync_mode required for set_sync_mode, schedule_hour/minute for scheduled, export_mode for export_all) and the whole-list semantics of hidden_widget_ids. The prose largely restates the action list, adding little syntax or format detail beyond the schema, so the baseline 3 applies.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The opening states a specific verb+resource (exporting answers to Google Sheets) and then enumerates every action the tool performs, mapping transparently onto the action enum (show, activate, deactivate, delete, save_widgets, save_switchers, set_sync_mode, sync_now, export_all). An agent can tell this apart from the CSV/XLSX/SPSS export siblings because it is the live Sheets-integration manager, not a one-off file export.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It gives clear operational context: 'show' reveals current state, account connection and table selection happen in the cabinet rather than through this tool, and synchronization logs live in get_quiz_integrations. This explicit routing to another tool/cabinet is strong. It stops short of an explicit when-not-to-use rule versus the static export tools, so it is not a full 5.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources