AutoProctor

⌘K
🚀 Getting Started
Adding Timer and Proctor to Google Forms
What do the different AutoProctor Settings mean?🤔
📑 Instructions
Instructions for taking a Timed Test⏱
Instructions for taking a Proctored Test
🙌 Best Practices
Things you *NEED* to know
Best Practices for Teachers🧑‍🏫
❗️ Errors
Error Using AutoProctor Add-On
📢 Announcements
Non-Google Forms Tests & Other Announcements
🔐 Account Information
How do I know the Usage of my Test Packs
The Test Packs I bought are not reflecting in my account
Invoices for Payments
How to cancel your AutoProctor Subscription
Test Reports
How to see details of Unsubmitted Tests
Automatically Write Test Results to Google Sheets
Consolidated Test Report
ℹ️ Misc
Adding Collaborators to your Tests
Archiving and Deleting Tests
How to add query arguments to IFrames on AutoProctor
Restricting the test based on email ID
Socratease Quiz
Overview
Quiz Settings
Demo Timed Socratease Quiz
Demo Proctored Socratease Quiz
AutoProctor for Hiring
Why we recommend Equip for Hiring
Docs powered by archbee 
7min

Automatically Write Test Results to Google Sheets

From the test report page on AutoProctor, you can export the results as an Excel file. But, you may also want the results to show up on a Google Sheet automatically because you can apply filters, etc to it. To do this, you can use our Automatically Write to Google Sheets feature. Note that this is a Premium Feature.

The video above shows how to use the feature. But, the main steps are:

  1. Visit the Test Settings for a new or existing test.
  2. Scroll down to the Advanced Settings where it says Google Sheets ID
  3. Create an empty Google Sheet on your Google Drive
  4. Give hello@autoproctor.co write access to the Sheet. That is, the hello@autoproctor.co account should be able to make changes to this sheet
  5. Copy the URL of the Google Sheet and Paste it on the Test Settings on AutoProctor.
  6. Create or Update the test.
  7. Take the test. After you finish the test, if you look at the Google Sheet, it should have created a new Sheet called AutoProctor. You should be able to see the data too.
  8. Subsequent Test Attempts should get populated too.
Updated 15 Sep 2021
Did this page help you?
Yes
No
UP NEXT
Consolidated Test Report
Docs powered by archbee