notion_newsletter_archive.ts

import { Client } from "npm:@notionhq/client@2";

const notion = new Client({ auth: Deno.env.get("NOTION_API_KEY") });

(async () => {
  const databaseId = "af3db26e54964a939c1f6bf32c79364e";
  const response = await notion.databases.query({
    database_id: databaseId,
    filter: {
      and: [
        {
          property: "Tags",
          multi_select: {
            contains: "newsletter",
          },
        },
      ],
    },
    sorts: [
      {
        property: "Created time",
        direction: "ascending",
      },
    ],
  });

  const results = response.results;

  results.map((x) => {
    notion.pages.update({
      page_id: x.id,
      archived: true,
    });
  });
})();