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

![](/files/-MKQogv9SYSXwDAWkWqt)

2\. Change the type of sheet sharing.

![](/files/-MiHr5yMpiItGP2eInjG)

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

![](/files/-MKQpPlR15h8LBUAlBUw)

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

![](/files/-MSYzDEtCMI7UIDx1iO-)

## 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](/files/-MKQpb1Nft80CWP8-gWD)

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

![](/files/-MObRwxKQlNIdUuYkbX4)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.roivenue.com/roivenue-resources/roivenue-training/data-exports/export-to-google-sheet.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.