> ## Documentation Index
> Fetch the complete documentation index at: https://help.lobstr.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Export scraped data automatically to Google Sheets

> Connect lobstr.io to Google Sheets and automatically push scraped results into a collaborative spreadsheet after every Squid run — no manual uploads needed.

Instead of downloading a CSV after every run and re-uploading it manually, you can connect your Squid to a Google Sheet so results are pushed there automatically. This keeps your data in one place, makes it easy to share with teammates, and saves you the repetitive download-and-upload cycle.

<Frame>
  <img src="https://mintcdn.com/lobstrio-8dcae32c/oM3Rw_5SkIYdley8/images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-17_amnz2c.png?fit=max&auto=format&n=oM3Rw_5SkIYdley8&q=85&s=b6fcdf5c1af9242f0b58ccd9f132104d" alt="Auto-export data from a lobstr.io Squid to a Google Sheet" width="1026" height="1176" data-path="images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-17_amnz2c.png" />
</Frame>

## Watch the full walkthrough

<iframe width="100%" height="420" src="https://www.loom.com/embed/2bdf4bcbffc3462a8be1a7546c103f55" frameborder="0" allowfullscreen />

## Step-by-step instructions

<Steps>
  <Step title="Create and configure your Google Sheet">
    Go to [Google Sheets](https://docs.google.com/spreadsheets/u/0/) and create a new spreadsheet.

    <Frame>
      <img src="https://mintcdn.com/lobstrio-8dcae32c/oM3Rw_5SkIYdley8/images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-17_1uwtssq.png?fit=max&auto=format&n=oM3Rw_5SkIYdley8&q=85&s=1acc4b1b99802b6038aafce2688614b0" alt="Create a new Google Sheet" width="1600" height="352" data-path="images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-17_1uwtssq.png" />
    </Frame>

    Next, make the sheet accessible to lobstr.io so its scrapers can write to it.

    Click **Share**.

    <Frame>
      <img src="https://mintcdn.com/lobstrio-8dcae32c/oM3Rw_5SkIYdley8/images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-17_v33j6l.png?fit=max&auto=format&n=oM3Rw_5SkIYdley8&q=85&s=6e0cc606f6dc6cd07d21c2740bf8fde0" alt="Click Share in Google Sheets" width="1600" height="716" data-path="images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-17_v33j6l.png" />
    </Frame>

    Under **General access**, select **Anyone with the link**.

    <Frame>
      <img src="https://mintcdn.com/lobstrio-8dcae32c/oM3Rw_5SkIYdley8/images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-17_1ulo7ps.png?fit=max&auto=format&n=oM3Rw_5SkIYdley8&q=85&s=c1f72c345985f31eba0b2bf8273fe2a9" alt="Select Anyone with the link in General access" width="1600" height="763" data-path="images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-17_1ulo7ps.png" />
    </Frame>

    Then change the role to **Editor**.

    <Frame>
      <img src="https://mintcdn.com/lobstrio-8dcae32c/oM3Rw_5SkIYdley8/images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-18_5hfxlg.png?fit=max&auto=format&n=oM3Rw_5SkIYdley8&q=85&s=09c0e80c756cb5015f7a15f6e32f1d58" alt="Set role to Editor" width="1600" height="820" data-path="images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-18_5hfxlg.png" />
    </Frame>

    Finally, click **Copy link** — you'll need this URL in the next step.

    <Frame>
      <img src="https://mintcdn.com/lobstrio-8dcae32c/oM3Rw_5SkIYdley8/images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-18_zuibn5.png?fit=max&auto=format&n=oM3Rw_5SkIYdley8&q=85&s=44909e48ec8fbad7c88ecb5fd722a949" alt="Copy the Google Sheet link" width="1600" height="733" data-path="images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-18_zuibn5.png" />
    </Frame>
  </Step>

  <Step title="Attach the Google Sheet to your Squid">
    Go back to your Squid page in lobstr.io.

    Click the **Delivery** icon in the top-right of the Squid page.

    <Frame>
      <img src="https://mintcdn.com/lobstrio-8dcae32c/oM3Rw_5SkIYdley8/images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-18_1fblm7v.png?fit=max&auto=format&n=oM3Rw_5SkIYdley8&q=85&s=7a1b260b47ec8d071f891a63ad954cbb" alt="Click the Delivery icon on the Squid page" width="1600" height="659" data-path="images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-18_1fblm7v.png" />
    </Frame>

    Then:

    1. Tick the **Google Sheet** checkbox.
    2. Paste the Google Sheet URL in the field.

    <Frame>
      <img src="https://mintcdn.com/lobstrio-8dcae32c/oM3Rw_5SkIYdley8/images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-18_yrq0b9.png?fit=max&auto=format&n=oM3Rw_5SkIYdley8&q=85&s=d04a9253c63bb41319765998780a8188" alt="Paste the Google Sheet URL in the Squid delivery settings" width="1210" height="974" data-path="images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-18_yrq0b9.png" />
    </Frame>

    <Tip>
      You can click **Test Google Sheet** to confirm the sheet is correctly configured and attached to the Squid before saving.
    </Tip>
  </Step>

  <Step title="Choose the export scope">
    There are two radio buttons:

    * **Export data from last run** — only the latest run's data is written to the sheet. Each new run overwrites the previous export. Use this when you only need the freshest dataset.
    * **Export data from all runs** — every time a new run completes, its results are appended below the previous rows. Use this to build one continuously growing, consolidated dataset.

    <Frame>
      <img src="https://mintcdn.com/lobstrio-8dcae32c/oM3Rw_5SkIYdley8/images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-18_17w9liu.png?fit=max&auto=format&n=oM3Rw_5SkIYdley8&q=85&s=b32e18661edf872a4479347683a68693" alt="Export data from all runs vs export data from last run" width="1600" height="987" data-path="images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-18_17w9liu.png" />
    </Frame>

    <Warning>
      If you select **Export data from last run**, each new run overwrites the data from the previous one. Choose **Export data from all runs** if you want to preserve history.
    </Warning>

    Click **Save**.

    <Frame>
      <img src="https://mintcdn.com/lobstrio-8dcae32c/oM3Rw_5SkIYdley8/images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-18_1qjn9wj.png?fit=max&auto=format&n=oM3Rw_5SkIYdley8&q=85&s=9ca916077d63ad88eb7999e268606319" alt="Click Save in the delivery settings" width="1600" height="1049" data-path="images/how-to-export-data-to-googlesheet/capture-decran-2024-03-11-a-18_1qjn9wj.png" />
    </Frame>
  </Step>

  <Step title="Launch your Squid">
    Click **Launch** to start a run. Once it completes, lobstr.io automatically pushes the results to your Google Sheet.

    From this point on, every future run triggers an automatic export — no manual steps required.
  </Step>
</Steps>

<Note>
  Google Sheets export applies to **future runs only**. Data from runs that completed before you set up the integration will not be exported retroactively. To get historical data into your sheet, download the combined CSV with the green **Download** button and import it manually.
</Note>
