# Do’s and Don'ts of Google Sheet Integration.

### Don'ts :- 

***

1. Keep your Sheet in **normal Google Sheet format** and NOT in .XLS format.

<figure><img src="https://2103666731-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MJasmeOMeAJhTVh0M75%2Fuploads%2FNjulNtgonlkC1VUh9b0e%2FGoogle%20Sheet%209.png?alt=media&#x26;token=b4103eff-cbdc-4b89-86da-743e69c7c433" alt="" width="563"><figcaption></figcaption></figure>

2. Don’t **apply** any formula on the headers or on the sheet where data is coming on the basis of the **formula**. Keep the sheet **clean**.
3. Keep the contact number in a **proper number format**. In one cell, keep only **one number** and not multiple numbers separated by commas.
4. **Avoid** giving gaps/blank cells in the **contact number column**, those leads will not be created.

<figure><img src="https://2103666731-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MJasmeOMeAJhTVh0M75%2Fuploads%2FhE1sEcQuh4BaAyzbWS71%2FGoogle%20Sheet%2010.png?alt=media&#x26;token=a6cee241-7bcb-459b-8d4c-557666cfb8dc" alt="" width="563"><figcaption></figcaption></figure>

5. Don’t keep any **Header** of the column **blank** where you have the **data**, in any tab of that sheet.
6. Avoid **deleting** any integrated rows of the sheet because neodove reads the rows of the google sheet at the time of **syncing** the data. Every time you sync **NeoDove reads** the row after the **last synced row** of the Sheet.&#x20;

### Do’s :-&#x20;

***

1. Keep your sheet in the **normal sheet format**.
2. Make sure that you have **access** to the particular sheet you want to **upload**.
3. Make sure that you have a **Phone number column** in your data because in NeoDove, without a number **lead** will not be created.
4. Make sure the contact number is in **normal number format**.