How to use the sheets function from googleapis

gsclient.js

GitHub: ExentriqLtd/CryptoCurrencies

-4

2

4

11

demo.js

GitHub: formulaslug/expense

48
49
50
51
52
53
54
55
56
57
function GetSpreadsheetID() {
    // Reading from a file was not working correctly for some reason.
    return Promise.resolve('1Rg7K7F4y4PL4LPvB32kKRb6FEd8uV5hOkSa0rcnkDWM');
}
function AppendRow() {
    var gSheets = GoogleApis.sheets('v4');

    gSheets.spreadsheets.values.append({
        auth: globalData.gAPIAuthClient,
        spreadsheetId: globalData.spreadsheetID,

0

3

10

gsheets.ts

GitHub: kaorun343/pwmetrics

9
10
11
12
13
14
15
16
17
18
import { Logger } from '../utils/logger';
const logger = Logger.getInstance();

async function getRange(auth: Oauth2Client, range: number, spreadsheetId: string): Promise<Array<GSheetsValuesToAppend>> {
  try {
    const sheets = google.sheets('v4');
    const response = await promisify(sheets.spreadsheets.values.get)({
      auth: auth,
      spreadsheetId: spreadsheetId,
      range: range

74

0

2

+ 3 other calls in file

ReportsDetailsController.js

GitHub: riddhasoftchris/demo_EMS

8
9
10
11
12
13
14
15
16
17
18
moment.suppressDeprecationWarnings = true; // removing those Deprecation Warnings that aren't relavant


module.exports = {
  getDetails: async (req, res) => {
    const auth = await authentication.authenticate();
    const sheets = google.sheets("v4");
    const getValues = promisify(sheets.spreadsheets.values.get);
    try {
      const response = await getValues({
        auth,

0

0

1