In this article:

How to Connect Google Sheets to Notion (2023 Update)

May 8, 2024

How to Connect Google Sheets to Notion

To view your Google Sheets in real time within Notion, you can use the embed option. Here's how to do it: 

Step 1: Open Your Google Sheet

Navigate to Google Sheets and open the spreadsheet you want to embed.

Step 2: Get the Shareable Link

In the upper right corner of your Google Sheets interface, click on the "Share" button. A window will pop up.

google sheets to notion

 

Click on “Anyone with the link” if your sheet isn’t already set to be viewable by anyone with the link. 

connect google sheets to notion

Copy the link provided. This is the link to your spreadsheet that you will embed in Notion.

embed google sheets to notion

Step 3: Open Notion

Navigate to Notion and open the page where you want to embed the Google Sheet.

Step 4: Embed the Google Sheet

In your Notion page, click on the body where you want to embed the Google Sheet. Type "/embed" to bring up the embed block option and select it.

how to connect google sheets to notion

Paste the Google Sheet link you copied earlier into the URL field in the embed block.

how to embed google sheets to notion

Press "Embed Link." Notion will then process the link and embed the Google Sheet into your page.

import google sheets to notion

Step 5: Adjust the Embedded Sheet (Optional)

Once the Google Sheet is embedded, you can adjust its size by dragging the corners of the embed block. If needed, you can also reposition the embed block by dragging it to a new location on your Notion page.

We hope that this article has helped you and given you a better understanding of how to connect Google Sheets to Notion. If you enjoyed this article, you might also like our articles on how to perform a fuzzy match in Google Sheets and highlight distinct values in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->