> ## Documentation Index
> Fetch the complete documentation index at: https://docs.nemu.com.br/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets

> How to integrate Google Sheets to Nemu Dashboard

# Google Sheets Integration 📊

## Objective

In this tutorial, you will learn how to:

* Create a copy of a Google Sheet;
* Fill in with specific data;
* Extract the ID (GID) of the spreadsheet;
* Integrate the spreadsheet into the Nemu platform for ad tracking.

***

## Steps to Follow

### Step 1: Create a Copy of the Spreadsheet

1. Open your Google Drive and locate the original spreadsheet.
2. In the top menu, click on **File → Make a copy...**
3. Name your new spreadsheet (e.g., "My Integrated Spreadsheet") and choose where to save it in Drive.

***

### Step 2: Open the Copy

1. Access Google Drive.
2. Find the copied spreadsheet and open it.

***

### Step 3: Fill in the **Ads** Tab

In the open spreadsheet, navigate to the **Ads** tab and enter data in the columns:

| adsPlatform | cost\_ads | date\_ads  |
| ----------- | --------- | ---------- |
| kwai        | 100       | 2024-06-01 |
| kwai        | 50        | 2024-06-02 |

***

### Step 4: Extract the Spreadsheet ID (GID)

1. With the spreadsheet open, look at the URL in the address bar.
2. After `gid=`, copy the numeric value present in the URL.

Example:\
`https://docs.google.com/spreadsheets/d/1AbCdEfGhIJKlmnOPqRsTuvWxYz/edit#gid=123456789`

In this case, the GID is `123456789`.

***

### Step 5: Integrate in Nemu

1. In the Nemu dashboard, go to the **Integrations** settings.
2. Look for the integration with **Google Sheets**.
3. In the **Spreadsheet ID** field, paste the extracted GID.
4. Save the integration.

***

## ✅ Conclusion

By following these steps, you collect campaign investment data directly in your Nemu account, facilitating the tracking and analysis of ad performance.