Connecting spreadsheets

A connection in Sheetgo is any time you link 2 or more spreadsheets together so that you can transfer data from one (source) to the other (destination). With Sheetgo you can connect Google Sheets, Excel, CSV, TSV, and ODS files stored in Google Drive. Below is a quick summary of how to create a connection 

Create your first connection 

  1. Click on the "plus" icon in your add-on or Web App. 
  2. Select the "Data source", the source spreadsheet where you want to transfer data from. Then select the sheet (tab) that you want to transfer.
  3. Select the "Data destination" (On Web App only), this is the spreadsheet where the data form the data source will be transferred to. On add-on the data destination is the spreadsheet that you are currently using.
  4. Click on the check mark.

Connection examples

Here are some examples of connections that you can create. Remember that all of these files must be in your Google Drive.

Google Sheet to Google Sheet

  • Source: Google Sheet
  • Destination: new or existing Google Sheet

Excel to Google Sheet

  • Source: Excel file
  • Destination: new or existing Google Sheet

CSV to Google Sheet

  • Source: CSV file
  • Destination: new or existing Google Sheet
Did this answer your question?