Import From Google Sheets

To set up importing from Google Sheets, perform the following actions:

1. Create a GameTable object (right click on Project window then Create / Game Tables / Game Table).
2. Set up the GameTable object properties:
   1. Choose Google Sheets in the Source dropdown.
   2. Copy the URL of a Google Sheets document into the Spreadsheet Id field. You can also paste just the id part here.
   3. If the specified document has a locale that’s differ from United States you have to change it in the File / Spreadsheet Settings menu in Google Sheets.
   4. If you’re connecting Game Tables to Google Sheets for the first time, you will be prompted to authorize in Google and grant Game Tables application read access to your documents. See Authorize In Google Sheets for details.
   5. Enter into the Search Path text box a path to the folder containing Prefabs the spreadsheet refers on. The path is specified relative the project root, for example Assets/Prefabs/Units.
   6. Optional. Specify additional settings that alter the way the table data should be interpreted. For example, you may choose whether to use object-per-row or property-per-row layout. For more see GameTable Inspector.
3. Click Apply Game Table.
4. Check the Console window. If everything gone well, it should contain a message like the following:

   Game Tables: modified 5 objects (of 5), 53 properties (of 88), 0 items removed

   If the Console contains any errors, fix their causes and then click Apply Game Table again.

5. Optional. Save all the changes made by Game Tables by clicking File / Save Project menu.