import requests url = "https://api.switch-bot.com/v1.1/devices/{デバイスID}/status" headers = { "Authorization": "YOUR_API_TOKEN", "Content-Type": "application/json" } response = requests.get(url, headers=headers) data = response.json() temperature = data['body']['temperature'] humidity = data['body']['humidity'] battery = data['body']['battery'] print(f"温度: {temperature}℃, 湿度: {humidity}%, 電池残量: {battery}%")

// // SwichBotAPIのサービスURL、認証情報
const url = 'https://api.switch-bot.com'
const token = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"//Swichbotのトークン（アプリの開発者オプションから取得）
const secret = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"//Swichbotのクライアントシークレット（アプリの開発者オプションから取得）
//SwitchBotに登録されているデバイスの一覧を表示する。
function getDeviceInfo() {
  const path = '/v1.1/devices'
  const nonce = Utilities.getUuid() // 任意の文字列で可 
  let timestamp = new Date()
  timestamp = timestamp.getTime().toString()
  let sign = Utilities.computeHmacSignature(Utilities.MacAlgorithm.HMAC_SHA_256, token + timestamp + nonce, secret)
  sign = Utilities.base64Encode(sign).toUpperCase()
  headers = {
    'Authorization': token,
    'sign': sign,
    't': timestamp,
    'nonce': nonce
  }
  const options = {
    'method': 'GET',
    'headers': headers,
  }
  Logger.log(UrlFetchApp.fetch(url + path, options).getContentText())
}

function getSwitchBotData() {
  const API_TOKEN = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
  const SECRET_TOKEN = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
  const SPREADSHEET_ID = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXX';
  const SHEET_NAME = 'テスト取得';
  // 既知のデバイス情報
  const devices = [
    {deviceId: "XXXXXXXXXXXX", deviceName: "温湿度計1"},
    {deviceId: "XXXXXXXXXXXX", deviceName: "温湿度計2"},
    {deviceId: "XXXXXXXXXXXX", deviceName: "温湿度計3"},
    {deviceId: "XXXXXXXXXXXX", deviceName: "温湿度計4"},
    {deviceId: "XXXXXXXXXXXX", deviceName: "温湿度計5"}
  ];
  try {
    const sheet = SpreadsheetApp.openById(SPREADSHEET_ID).getSheetByName(SHEET_NAME);
    if (!sheet) {
      throw new Error('指定されたシートが見つかりません。');
    }
    // ヘッダーの設定
    const headers = ['デバイス名', 'デバイスID', '日付', '時間', '温度', '湿度', '絶対湿度', 'VPD', 'バッテリー残量'];
    if (sheet.getLastRow() === 0) {
      sheet.getRange(1, 1, 1, headers.length).setValues([headers]);
    }
    Logger.log(`処理するデバイス数: ${devices.length}`);
    
    devices.forEach((device, index) => {
  try {
    const status = getDeviceStatus(API_TOKEN, SECRET_TOKEN, device.deviceId);
    if (status) {
      const now = new Date();
      const date = Utilities.formatDate(now, "Asia/Tokyo", "yyyy/MM/dd");
      const time = Utilities.formatDate(now, "Asia/Tokyo", "HH:mm");
      
      // 時間を数値として計算
      const [hours, minutes] = time.split(':').map(Number);
      const timeValue = (hours + minutes / 60) / 24; // スプレッドシートの時間表現（0-1の間の小数）
      const temp = status.temperature;
      const humidity = status.humidity;
      const absoluteHumidity = calculateAbsoluteHumidity(temp, humidity);
      const vpd = calculateVPD(temp, humidity);
      const battery = status.battery;
      const rowData = [
        device.deviceName,
        device.deviceId,
        date,
        time,
        temp,
        humidity,
        absoluteHumidity.toFixed(2),
        vpd.toFixed(2),
        battery,
        timeValue // 計算された時間値
      ];
      const lastRow = sheet.getLastRow();
      const range = sheet.getRange(lastRow + 1, 1, 1, rowData.length);
      range.setValues([rowData]);
      sheet.getRange(lastRow + 1, 3).setNumberFormat('yyyy/mm/dd');
      sheet.getRange(lastRow + 1, 4).setNumberFormat('HH:mm');
      sheet.getRange(lastRow + 1, 10).setNumberFormat('HH:mm'); // 新しい列の書式を設定
      Logger.log(`デバイス ${index + 1}/${devices.length} のデータを追加しました: ${device.deviceName}`);
    } else {
      Logger.log(`デバイス ${index + 1}/${devices.length} のステータス取得に失敗しました: ${device.deviceName}`);
    }
  } catch (deviceError) {
    Logger.log(`デバイス ${index + 1}/${devices.length} の処理中にエラーが発生しました: ${deviceError.message}`);
  }
  
  Utilities.sleep(1000);
});
    Logger.log('すべてのデータの取得と記録が完了しました。');
  } catch (error) {
    Logger.log(`エラーが発生しました: ${error.message}`);
  }
}
function getDeviceStatus(apiToken, secretToken, deviceId) {
  const url = `https://api.switch-bot.com/v1.1/devices/${deviceId}/status`;
  const headers = createHeaders(apiToken, secretToken);
  
  try {
    const response = UrlFetchApp.fetch(url, {
      method: 'get',
      headers: headers,
      muteHttpExceptions: true
    });
    
    const responseData = JSON.parse(response.getContentText());
    
    if (responseData.statusCode === 100) {
      return responseData.body;
    } else {
      Logger.log(`デバイス ${deviceId} のステータス取得に失敗しました: ${responseData.message}. 完全なレスポンス: ${JSON.stringify(responseData)}`);
      return null;
    }
  } catch (error) {
    Logger.log(`デバイス ${deviceId} のステータス取得中にエラーが発生しました: ${error.message}`);
    return null;
  }
}
function createHeaders(apiToken, secretToken) {
  const t = Date.now();
  const nonce = Utilities.getUuid();
  const data = apiToken + t + nonce;
  const signTerm = Utilities.computeHmacSha256Signature(data, secretToken);
  const sign = Utilities.base64Encode(signTerm);
  return {
    "Authorization": apiToken,
    "sign": sign,
    "t": t.toString(),
    "nonce": nonce
  };
}
function calculateAbsoluteHumidity(temp, relativeHumidity) {
  const e = 6.11 * Math.pow(10, (7.5 * temp / (237.3 + temp)));
  return 217 * e / (temp + 273.15) * (relativeHumidity / 100);
}
function calculateVPD(temp, relativeHumidity) {
  const satVaporPressure = 610.7 * Math.pow(10, (7.5 * temp / (237.3 + temp)));
  return (satVaporPressure * (1 - (relativeHumidity / 100))) / 1000;
}

function sendSwitchbotReport() { var reportUrl = 'YOUR_LOOKER_STUDIO_REPORT_URL'; var recipients = ['email1@example.com', 'email2@example.com']; var subject = 'Switchbot温湿度レポート - ' + new Date().toLocaleDateString(); var body = '添付のリンクから最新のSwitchbot温湿度レポートをご確認ください。\n\n' + reportUrl; MailApp.sendEmail({ to: recipients.join(','), subject: subject, body: body }); }

function notifyLabeledEmails() {
  var labelName = "温度・湿度管理レポート";
  var label = GmailApp.getUserLabelByName(labelName);
  var targetEmail = "自分のメールアドレス@ドメイン";
  console.log("ラベル名: " + labelName);
  console.log("ラベルが見つかりました: " + (label !== null));
  if (!label) {
    console.error("ラベル '" + labelName + "' が見つかりません。");
    return;
  }
  var threads = label.getThreads();
  var lineToken = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX';発行したLINEトークンを入力
  console.log("処理するスレッド数: " + threads.length);
  for (var i = 0; i < threads.length; i++) {
    console.log("スレッド " + (i+1) + " を処理中");
    var messages = threads[i].getMessages();
   
    for (var j = 0; j < messages.length; j++) {
      var message = messages[j];
     
      if (!message.isStarred() && message.getTo().indexOf(targetEmail) !== -1) {
        console.log("未通知のメッセージを処理中: " + message.getSubject());
        var subject = message.getSubject();
        var attachments = message.getAttachments();
       
        try {
          var jpgAttachments = attachments.filter(function(attachment) {
            return attachment.getContentType() === "image/jpeg";
          });
         
          var notificationBody = `件名: ${subject}`;
          if (jpgAttachments.length > 0) {
            notificationBody += `\n\n${jpgAttachments.length}個のJPG画像が添付されています。`;
          }
         
          console.log("LINE Notifyに通知を送信中");
          sendLongLineNotify(notificationBody, lineToken);
         
          for (var k = 0; k < jpgAttachments.length; k++) {
            sendLineNotifyWithImage(jpgAttachments[k], lineToken);
          }
         
          message.star();
          console.log("メッセージを通知済みとしてマーク");
        } catch (error) {
          console.error('Error sending notification:', error);
        }
      } else {
        console.log("対象外または既に通知済みのメッセージをスキップ: " + message.getSubject());
      }
    }
  }
  console.log("全てのスレッドの処理が完了しました");
}
function sendLongLineNotify(message, token) {
  const maxLength = 1000;
  const url = 'https://notify-api.line.me/api/notify';
  var parts = [];
  for (let i = 0; i < message.length; i += maxLength) {
    parts.push(message.substr(i, maxLength));
  }
  console.log("メッセージを " + parts.length + " 部分に分割しました");
  for (let i = 0; i < parts.length; i++) {
    let chunk = parts[i];
    if (parts.length > 1) {
      chunk = `(${i+1}/${parts.length}) ${chunk}`;
    }
   
    console.log("部分 " + (i+1) + " を送信中");
    sendLineNotify(chunk, token);
   
    Utilities.sleep(1000);
  }
}
function sendLineNotify(message, token) {
  const url = 'https://notify-api.line.me/api/notify';
 
  var options = {
    'method': 'post',
    'headers': {
      'Authorization': 'Bearer ' + token,
    },
    'payload': {
      'message': message
    },
    'muteHttpExceptions': true
  };
 
  console.log("LINE Notify APIにリクエストを送信中");
  var response = UrlFetchApp.fetch(url, options);
 
  console.log('Response Code: ' + response.getResponseCode());
  console.log('Response Content: ' + response.getContentText());
 
  if (response.getResponseCode() !== 200) {
    throw new Error('LINE Notify API request failed: ' + response.getContentText());
  }
}
function sendLineNotifyWithImage(imageBlob, token) {
  const url = 'https://notify-api.line.me/api/notify';
 
  var boundary = Utilities.getUuid();
 
  var data = Utilities.newBlob(
    '--' + boundary + '\r\n' +
    'Content-Disposition: form-data; name="message"\r\n\r\n' +
    '画像を送信します\r\n' +
    '--' + boundary + '\r\n' +
    'Content-Disposition: form-data; name="imageFile"; filename="image.jpg"\r\n' +
    'Content-Type: ' + imageBlob.getContentType() + '\r\n\r\n'
  ).getBytes();
 
  data = data.concat(imageBlob.getBytes());
  data = data.concat(Utilities.newBlob('\r\n--' + boundary + '--\r\n').getBytes());
 
  var options = {
    'method': 'post',
    'headers': {
      'Authorization': 'Bearer ' + token,
      'Content-Type': 'multipart/form-data; boundary=' + boundary
    },
    'payload': data,
    'muteHttpExceptions': true
  };
 
  console.log("LINE Notify APIに画像を送信中");
  var response = UrlFetchApp.fetch(url, options);
 
  console.log('Response Code: ' + response.getResponseCode());
  console.log('Response Content: ' + response.getContentText());
 
  if (response.getResponseCode() !== 200) {
    throw new Error('LINE Notify API request failed: ' + response.getContentText());
  }
}

// Switchbot APIの設定 
const SWITCHBOT_API_TOKEN = 'YOUR_SWITCHBOT_API_TOKEN'; 
const DEVICE_ID = 'YOUR_DEVICE_ID'; // スプレッドシートの設定 
const SPREADSHEET_ID = 'YOUR_SPREADSHEET_ID'; 
const SHEET_NAME = 'シート1'; // LINE Notifyの設定 
const LINE_NOTIFY_TOKEN = 'YOUR_LINE_NOTIFY_TOKEN'; // Switchbotデバイスの情報を取得 
function getSwitchbotDevices() { const url = 'https://api.switch-bot.com/v1.1/devices'; 
const options = { 'method': 'get', 'headers': { 'Authorization': SWITCHBOT_API_TOKEN, 'Content-Type': 'application/json' } }; 
const response = UrlFetchApp.fetch(url, options); 
const json = JSON.parse(response.getContentText()); Logger.log(JSON.stringify(json, null, 2)); } // センサーデータを取得 
function getSwitchbotSensorData(deviceId) { const url = `https://api.switch-bot.com/v1.1/devices/${deviceId}/status`; 
const options = { 'method': 'get', 'headers': { 'Authorization': SWITCHBOT_API_TOKEN, 'Content-Type': 'application/json' } }; 
const response = UrlFetchApp.fetch(url, options); 
const json = JSON.parse(response.getContentText()); 
return { temperature: json.body.temperature, humidity: json.body.humidity, battery: json.body.battery }; } // スプレッドシートにデータを記録 
function recordSwitchbotData() { const data = getSwitchbotSensorData(DEVICE_ID); const timestamp = new Date(); 
const deviceName = 'リビング温湿度計'; // デバイス名を適宜変更 
const sheet = SpreadsheetApp.openById(SPREADSHEET_ID).getSheetByName(SHEET_NAME); 
sheet.appendRow([ timestamp, deviceName, data.temperature, data.humidity, data.battery ]); } // LINEに通知を送信 
function sendSwitchbotDataToLine() { const data = getSwitchbotSensorData(DEVICE_ID); 
const message = `現在の温度: ${data.temperature}℃\n湿度: ${data.humidity}%\n電池残量: ${data.battery}%`; 
const options = { 'method': 'post', 'headers': {'Authorization': 'Bearer ' + LINE_NOTIFY_TOKEN}, 'payload': {'message': message} }; 
UrlFetchApp.fetch('https://notify-api.line.me/api/notify', options); } // メインの実行関数 
function main() { recordSwitchbotData(); sendSwitchbotDataToLine(); } // Switchbotレポートをメールで送信 
function sendSwitchbotReport() { const reportUrl = 'YOUR_LOOKER_STUDIO_REPORT_URL'; 
const recipients = ['email1@example.com', 'email2@example.com']; 
const subject = 'Switchbot温湿度レポート - ' + new Date().toLocaleDateString(); const body = '添付のリンクから最新のSwitchbot温湿度レポートをご確認ください。\n\n' + 
reportUrl; MailApp.sendEmail({ to: recipients.join(','), subject: subject, body: body }); }

<code>function getSwitchBotData() {
  const API_TOKEN = &#39;XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&#39;;
  const SECRET_TOKEN = &#39;XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&#39;;
  const SPREADSHEET_ID = &#39;XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&#39;;
  const SHEET_NAME = &#39;XXXXXXXXXXXX&#39;;
  // 既知のデバイス情報
  const devices = [
    {deviceId: &quot;XXXXXXXXXXXX&quot;, deviceName: &quot;XXXXXXXXXXXX&quot;},
    {deviceId: &quot;XXXXXXXXXXXX&quot;, deviceName: &quot;XXXXXXXXXXXX&quot;},
    {deviceId: &quot;XXXXXXXXXXXX&quot;, deviceName: &quot;XXXXXXXXXXXX&quot;}
  ];
  try {
    const sheet = SpreadsheetApp.openById(SPREADSHEET_ID).getSheetByName(SHEET_NAME);
    if (!sheet) {
      throw new Error(&#39;指定されたシートが見つかりません。&#39;);
    }
    // ヘッダーの設定
    const headers = [&#39;デバイス名&#39;, &#39;デバイスID&#39;, &#39;日付&#39;, &#39;時間&#39;, &#39;温度&#39;, &#39;湿度&#39;, &#39;絶対湿度&#39;, &#39;VPD&#39;, &#39;バッテリー残量&#39;];
    if (sheet.getLastRow() === 0) {
      sheet.getRange(1, 1, 1, headers.length).setValues([headers]);
    }
    Logger.log(`処理するデバイス数: ${devices.length}`);
    
    devices.forEach((device, index) => {
      try {
        const status = getDeviceStatus(API_TOKEN, SECRET_TOKEN, device.deviceId);
        if (status) {
          const now = new Date();
          const date = Utilities.formatDate(now, &quot;Asia/Tokyo&quot;, &quot;yyyy/MM/dd&quot;);
          const time = Utilities.formatDate(now, &quot;Asia/Tokyo&quot;, &quot;HH:mm:ss&quot;);
          
          const temp = status.temperature;
          const humidity = status.humidity;
          const absoluteHumidity = calculateAbsoluteHumidity(temp, humidity);
          const vpd = calculateVPD(temp, humidity);
          const battery = status.battery;
          const rowData = [
            device.deviceName,
            device.deviceId,
            date,
            time,
            temp,
            humidity,
            absoluteHumidity.toFixed(2),
            vpd.toFixed(2),
            battery
          ];
          sheet.appendRow(rowData);
          Logger.log(`デバイス ${index + 1}/${devices.length} のデータを追加しました: ${device.deviceName}`);
        } else {
          Logger.log(`デバイス ${index + 1}/${devices.length} のステータス取得に失敗しました: ${device.deviceName}`);
        }
      } catch (deviceError) {
        Logger.log(`デバイス ${index + 1}/${devices.length} の処理中にエラーが発生しました: ${deviceError.message}`);
      }
      
      // 各リクエストの間に1秒の遅延を入れる
      Utilities.sleep(1000);
    });
    Logger.log(&#39;すべてのデータの取得と記録が完了しました。&#39;);
  } catch (error) {
    Logger.log(`エラーが発生しました: ${error.message}`);
  }
}
function getDeviceStatus(apiToken, secretToken, deviceId) {
  const url = `https://api.switch-bot.com/v1.1/devices/${deviceId}/status`;
  const headers = createHeaders(apiToken, secretToken);
  
  try {
    const response = UrlFetchApp.fetch(url, {
      method: &#39;get&#39;,
      headers: headers,
      muteHttpExceptions: true
    });
    
    const responseData = JSON.parse(response.getContentText());
    
    if (responseData.statusCode === 100) {
      return responseData.body;
    } else {
      Logger.log(`デバイス ${deviceId} のステータス取得に失敗しました: ${responseData.message}. 完全なレスポンス: ${JSON.stringify(responseData)}`);
      return null;
    }
  } catch (error) {
    Logger.log(`デバイス ${deviceId} のステータス取得中にエラーが発生しました: ${error.message}`);
    return null;
  }
}
function createHeaders(apiToken, secretToken) {
  const t = Date.now();
  const nonce = Utilities.getUuid();
  const data = apiToken + t + nonce;
  const signTerm = Utilities.computeHmacSha256Signature(data, secretToken);
  const sign = Utilities.base64Encode(signTerm);
  return {
    &quot;Authorization&quot;: apiToken,
    &quot;sign&quot;: sign,
    &quot;t&quot;: t.toString(),
    &quot;nonce&quot;: nonce
  };
}
function calculateAbsoluteHumidity(temp, relativeHumidity) {
  const e = 6.11 * Math.pow(10, (7.5 * temp / (237.3 + temp)));
  return 217 * e / (temp + 273.15) * (relativeHumidity / 100);
}
function calculateVPD(temp, relativeHumidity) {
  const satVaporPressure = 610.7 * Math.pow(10, (7.5 * temp / (237.3 + temp)));
  return (satVaporPressure * (1 - (relativeHumidity / 100))) / 1000;
}</code>