| title | tags | parameters | reference | |||
|---|---|---|---|---|---|---|
リンク切れ |
|
|
Fumikazu Fujiwara | Freddie freddiefujiwara
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| init by gas-hub, just delete this file. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const SPREADSHEET_ID = "1LjFZsrQJJkOHcmKPWnFwcipUjIRRwNNsJfQU1r1Y_RE"; | |
| const sheet = SpreadsheetApp.openById(SPREADSHEET_ID); | |
| const list = sheet.getSheetByName("list"); | |
| function doPost(e) { | |
| const values = list.getDataRange().getValues(); | |
| const headers = values.shift(); | |
| const data = JSON.parse(e.postData.getDataAsString()); | |
| const id = data.id; | |
| const output = ContentService.createTextOutput(); |
freddiefujiwara
/ appsscript.json
Created
July 20, 2021 06:19
https://www.kawaguchi-stopcovid19.jp/ crawler
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "timeZone": "Asia/Tokyo", | |
| "dependencies": { | |
| }, | |
| "webapp": { | |
| "access": "ANYONE_ANONYMOUS", | |
| "executeAs": "USER_DEPLOYING" | |
| }, | |
| "exceptionLogging": "STACKDRIVER", | |
| "runtimeVersion": "V8" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const sheet = SpreadsheetApp.getActiveSheet(); | |
| function doGet(e) { | |
| refresh(); | |
| const values = sheet.getDataRange().getValues(); | |
| const header = []; | |
| values.forEach(h => { | |
| header.push(h[0]); | |
| }); | |
| const target = { |
freddiefujiwara
/ appsscript.json
Last active
July 20, 2021 06:14
Crawl hellocycling.jp and provide API
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "timeZone": "Asia/Tokyo", | |
| "dependencies": { | |
| }, | |
| "webapp": { | |
| "access": "ANYONE_ANONYMOUS", | |
| "executeAs": "USER_DEPLOYING" | |
| }, | |
| "exceptionLogging": "STACKDRIVER", | |
| "runtimeVersion": "V8" |
freddiefujiwara
/ ListOfStuff.gs
Last active
August 1, 2021 04:05
Sync ROOM and Google Spread Sheet + API provider
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const SPREADSHEET_ID = "1yxnHhfAT2cEF50hvajHoLMsW_sf7JlxnjFKeDFLNAkc"; | |
| const sheet = SpreadsheetApp.openById(SPREADSHEET_ID); | |
| const room = sheet.getSheetByName("room"); | |
| const roomLastRaw = room.getLastRow(); | |
| const workman = sheet.getSheetByName("workman"); | |
| const workmanLastRaw = workman.getLastRow(); | |
| const variety = sheet.getSheetByName("variety"); | |
| const varietyLastRaw = variety.getLastRow(); | |
| function crawlRoom() { |
| title | tags | parameters | reference | ||||||
|---|---|---|---|---|---|---|---|---|---|
マネーフォワードの資産、負債をGoogle Sperad Sheetに記録します |
|
|
| title | tags | parameters | reference | |||||
|---|---|---|---|---|---|---|---|---|
いつでも相談できるオンラインメンターが見つかるサイトMENTAで各メンターさんからの最新のメッセージを取得します |
|
|
| title | tags | parameters | reference | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
タイムズカーシェアで直前に利用したステーションの車を土日一番予約できる先の日付で予約します |
|
|