> For the complete documentation index, see [llms.txt](https://docs.neodove.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.neodove.com/admin-portal/integrations/google-sheets-integration/integration-steps.md).

# Steps to integrate Google Sheets

Integrate your Sheets in just 2 minutes

## Steps:

***

1. **Log in** to your NeoDove account (<https://connect.neodove.com/login>)  &#x20;
2. &#x20;Go to the **Integrations** section, present on the left side-bar of your **screen**.

<figure><img src="https://2103666731-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MJasmeOMeAJhTVh0M75%2Fuploads%2FnoINXfuWnrCEe8lOZwUt%2FIntegration.png?alt=media&amp;token=ab2db7c7-1db2-4039-975c-2d81a323c108" alt=""><figcaption></figcaption></figure>

3. Once clicked, then click on the “**Google Sheet**” integration.

<figure><img src="https://2103666731-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MJasmeOMeAJhTVh0M75%2Fuploads%2Fu91CpW3rdcTYc1CC2XDh%2FGoogle%20Sheet.png?alt=media&amp;token=37377358-b7ff-4152-b083-d5252abf6933" alt=""><figcaption></figcaption></figure>

4. Then a **pop-up** will appear where you need to add the **URL** of your Google Sheet.

<figure><img src="https://2103666731-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MJasmeOMeAJhTVh0M75%2Fuploads%2FYIa7cnl94F4VXMLplRz9%2FGoogle%20Sheets.png?alt=media&amp;token=85bd545f-9cf4-44a4-a16c-13766bb63da4" alt=""><figcaption></figcaption></figure>

* **Where can you find the Google Sheet link?**

<figure><img src="https://2103666731-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MJasmeOMeAJhTVh0M75%2Fuploads%2FWF4Osk1RPuiTjYcJXVmD%2FG-Sheets.png?alt=media&amp;token=0fe192d3-fa9e-4129-8e42-225f76eada1f" alt=""><figcaption></figcaption></figure>

* Now paste the same link on **NeoDove** and then need to click on the "**Upload Google Sheet**" option.

<figure><img src="https://2103666731-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MJasmeOMeAJhTVh0M75%2Fuploads%2FHRPLetQQMUJnaT5EzDJ5%2FG-Sheet%20Link.png?alt=media&amp;token=969c6e8d-5e1b-4b11-bd8d-259ccd22ba2a" alt=""><figcaption></figcaption></figure>

5. Add the Google Account and link it with your NeoDove Account.

<figure><img src="https://2103666731-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MJasmeOMeAJhTVh0M75%2Fuploads%2FT1V4DRB4yW1Un2FX21xM%2FG-Sheet%20Id.png?alt=media&amp;token=47750f4a-3a34-40ba-ac83-fc5ce7b42dde" alt=""><figcaption></figcaption></figure>

6. Allow the **necessary permission** to NeoDove to link your account.

<figure><img src="https://2103666731-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MJasmeOMeAJhTVh0M75%2Fuploads%2FM4ckHJJVzxY3Y5lfKasK%2FG-Sheet%20Allow.png?alt=media&amp;token=8cb3c9a1-5ce7-4cec-a209-37121de7e26a" alt=""><figcaption></figcaption></figure>

7. Now after linking your Google Account, you have to **Select a campaign** in NeoDove for your Data.

* If you want to add all the leads into a **New Campaign**, then select the 1st option and set a campaign.
* If you have **already a campaign** for Google Sheet data, then select the second option and select your **existing campaign** from the dropdown.

<figure><img src="https://2103666731-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MJasmeOMeAJhTVh0M75%2Fuploads%2FnMjB5UYzneUZWE0EqFUX%2FUpload%20G-Sheet.png?alt=media&amp;token=ef0aec01-1322-406e-8709-64f95f48c0b6" alt=""><figcaption></figcaption></figure>

8. Then, map the **necessary fields of Google Sheet here in NeoDove**.

<figure><img src="https://2103666731-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MJasmeOMeAJhTVh0M75%2Fuploads%2FyTlApfDZYhPoM6SNmQzF%2FG-Sheet%20mapping.png?alt=media&amp;token=e15df518-ad2f-429b-a63d-a7feab346759" alt=""><figcaption></figcaption></figure>

* You have to **match** the fields against the same fields from the dropdown. Under dropdown you will get all the **options** of the fields you have in your Google Sheet as **columns**.
* You need to **map** “Contact Name” & “Contact Number”. All **other details** you have in your Google Sheet can be created with the lead **without mapping**.
* Then click on "**Submit**" and your leads will be uploaded into the campaign and **integration** is completed.

### How to get the new leads Synced of the integrated Sheet in NeoDove?

***

* **Just One Click:**  Go to the Integration Page of NeoDove and there you will see the **same added Integration** of your Google Sheet.&#x20;
* Go to the **Action button** (Three Dots) and client on **Sync.**

<figure><img src="https://2103666731-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MJasmeOMeAJhTVh0M75%2Fuploads%2FJiPl4PZbH1mmrQEPcgO2%2FSync%20G-Sheet.png?alt=media&amp;token=f47f1627-6e8e-4ee7-b232-4e5be32ccddc" alt=""><figcaption></figcaption></figure>

* **Your new leads will be synced into NeoDove.**
