# Export to a Google Sheet

## Step 1: **Google Sheet Preparation**

In the first step you need to create a Google Sheet document to store the exported data.

1\. Create a new Google Sheet, name it and click on the Share button.

![](https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGvvrlVUvq4TNL0oYP6%2F-MKQmkJsLrn992Djf4bQ%2F-MKQogv9SYSXwDAWkWqt%2Fexports%20to%20google%20sheets%201.png?alt=media\&token=df7eb5da-e82d-44e1-bd7b-e0d7604ca265)

2\. Change the type of sheet sharing.

![](https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGvvrlVUvq4TNL0oYP6%2F-MiHpzjV-7v_slEfQMZF%2F-MiHr5yMpiItGP2eInjG%2Fgs_export_censored.jpg?alt=media\&token=4afecf48-5f23-4a6d-9303-8db299a3b19f)

3\. Choose the sharing option: anyone with the link.

![](https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGvvrlVUvq4TNL0oYP6%2F-MKQmkJsLrn992Djf4bQ%2F-MKQpPlR15h8LBUAlBUw%2Fs%CC%8Cexport%20to%20google%20sheets%20.png?alt=media\&token=f64f50e8-64cd-4925-bd1e-78f561a431e8)

4\. Click on the "Viewer" selection on the right and choose the "Editor" role.

![](https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGvvrlVUvq4TNL0oYP6%2F-MSYz7QLNMh9tktAMkEs%2F-MSYzDEtCMI7UIDx1iO-%2Fsheets.png?alt=media\&token=74b9732c-6cb2-4d5b-ab84-a38f26200bf7)

## Step 2: Paste the Google Document ID in ROIVENUE Data Exports

Now your Google Sheet is ready to be populated with data from Roivenue. **Copy the unique Google Document ID.** 

**What and where is the Google Document ID?**

{% hint style="info" %}
**Note:** What and where is the Google Document ID?

Let's say that you have this URL : *<https://docs.google.com/spreadsheets/d/1OQE1SYpMEmmdLHRAc9h829I2Tz73YFElHlhIXr\\_57OY/edit#gid=0>.*

Then the **Document ID** **is this part from the URL**:&#x20;

*OQE1SYpMEmmdLHRAc9h829I2Tz73YFElHlhIXr\_57OY*
{% endhint %}

![The highlighted part of the URL is the Google Document ID](https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGvvrlVUvq4TNL0oYP6%2F-MKQmkJsLrn992Djf4bQ%2F-MKQpb1Nft80CWP8-gWD%2Fexport%20to%20google%20sheets%205%C2%A8.png?alt=media\&token=a9764df8-d140-478e-91bd-eade12d1a528)

&#x20;After you will have the correct Google Document ID, you can copypaste it to Roivenue's Google Sheet settings.

![](https://4279879158-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MGvvrlVUvq4TNL0oYP6%2F-MObQo37rOi3P4DpUy7u%2F-MObRwxKQlNIdUuYkbX4%2Fsheets%20document%20ID.png?alt=media\&token=2312d229-a4c1-462f-b53a-b0ea086260e6)