# Connect to Google Sheet

1. Navigate to Add Collection Page by clicking Add New Collection

<figure><img src="https://3534133090-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FG93O6Idiv5yQuWPEL8mh%2Fuploads%2FeXqDAs490AJPSvjUM5lP%2FScreenshot%202023-08-05%20at%2011.03.17%20AM.png?alt=media&#x26;token=64e9ddde-a208-4218-911a-a13624c33e78" alt=""><figcaption><p>You can find the button at the side menu</p></figcaption></figure>

2. Find the Google Sheet Integration Item

<figure><img src="https://3534133090-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FG93O6Idiv5yQuWPEL8mh%2Fuploads%2FTctM9gERQguuyMCq3TvQ%2FScreenshot%202023-08-05%20at%2011.01.12%20AM.png?alt=media&#x26;token=4a2ed585-917a-492e-96d6-f1be00917fb3" alt=""><figcaption><p>It's under 3rd Party Integration</p></figcaption></figure>

3. Find the instruction and enter the detail for your spreadsheet

<figure><img src="https://3534133090-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FG93O6Idiv5yQuWPEL8mh%2Fuploads%2FRO0FSQeOZmj53B1YBjCT%2FScreenshot%202023-08-05%20at%2011.06.44%20AM.png?alt=media&#x26;token=57dfae49-f889-48e8-b663-73fb0fd7c452" alt=""><figcaption></figcaption></figure>

4. Copy the service account email and add it as your editor in your spreadsheet

To put it simply, a [service account](https://cloud.google.com/iam/docs/service-account-overview) is an account used by computer to access information in Google. By adding our service account (which is managed by Google Cloud) to your spreadsheet, you are connecting your spreadsheet with our platform which is secured by Google Cloud.&#x20;

<figure><img src="https://3534133090-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FG93O6Idiv5yQuWPEL8mh%2Fuploads%2FbdKne2afYfY1OgJ7Gta4%2FMy%20Movie%202.gif?alt=media&#x26;token=3572e268-3f58-4f14-b60b-919b61bcd38c" alt=""><figcaption><p>You just have to paste the email onto the input field</p></figcaption></figure>

5. Copy the spreadsheet URL, sheet name, data range back to Connectome

<figure><img src="https://3534133090-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FG93O6Idiv5yQuWPEL8mh%2Fuploads%2FWL13hDo2VbDqQGKmQkS4%2FScreen%20Recording%202023-08-05%20at%2011.24.03%20AM.gif?alt=media&#x26;token=981c81d8-bc32-4b37-9e40-24fde4ce41c3" alt=""><figcaption><p>Copy your spreadsheet url to Connectome</p></figcaption></figure>

**Sheet Name** can be found at the bottom of your screen

<figure><img src="https://3534133090-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FG93O6Idiv5yQuWPEL8mh%2Fuploads%2FCqQ1cKV2H8BuTcZwaKds%2FScreenshot%202023-08-05%20at%2011.54.41%20AM.png?alt=media&#x26;token=fb120fcb-b81f-4b42-a3fb-d097c5ab73a3" alt=""><figcaption></figcaption></figure>

**Data Range** indicates which range of data will you like us to access in Connectome. An example will be A:B if you want us to access all cells in column A and column B.

6. Press Next and you will be brought to the collection page linked to your spreadsheet!