Currently if a user rearranges the order of the sheets in their migration spreadsheet, migrations break.

It would be nice to tie the specific sheet you're migrating to something less likely to be changed, like the sheet title.

Comments

mariacha1 created an issue. See original summary.

gcb’s picture

gcb
he/him
Location Portland, OR
commented

I can't find anything in the feeds that will actually provide a coherent list. The best I can find is that the sheet requests DO include "this sheet's name", so we could potentially add the name to our configuration and validate it as we pull information in.

duaelfr’s picture

duaelfr
he/him
Primary language French
Location Montpellier, France
commented

I found out a tutorial on Medium to figure out what to do: https://medium.com/@scottcents/how-to-convert-google-sheets-to-json-in-j...

In its third step it shows how to find the Worksheet ID (which is no more a simple integer). It seem to be possible by parsing the main document JSON to look for the sheet name in data.feed.entry[N].title.$t then get the sheet URL in data.feed.entry[N].id.$t.

karlshea’s picture

karlshea
he/him
Primary language English
Location Minneapolis 🇺🇸
commented
Status: Active » Closed (outdated)

v4 API uses sheet tab title as a string