Notion×スプレッドシート連携で二重管理をやめた設計(月のズレ0件に)

const NOTION_TOKEN = 'ここにNotion Integrationのシークレットを入れる';
const DATABASE_ID = 'ここに案件管理DBのIDを入れる';
const SHEET_NAME = '案件一覧(同期)';

function syncNotionToSheet() {
  const results = queryNotionDatabase_();
  const sheet = getOrCreateSheet_();

  sheet.clearContents();
  sheet.appendRow(['案件名', 'ステータス', '金額', '締切', 'Notionリンク']);

  results.forEach(page => {
    const props = page.properties;
    const name = props['案件名']?.title?.[0]?.plain_text || '';
    const status = props['ステータス']?.status?.name || '';
    const amount = props['金額']?.number ?? '';
    const deadline = props['締切']?.date?.start || '';
    const url = page.url;

    sheet.appendRow([name, status, amount, deadline, url]);
  });
}

function queryNotionDatabase_() {
  const url = `https://api.notion.com/v1/databases/${DATABASE_ID}/query`;
  const response = UrlFetchApp.fetch(url, {
    method: 'post',
    headers: {
      'Authorization': `Bearer ${NOTION_TOKEN}`,
      'Notion-Version': '2022-06-28',
      'Content-Type': 'application/json'
    },
    payload: JSON.stringify({})
  });
  const json = JSON.parse(response.getContentText());
  return json.results;
}

function getOrCreateSheet_() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheet = ss.getSheetByName(SHEET_NAME);
  if (!sheet) sheet = ss.insertSheet(SHEET_NAME);
  return sheet;
}