Google Export not refreshing

I've got a different issue with exporting changes to Google.

Everything worked like a charm yesterday when I uploaded my first 25 terms. The google spreadsheet opened after export and everything was there.

Today, I added another 75 terms in the editor, and then hit export to the same Google spreadsheet. The spreadsheet opened up just like yesterday, but none of the new terms from today were added. bummer.

I exported my source to a local csv file and all 100 terms are present. (sigh of relief)

So is there a bug in the refresh process, or maybe a setting in my Google drive that I need to change to get the latest export to replace what's on the Drive? For example, maybe Google always thinks the server copy is the latest version???

Or is export from i2 only a one-time feature, that is, it's not also export and replace?

I haven't used categories (yet), and there's no second spreadsheet.

However, I did create some terms that included returns to create some spacing, especially for bulleted lists. When I did the auto-translate, <br> was added automatically. I then replaced those with a return in each of the translations to re-establish the spacing. It looks great in the game, but maybe is tripping up the Google export?

Comparing yesterday's file to today's CSV, I don't think it's the return break since all the terms with them were in yesterday's google file.

What may be more interesting is the first missing term is a term from a different scene than what was successfully saved yesterday. So maybe that is related to the issue.

Still have not succeeded in exporting or importing from Google spreadsheet.

What's interesting is that I tried creating a new spreadsheet on GoogleDrive, and hitting refresh in the editor found it and the key easily enough. However, when I tried exporting, it just opened up the empty spreadsheet, which is essentially the same behavior as not updating an existing spreadsheet.

I tried quitting google drive on my laptop so it would only work via the browser in case their were dueling synch races happening but that didn't solve it.

So weird that I can still export to local csv, but can't send anything to a known google drive spreadsheet.

One thought is that the sharing permissions on the spreadsheet on the drive need to be set in a specific way, although I haven't yet found a combination that works. see attached screenshot




Also I tried importing a google drive spreadsheet, after updating some of my translations on the server, and the changes showed up but one of the term keys came back with a weird symbol stuck in it, and game no longer would switch languages. Further, under terms in the editor, where it normally showed a toggle list on the far right of nothing, everything, default, it was now showing nothing, everything, Sheet1

So it will also be good to learn if there are special steps to import the changes from the server back into the game so everything works like they did prior to export.