To view your Google Sheets in real time within Notion, you can use the embed option. Here's how to do it:
Navigate to Google Sheets and open the spreadsheet you want to embed.
In the upper right corner of your Google Sheets interface, click on the "Share" button. A window will pop up.
Click on “Anyone with the link” if your sheet isn’t already set to be viewable by anyone with the link.
Copy the link provided. This is the link to your spreadsheet that you will embed in Notion.
Navigate to Notion and open the page where you want to 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.
Paste the Google Sheet link you copied earlier into the URL field in the embed block.
Press "Embed Link." Notion will then process the link and embed the Google Sheet into your page.
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.
