# Google Maps Scraper Results to Google Sheets

**Use case:** 

Главный «пугающий» момент здесь — ключ сервис-аккаунта (без него sheets-sync не запишет). Убрать его нельзя, но можно подать так, чтобы Google-Maps-пользователь

## Input

```json
{
  "spreadsheet": "https://docs.google.com/spreadsheets/d/1ReplaceWithYourGoogleSheetIdHere0123456789/edit",
  "mode": "append",
  "rows": [
    {
      "id": 1,
      "name": "Ada Lovelace",
      "score": 95
    },
    {
      "id": 2,
      "name": "Alan Turing",
      "score": 88
    }
  ],
  "createSheetIfMissing": true,
  "valueInputOption": "RAW",
  "dryRun": true
}
```

## Output

```json
{
  "type": {
    "label": "Record",
    "format": "text"
  },
  "status": {
    "label": "Status",
    "format": "text"
  },
  "mode": {
    "label": "Mode",
    "format": "text"
  },
  "sheetTitle": {
    "label": "Sheet",
    "format": "text"
  },
  "rowsAppended": {
    "label": "Appended",
    "format": "number"
  },
  "rowsUpdated": {
    "label": "Updated",
    "format": "number"
  },
  "cellsWritten": {
    "label": "Cells",
    "format": "number"
  },
  "writeRequests": {
    "label": "Requests",
    "format": "number"
  },
  "durationMs": {
    "label": "Duration (ms)",
    "format": "number"
  },
  "code": {
    "label": "Error code",
    "format": "text"
  },
  "message": {
    "label": "Message",
    "format": "text"
  }
}
```

## About this Actor

This example demonstrates how to use [Dataset to Google Sheets - Reliable Writer (Validate, Upsert)](https://apify.com/amazing_wizdom/sheets-sync-guardrails) with a specific input configuration. Visit the [Actor detail page](https://apify.com/amazing_wizdom/sheets-sync-guardrails) to learn more, explore other use cases, and run it yourself.