【SEO】Google Search Consoleの「検出 - インデックス未登録」を18記事分解消した全手順

https://example.com/blogs/328a0ffb73d1813eacd7f8a0ee759f1a
https://example.com/blogs/328a0ffb73d181429677ece0e30e193a

const slug = richTextToPlain(props.Slug?.rich_text || []);
const id = slug || page.id.replace(/-/g, '');
// Slugがなければpage IDがそのままURLになる

curl -s -X POST \
  "https://api.notion.com/v1/databases/${DATABASE_ID}/query" \
  -H "Authorization: Bearer ${NOTION_API_KEY}" \
  -H "Notion-Version: 2022-06-28" \
  -H "Content-Type: application/json" \
  -d '{"page_size": 100}' | python3 -c "
import json, sys
data = json.load(sys.stdin)
for page in data['results']:
    props = page['properties']
    title = ''.join(
        t['plain_text']
        for t in props.get('Title',{}).get('title',[])
    )
    slug_arr = props.get('Slug',{}).get('rich_text',[])
    slug = ''.join(t['plain_text'] for t in slug_arr)
    if not slug:
        print(f'{page[\"id\"]} | {title}')
"

set_slug() {
  local page_id="$1" slug="$2"
  curl -s -o /dev/null -w "%{http_code}" \
    -X PATCH "https://api.notion.com/v1/pages/${page_id}" \
    -H "Authorization: Bearer ${NOTION_API_KEY}" \
    -H "Notion-Version: 2022-06-28" \
    -H "Content-Type: application/json" \
    -d "{\"properties\":{\"Slug\":{\"rich_text\":[{\"text\":{\"content\":\"${slug}\"}}]}}}"
}

set_slug "[page-id-1]" "notion-api-blog-system-nextjs"
set_slug "[page-id-2]" "cloudflare-pages-ssr-66x-speedup"

import { Metadata } from 'next';

const siteUrl = process.env.SITE_URL || 'https://example.com';

export async function generateMetadata({
  params,
}: {
  params: Promise<{ categoryId: string; pageId: string }>;
}): Promise<Metadata> {
  const { categoryId, pageId } = await params;
  const category = await getCategoryDetail(
    decodeURIComponent(categoryId)
  ).catch(() => null);
  const name = category?.name
    || decodeURIComponent(categoryId);
  const title = `${name}の記事一覧${
    Number(pageId) > 1 ? ` (${pageId}ページ目)` : ''
  }`;
  const description =
    `${name}に関する技術記事の一覧です。`;
  const url =
    `${siteUrl}/categories/${categoryId}/page/${pageId}`;

  return {
    title,
    description,
    alternates: { canonical: url },
    openGraph: {
      title, description, url, type: 'website',
    },
    twitter: { card: 'summary', title, description },
  };
}

import json, time, base64, urllib.request
import subprocess, tempfile

with open('/tmp/sc-auth.json') as f:
    sa = json.load(f)

header = base64.urlsafe_b64encode(
    json.dumps({"alg":"RS256","typ":"JWT"}).encode()
).rstrip(b'=')
now = int(time.time())
claims = {
    "iss": sa["client_email"],
    "scope":
      "https://www.googleapis.com/auth/indexing",
    "aud": sa["token_uri"],
    "iat": now, "exp": now + 3600
}
payload = base64.urlsafe_b64encode(
    json.dumps(claims).encode()
).rstrip(b'=')

# opensslで署名
with tempfile.NamedTemporaryFile(
    mode='w', suffix='.pem', delete=False
) as kf:
    kf.write(sa["private_key"])
    key_file = kf.name
sign_input = header + b'.' + payload
result = subprocess.run(
    ['openssl','dgst','-sha256','-sign',key_file],
    input=sign_input, capture_output=True
)
signature = base64.urlsafe_b64encode(
    result.stdout
).rstrip(b'=')
jwt_token = (
    header + b'.' + payload + b'.' + signature
).decode()

data = urllib.parse.urlencode({
    'grant_type':
      'urn:ietf:params:oauth:grant-type:jwt-bearer',
    'assertion': jwt_token
}).encode()
req = urllib.request.Request(
    sa["token_uri"], data=data
)
resp = urllib.request.urlopen(req)
access_token = json.loads(
    resp.read()
)['access_token']

TOKEN=$(cat /tmp/sc-token.txt)
for slug in \
  "notion-api-blog-system-nextjs" \
  "cloudflare-pages-ssr-66x-speedup" \
  "microcms-to-notion-api-migration"; do
  curl -s -X POST \
    "https://indexing.googleapis.com/v3/\
url Notifications:publish" \
    -H "Authorization: Bearer ${TOKEN}" \
    -H "Content-Type: application/json" \
    -d "{\"url\":\"https://example.com/blogs/${slug}\",\
\"type\":\"URL_UPDATED\"}"
done