Month: November 2022

TRATAMIENTO	CATIDAD	PRECIO NETO
CORTE DE PUENTE 36	1	7000
IMPLANTE/ CORONA SOBRE IMPLANTE 36 / TOMA DE IMPRESION	1/1/1	59500
PERNO- RECONSTRUCCION 35 (OJO)	1/1	10000
CORONA PROVISIONAL 35/ TOMA DE IMPRESION	1/1	4500
CORONA DEFINITIVA 35 / TOMA DE IMPRESION	1/1	19500
GINGIVECTOMIA 35	1	5000
RECONSTRUCCION 37	1	5000
CORONA PROVISIONAL 37/ TOMA DE IMPRESION	1/1	4500
CORONA DEFINITIVA 37/ TOMA DE IMPRESION	1/1	19500
CORONA DEFINITIVA EN ZIRCONIA 46/TOMA DE IMPRESION	1/1	19500
ADITAMENTOS/ CICATRIZADOR 36	1/1	30000
		184000

You have to install googleapis package:

npm install googleapis

Save credentials for service account to the root derictory of the project under the name credentials.json

Grant access to your spreadsheet to service account.

Create index.js file and paste following code:

let {google} = require('googleapis');
let privatekey = require('./credentials.json');

const SCOPES = ['https://www.googleapis.com/auth/spreadsheets']
async function getAuthToken() {
  const auth = new google.auth.GoogleAuth({
    keyFile:'./credentials.json',
    scopes: SCOPES
  });
  const authToken = await auth.getClient();
  return authToken;
}

const myId = 'YOUR SPREADSHEET ID';

const main = async () => {
  const auth = await getAuthToken()
  const client = google.sheets({ version: "v4", "auth": auth });
  const data = await client.spreadsheets.get({ spreadsheetId: myId});
  console.log(data.data)
}
main()

Run node index.js

Enjoy!