Updated on June 10, 2026easy, ~2 min
How to Embed Google Sheets in Notion (Live Data)
There are two ways to embed Google Sheets in Notion. For a clean, read-only table, go to File → Share → Publish to web in your sheet, copy the link, and paste it into a /embed block. For the full spreadsheet interface, set sharing to "Anyone with the link" and embed the share URL instead. Both stay live — edits in the source sheet show up in Notion after a short delay.
Why embed Google Sheets in Notion?
- Show a live budget, roadmap, or tracker that updates itself.
- Keep heavy spreadsheet logic in Sheets while surfacing the result in Notion.
- Share read-only data with a team without exporting static screenshots.
How to embed Google Sheets in Notion
Open Publish to web
In Google Sheets go to File → Share → Publish to web. This creates a public, read-only web version of the data — separate from the editable file, and it stays online until you click "Stop publishing" in the same dialog.
Choose what to publish
Pick "Entire document" or a single sheet/tab. Leave the format as "Web page". Keep "Automatically republish when changes are made" ticked (it's under Published content & settings) unless you want a frozen snapshot.
Publish and copy the link
Click Publish and confirm. Copy the link it gives you (ending in /pubhtml). This is the URL Notion will embed. Viewers will see your values, formatting, and charts — but not your formulas, and there is no toolbar.
Embed it in Notion
Type /embed on a Notion page, press Enter, paste the published link, and click "Embed link". Resize as needed.
Alternative: embed the share link instead
If you want the full Sheets interface — tabs, toolbar, even inline editing — click Share on the sheet, set General access to "Anyone with the link", copy that link, and embed it in the same /embed block. Anyone viewing the Notion page in a browser where they're signed into Google (with edit access) can edit the sheet right inside Notion. It looks busier than the published version, so use it for working documents, not dashboards.
Good to know
- Publish to web makes the data visible to anyone with the URL — never publish sensitive sheets. The published copy stays live until you explicitly click "Stop publishing", even if you later restrict the file's sharing settings.
- The published embed is read-only and stripped down: viewers see cell values, formatting, and charts, but formulas and the Sheets toolbar are hidden.
- Republishing isn't instant — Google notes automatic updates "might take a few minutes" to reach the published version, so the Notion embed can briefly lag the source sheet.
- Pasting the sheet's /edit URL while access is restricted shows visitors a Google sign-in or "request access" screen instead of your data. This also bites in Notion's desktop app, which has no Google session — test your embed in an incognito browser window to see what others see.
- The published "Web page" format isn't responsive: very wide sheets scroll horizontally inside the embed, and the table can be hard to read on phones.
Frequently asked questions
Will the embedded sheet update automatically?
Yes, as long as "Automatically republish when changes are made" stays enabled. Google's own docs note the update can take a few minutes, so don't worry if Notion briefly shows older values.
Can I edit a Google Sheet inside Notion?
Yes — with the share-link method. Embed the sheet's share URL (General access: "Anyone with the link", role Editor) and open the Notion page in a browser where you're signed into Google. Published /pubhtml links are always read-only, and the Notion desktop app can't edit either, because it has no Google login session.
Can I embed a private Google Sheet in Notion?
Not really. Publish to web requires making the data public, and a restricted share link shows everyone else a "request access" screen. For private data, keep the numbers in a Notion database or paste a static export instead.
How do I embed only one tab instead of the whole spreadsheet?
In the Publish to web dialog, switch the dropdown from "Entire document" to the specific sheet before publishing. Power users can go further: published URLs accept gid (tab id) and range parameters, so you can embed a single tab or even a specific cell range like A1:D10.
Can Notion pull Google Sheets data into a database?
No — an embed only displays the sheet; Notion can't filter or query it. For a one-time move, export the sheet as CSV and import it (Settings → Import → CSV). For ongoing sync, you need a connector like Sync2Sheets or Zapier between Sheets and a Notion database.
Why does the embedded sheet look different from the real one?
The published version is a simplified web page by design: no toolbar, no formula bar, no row/column headers unless you request them. Your values, number formatting, and charts carry over — the editing chrome doesn't.
Need a widget that doesn’t exist yet?
Describe it in plain English and generate a custom Notion widget with a stable embed link — no code required.
Create a widget