> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://lobstr.crisp.help/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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__.

![auto export data from a lobstr squid to a googlesheet](https://storage.crisp.chat/users/helpdesk/website/f3f3be820b67c800/capture-decran-2024-03-11-a-17_amnz2c.png)

### Complete Video

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

[https://www.loom.com/share/2bdf4bcbffc3462a8be1a7546c103f55](https://www.loom.com/share/2bdf4bcbffc3462a8be1a7546c103f55)

### Step-by-step Instructions

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

1. Update GoogleSheet settings
2. Attach the GoogleSheet to the lobstr Squid
3. Specify the scope of delivery

#### Update GoogleSheet settings

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

![create a new googlesheet](https://storage.crisp.chat/users/helpdesk/website/f3f3be820b67c800/capture-decran-2024-03-11-a-17_1uwtssq.png)

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_.

![click on share googlesheet](https://storage.crisp.chat/users/helpdesk/website/f3f3be820b67c800/capture-decran-2024-03-11-a-17_v33j6l.png)

Then, in _General access_, **click on _Anyone with the link_**.

![in general access click on anyone with the link](https://storage.crisp.chat/users/helpdesk/website/f3f3be820b67c800/capture-decran-2024-03-11-a-17_1ulo7ps.png)

And in _Role_, click on _Editor_. **Update to Editor.**

![in role click on editor](https://storage.crisp.chat/users/helpdesk/website/f3f3be820b67c800/capture-decran-2024-03-11-a-18_5hfxlg.png)

OKK the GoogleSheet is now **successfully setup**!

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

![click on copy googlesheet link](https://storage.crisp.chat/users/helpdesk/website/f3f3be820b67c800/capture-decran-2024-03-11-a-18_zuibn5.png)

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**.

![click on the delivery icon on the top right](https://storage.crisp.chat/users/helpdesk/website/f3f3be820b67c800/capture-decran-2024-03-11-a-18_1fblm7v.png)

Then, proceed as follows: 

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

![paste your googlesheet url in the squid settings](https://storage.crisp.chat/users/helpdesk/website/f3f3be820b67c800/capture-decran-2024-03-11-a-18_yrq0b9.png)

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.

![export data from all runs vs export data from last run delivery settings](https://storage.crisp.chat/users/helpdesk/website/f3f3be820b67c800/capture-decran-2024-03-11-a-18_17w9liu.png)

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

Endly, click on _Save_.

![click on save](https://storage.crisp.chat/users/helpdesk/website/f3f3be820b67c800/capture-decran-2024-03-11-a-18_1qjn9wj.png)

And that’s it!

Now simply click on _Launch_ to launch a run.

**Data will be automatically exported to the GoogleSheet**.