How to use the Google Sheets Integration
In this article, you will learn how to use Cogniflow models from Google Sheets.
First, open the following link: Cogniflow Apps Script project
Click on Overview in the sidebar.
![Open project](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/1image16_1jgnmzv.png)
Then, click on Make a copy button.
Please allow pop-ups and redirects if you see a warning from your browser.
![Copy Project](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/2image1_a2mgi6.png)
After a few seconds, a new tab will open with the newly copied project called "Copy of Cogniflow". Then click on Deploy -> Test deployments
![Test Deploy](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/3image12_1mtt3cg.png)
You will see a pop-up window. Now click on the Select type icon, and then select Google Workspace Add-on
![Test deployment type](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/4image5_res398.png)
Click on Install, and then Done.
![Deploy Install](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/5image4_ezdob5.png)
Great. Now open a spreadsheet, and you will see the Cogniflow Add-on on the side panel at the right:
![Open Cogniflow Add-on](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/6image17_svb9j1.png)
Open Cogniflow Add-on. The first time you need to:
Click on Authorize Access.
Select your Google Account.
![Authorize Access](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/7image13_1cdh48j.png)
If you see the following alert, please click on Advanced and then on Go to Copy of Cogniflow.
![Authorize Access 2](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/8image3_w8mbvr.png)
Finally, click on Allow to start using the add-on.
![Allow](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/9-allow-image8_722jfq.png)
Click the play button to open Cogniflow.
![Open Cogniflow](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/10-start-image9_1isacbe.png)
In case you are logged into a different account after giving permissions, which does not allow you to start the add-on. Try logging out of all your accounts and then log in to the one you want.
Now you will see the login screen. Enter your credentials to continue:
![Login](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/11-login-image11_1woakla.png)
Once authenticated, you can see all the models/experiments allowed to be used from Google Sheets:
![My Experiments](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/12-my-experiments-image19_7dpglp.png)
Great! Now you can select the experiment you want to use.
This is an example of executing a public experiment to automatically identify the language of the text in the first column:
First, open the following link: Cogniflow Apps Script project
Click on Overview in the sidebar.
![Open project](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/1image16_1jgnmzv.png)
Then, click on Make a copy button.
Please allow pop-ups and redirects if you see a warning from your browser.
![Copy Project](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/2image1_a2mgi6.png)
After a few seconds, a new tab will open with the newly copied project called "Copy of Cogniflow". Then click on Deploy -> Test deployments
![Test Deploy](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/3image12_1mtt3cg.png)
You will see a pop-up window. Now click on the Select type icon, and then select Google Workspace Add-on
![Test deployment type](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/4image5_res398.png)
Click on Install, and then Done.
![Deploy Install](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/5image4_ezdob5.png)
Great. Now open a spreadsheet, and you will see the Cogniflow Add-on on the side panel at the right:
![Open Cogniflow Add-on](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/6image17_svb9j1.png)
Open Cogniflow Add-on. The first time you need to:
Click on Authorize Access.
Select your Google Account.
![Authorize Access](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/7image13_1cdh48j.png)
If you see the following alert, please click on Advanced and then on Go to Copy of Cogniflow.
![Authorize Access 2](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/8image3_w8mbvr.png)
Finally, click on Allow to start using the add-on.
![Allow](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/9-allow-image8_722jfq.png)
Click the play button to open Cogniflow.
![Open Cogniflow](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/10-start-image9_1isacbe.png)
In case you are logged into a different account after giving permissions, which does not allow you to start the add-on. Try logging out of all your accounts and then log in to the one you want.
Now you will see the login screen. Enter your credentials to continue:
![Login](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/11-login-image11_1woakla.png)
Once authenticated, you can see all the models/experiments allowed to be used from Google Sheets:
![My Experiments](https://storage.crisp.chat/users/helpdesk/website/447a0bfe5ea4e800/12-my-experiments-image19_7dpglp.png)
Great! Now you can select the experiment you want to use.
This is an example of executing a public experiment to automatically identify the language of the text in the first column:
Updated on: 12/10/2022
Thank you!