Skip to main content
Instead of downloading a file after every run and re-uploading it manually, you can connect your Squid 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 Squid 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 Squid

Go back to your Squid page in lobstr.io.Click the Delivery icon in the top-right of the Squid page.
Click the Delivery icon on the Squid page
Then:
  1. Tick the Google Sheet checkbox.
  2. Paste the Google Sheet URL in the field.
Paste the Google Sheet URL in the Squid delivery settings
You can click Test Google Sheet to confirm the sheet is correctly configured and attached to the Squid 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 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.
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.