# Doc: https://www.hipaatizer.com/docs/integrations/google-sheets

> LLM view for https://www.hipaatizer.com/docs/integrations/google-sheets

This file contains all documentation content in a single document following the llmstxt.org standard.

## How to Integrate Google Sheets with HIPAAtizer: Step-by-Step Guide - HIPAAtizer

# Google Sheets

:::::warning[Please Note]
**Google Sheets is not HIPAA-compliant by default.**
Do **not** send fields containing [Protected Health Information (PHI)](https://www.hipaatizer.com/blog/understanding-protected-health-information-phi-and-hipaa-regulations/) to Google Sheets.

Covered Entities and Business Associates must ensure that no PHI is included when integrating with non-HIPAA-compliant tools.
👉 [Learn what counts as PHI](https://www.hipaatizer.com/blog/understanding-protected-health-information-phi-and-hipaa-regulations/)
:::::

---

## Share Your Spreadsheet with HIPAAtizer

1. Open your Google Spreadsheet and click **Share** in the top-right corner.
2. In the **Add people and groups** field, enter: ```hipaatizer-google-sheets-integ@hipaatizer.iam.gserviceaccount.com```

3. Set the role to **Editor**, then click **Send**.

![Share Spreadsheet](https://www.hipaatizer.com/docs/assets/images/2023-05-02_12-57-34-e71b6d94c1ec98de8580bc6a343791c7.png)
![Grant Editor Access](https://www.hipaatizer.com/docs/assets/images/2023-05-02_12-57-58-c53d607fa10fc3b2a5625f68ccc3349e.png)

---

## Authenticate Your Google Sheets Account

1. Click **Share** again and select **Copy link** to copy the spreadsheet URL.
2. In HIPAAtizer, go to **Integrations** → **Integrated Account**.
3. Select **Google Sheets**, then click **Authenticate your Google Sheets Account**.

![Integrations Menu](https://www.hipaatizer.com/docs/assets/images/2024-07-29_11-38-35-6f4a2346c14fa10f4127fbfa4ff05ec2.png)
![Authenticate](https://www.hipaatizer.com/docs/assets/images/2024-07-29_11-31-01__2_-77b3b1e466927e5c5c924d7fab3f5952.png)

---

## Link Your Form to Google Sheets

1. Navigate to **My Forms** in HIPAAtizer and click the **Settings** icon for the form you want to integrate.
2. Open the **Integrations** tab and choose **Google Sheets**.
3. Paste the copied spreadsheet URL into the **Spreadsheet URL** field.

![Paste URL](https://www.hipaatizer.com/docs/assets/images/2024-07-29_11-44-32-4d2c05242e539b856aec7a1f1ccd4198.png)
![URL Field](https://www.hipaatizer.com/docs/assets/images/2024-07-29_11-45-39-871065de4fe5649f8e34f49a03cd9877.png)
![Integration Settings](https://www.hipaatizer.com/docs/assets/images/2023-05-03_16-00-02-755fb8be3e54f60f1c3ca092e89baced.png)

---

## Configure Your Integration

1. Click **Show Sheets** to load available sheets.
2. Select the target sheet from the dropdown.

![Show Sheets](https://www.hipaatizer.com/docs/assets/images/2023-05-03_16-03-13-4efb238744251d02fcec6c8f5c299ca5.png)

3. Match your form fields to the columns in your spreadsheet using the dropdowns.

:::tip
Avoid mapping any fields that contain PHI.
:::

4. Use the **Add All** button to auto-map fields, then click **Save**.

![Field Mapping](https://www.hipaatizer.com/docs/assets/images/2023-05-03_16-04-19-30e9d5d98ad8f0d6028255724fc6bb46.png)
![Save Integration](https://www.hipaatizer.com/docs/assets/images/2023-05-03_16-05-23-75bcc17ec9084e52ae20bac80adc6a9d.png)