> For the complete documentation index, see [llms.txt](https://docs.big-brain.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.big-brain.co/apps/data-cleaning/data-cleaning-form/sources/google-sheets.md).

# Google Sheets

If you already have prospect data that you want to clean, you can use the Google Sheets source to import the list of contacts into Big Brain. Simply select "Google Sheets" as a source and import your prospect data. &#x20;

<figure><img src="/files/I8xgxSsKzRtrhOSdausc" alt=""><figcaption><p>Google Sheets Import</p></figcaption></figure>

#### List Name

Your list name when using Google Sheets as a source in Big Brain must be an **exact match** to the List column in the Google Sheet.&#x20;

<figure><img src="/files/fQA1pxwoUKcmBXm9sjS5" alt=""><figcaption><p>List in Google Sheets</p></figcaption></figure>

<figure><img src="/files/CeeBDbIOOlJJvYVCMQql" alt=""><figcaption><p>List in Big Brain</p></figcaption></figure>

#### Public Google Sheet URL

A Google Sheet will automatically be created for your Big Brain account. Open this Sheet and import your prospects.&#x20;

{% hint style="info" %}
You must make the data you are importing line up with the existing columns. Do not replace the Spreadsheet.
{% endhint %}

{% hint style="info" %}
You can replace the default Google Sheet URL provided with a new Google Sheet, but you must set the share options to Publicly Editable.&#x20;
{% endhint %}

#### Create a Sync

If you check this box, Big Brain will watch the Google Sheet for new prospects on a daily basis. You can add new prospects to the bottom of the Sheet and your data cleaning setup will automatically be applied to new prospects. If you leave this checkbox blank, we will import prospects one-time, but won't re-check the Sheet for new prospects until you submit the Data Cleaning form again.&#x20;
