Basic Results Generator
Creates separate study result Views. Suitable when Pre and Post assessments do not need to be combined into one participant row.
Google Sheets & Apps Script
Use the BlitzTrials spreadsheet tools to receive Google Form results, create clean reporting tables and prepare your study data inside your own Google workspace.
Start with the step-by-step tutorial
The main tutorial explains which spreadsheet edition to use, how to make a copy, authorise the script, create a study, obtain the MAGIC link and troubleshoot setup.
Choose your spreadsheet template
Pre/Post Longitudinal Generator
Combines Pre, Post 1, Post 2 and later assessments using Participant ID or verified email, with missing and duplicate attempt flags.
You do not need to sign in to BlitzTrials again from this page. Google may still ask you to sign in or authorise Apps Script using the Google account that will own or manage the spreadsheet and Form.