> ## Documentation Index
> Fetch the complete documentation index at: https://help.autoproctor.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Write Results to Google Sheets

> Set up automatic export of AutoProctor test results to Google Sheets so data flows in real time without manual downloads.

Instead of manually downloading Excel files after each test, you can configure AutoProctor to automatically write test results to a Google Sheet. Results appear in the sheet as candidates complete their tests, keeping your data current without any extra effort.

> [!NOTE]
>
> This is a **Premium Feature** and requires a Premium or Elite subscription. See [Payments and Credits](https://help.autoproctor.co/payments-and-credits.md) for plan details.

## Setup Instructions

**1. Create a Blank Google Sheet**

Create an empty Google Sheet in your Google Drive. You will use this sheet to receive AutoProctor results.

**2. Grant Write Access**

Share the Google Sheet with `hello@autoproctor.co` and grant **Editor** permissions. This allows AutoProctor to write data to the sheet.

> [!WARNING]
>
> If you do not share the sheet with `hello@autoproctor.co` as an Editor, AutoProctor cannot write results to it. Make sure you grant Editor access, not just Viewer. When a write fails for this reason, AutoProctor emails the test's admins to ask for access.

**3. Open the After the Test Section**

Go to your [**Tests**](https://www.autoproctor.co/test-admin/home/) page, click **Settings** next to the test, and choose **After the test** from the list of sections.

**4. Paste the Google Sheet Link**

Open the sheet, copy its address from your browser, and paste it into the **Send results to a Google Sheet** field. The address starts with `https://docs.google.com/spreadsheets/d/`.

Below the field, **Results go to sheet** followed by a short link confirms which sheet AutoProctor will write to.

**5. Save**

Click **Save settings**.

**6. Verify the Integration**

Complete a test attempt. A new sheet tab labeled **AutoProctor** automatically appears in your Google Sheet with the results data.

![Send results to a Google Sheet field holding a docs.google.com spreadsheet link. Below it, the hint reads Results go to sheet followed by the last characters of the sheet id and a Set-up help link](https://mintcdn.com/autoproctor/4bsvsaJCp4E0AK7P/images/write-results-to-google-sheets/send-results-to-sheet.png?fit=max\&auto=format\&n=4bsvsaJCp4E0AK7P\&q=85\&s=90d25b758dcb271d603c4dbda03d9455)

A sheet's link pasted into Send results to a Google Sheet, confirmed by the hint below it

Subsequent test attempts automatically populate the same Google Sheet without any additional setup.

> [!NOTE]
>
> The sheet link is read when a candidate **starts** an attempt. Attempts that started before you saved the link are not added to the sheet.

## Proctoring Must Be On

**Send results to a Google Sheet** works only with **proctoring on**. You turn proctoring on with the switch at the top right of the **Proctoring** section.

> [!WARNING]
>
> While proctoring is off, the field is disabled and nothing is written to the sheet. Saving the settings with proctoring off also removes the sheet link from the test. The sheet itself is untouched.

## What Gets Written

Every submitted attempt is added as one row in the **AutoProctor** tab.

| Column | Contents |
| - | - |
| **First Name** | The candidate's first name |
| **Last Name** | The candidate's last name |
| **Email** | The candidate's email address |
| **Trust Score** | The Trust Score of the attempt |
| **Evidence URLs (sample)** | Left empty. Open the Test Report URL to review the evidence |
| **Test Report URL** | A link to the proctoring report of the attempt |
| **Socratease Percentage Scored (%)** | The quiz score as a percentage. Socratease quizzes only |

## Socratease Quiz Integration

For Socratease Quizzes, the system writes both proctoring scores and quiz scores to the sheet. However, individual questions and answers are not included. Only aggregate scoring data appears.

> [!NOTE]
>
> If you need detailed question-level data for Socratease Quizzes, click **Results** next to the test on your [**Tests**](https://www.autoproctor.co/test-admin/home/) page and use the [individual submissions](https://help.autoproctor.co/access-candidate-responses.md) view instead.

## Related Resources

* [Export to Excel](https://help.autoproctor.co/export-results-to-excel.md) - Manually download results as a spreadsheet
* [Access Answers and Candidate Responses](https://help.autoproctor.co/access-candidate-responses.md) - View detailed per-candidate responses
* [Where Can I See My Quiz Results?](https://help.autoproctor.co/where-to-find-quiz-results.md) - Overview of quiz results vs. proctoring results
* [Payments and Credits](https://help.autoproctor.co/payments-and-credits.md) - Plan details and feature availability
* [Sharing Test Results](https://help.autoproctor.co/share-exam-results.md) - Grant other users access to test results


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.