AI検索エンジン「Perplexity」とGASを活用した情報収集スプレッドシートの作成方法

const PERPLEXITY_API_KEY = ‘取得したperplexity apiキー’


function callAPI(url, method, headers, payload) {
 const options = {
   'method': method,
   'contentType': 'application/json',
   'headers': headers,
   'payload': JSON.stringify(payload)
 };


 const response = UrlFetchApp.fetch(url, options);
 return JSON.parse(response.getContentText());
}


function callPerplexity(prompt) {
 const url = 'https://api.perplexity.ai/chat/completions';
 const payload = {
   "model": "llama-3.1-sonar-large-128k-online",
   'messages': [
     { "role": "user", "content": prompt }
   ]
 };
 const headers = { 'Authorization': `Bearer ${PERPLEXITY_API_KEY}` };
 const resJson = callAPI(url, 'post', headers, payload);


 return extractCitationsAndContent(JSON.stringify(resJson));
}


function extractCitationsAndContent(jsonString) {
 const data = JSON.parse(jsonString);
 const citations = data.citations;
 const content = data.choices[0].message.content; return {
   citations: citations,
   content: content
 };
}


function testPerplexity() {
 const prompt = '今日は何の日？';
 const response = callPerplexity(prompt);
 console.log('Perplexity Response:', response);
}

function searchMultipleKeywords() {
 const sheet = SpreadsheetApp.getActiveSheet();
 const lastRow = sheet.getLastRow();
  for (let row = 2; row <= lastRow; row++) {
   const keyword = sheet.getRange(row, 1).getValue();
   if (keyword) {
     searchAndOutputRow(sheet, row, keyword);
   }
 }
}


function searchAndOutputRow(sheet, row, keyword) {
 const result = callPerplexity(`${keyword}について最新情報を調べよ`);
 sheet.getRange(row, 2).setValue(result.content);
 const citations = result.citations;
 for (let i = 0; i < Math.min(citations.length, 5); i++) {
   sheet.getRange(row, 3 + i).setValue(citations[i]);
 }
}