フリーランスの顧客管理をNotion×GASで自動化、対応履歴を自動蓄積

const NOTION_TOKEN = 'ここにNotion Integrationのシークレットを入れる';
const HISTORY_DB_ID = 'ここに対応履歴DBのIDを入れる';
const GMAIL_LABEL = 'クライアント対応'; // このラベルを付けたメールだけを対象にする

function syncClientHistory() {
  const threads = GmailApp.search(`label:${GMAIL_LABEL} newer_than:1d`);
  const recordedIds = getRecordedMessageIds_();

  threads.forEach(thread => {
    thread.getMessages().forEach(message => {
      const id = message.getId();
      if (recordedIds.has(id)) return;

      createNotionRecord_({
        subject: message.getSubject(),
        from: message.getFrom(),
        date: message.getDate(),
        snippet: message.getPlainBody().slice(0, 200),
        messageId: id
      });
    });
  });
}

function createNotionRecord_(data) {
  UrlFetchApp.fetch('https://api.notion.com/v1/pages', {
    method: 'post',
    headers: {
      'Authorization': `Bearer ${NOTION_TOKEN}`,
      'Notion-Version': '2022-06-28',
      'Content-Type': 'application/json'
    },
    payload: JSON.stringify({
      parent: { database_id: HISTORY_DB_ID },
      properties: {
        '件名': { title: [{ text: { content: data.subject } }] },
        '差出人': { rich_text: [{ text: { content: data.from } }] },
        '日時': { date: { start: data.date.toISOString() } },
        'メールID': { rich_text: [{ text: { content: data.messageId } }] }
      },
      children: [{
        object: 'block',
        type: 'paragraph',
        paragraph: { rich_text: [{ text: { content: data.snippet } }] }
      }]
    })
  });
}