Tratamiento

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

How to use Google Sheets API with google service account on Node.js

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!

Our Visitor

0 0 0 3 7 4
Users Today : 0
Users Yesterday : 0
Users Last 7 days : 2
Users Last 30 days : 18
Users This Month : 14
Users This Year : 169
Total Users : 374
Views Today :
Views Yesterday :
Views Last 7 days : 2
Views Last 30 days : 21
Views This Month : 17
Views This Year : 181
Total views : 496
Who's Online : 0
Your IP Address : 3.236.27.143
Server Time : 2023-05-28