Help center

    Start for free Sign in search

      Get Started Add Content Billing FAQs

      Import data from Google Sheets

      Thy Nguyen

      Updated on April 18th, 2023

      Table of Contents

      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  
      1. 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.

      Was this article helpful?


      5 out of 5 found this helpful

      Still need some help?

      Contact Support