You can create connections by going to /new-connection.
First you select the source spreadsheet > source sheet. You can choose from a file stored in Google Drive or OneDrive. You can also select an entire folder. If you select more than one sheet, it assumes you want to consolidate them.
Second choose the destination spreadsheet. Sheetgo will create a new sheet inside this spreadsheet that connects the source with the destination.
Lastly, choose from settings like automatic updates or the connection name. The name of the connection becomes the future name of the sheet which is going to be created. You can also define a filter to only select the data that you need. If you are familiar with SQL, you can use a query. If you want to append your data, you can find the setting there.