How to Connect Notion to Google Sheets

Notion exports any database view to CSV in two clicks, which handles one-off requests. For anything that needs to stay current you go through the Notion API, and two things reliably break the first attempt: the integration has no access to your databases until you explicitly share each one with it, and every property comes back as a typed object rather than a value. This guide covers both, plus pagination and write-back.

The two-minute option: CSV export

Open the database as a full page, use the ••• menu, and choose Export with format CSV. Import into Sheets via File → Import. As with most tools, the export follows the current view, so its filters, sorts and hidden properties all apply. Sub-pages and page content are not included: you get the database properties, not what is written inside each page.

Notion to Google Sheets for free (Apps Script + API)

Create an integration at notion.so/my-integrations, choose your workspace, and copy the internal integration token (it begins ntn_ or secret_ on older integrations).

Now the step people miss. Creating the integration grants it access to nothing at all. Open the database you want to read, click •••, find Connections, and add your integration. Skip this and every request returns object_not_found as a 404, which looks exactly like a wrong database ID and sends people re-checking the ID for an hour.

Get the database ID from the URL of the database opened as a full page: it is the 32-character hex string before ?v=. The value after ?v= is the view ID and will not work.

1function importNotionDatabase() {2  const TOKEN = "ntn_XXXXXXXXXXXXXXXX";3  const DATABASE_ID = "a1b2c3d4e5f6a1b2c3d4e5f6a1b2c3d4";4 5  const headers = {6    Authorization: "Bearer " + TOKEN,7    "Notion-Version": "2022-06-28",   // required; omitting it returns 4008    "Content-Type": "application/json",9  };10 11  const pages = [];12  let cursor = null;13 14  do {15    const body = { page_size: 100 };   // 100 is the maximum16    if (cursor) body.start_cursor = cursor;17 18    const res = JSON.parse(UrlFetchApp.fetch(19      "https://api.notion.com/v1/databases/" + DATABASE_ID + "/query",20      { method: "post", headers: headers, payload: JSON.stringify(body),21        muteHttpExceptions: true }22    ).getContentText());23 24    if (res.object === "error") throw new Error(res.code + ": " + res.message);25 26    pages.push(...res.results);27    cursor = res.has_more ? res.next_cursor : null;28    if (cursor) Utilities.sleep(350);  // ~3 requests/second average limit29  } while (cursor);30 31  if (!pages.length) return;32 33  const columns = Object.keys(pages[0].properties);34  const rows = pages.map((p) =>35    columns.map((c) => readProperty(p.properties[c]))36  );37 38  const ss = SpreadsheetApp.getActiveSpreadsheet();39  const sheet = ss.getSheetByName("Notion") || ss.insertSheet("Notion");40  sheet.clearContents();41  sheet.getRange(1, 1, 1, columns.length).setValues([columns]);42  sheet.getRange(2, 1, rows.length, columns.length).setValues(rows);43}44 45// Every property is a typed object. Each type unwraps differently, which is46// why writing the property straight into a cell yields [object Object].47function readProperty(prop) {48  if (!prop) return "";49  switch (prop.type) {50    case "title":        return (prop.title[0] || {}).plain_text || "";51    case "rich_text":    return prop.rich_text.map((t) => t.plain_text).join("");52    case "number":       return prop.number;53    case "select":       return prop.select ? prop.select.name : "";54    case "status":       return prop.status ? prop.status.name : "";55    case "multi_select": return prop.multi_select.map((s) => s.name).join(", ");56    case "date":         return prop.date ? prop.date.start : "";57    case "people":       return prop.people.map((u) => u.name).join(", ");58    case "checkbox":     return prop.checkbox;59    case "url":          return prop.url || "";60    case "email":        return prop.email || "";61    case "relation":     return prop.relation.length;   // count; IDs are opaque62    case "formula":      return prop.formula[prop.formula.type];63    case "rollup":       return prop.rollup[prop.rollup.type];64    default:             return "";65  }66}

Run once to authorise, then add a time-driven trigger. Note the Notion-Version header is mandatory, not optional: requests without it are rejected outright. And relation properties return arrays of page IDs rather than titles, so displaying the related page's name means a second lookup per ID, which is why the example returns a count instead.

Limits: the API averages around three requests per second, Apps Script stops at six minutes, and page content (the body of each Notion page) requires separate block-level calls entirely.

The Brooked method

Brooked handles the cursor pagination and unwraps each property type into a plain column, including resolving relations to the titles of the pages they point at rather than leaving opaque IDs. Several databases can import into one spreadsheet on a single schedule.

Step 1: Install Brooked

Install Brooked from the Google Workspace Marketplace. Free tier includes 100 imports per month, no credit card required.

Step 2: Connect Notion and share the database

Choose Notion in Brooked and paste your integration token. Then share each database with the integration through its ••• → Connections menu. Brooked can only list databases that have been shared, so if the list looks empty this sharing step is almost always why.

Step 3: Schedule the refresh

Set the import to re-run hourly, daily or weekly. Since it re-reads the database rather than reacting to individual page events, edits made while an automation was failing still get picked up on the next run.

Brooked AI, Notion

Live

Ask anything about your Notion data…

Method comparison

Common use cases

• Roadmap reporting: roll a Notion project database into charts leadership reads in Sheets
• Content calendars: report on editorial pipelines without giving every stakeholder workspace access
• CRM-lite tracking: pull a Notion pipeline into a sheet to join against billing or product data
• Historical snapshots: schedule a daily import so you keep history Notion itself does not retain
• Cross-database reporting: combine several Notion databases into one table

Troubleshooting common issues

Related Articles

• How to Connect Monday.com to Google Sheets
• How to Connect Clockify to Google Sheets
• How to Connect ClickUp to Google Sheets

Frequently asked questions