Skip to main content
Help Center

Import data from Google Sheets

Gridly Product Team
  • Updated

In this article:

Gridly supports the ability to sync data from Google Sheets to Gridly using our function - Gridly Connector. You can now connect your Google Sheet and import data directly to Gridly, without the need to export the files to CSV/XLSX files and re-import again. For other import options, please view these articles:

Open Gridly connector

Open Gridly, on the project page click on Integration settings. If you are in a Grid, click image1.png on the header to open Integrations, and switch to Gridly Connector. 

image2.gif

 

Create a Google Sheet source 

  1. Open Gridly connectors, on the Connections tab, click + New connection.
  2. Click Create a source. 
  3. Name your source, ideally something similar to your Google Sheet file name.
  4. Copy the Authorize Google account and share it to your Google sheet file. Addsource_final.gif
  5. Enter the ID of your spreadsheet in the SheetID field. You can find the spreadsheet ID in a Google Sheet URL:
     
    https://docs.google.com/spreadsheets/d/spreadsheetId/edit#gid=0  
  6. Click Save & check connection. image6.png

Connect Google Sheet source to a Grid

  1. Open Gridly connectors, on the Connections tab, click + New connection.
  2. Select the source you just created from the source list.
  3. Select the worksheet you want to import. image4.gif

If you have created a Grid

  1. Select where you want to import the data in Gridly: Select project, database and Grid.
  2. Gridly will attempt to map as many columns as it can Google Sheet with columns in the destination Grid, confirm and click Finish. image5.gif

If you do not have a Grid 

  1. If you have not created a new Grid: Select the project and database where you want to add the new Grid, click Add new Grid in the Grid fields. 
  2. Gridly automatically customizes the new Grid with data from the Google Sheet, click Create to confirm. 
  3. Give the connection a name, check the mapping to make sure the data will be imported correctly and make changes if needed and click Finish. image7.gif

Now, open your Grid and check if the data is imported successfully. Whenever the Google Sheet data is updated, you’ll just have to sync data to update the destination Grid. To sync data, open Gridly connector in the sidebar, click Sync now.


image3.png

 

Other than Google Sheet, Gridly connector also supports connecting Gridly to other data sources, such as MySQL and PostgreSQL. To learn more about Gridly connector, click here.

Related articles