Skip to content
Export and delivery

Export scraped data automatically to Google Sheets

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

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

Auto-export data from a lobstr.io batch to a Google Sheet

Watch the full walkthrough

Step-by-step instructions

  1. Create and configure your Google Sheet

    Go to Google Sheets and create a new spreadsheet.

    Create a new Google Sheet

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

    Click Share.

    Click Share in Google Sheets

    Under General access, select Anyone with the link.

    Select Anyone with the link in General access

    Then change the role to Editor.

    Set role to Editor

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

    Copy the Google Sheet link
  2. Attach the Google Sheet to your batch

    Go back to your batch page in lobstr.io.

    Click the Delivery icon in the top-right of the batch page.

    Click the Delivery icon on the batch page

    Then:

    1. Tick the Google Sheet checkbox.
    2. Paste the Google Sheet URL in the field.
    Paste the Google Sheet URL in the batch delivery settings

    You can click Test Google Sheet to confirm the sheet is correctly configured and attached to the batch before saving.

  3. Confirm the export scope

    The export scope is Export data from last run: each time a run ends, lobstr.io writes that run's results to the sheet, overwriting the previous export.

    Googlesheet delivery panel with the Export data from last run option

    Each new run overwrites the previous data in the sheet. To preserve run history, download past runs from the Runs table, or set up Amazon S3 delivery — it delivers a separate file for every run.

    Click Save.

    Click Save in the delivery settings
  4. Launch your batch

    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.

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 past runs one by one from the Runs table and import them manually.