Open a Google spreadsheet. Start Sheetgo by going to the Add-ons menu at the top and click on "Sheetgo" > "Start". Once the sidebar is open, mouse over the green plus sign. Choose from three options:
- Import data into the current spreadsheet
- Export data from the current spreadsheet to another one
- Create a template system with the current spreadsheet being the master
Next, choose whether to connect, consolidate or append. Select the source (if import) or the destination (if export) from your Google Drive.
Now take a look at the settings. Connection name becomes the future sheet name of the imported data or the name of the sheet created in the destination spreadsheet if you choose export.
You can enable automatic updates or use a filter to only transfer a selection of data.