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
- Open your Google Drive and locate the original spreadsheet.
- In the top menu, click on File → Make a copy…
- Name your new spreadsheet (e.g., “My Integrated Spreadsheet”) and choose where to save it in Drive.
Step 2: Open the Copy
- Access Google Drive.
- 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)
- With the spreadsheet open, look at the URL in the address bar.
- After
gid=, copy the numeric value present in the URL.
https://docs.google.com/spreadsheets/d/1AbCdEfGhIJKlmnOPqRsTuvWxYz/edit#gid=123456789
In this case, the GID is 123456789.
Step 5: Integrate in Nemu
- In the Nemu dashboard, go to the Integrations settings.
- Look for the integration with Google Sheets.
- In the Spreadsheet ID field, paste the extracted GID.
- Save the integration.