Skip to content

Instantly share code, notes, and snippets.

@Asano-Naoki
Asano-Naoki / appsscript.json
Last active August 18, 2024 05:40
ダイアログを表示するようにした
{
"timeZone": "Asia/Tokyo",
"dependencies": {
"enabledAdvancedServices": [{
"userSymbol": "Drive",
"serviceId": "drive",
"version": "v2"
}]
},
"exceptionLogging": "STACKDRIVER",
@Asano-Naoki
Asano-Naoki / appsscript.json
Last active August 8, 2024 21:57
タイトルが変更されることにも対応
{
"timeZone": "Asia/Tokyo",
"dependencies": {
"libraries": [
{
"userSymbol": "Parser",
"version": "8",
"libraryId": "1Mc8BthYthXx6CoIz90-JiSzSafVnT6U3t0z_W3hLTAX5ek4w0G_EIrNw"
}
]
@Asano-Naoki
Asano-Naoki / appsscript.json
Last active February 9, 2025 15:53
document ai ocr
{
"timeZone": "Asia/Tokyo",
"dependencies": {
},
"exceptionLogging": "STACKDRIVER",
"runtimeVersion": "V8"
}
@Asano-Naoki
Asano-Naoki / appsscript.json
Last active October 20, 2024 23:13
明細を取得するテーブルの列番号を見出し行から算出
{
"timeZone": "Asia/Tokyo",
"dependencies": {
},
"exceptionLogging": "STACKDRIVER",
"runtimeVersion": "V8",
"oauthScopes": [
"https://www.googleapis.com/auth/drive",
"https://www.googleapis.com/auth/spreadsheets",
"https://mail.google.com/",
@Asano-Naoki
Asano-Naoki / all_json.gs
Last active February 10, 2025 05:13
payslip
function extractAll() {
// 情報を書き出すスプレッドシートのファイル名を設定
const FILENAME = "プライベートテスト2"
// jsonファイルをGoogleドライブにアップロードしてテスト
const jsonFile = DriveApp.getFileById('1CfwuzEQTKZA6616ZbfGcxxfkTKumQn3m');
// スプレッドシートを新規作成
const ss = SpreadsheetApp.create(FILENAME);
@Asano-Naoki
Asano-Naoki / appsscript.json
Last active December 19, 2024 23:11
画像の個別送信とエラー処理
{
"timeZone": "Asia/Tokyo",
"dependencies": {
},
"exceptionLogging": "STACKDRIVER",
"runtimeVersion": "V8"
}