> ## Documentation Index
> Fetch the complete documentation index at: https://www.octoparse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets data sync

> Keep Google Sheets updated with Octoparse extraction results through recurring or automated sync workflows.

Google Sheets data sync keeps spreadsheet output updated as Octoparse tasks run. It is designed for recurring workflows where users need fresh data in a shared sheet without manually downloading and uploading files.

## How it differs from one-time export

| One-time export                   | Data sync                                      |
| --------------------------------- | ---------------------------------------------- |
| Manual or occasional delivery     | Recurring or automated delivery                |
| Good for ad hoc review            | Good for ongoing workflows                     |
| User downloads or sends data once | Spreadsheet stays updated after task runs      |
| Lower setup complexity            | Requires export behavior and schedule planning |

## Typical sync workflow

<Steps>
  <Step title="Stabilize the task">
    Confirm the task extracts the correct fields consistently.
  </Step>

  <Step title="Connect Google Sheets">
    Authorize the Google account and choose the destination spreadsheet.
  </Step>

  <Step title="Choose sync behavior">
    Octoparse automatically exports non-exported data only.
  </Step>

  <Step title="Schedule the task">
    Set a [recurring run](/docs/en/platform/schedules) if the sheet should update automatically.
  </Step>

  <Step title="Monitor the first runs">
    Check the spreadsheet after several runs to confirm row count, duplicates, and field mapping.
  </Step>
</Steps>

## What to watch for

* Repeated headers
* Duplicate rows
* Changed field names
* Missing values
* Permission errors
* Large sheets becoming slow
* Manual edits conflicting with synced data

## Recommended setup

Use one sheet tab for raw synced data and another tab for formulas, charts, or reporting views. This keeps the Octoparse-controlled output separate from your analysis layer.

<Warning>
  If you manually edit synced rows or columns, future exports may overwrite or misalign the sheet depending on the export settings.
</Warning>