Integrate SheetMania into your applications with our comprehensive API
The SheetMania API allows you to programmatically create, manage, and monitor your automations. Our RESTful API uses standard HTTP methods and returns JSON responses.
Base URL: https://api.sheetmania.com/v1
All API requests require authentication using an API key in the Authorization header.
curl -H "Authorization: Bearer YOUR_API_KEY" \
https://api.sheetmania.com/v1/automationsRetrieve a list of all automations for your account.
GET /v1/automations
{
"automations": [
{
"id": "auto_123",
"name": "Daily Report",
"status": "active",
"created_at": "2024-01-05T10:30:00Z"
}
]
}Create a new automation with triggers and actions.
POST /v1/automations
{
"name": "Daily Report",
"trigger": {
"type": "schedule",
"schedule": "daily_9am"
},
"actions": [
{
"type": "send_email",
"recipients": ["admin@company.com"]
}
]
}Webhooks are sent to your configured endpoint when events occur.
POST https://your-webhook-endpoint.com/webhooks
{
"event_type": "automation.executed",
"automation_id": "auto_123",
"execution_id": "exec_456",
"status": "success",
"timestamp": "2024-01-05T10:30:00Z",
"data": {
"rows_processed": 150,
"duration_ms": 2341
}
}The API returns standard HTTP status codes and detailed error information.
{
"error": {
"code": "invalid_trigger",
"message": "The specified trigger configuration is invalid",
"details": {
"field": "trigger.schedule",
"reason": "Invalid cron expression"
}
}
}Webhooks allow your application to receive real-time notifications when events occur in SheetMania. Set up webhook endpoints in your account settings.
Fired when a new automation is created
Fired when an automation configuration changes
Fired when an automation runs successfully
Fired when an automation encounters an error
Fired when an automation is deleted
Request succeeded
Resource created successfully
Invalid request parameters
Invalid or missing API key
Resource not found
Too many requests
Internal server error
Service temporarily unavailable