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.