Google sheet read
🧩 Syntax:
import { JWT } from 'google-auth-library';
import { google } from 'googleapis';
let jwtClient = new google.auth.JWT(client_email, null, privatekey, ['https://www.googleapis.com/auth/spreadsheets']);
jwtClient.authorize((err, tokens) =>{
if(err) console.log("Ca aaa chiéééé");
});
this.sheets.spreadsheets.values.get({
auth: jwtClient,
spreadsheetId: "SHEET ID",
range: "SHEET NAME",
}, (err, response) => {
//blablablal
}})