A Sheetgo connection is created when you transfer data from a source spreadsheet(s) to a destination spreadsheet.
With Sheetgo, you can connect Google Sheets, Excel, CSV and TSV files stored in Google Drive.
The best way to sync your files to Google Drive is to use Google's Backup and sync software.
For more guidance on syncing local files to Drive, check out these tips.
Create your first connection
- In the Sheetgo web app, click on + Create Workflow, then Start connecting. If you are using the Sheetgo add-on, open a Google Sheet and open the add-on from the menu bar. Click on the green + button then Import data.
- Select your data source: this is the source spreadsheet that you want to transfer (export) data from. Choose the file from Google Drive and then click on the blue Upload Files button.
- Now select the source tab (sheet) from inside that spreadsheet. This is the tab containing the data that you want to transfer (export).
- Select your data destination: this is the spreadsheet where you want to move the data to. In the web app, you can send the data to a new spreadsheet or choose an existing file. If you are using the Sheetgo add-on, by default, the data destination is the Google Sheet that you are currently using.
- Adjust the settings. Here you can schedule automatic updates, and filter the data you want to import.
- Click Save Connection to begin the data transfer. Look in your destination spreadsheet - you will see a new tab (sheet) has been created, containing the imported data.
Looking for more guidance? Check out our posts on how to upload Excel files to Google Sheets, How to convert Google Sheets to Excel automatically and how to automatically import CSV data to Google Sheets.