Google Sheets API Help
Currently trying to have the AI record information as values to input into Google Sheets with the tool.
There's no Value section for the Dashboard though, it just asks for a SheetID and for a Range, but there's no way to edit the parameters or what it should be recording in each column.
That code currently looks like this:
{
"id": "1176d4af-d822-4316-a262-0dcf983693ed",
"createdAt": "2025-09-30T18:12:09.726Z",
"updatedAt": "2025-09-30T18:14:18.864Z",
"type": "google.sheets.row.append",
"function": {
"name": "quote_intake_submit",
"description": "Use this tool to record a completed rental quote request from a customer into the Google Sheets “Quote Submissions” spreadsheet.\n\nCollect all required information from the customer first — including full name, phone, email, equipment type, lift height, rental start date, rental duration, jobsite ZIP, whether delivery is required, and the source channel. Optional details such as company name, model requested, capacity, fuel type, terrain, address, urgency, referral source, budget notes, and special delivery constraints can also be included.\n\nOnly invoke this tool once all required fields have been confirmed with the customer. The tool will then append a new row with all these values to the Google Sheet. Do not use this tool for reading or modifying existing data — it is for adding new rows only.\n\nAlways confirm the data with the customer before submitting, and thank them for providing their details.",
"parameters": {
"type": "object",
"properties": {},
"required": []
}
},
"messages": [
{
"type": "request-start",
"blocking": false
}
],
"metadata": {
"spreadsheetId": "1oILmK0hL1iWY5dZwS8xbTZhKTsFuKmQVP8nEFQ6Jmto",
"range": "Quote Submissions!A:Z"
},
"orgId": "4a55f79e-5729-427d-a231-8c7c7b172c7b"
}
There's no Value section for the Dashboard though, it just asks for a SheetID and for a Range, but there's no way to edit the parameters or what it should be recording in each column.
That code currently looks like this:
{
"id": "1176d4af-d822-4316-a262-0dcf983693ed",
"createdAt": "2025-09-30T18:12:09.726Z",
"updatedAt": "2025-09-30T18:14:18.864Z",
"type": "google.sheets.row.append",
"function": {
"name": "quote_intake_submit",
"description": "Use this tool to record a completed rental quote request from a customer into the Google Sheets “Quote Submissions” spreadsheet.\n\nCollect all required information from the customer first — including full name, phone, email, equipment type, lift height, rental start date, rental duration, jobsite ZIP, whether delivery is required, and the source channel. Optional details such as company name, model requested, capacity, fuel type, terrain, address, urgency, referral source, budget notes, and special delivery constraints can also be included.\n\nOnly invoke this tool once all required fields have been confirmed with the customer. The tool will then append a new row with all these values to the Google Sheet. Do not use this tool for reading or modifying existing data — it is for adding new rows only.\n\nAlways confirm the data with the customer before submitting, and thank them for providing their details.",
"parameters": {
"type": "object",
"properties": {},
"required": []
}
},
"messages": [
{
"type": "request-start",
"blocking": false
}
],
"metadata": {
"spreadsheetId": "1oILmK0hL1iWY5dZwS8xbTZhKTsFuKmQVP8nEFQ6Jmto",
"range": "Quote Submissions!A:Z"
},
"orgId": "4a55f79e-5729-427d-a231-8c7c7b172c7b"
}
