Google Sheets export is continuous and automatic. Every time your Squid runs, lobstr.io pushes the new results to your sheet without any manual action on your part.
Create and configure your Google Sheet
Go to sheets.google.com and create a new spreadsheet.Next, make the sheet accessible to lobstr.io:
- Click Share in the top-right corner.
- Under General access, select Anyone with the link.
- Set the role to Editor.
- Click Copy link — you will need this URL in the next step.
Attach the Google Sheet to your Squid
Go back to your Squid page in lobstr.io.
- Click the Delivery icon in the top-right area of the Squid page.
- Check the Google Sheet checkbox.
- Paste the Google Sheet URL you copied into the field.
- Optionally, click Test Google Sheet to confirm the connection is working correctly.
Choose the export scope
Select which data you want lobstr.io to push to your sheet after each run:
- Export data from last run — only the most recent 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 a continuously growing, consolidated dataset.
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 using the green Download button and import it manually.