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

# Google Sheets

This is a step-by-step guide on how to use Google Sheets Integration for syncing leads data on your Orimon.ai Chat-Bot.

{% embed url="<https://www.loom.com/share/f10c0912171d4ccdac06d6bb23408253?sid=9bdd4171-1e52-47a9-b613-578c4257c39f>" %}

1. Log in to [Dashboard](https://orimon.ai/login) using your Google account/manual signup
2. Once logged in, you should see an icon for your bot. Click on it to go to the bot's overview page.

<figure><img src="https://55912965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxUW02x9klXneNc1Bxtt6%2Fuploads%2FFggcGJj0csqUzA1brMeF%2FScreenshot%20from%202024-01-12%2012-41-48.png?alt=media&amp;token=14feb440-eb5a-4f7c-b6bc-521d473732fc" alt=""><figcaption></figcaption></figure>

3. On the overview page, you will see several tabs. Click on "**Settings**" -> "**LeadFlow** **Integrations**".

<figure><img src="https://55912965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxUW02x9klXneNc1Bxtt6%2Fuploads%2Fuwh8ymQ9dB5jdBAapLsu%2FScreenshot%20from%202024-01-12%2013-55-38.png?alt=media&amp;token=e0c3c589-cd67-47dc-b216-a49df1c2b51e" alt=""><figcaption></figcaption></figure>

<figure><img src="https://55912965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxUW02x9klXneNc1Bxtt6%2Fuploads%2F2uGvx3Ct0SJ48ZxM0fCZ%2FScreenshot%20from%202024-01-29%2011-56-27.png?alt=media&amp;token=f2260326-593b-4d04-a9fb-5be49d8d86ea" alt=""><figcaption></figcaption></figure>

Click on this option to navigate to a integrations page and click on "**Google Sheets**". You will see a page shown below.&#x20;

<figure><img src="https://55912965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxUW02x9klXneNc1Bxtt6%2Fuploads%2FROCnLL8shRVoOnRrFYsD%2FScreenshot%20from%202024-04-02%2017-14-50.png?alt=media&amp;token=dc04375c-44cb-432d-80d7-cf9409e58e5d" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
**Note** : *You must Log In to your <mark style="color:blue;">**G**</mark><mark style="color:red;">**o**</mark><mark style="color:yellow;">**o**</mark><mark style="color:blue;">**g**</mark><mark style="color:green;">**l**</mark><mark style="color:red;">**e**</mark> account to proceed, & integrate this feature with your chat-bot.*
{% endhint %}

Now, Go to your **Google Drive** and open the Google-Sheet you want to connect to your OrimonAI chat-bot, then copy its link and paste it below as shown.

<figure><img src="https://55912965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxUW02x9klXneNc1Bxtt6%2Fuploads%2FJFa1p7zwNRqoKeTlwxvC%2FScreenshot%20from%202023-10-13%2013-45-56-1.jpg?alt=media&amp;token=0e07d22a-e470-4668-bcb6-de622a8f5e08" alt=""><figcaption></figcaption></figure>

Now click on "**Connect**" to start the Integration process, after which you will be redirected to an authentication page as shown below.

<figure><img src="https://55912965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxUW02x9klXneNc1Bxtt6%2Fuploads%2F4OCdsv8YB0BHB7Yq8Xor%2FScreenshot%20from%202024-04-02%2017-27-30.png?alt=media&amp;token=a3cf785f-7793-42b0-bcc0-909bf28aa36b" alt=""><figcaption></figcaption></figure>

Click on "**Allow**" and that will automatically connect & sync your leads from OrimonAI to SalesForce.

Once the authentication is complete, you will see a page as shown below.

<figure><img src="https://55912965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxUW02x9klXneNc1Bxtt6%2Fuploads%2FdAl2Sy8fLcU04fiyb4Vf%2FScreenshot%20from%202024-04-02%2017-28-40.png?alt=media&amp;token=b12cc82a-15d6-4b5f-b344-60f6316a864f" alt=""><figcaption></figcaption></figure>