# Batch export public Google Sheets

**Use case:** 

Batch export public Google Sheets to Apify datasets for scheduled automations, webhooks, CSV downloads, and API integrations.

## Input

```json
{
  "startUrls": [
    {
      "url": "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0"
    },
    {
      "url": "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/export?format=csv&gid=0"
    }
  ],
  "sheetIds": [],
  "gid": "0",
  "maxRowsPerSheet": 20,
  "trimValues": true,
  "includeRawRow": true,
  "skipBlankRows": true
}
```

## Output

```json
{
  "_rowNumber": {
    "label": "Row #"
  },
  "_sourceUrl": {
    "label": "Source URL"
  },
  "_sheetId": {
    "label": "Sheet ID"
  },
  "_gid": {
    "label": "GID"
  },
  "columns": {
    "label": "Normalized columns"
  },
  "_rawRow": {
    "label": "Raw row"
  },
  "_fetchedAt": {
    "label": "Fetched at"
  }
}
```

## About this Actor

This example demonstrates how to use [Google Sheet Exporter](https://apify.com/automation-lab/google-sheet-exporter) with a specific input configuration. Visit the [Actor detail page](https://apify.com/automation-lab/google-sheet-exporter) to learn more, explore other use cases, and run it yourself.