google-sheet-to-notion

Load values from google sheet and convert to request body of notion.

Usage

Given data of google sheet. data SHOULD include the header line.

$id	title	$cover	$icon	property1	property2
deadbeef-deadbeef-deadbeef-deadbeef	A Title	https://example.com/cover.png	🎉	A property	1

Also, given databese of notion with properties.

• property1
  • Text
• property2
  • Number

The database can be created by Notion API with this parameters.

const properties = {
  title: { title: {} },
  property1: { rich_text: {} },
  property2: { rich_text: {} },
};

// notionClient.databases.create({ parent: { type: "page_id, page_id: "XXX" }, title: "A database title", properties });

With the properties, You can parse values as Notion-aware data by praseData.

// You can get data by `sheetsClient.spreadsheets.values.get`
const data = [
  ["$id", "title", "$cover", "$icon", "property1", "property2"],
  ["deadbeef-deadbeef-deadbeef-deadbeef", "A Title", "https://example.com/cover.png", ":tada:", "A property", 1],
];

const values = parseData({ data, schema: { properties } });
console.log(values);
// [
//   {
//     $id: "deadbeef-deadbeef-deadbeef-deadbeef",
//     $cover: "https://example.com/cover.png",
//     title: "A Title",
//     property1: "A property",
//     property2: 1,
//   },
// ];

You can create request body of Notion Page from a value by buildPageParameters.

const body = buildPageParameters( { data: ...values[0], schema: { properties }});

notionClient.pages.update(body);

When $id is present, buildPageParameters builds body for update. If $id is empty, you should assign schema.id or schema.database_id to build body for create.