> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://linkie.bio/help/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to set up Google Sheets for email collection

# How to set up Google Sheets for email collection

###### **Step-by-step guide on how to set up a Google spreadsheet for email collection**

Set up a Google spreadsheet in Linkie so new subscribers are saved automatically in one place. Before you start, make sure you have already [connected Google Sheets](https://linkie.bio/help/en/article/how-to-integrate-google-sheets-1qvto38/) to your Linkie page.

### Open collect emails

![](https://storage.crisp.chat/users/helpdesk/website/-/1/0/c/0/10c04ec9d8785f00/collect-emails-btn_1lqazq3.png =600x499)
Click **Collect emails** in the Linkie [playground](https://app.linkie.bio/playground).

### Create a new spreadsheet

![](https://storage.crisp.chat/users/helpdesk/website/-/1/0/c/0/10c04ec9d8785f00/step-4_een9q1.png =600x707)
Open the spreadsheet dropdown and select **Create a new spreadsheet**.

### Name the spreadsheet

![](https://storage.crisp.chat/users/helpdesk/website/-/1/0/c/0/10c04ec9d8785f00/step-5_16i5mna.png =600x597)
Type the spreadsheet name, then click **Create**.

### Save your changes

Click **Save** to apply the spreadsheet setup to your Linkie page.

### Open the spreadsheet in Google Sheets

Open your [Google Sheets](https://essentials.withgoogle.com/?o=hp&type=Sheets) account to view the spreadsheet created through Linkie.

Everyone who [subscribes](https://linkie.bio/help/en/article/how-to-subscribe-to-updates-on-a-linkie-account-1st0wey/) through your Linkie page will automatically be added to your Google spreadsheet as a list of emails.
---

### Things to note

* You can only access and manage spreadsheets created through Linkie. Spreadsheets created outside of Linkie cannot be accessed from Linkie.
* You can customize the invitation text sent to email subscribers to match your style and brand. Learn how in [this guide](https://linkie.bio/help/en/article/how-to-customize-the-invitation-text-114jvg8/).
* If you have not connected Google Sheets yet, follow [this guide](https://linkie.bio/help/en/article/how-to-integrate-google-sheets-1qvto38/) first.
