Technology Subset

Embed Google Sheets Charts in Notion without 3rd Party Tools – Technology Subset

The other day, I was searching for some ways to embed Google Sheets Charts in Notion because just copy-pasting the chart link wasn’t working.

But… I finally got it done.

In this post, I will explain how to add charts from Google Sheets in Notion without using any 3rd party tools.

Embed Google Sheets Charts in Notion

I will explain the entire process step-by-step so it becomes easier to follow. Below is the screenshot of the chart that I will be embedding in Notion:

Google Sheets Chart
The Google Sheets Chart that I will be embedding in Notion

#1 – Publish the Chart in Google Sheets

Foremost, open your Google Sheets document where the chart is and publish the chart. You can click on the little 3-dots on the top-right side of the chart and select the Publish chart option, as shown in the screenshot below:

Select Publish Chart Option

On the next screen, click the Publish button and select OK on the prompt popup, as shown in the screenshot below. And make sure, you don’t change other options in there.

Click Publish and Select Ok

On the next screen, it will show the embed URL that you have to copy to your clipboard.

Copy Published Link

Thereafter, move to the next step.

#2 – Embed the chart in Notion

After copying the embed link of the published chart, navigate to the Notion page where you want to embed the chart.

Embed a PDF block in Notion

In Notion, we will be using the Embed a PDF block for the task. Just type /pdf and select the Embed a PDF block; alternatively, you can also little + icon on the left side and select the Embed a PDF block.

After that, click on the Embed link option and paste the link that you copied from the Google Sheets chart, and click the Embed PDF button.

Select Embed Link option in the PDF block

It will take a few seconds and the chart will be embedded. You might need to resize the embedded area depending on the size of the chart.

Embed Google Sheets Charts in Notion
The final embedded chart

And just like that, the Google Sheets chart will now be embedded in your desired Notion page. The chart will be interactive too.

Note that, you will have to reload your Notion page for the chart to be updated. And it takes Google Sheets 2-5 minutes to publish the recent changes made to the data.

How to stop publishing Google Sheets chart

At some point, if you want to stop publishing the chart from Google Sheets, here’s what to do:

Stop Publishing Google Sheets Charts
  • Open the Google Sheets
  • Click on the Publish chart option, and
  • Click the Stop publishing button (see above screenshot)

After that, delete the embedded block in Notion and you’re done.

Related: Insert Blank Rows after Each Row in Google Sheets

Final words

It’s a bit unusual to be using the PDF embed block in Notion to publish Google Sheets charts. But it works!

If you get stuck anywhere in between, just me know in the comments below.

Also, kindly share the article with the people who you think might be interested in knowing this interesting trick.

Source link

Leave a Reply