Google Sheets Integration

Connect Dunmore to Google Sheets to append payment events as spreadsheet rows. Useful for lightweight payment tracking, sharing with non-technical team members, or quick CSV exports.

Setup

1. Create a Google Sheet with headers: Timestamp, Status, Amount, Endpoint, Payer, Network/Error, TX Hash, Event ID
2. Create a Google Cloud service account with Google Sheets API access
3. Share the spreadsheet with the service account email
4. Generate an access token for the service account
5. Add a Google Sheets connector in the Dunmore console or via the API

Supported Events

Dunmore Event	Row Content
payment.settled	Timestamp, "Settled", amount, endpoint, payer wallet, network name, TX hash, event ID
payment.failed	Timestamp, "Failed", amount, endpoint, payer wallet, stage + error code, (empty), event ID
customer.first_payment	Timestamp, "New Customer", amount, endpoint, payer wallet, (empty), (empty), event ID

Rows are appended to columns A through H in the specified sheet.

Configuration

{
  "type": "google-sheets",
  "config": {
    "spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
    "accessToken": "ya29....",
    "sheetName": "Payments"
  },
  "eventTypes": ["payment.settled", "payment.failed", "customer.first_payment"]
}

Field	Required	Default	Description
spreadsheetId	Yes	—	Google Sheet ID (from the URL)
accessToken	Yes	—	Google OAuth access token
sheetName	No	Payments	Name of the sheet tab to append to

API Example

curl -X POST https://api.dunmore.xyz/api/projects/{projectId}/connectors \
  -H "Authorization: Bearer {token}" \
  -H "Content-Type: application/json" \
  -d '{
    "type": "google-sheets",
    "config": {
      "spreadsheetId": "YOUR_SPREADSHEET_ID",
      "accessToken": "YOUR_ACCESS_TOKEN",
      "sheetName": "Payments"
    },
    "eventTypes": ["payment.settled", "payment.failed"]
  }'