Google Sheets
We read the rows of the spreadsheets you choose, such as registers, distribution logs and case lists.
Account sign-in
An example
| A | AM | AN | 37 more columns | |
|---|---|---|---|---|
| 1 | Name | 01/11/2026 | 08/11/2026 | |
| 24 | Mizan |
- AM27Read: attended
- Row 36Not read: a totals row
1. What it reads
The spreadsheets you pick. A register, names down and dates across, is read one tick at a time.
2. What it picks out
Cell AM27
Name: Vetri Date: 01/11/2026 Attended: ✓ Dorm: Woodlands
3. The record it makes
- Type
- Attendance
- Date
- 1 Nov 2026
- Programme
- English Classes
- Person
- P-0015
- Reads
- Every tab of the spreadsheets you pick.
- Leaves out
- Empty cells, marks like “absent”, the totals row, and columns of phone or ID numbers or donors' names.
- How often
- Every 30 minutes, and only when the sheet has changed.
- You need
- A Google account that can open the sheet. You pick it in Google's own file picker.
- When things change
- A deleted row stops counting. A corrected cell is read again. A renamed column is read as before.
Connect it, step by step
In Sources, pick Google Sheets, then Continue with Google.
Choose your account and allow read-only access to the files you choose.
Press Choose spreadsheets, then pick them in Google's picker.
Check its name and how many rows it holds, or ticks if it's a register. Press Continue.
Watch the first rows being read. You can close the page.
Where you'll see it
- Sources shows when it was last read, its rows and the records found. Press Change to pick more.
- Overview counts attendances and people served. Open a number to see the row, with its tick highlighted.
- People lists each learner as a code, with the spellings seen.
- Review asks “Same person?” when a name is written two ways.