Google Sheet matan
Interact with Google Sheets via the Maton API Gateway — read, write, append, and clear spreadsheet data using curl. Use this skill whenever the user mentions...
Google Sheets (Generic, via Maton Gateway)
Access and manage any Google Sheets spreadsheet via Maton Gateway with full OAuth authentication. Supports reading, writing, updating, appending, clearing, formatting, sheet management, formulas, and protection.
🌐 Base URL https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/{native-api-path}
{SPREADSHEET_ID} → Your spreadsheet ID {native-api-path} → Google Sheets API path (values, sheets, etc.) 🔐 Authentication
Include your Maton API key in headers:
-H "Authorization: Bearer $MATON_API_KEY"
Set in environment:
export MATON_API_KEY="YOUR_API_KEY"
📄 Operations (Generic Placeholders)
- Read Values
curl "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values/{SHEET_NAME}!{RANGE}"
-H "Authorization: Bearer $MATON_API_KEY"
Placeholders:
{SHEET_NAME} → Name of any sheet/tab {RANGE} → A1 notation (A1:Z100) 2. Append Values
Add new rows to the bottom of a sheet.
curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values/{SHEET_NAME}!{RANGE}:append?valueInputOption=USER_ENTERED"
-H "Authorization: Bearer $MATON_API_KEY"
-H "Content-Type: application/json"
-d '{
"values": [
["{VALUE1}", "{VALUE2}", "{VALUE3}", "...", "{VALUEN}"]
]
}'
{VALUE1} ... {VALUEN} → Any generic values
3. Update Values
curl -X PUT "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values/{SHEET_NAME}!{RANGE}?valueInputOption=USER_ENTERED"
-H "Authorization: Bearer $MATON_API_KEY"
-H "Content-Type: application/json"
-d '{
"values": [
["{VALUE1}", "{VALUE2}", "{VALUE3}", "...", "{VALUEN}"]
]
}'
- Batch Update Values
Update multiple ranges at once:
curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values:batchUpdate"
-H "Authorization: Bearer $MATON_API_KEY"
-H "Content-Type: application/json"
-d '{
"valueInputOption":"USER_ENTERED",
"data":[
{"range":"{SHEET_NAME}!{RANGE1}","values":[["{VALUE1A}", "{VALUE1B}", "..."]]},
{"range":"{SHEET_NAME}!{RANGE2}","values":[["{VALUE2A}", "{VALUE2B}", "..."]]}
]
}'
-
Clear Values curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values/{SHEET_NAME}!{RANGE}:clear"
-H "Authorization: Bearer $MATON_API_KEY" -
Get Spreadsheet Metadata curl "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}"
-H "Authorization: Bearer $MATON_API_KEY"
Returns sheets, properties, titles, IDs
7. Add a New Sheet
curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}:batchUpdate"
-H "Authorization: Bearer $MATON_API_KEY"
-H "Content-Type: application/json"
-d '{
"requests":[
{"addSheet":{"properties":{"title":"{NEW_SHEET_NAME}"}}}
]
}'
-
Delete a Sheet curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}:batchUpdate"
-H "Authorization: Bearer $MATON_API_KEY"
-H "Content-Type: application/json"
-d '{ "requests":[ {"deleteSheet":{"sheetId":{SHEET_ID}}} ] }' -
Copy Sheet curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/sheets/{SHEET_ID}:copyTo"
-H "Authorization: Bearer $MATON_API_KEY"
-H "Content-Type: application/json"
-d '{ "destinationSpreadsheetId":"{DEST_SPREADSHEET_ID}" }' -
Formatting & Cell Styling curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}:batchUpdate"
-H "Authorization: Bearer $MATON_API_KEY"
-H "Content-Type: application/json"
-d '{ "requests":[ { "repeatCell":{ "range":{"sheetId":{SHEET_ID},"startRowIndex":{START_ROW},"endRowIndex":{END_ROW},"startColumnIndex":{START_COL},"endColumnIndex":{END_COL}}, "cell":{"userEnteredFormat":{"backgroundColor":{"red":{R},"green":{G},"blue":{B}}}}, "fields":"userEnteredFormat.backgroundColor" } } ] }' -
Insert Formulas curl -X PUT "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}/values/{SHEET_NAME}!{CELL}?valueInputOption=USER_ENTERED"
-H "Authorization: Bearer $MATON_API_KEY"
-H "Content-Type: application/json"
-d '{ "values":[["{FORMULA}"]] }' -
Protected Ranges curl -X POST "https://gateway.maton.ai/google-sheets/v4/spreadsheets/{SPREADSHEET_ID}:batchUpdate"
-H "Authorization: Bearer $MATON_API_KEY"
-H "Content-Type: application/json"
-d '{ "requests":[ {"addProtectedRange":{"protectedRange":{"range":{"sheetId":{SHEET_ID},"startRowIndex":{START_ROW},"endRowIndex":{END_ROW}},"description":"{DESCRIPTION}"}}} ] }'
📚 Notes {SPREADSHEET_ID} → Your spreadsheet ID {SHEET_NAME} → Any sheet/tab name {RANGE} → A1 notation (e.g., A1:Z100) {VALUE1}, {VALUE2}, … → Generic placeholders for any cell content USER_ENTERED parses numbers, dates, formulas automatically batchUpdate is required for structural changes (add/delete sheets, formatting, protection)
Related skills
- Downloads
- 907All time
- Security audit
- Pass
- Last updated
- 6mo ago
- Current version
- v1.0.1
- License
- MIT-0
