I have been using data linking with Google sheets for years and have loved it. However recently I noticed what I think is a change. In the past I would create a UID column in the google sheet and populate this with unique numbers. I would then select this column in the linked spreadsheet as the Reference Key so that each line of data in the imported copy of the sheet would retain the link back to the original google sheet. Changes in the google sheet would show up in the Lucid Diagram.
Now it appears that when I insert a new row in google sheets the linking jumps down by the same number of inserted rows. I.e. All of my in-diagram entities now show the wrong data points.
Also I am now unable to change the Reference Key Column in the linked data table in lucid.
Did something change to how lines are linked to google sheets?