Export form responses to Sheets
google_forms_export_responsesAppend Google Form responses to Sheets with a response ID column for deduplication; migrate existing rows by matching answers and handle added or reordered questions safely.
Instructions
Append form responses to Sheets with a __google_forms_response_id column for deduplication by response ID. Existing rows are migrated by answer matching; added questions go after the ID column, while reordered columns fail safely.
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": {
"formId": "<formId>",
"spreadsheetId": "<spreadsheetId>"
},
"name": "google_forms_export_responses"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| formId | Yes | Form ID. | |
| account | No | Account nickname to use. | |
| sheetName | No | Tab name (default Sheet1). | |
| spreadsheetId | Yes | Destination spreadsheet ID. |