Google Sheets Connections


With the Google Sheets Connections feature, you are able to import and export data and results between SIMUL8 and Google Sheets. You will find the Google Sheets Connections on the Data and Rules tab. Select Google Sheets Connections and a window containing a list of all connections will appear. From this menu, you can create, edit and erase Google Sheets Connections, and use this window to perform the actual import and export of data.

New Connection

From the Google Sheets Connections window, select New; this will open the Google Connection Properties window. This is where you will set up the link to Google Sheets. For setting up this link, SIMUL8 should be granted access to your Google Account. Once you click New, you will be directed to a new Tab on Google Chrome, where you will be asked to grant permissions to SIMUL8.

Then, you will be provided with a code, which you should copy, and paste it when switching back to SIMUL8, in the Access Code window.

Please note that if you don’t check the “Keep me signed in” option, you will be asked to grant permissions every hour. After permissions are granted, you will be able to set your Google Sheets Connection’s Properties.

For telling SIMUL8 which Google Sheet to use for importing or exporting data, enter the Spreadsheet URL of your Google Sheet. If you then select Connect SIMUL8 will automatically connect to that Google Sheet and will populate a list of Sheet names that you have given access to. By then opening the Sheet Name dropdown, you can select the sheet you want to reference. When that is selected SIMU8 calculates the area that is populated by data.

The Internal Spreadsheet Settings determines what SIMUL8 spreadsheet you are using for importing/exporting. You can use the New button to create a new internal spreadsheet directly from the Google Sheets Connections Property menu.

The Data Flow section determines the flow of data, whether you are moving from SIMUL8 to Google Sheets, or Google Sheets to SIMUL8. You can also choose to clear the spreadsheets before import/export.

Advanced Settings

On the Advanced Settings tab, you can specify a data range for both the Google Sheet (on import) and Internal Spreadsheet (on export).

Once you have created your connection, choose OK to see your connection on the list.

Excel Connections List

Select the connection and click the Import/Export button to transfer the data.

For ease of use, once you have created connections, you can import/export multiple connections at once. To do this, navigate to the Data and Rules tab, and select Import All or Export All on the Google Sheets Connections section. The dropdown on each also allows you to import or export a specific connection without having to open the connections menu.