Embed Google Sheets in Notion | Sync Live Charts & Pivots

Last Modified: February 2, 2024 - 2 min read

Julian Alvarado

Integrating Google Sheets into Notion elevates productivity for teams and individuals in our increasingly data-driven world. 

Notion’s flexibility combined with the dynamic capabilities of Google Sheets revolutionizes how we manage and collaborate on projects.

In this blog, you’ll learn the step-by-step process of embedding Google Sheets into Notion, understand the benefits of this integration, and explore practical use cases. 

Why Embed Google Sheets in Notion?

By embedding Google Sheets in Notion, you bring data to the forefront of your workspace. 

Live charts and pivot tables, powered by Coefficient, transform data interaction, making it instantly accessible and actionable.

Step-by-Step Guide to Embedding Google Sheets in Notion

Note: In this guide, we are using a pre-existing chart created in Google Sheets. 

This approach assumes you have already set up your chart with the relevant data for your project.

Create Your Google Chart

Select the data in Google Sheets and generate a chart.

Create your Google Chart.

Selecting data in Google Sheets for Notion integration.

Click the ‘…‘ icon on the chart corner and choose ‘Publish chart’.

Creating a chart in Google Sheets.

On the ‘Link‘ tab, ensure ‘Interactive’ is selected.

Publishing the chart in Google Sheets.

Click ‘Automatically republish when changes are made’.

Choosing the embed option for the chart.

Click ‘Publish’.

Copying the embed link from Google Sheets.

Select ‘Ok’ from the dialogue window. 

Opening the desired page in Notion.

Copy the provided embed link.

spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

Using the embed command in Notion.

Embed in Notion

Log in to your Notion account and navigate to the page where you want to embed the chart.

Type ‘/embed’ to open the embed block.

Paste the copied link into the embed block.

Pasting the embed link in Notion.

Wait for the chart to load. 

Adjusting display settings for the embedded chart in Notion.

This may take a few moments, depending on the size and complexity of your chart.

Troubleshooting Common Issues

If you encounter issues, verify that your Google Sheet’s sharing settings are on ‘Anyone with the link can view’ and recheck the embed link. 

Conclusion

Embedding Google Sheets in Notion, especially with Coefficient’s help, transforms data management for B2B go-to-market teams.

It turns data into a real-time, actionable asset, boosting decision-making and operational efficiency.

Ready to revolutionize your data management process? Discover Coefficient today.

Set Spreadsheet Data on Refresh

Try the Spreadsheet Automation Tool Over 300,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 300,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Julian Alvarado Content Marketing
Julian is a dynamic B2B marketer with 8+ years of experience creating full-funnel marketing journeys, leveraging an analytical background in biological sciences to examine customer needs.
Google icon
300,000+ users on Google Marketplace
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies