durss

Google sheet read

Apr 3rd, 2022 (edited)
214
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. import { JWT } from 'google-auth-library';
  2. import { google } from 'googleapis';
  3.  
  4. let jwtClient = new google.auth.JWT(client_email, null, privatekey, ['https://www.googleapis.com/auth/spreadsheets']);
  5. jwtClient.authorize((err, tokens) =>{
  6. if(err) console.log("Ca aaa chiéééé");
  7. });
  8.  
  9. const sheets = google.sheets('v4');
  10. sheets.spreadsheets.values.get({
  11.     auth: jwtClient,
  12.     spreadsheetId: "SHEET ID",
  13.     range: "SHEET NAME",
  14. }, (err, response) => {
  15. //blablablal
  16. }})
Add Comment
Please, Sign In to add comment