<aside> 💡 참고자료 npm google_sheet api

</aside>

계획

node JS로 구글 시트 api와 통신해서, 받은 accesslog를 write 할 수 있음.

자료를 참고하여 애플리케이션 구현하면 될듯..

express-googleapis

const express = require('express');

const {google} = require('googleapis');

const app = express();

app.get("/", async (req, res) => {
    const auth = new google.auth.GoogleAuth({
        keyFile: "credentials.json",
        scopes: "<https://www.googleapis.com/auth/spreadsheets>",
    })
    
    // Auth를 위한 client 생성
    const client = await auth.getClient();

    const spreadsheetId = "1bbBb11u0E8eXsMnU1lqS5UAujJCOEVK07OJhDvrAYEA";
    // GoogleSheets API 인스턴스
    const googleSheets = google.sheets({version: "v4", auth: client});
    
    // Get metadata about spreadsheet
    const metadata = await googleSheets.spreadsheets.get({
        auth,
        spreadsheetId,
    });

    // Row 읽기
    const getRows = await googleSheets.spreadsheets.values.get({
        auth,
        spreadsheetId,
        range: "20220713",
    });

    // Row 쓰기
    await googleSheets.spreadsheets.values.append({
        auth,
        spreadsheetId,
        range: "20220713!A:B",
        valueInputOption: "USER_ENTERED",
        resource: {
            values: [
                ["127.0.0.1", "POST"],
                ["127.0.0.1", "POST"]
            ]
        }
    })

    res.send(getRows.data);
})

app.listen(1337, (req, res) => console.log("app is running on 1337"));