Pull data from Google Sheet

[rcross]

It would be great if we could store/pull data for the cards from a Google Sheet (public available url of course). There would be less need to implement a lot of sophisticated features in the data editor if this was possible.

It would also be excellent if we could point the assets at at Google Drive folder (or other cloud storage). Using the filenames as the names. Right now, it seems the assets are the same across any deck, which doesn't seem correct unless there is more of a distinction between a project (with one or more decks) and a deck. Similarly, there is no ability to have a folder to organise assets (like one folder for icons and another for feature art). The ability to link to a google folder (and maybe cache it) would make all of that much easier.

[hristoiankov]

The desktop version of Cider supports writing to a project directory. In there all the card listings are saved as .csv files. Those can be opened up in any .csv editor like Google Sheet for editing. Once the project is reopened in Cider, it will pick up those changes. Ex. project structure: https://github.com/oatear/cosmic-apple-game So far my thinking is that tracking changes to a project and tagging versions is much easier and more robust if you save your project into a repository than to track separate files in Google Sheets. I will continue to reconsider it.

I originally segregated each deck to have its own assets. That was not a great experience when having to re-upload the same images for symbols used in different decks. I will think more on the multiple folder idea. There is however benefit in having a flat map of all the assets as they are available on one table and can be searched and filtered. Its also easy enough to hierarchically name the assets, ex. icon-health, feature-potion, location-forest.

[jonborchardt]

+1 I do this manually, and I believe it could be done like nandeck does it.

[jonborchardt]

Export a Google Sheet Tab to Cider

Steps

1. Prepare the Sheet

   • Share the Google Sheet in advance.
   • Copy the spreadsheet ID from the URL.
     Example:

     https://docs.google.com/spreadsheets/d/<spreadsheetID>/edit
     

   • If you have a tab, copy the tab ID (the gid value) for the specific tab you want.
     Example:

     https://docs.google.com/spreadsheets/d/<spreadsheetID>/edit?gid=<tabGid>
     

2. Close Cider

   • Make sure Cider is not running.

3. Download the Sheet as CSV

   • In your command line, run:

     curl -L "https://docs.google.com/spreadsheets/d/<spreadsheetID>/export?format=csv&gid=<tabGid>" -o <path-to-your-cider-project>/cards.csv

   • Replace:
     • <spreadsheetID> with the sheet’s ID.
     • <tabGid> with the tab’s gid.
     • <path-to-your-cider-project> with the path where cards.csv should be saved.

4. Reopen Cider

   • Restart Cider and it will load the updated cards.csv.

Note: Cider could give you a place to save these settings and a button to do the above for you while its running....