# Google Sheets
## Authentication
Follow the steps below to create a service account for your Google Cloud project and share your Google sheet through the \*\*\*\* service account key.
### Create a service account key
Follow the steps below:
1. Enable the [Google Sheets API](https://console.cloud.google.com/apis/library/sheets.googleapis.com) of your Google Cloud project.
2. Select **APIs & Services** > **Credentials** from the left panel.
3. Click **+ CREAT CREDENTIALS** > **Service account** to create a new service account.
4. Get a service account key:
1. Click the **Email** of the service account.
2. Click **KEYS** > **ADD KEY** > **Create new key**.
3. Select **JSON** as the key type.
4. Click **CREATE** to download it.
{% hint style="success" %}
Now the service account key, in a JSON format, is downloaded to your device. Make sure to keep it somewhere safe.
{% endhint %}
### Share your Google sheet
Navigate back to to [Google Sheets](https://docs.google.com/spreadsheets), and follow the steps below to share your sheet through the \*\*\*\* service account key.
1. Open the JSON file of the key.
2. Copy the value of `client_email`, which is an identity used for access management of your sheet.
3. Click **Share** at the top right and paste the copied `client_email` value to add a member with access.
4. Select **Editor** as the role and click **Send**.
{% hint style="success" %}
When you see the notification **Access updated**, you have authorized this service account to edit your sheet.
{% endhint %}
## Connect Google Sheets to Appizap
Follow the steps below:
1. Click **Data Sources** on Appizap homepage.
2. Click **New Data Source** on the top right. Note that this permission is restricted to workspace admins and developers.
3. Select **Database** > **Google Sheets** as the type.
4. Set its name and paste the whole content in the JSON flie of the key to **Service Account**.
5. Click **Save**, and you can check it in your data source library later.
6. To access and manipulate data in your app, you can fill in the **Spreadsheet** id and **Sheet Name** in a query editor as follows.
The available methods are **Read Data**, **Append Row**, **Update Row**, and **Clear Row**.
%20(1)%20(1)%20(1)%20.png)