PubMedのRSSを使って、論文チェックから業績管理まで

const NOTION_TOKEN = 'NOTION_INTEGRATION_TOKEN';
const NOTION_DATABASE_ID = 'NOTION_DBID';
const RSS_FEED_URL = 'PubMed_RSSFeed';
function fetchPubmedToNotion() {
  const xml = UrlFetchApp.fetch(RSS_FEED_URL).getContentText();
  const document = XmlService.parse(xml);
  const root = document.getRootElement();
  const channel = root.getChild('channel');
  const items = channel.getChildren('item');

  const dcNS = XmlService.getNamespace('dc', 'http://purl.org/dc/elements/1.1/');
  const contentNS = XmlService.getNamespace('content', 'http://purl.org/rss/1.0/modules/content/');

  items.forEach(item => {
    const title = item.getChildText('title');
    const link = item.getChildText('link');
    const description = item.getChildText('description');
    const pubDateStr = item.getChildText('pubDate');
    const pubDate = new Date(pubDateStr);

    const contentEncoded = item.getChild('encoded', contentNS)?.getText() || '';
    const creators = item.getChildren('creator', dcNS).map(el => el.getText());
    const authors = creators.join(', ');
    const journal = item.getChildText('source', dcNS);
    const yearMatch = contentEncoded.match(/\b(\d{4})\b/);
    const year = yearMatch ? yearMatch[1] : '';

    const volIssuePagesMatch = contentEncoded.match(/(\d+)\s*(?:\((\d+)\))?:([\d\-]+)/);
    const volume = volIssuePagesMatch ? volIssuePagesMatch[1] : '';
    const issue = volIssuePagesMatch ? volIssuePagesMatch[2] : '';
    const pages = volIssuePagesMatch ? volIssuePagesMatch[3] : '';

    const doiMatch = contentEncoded.match(/doi:\s*([\w./-]+)/i);
    const doi = doiMatch ? doiMatch[1] : '';

    const pmidMatch = contentEncoded.match(/PMID:<a.*?>(\d+)<\/a>/);
    const pmid = pmidMatch ? pmidMatch[1] : '';

    // 重複チェック：既存のPMIDがあるか確認
    if (pmid && checkDuplicatePMID(pmid)) {
      Logger.log(`Duplicate found: PMID ${pmid} already exists. Skipping...`);
      return;
    }

    const metadata = {
      authors, journal, volume, issue, pages, year, doi, pmid
    };

    postToNotion(title, link, pubDate, description, metadata);
  });
}

function checkDuplicatePMID(pmid) {
  const queryUrl = `https://api.notion.com/v1/databases/${NOTION_DATABASE_ID}/query`;

  const payload = {
    filter: {
      property: 'PMID',
      rich_text: {
        equals: pmid
      }
    }
  };

  const options = {
    method: 'post',
    contentType: 'application/json',
    headers: {
      'Authorization': `Bearer ${NOTION_TOKEN}`,
      'Notion-Version': '2022-06-28'
    },
    payload: JSON.stringify(payload)
  };

  const response = UrlFetchApp.fetch(queryUrl, options);
  const data = JSON.parse(response.getContentText());
  return data.results && data.results.length > 0;
}

function postToNotion(title, link, pubDate, description, metadata) {
  const url = 'https://api.notion.com/v1/pages';

  const payload = {
    parent: { database_id: NOTION_DATABASE_ID },
    properties: {
      'Title': {
        title: [{ text: { content: title } }]
      },
      'URL': {
        url: link
      },
      'Date': {
        date: { start: pubDate.toISOString() }
      },
      'Description': {
        rich_text: [{ text: { content: description } }]
      },
      'Authors': {
        rich_text: [{ text: { content: metadata.authors } }]
      },
      'Journal': {
        rich_text: [{ text: { content: metadata.journal } }]
      },
      'Volume': {
        number: metadata.volume ? parseInt(metadata.volume) : null
      },
      'Issue': {
        number: metadata.issue ? parseInt(metadata.issue) : null
      },
      'Pages': {
        rich_text: [{ text: { content: metadata.pages } }]
      },
      'Year': {
        number: metadata.year ? parseInt(metadata.year) : null
      },
      'DOI': {
        rich_text: [{ text: { content: metadata.doi } }]
      },
      'PMID': {
        rich_text: [{ text: { content: metadata.pmid } }]
      },
      'Tag': {
         select: { name: 'My Paper' }
      }
    }
  };

  const options = {
    method: 'post',
    contentType: 'application/json',
    headers: {
      'Authorization': `Bearer ${NOTION_TOKEN}`,
      'Notion-Version': '2022-06-28'
    },
    payload: JSON.stringify(payload)
  };

  UrlFetchApp.fetch(url, options);
}