Spreadsheets are a common way for teams to store data sets from any source. Notion for Google Sheets lets teams and team leaders import their historical data from Google Sheets so they can begin to better collaborate and visualize their metrics.

Get the add-on

To get the Google Sheets for Notion add-on, visit the Chrome Store and add the importer to your Google Sheets account.

Import your data

Once you have the add-on installed, open the spreadsheet you plan to import data from. Choose "Notion for Google Sheets" from the Add-On dropdown in the Sheet and choose "Open Notion Sidebar."

With Notion for Google Sheets, you will import one "ingredient" at a time by choosing a row or column of data and the corresponding dates. You will be able to add your ingredients to formulas you create in Notion and easily visualize the data on dashboards or reports.

With the sidebar open, select one row or one column of data to import. Choose "Set" in the sidebar when you have selected the correct data. Then, choose the corresponding row of dates and hit "Set" in the sidebar.

Next, choose "Create Ingredient" which will let you choose the name for your ingredient, and then add your data to an importing template. Check to make sure the data there is correct.

If everything looks good, make sure you've added your API Token from your Notion API page, and then click "Import Data" to create the ingredient in Notion.

Use your data

View your new ingredients in your Notion Directory and create a recipe to combine ingredients from Sheets or any other data source.