Write Results to Google Sheets

Sync assessment results to a Google Sheet automatically, in real time, as candidates complete each test.

Equip can write assessment results directly to a Google Sheet as candidates finish each test. The sync updates in real time, so you never need to re-export as more candidates complete the assessment.

	Google Sheets sync	Export to Excel
Freshness	Updates live as each test is completed	Snapshot at the moment you export
Effort	Set up once per assessment	Re-export every time you want new data
Best for	Ongoing hiring drives, shared live dashboards	Final reports once everyone has finished

Enabling the Sync

The setting lives in your assessment’s Settings tab, under Miscellaneous.

1. Create a Google Spreadsheet

   Create a new, empty spreadsheet in your Google account. This is where Equip will write the results.

2. Grant Editor access to [e-mail]

   Use the spreadsheet’s Share option to give Editor permission to [e-mail]. Equip needs this to create sheets and write rows.

3. Paste the spreadsheet URL in assessment settings

   Open the assessment’s Settings tab, find Write results to Google Sheets under Miscellaneous, and paste the spreadsheet URL.

4. Save the assessment

   Click Create/Update to save your settings. The sync is now active for all future attempts.

If [e-mail] does not have Editor permission on the spreadsheet, Equip cannot write to it. In that case, Equip emails the assessment creator asking them to enable Editor access.

What Gets Synced

Once candidates start attempting the assessment, Equip automatically creates one sheet per test plus an overall assessment sheet inside your spreadsheet. A candidate’s row is written as soon as they complete each test.

Sheet	Columns
Assessment sheet (overall)	Email, Name, Overall Score, Start Date, Start Time, End Date, End Time
Test sheet (one per test)	Email, Name, Points Scored, Percentage Scored, Trust Score, Start Date, Start Time, End Date, End Time

You can view a sample results spreadsheet to see exactly what the output looks like.

Give your assessment and each test a distinct title. The sheet names come from those titles, so distinct names make the spreadsheet much easier to read.

Troubleshooting

Most sync issues come down to a few known causes:

• Older attempts are missing. Only candidates who attempt the assessment after you set up the sync are written to the sheet. Results from earlier attempts do not appear retroactively; use Export Results to get those.
• The sync stopped working. Check that [e-mail] still has Editor permission and that the spreadsheet URL saved in assessment settings is correct.
• Rows stopped appearing after edits to the spreadsheet. Do not rename the sheets Equip creates, and do not change their column names. Equip relies on both to find where to write.

The Google Sheet is a convenient live view, not the source of truth. The full results, including per-question detail and proctoring evidence, always remain available on your Equip dashboard.

Related Resources

• Download Reports - Export results to Excel or PDF instead of a live sync
• Test Scores and Overall Score - How the scores written to the sheet are calculated
• Missing Results - Why a candidate might not appear in your results
• Webhooks - Push results to your own systems programmatically