Create schedule
create_scheduleSchedule a saved query to run on a cron cadence and deliver its result to exactly one destination: a Google Sheets tab or a Slack channel. Use it when the user wants a report refreshed or posted regularly; for a one-off file use export_query_results. Save the SQL first with save_query if it is not in the library, and check list_schedules, since each saved query can have only one schedule. Every run replaces what the previous run wrote to the sheet range, or posts a new Slack message. Set spreadsheetId, or createNew with spreadsheetName, or slackChannelId, never more than one destination. Requires a plan that includes scheduling, the write and execute scopes, and a member role that can edit. The query must be one you could run yourself: shared with the team on an approved_queries connection, and a read unless the connection's aiAccess is same_as_people. Test it right away with run_schedule_now.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"savedQueryId": "<savedQueryId>",
"cronExpression": "<cronExpression>"
},
"name": "create_schedule"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| timezone | No | IANA timezone. Defaults to UTC. | |
| createNew | No | Create a new spreadsheet named spreadsheetName. | |
| sheetName | No | Tab to write to. | |
| startCell | No | A1 notation. Defaults to A1. | |
| savedQueryId | Yes | Saved query id from list_queries. | |
| spreadsheetId | No | Existing spreadsheet to write to. Omit and set createNew with spreadsheetName to make a new one. | |
| cronExpression | Yes | 5-field cron expression, e.g. '0 9 * * 1' for Monday 9am. | |
| includeHeaders | No | Write column names as the first row. Defaults to true. | |
| slackChannelId | No | Slack channel to post to, instead of a spreadsheet. | |
| spreadsheetName | No | Name for a new spreadsheet when createNew is true. | |
| slackChannelName | No | Display name of the Slack channel. | |
| slackMessageTemplate | No | Message template for Slack. Omit to post the raw result. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schedule | Yes |