Keep your sheets right: edit, re-sync, pause, fix

Once a sheet is running, LessonQ keeps it up to date on its own. This page is about the times you step in: adding your own notes, changing what a sheet holds, rebuilding it, pausing it, and fixing one that stopped.

In this video · 3:26

1. 0:00Your sheets
2. 0:33Your own columns
3. 0:55Edit items
4. 1:03Re-sync
5. 1:39Pause and resume
6. 1:58When it stops
7. 2:54Remove

Read the narration

1. 0:05Here is how to keep your sheets right once they are running.
2. 0:10Each sheet shows its status, its tabs, and how many rows were written.
3. 0:16If a row fails to write, it is counted here in red.
4. 0:21Open the menu, and click View details.
5. 0:26Its status, its tabs and columns, and Open in Google Sheets.
6. 0:34In the spreadsheet, you can add columns of your own, to the right of LessonQ’s.
7. 0:40Here, a “Called?” column. It stays with the right student, whatever changes.
8. 0:46Don’t type in LessonQ’s own columns: LessonQ writes them, and your edits would be replaced.
9. 0:53And put totals on a tab of their own, not under the rows.
10. 0:58To add or remove items, or change columns, use Edit items. Saving rebuilds the tabs.
11. 1:06Click Re-sync to rebuild the sheet from your LessonQ data.
12. 1:11Use it when rows have failed, after a pause, or after editing LessonQ’s columns by hand.
13. 1:18It says what it will overwrite,
14. 1:21and what it won’t touch: your own columns, and the row each record sits on.
15. 1:27Type the spreadsheet’s name to confirm, and click Re-sync.
16. 1:33Your “Called?” column is still there, next to the same student.
17. 1:39Pause stops writing to this sheet. Nothing in it is changed.
18. 1:45While it is paused, new records are not written, so the sheet falls behind.
19. 1:51Resume starts writing again. Re-sync afterwards to fill in what it missed.
20. 1:58Sometimes a sheet stops. Say someone changed LessonQ’s access in Google from Editor to Viewer.
21. 2:10Now a new student joins.
22. 2:14LessonQ can’t write her row. The sheet shows Error, with one row failed.
23. 2:20“The caller does not have permission” means the service account can no longer edit this spreadsheet.
24. 2:27To fix it, share the spreadsheet with the service account as Editor again.
25. 2:39Then Re-sync. The sheet is Active again, and the missing row is written.
26. 2:52If it says Reconnect needed instead, the key stopped working: replace it in Service account.
27. 2:59Remove stops a sheet. The rows already in your spreadsheet stay where they are.
28. 3:08And Disconnect, in Service account, removes the key and every sheet. Your spreadsheets stay.
29. 3:15More guides are at help.lessonq.com.

Before you start

• Who can do this: the academy owner and admins.
• Everything here is in Settings → Google Sheets, from each sheet’s ⋮ menu.

The sheets list

1. Status: Active, Paused or Error.
2. Rows: how many records were written. Rows that failed to write are counted under it, in red.
3. The ⋮ menu: View details, Open in Google Sheets, Edit items, Re-sync, Pause or Resume, and Remove.

View details shows a sheet’s status, its tabs and their columns, and Open in Google Sheets.

Your own columns

You can add columns of your own to the spreadsheet, to the right of LessonQ’s: a “Called?” column, notes, a fee you collected elsewhere. They stay next to the right record whatever changes, even after a re-sync.

1. Called?, a column of your own.

Three things to avoid:

• Don’t type in LessonQ’s own columns. LessonQ writes them; your edit is replaced the next time the row changes, or at the next re-sync.
• Don’t put totals under the rows. A re-sync clears anything below the records in LessonQ’s columns. Put totals on a tab of their own.
• Don’t delete the hidden ID column (the last of LessonQ’s). It’s how a record finds its row.

Change what a sheet holds: Edit items

Edit items opens the sheet’s three steps again: add or remove items, change the layout, leave columns out, set each tab’s filter. Save sheet rebuilds the tabs it writes.

Rebuild a sheet: Re-sync

Re-sync writes the whole sheet again from your LessonQ data. Use it:

• when rows have failed to write;
• after Resume, to fill in what came while the sheet was paused;
• after someone edited LessonQ’s columns by hand.

1. This will: rebuild every tab the sheet owns, clear anything below the synced rows, and blank the rows of records that no longer belong.
2. This will not touch: your own columns to the right, and the row each record already sits on.
3. Type the spreadsheet name to confirm, then click Re-sync.

Pause and resume

Pause stops writing to the sheet; nothing already in it changes. While it’s paused, new records aren’t written, so the sheet falls behind. Resume starts writing again, but doesn’t fill in what it missed: Re-sync after resuming.

1. Paused.

When a sheet stops

A sheet that can’t be written to shows Error, with the reason under its name and the failed rows counted in red.

1. Error.
2. The reason, as Google gives it.
3. 1 failed: a record that wasn’t written.

What it says	Why	What to do
The caller does not have permission	The service account can’t edit the spreadsheet any more: it was set to Viewer, or unshared.	Share the spreadsheet with the share address as Editor again, then Re-sync.
Something about the spreadsheet or a range not being found	The spreadsheet, or one of its tabs, was deleted or renamed in Google Sheets.	Restore it (a deleted spreadsheet is in Google Drive’s bin) and Re-sync, or Remove the sheet and add it again.
This sheet uses an older column layout	LessonQ’s columns changed since the sheet was set up.	Re-sync.
Reconnect needed (at the top of the panel)	The key stopped working: it was deleted or disabled in Google Cloud.	In Service account, Replace key with a new key file.

After a successful re-sync the sheet is Active again, and the missing rows are written.

1. Active again.

Remove a sheet, or disconnect Google

Remove stops LessonQ writing to a sheet. The spreadsheet and the rows already in it stay as they are.

1. What Remove does, and doesn’t do.

Disconnect, in the Service account window, removes the key and every sheet at once. Your spreadsheets stay in your Google Drive. See Connect Google Sheets to LessonQ.