Connect your private Google Sheet
Approve Google access, choose your spreadsheet, and enable certificate links. No Apps Script deployment or connection key is needed.
1. Sign in to BlitzTrials
Use the same account you use to create your studies. This sign-in is separate from the Google permission requested in step 2.
Choose Google sign-in only if that is your usual BlitzTrials sign-in method. You can also open your normal sign-in page and return here.
2. Choose your Google spreadsheet
Approve the Google account that owns your spreadsheet. It can be different from your BlitzTrials sign-in account.
No spreadsheet selected yet.
Open selected spreadsheet3. Enable certificate links for your study
Choose one of your saved studies with a certificate enabled. If you have not saved your study yet, connect the Sheet first, then choose it from Saved spreadsheet in the study builder.
Connection complete
New participant certificates for the selected study use your private Sheet. Existing certificates retain their original storage. You can return to your Sheet and try a test participant.
Open study builderLoading your BlitzTrials sign-in...
BlitzTrials creates its managed certificate tabs without replacing your existing reporting or Form tabs. Hidden bookkeeping tabs are still accessible to spreadsheet editors; hiding is not a privacy control.