How to export data to GoogleSheet?

You want to export data to a collaborative GoogleSheet — but you don’t want to painfully download and re-upload from a CSV?

In this short article, we will see how to export data scraped on lobstr on automated to a GoogleSheet.

Complete Video

Here is a complete video, with all steps you do need to follow.

https://www.loom.com/share/2bdf4bcbffc3462a8be1a7546c103f55

Step-by-step Instructions

We will enable auto-export to GoogleSheet in 3 simple steps:

Update GoogleSheet settings
Attach the GoogleSheet to the lobstr Squid
Specify the scope of delivery

Update GoogleSheet settings

First, [go on GoogleSheet](https://docs.google.com/spreadsheets/u/0/), and create a new sheet.



Now, we will update the settings of the GoogleSheet, so that the GoogleSheet can be modified by anyone.

Included the powerful lobstr scrapers.

First click on Share.



Then, in General access, click on Anyone with the link.



And in Role, click on Editor. Update to Editor.



OKK the GoogleSheet is now successfully setup!

Endly, let’s click on _Copy link_. We will need it for later.



Let’s attach it to our lobstr squid.

Attach the GoogleSheet to the lobstr Squid

Go back to your lobstr Squid page.

First, click on the lovely Delivery icon on the top-right of the screen.



Then, proceed as follows:

- Click on the GoogleSheet tickbox
- Past the GoogleSheet URL in the field



NB: you can click on Test Google Sheet to confirm your sheet is properly setup and well attached to the Squid

Last step, let’s specify what those 2 radio buttons mean.

Specify the scope of delivery

We have 2 radio buttons:

1️⃣ Export data from last run
🤝 Export data from all runs

What do they mean?

1️⃣

If you choose Export data from the last run, you will export only the data of the last run.

Be careful, if you scrape data through several runs, the data from the last run will overwrite the data previously exported.

We recommend doing this only if you need the most recent dataset.

🤝

If you choose Export data from all runs, you will export all the data from all the runs.

We recommend doing this if you want to get in 1 file all the data consolidated. From all your previous runs.



For the scope of this demo, we’ll simply pick: Export data from last run.

Endly, click on Save.



And that’s it!

Now simply click on Launch to launch a run.

Data will be automatically exported to the GoogleSheet.

Updated on: 11/03/2024