Syncing Data from Google Sheets
People reshape spreadsheets all the time: they rename headers, move columns and insert new ones. A sync follows those changes instead of treating every changed header as a new column.
How columns are followed
- Each column is tagged. When you import, Mycorr stores a small tag on each column of the sheet. The tag stays with the column when it is renamed or moved, so the sync knows it is the same column and keeps its history and links.
- Tags are per table. Several Mycorr tables can track the same tab without getting in each other's way.
- Untagged columns (added in the sheet after import) are matched by position, and tagged at the next sync.
- Ranges inside a Sheets table (made with Format → Convert to table) are matched by header name instead, because deleting a column inside such a table shifts the cells without moving the tag.
When the tags and names don't settle it, Mycorr compares the values. For example, if one header disappeared and another appeared in its place, it counts as a rename only when the data agrees. Otherwise the old column is removed and a new one added.
How rows are followed
Rows are matched the same way as for every connection, by the table's primary key. See Row tracking and When a sync needs a decision.
Good practice
- Keep the header row and the table's position on the sheet stable.
- Prefer renaming a column to deleting it and adding a new one: the rename keeps the column's history and links.
- Take Checkpoint, then sync before a big restructure, so you can go back.