---
description: >-
  In this page we show you how to setup Google sheets and also Directify to be
  used with Google sheets.
---

# 6. Setting up your Google Sheets for Leadsimporter

### 1. Setting up Google sheets and Leadsimporter

Create a new Google sheets, You can name it as you see fit.

1. Go to LeadsImporter page "API Settings".
2. If you are using "Directify", enable the toogle, if you are using only Google Sheets, skip to step 4.

<figure><img src="https://1940257904-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTSRJKeHPeoJbfG9BkjW3%2Fuploads%2F6hGmdZYV7rCt8nM0Huz5%2Fimage.png?alt=media&#x26;token=9620ceae-0f88-42a1-b7f5-4ff638b32259" alt=""><figcaption></figcaption></figure>

3. Add your directify website and click save.

<figure><img src="https://1940257904-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTSRJKeHPeoJbfG9BkjW3%2Fuploads%2Fgls4Fm0dkc4h9vwjR7wR%2Fimage.png?alt=media&#x26;token=5a19069b-1cb2-43e3-b5da-cd32667d9c10" alt=""><figcaption></figcaption></figure>

4. Copy the script using the "Copy to clipboard" and go to your Google sheet and navigate to "Extensions" and click "Apps script".

<figure><img src="https://1940257904-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTSRJKeHPeoJbfG9BkjW3%2Fuploads%2FZmMuM9OZONd2aNc5mRm8%2Fimage.png?alt=media&#x26;token=8b07a5a5-ac32-4d15-9a56-4a16ba211707" alt=""><figcaption></figcaption></figure>

4. Go to the script section and click in "Code.gs", a black canvas will appear.

<figure><img src="https://1940257904-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTSRJKeHPeoJbfG9BkjW3%2Fuploads%2F7QSX1kWOp7pSNZhTBKok%2Fimage.png?alt=media&#x26;token=a2bf169d-a386-49ec-9b1e-d20d4b8ba945" alt=""><figcaption></figcaption></figure>

5. Add the code copied from Leadsimporter.

<figure><img src="https://1940257904-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTSRJKeHPeoJbfG9BkjW3%2Fuploads%2FosUXDXlKprdsBslAEBvj%2Fimage.png?alt=media&#x26;token=626b8da5-bfbd-4b7c-8d79-ee15a63d7c14" alt=""><figcaption></figcaption></figure>

6. Go back to Leadsimporter and copy the Google sheets webhook.

<figure><img src="https://1940257904-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTSRJKeHPeoJbfG9BkjW3%2Fuploads%2FSzpA131af0BoZgsBU9uM%2Fimage.png?alt=media&#x26;token=8f079a87-bdb4-4fe9-bb44-e7db16c3f728" alt=""><figcaption></figcaption></figure>

7. Add it to the script in line 2 (Between the '' quotes).

<figure><img src="https://1940257904-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTSRJKeHPeoJbfG9BkjW3%2Fuploads%2FlAuX3lU7XePCl2G1helU%2Fimage.png?alt=media&#x26;token=6878f773-253d-4355-90d3-03780725763e" alt=""><figcaption></figcaption></figure>

8. Save by clicking the disk icon.

<figure><img src="https://1940257904-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTSRJKeHPeoJbfG9BkjW3%2Fuploads%2FOiyiakYIp0TUMHaBZDXh%2Fimage.png?alt=media&#x26;token=68fc55d3-b205-44b1-881b-7e31f8a1dd58" alt=""><figcaption></figcaption></figure>

9. If you have searched for listings already and imported to the temp database, you can click the "run" icon and the Google sheet should start to populate automatically. If no listings yet, please check step:

{% content-ref url="6.-setting-up-your-google-sheets-for-leadsimporter/6.1-importing-listings-to-google-sheets" %}
[6.1-importing-listings-to-google-sheets](6.-setting-up-your-google-sheets-for-leadsimporter/6.1-importing-listings-to-google-sheets)
{% endcontent-ref %}



<figure><img src="https://1940257904-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTSRJKeHPeoJbfG9BkjW3%2Fuploads%2FUtKf0IQklT8Ml6SQMm6x%2Fimage.png?alt=media&#x26;token=62a9f672-96b7-4c41-ad18-5fa5ad879b98" alt=""><figcaption></figcaption></figure>
