Error: error:1E08010C:DECODER routines::unsupported

[MarkForLoop]

I am creating this issue regarding the documentation at https://theoephraim.github.io/node-google-spreadsheet/#/guides/authentication?id=service-account specifically in the authentication section (service account). There's a note for users on Heroku or similar platforms, and in my case, I'm using Next.js.

The documentation suggests using the following function:

await doc.useServiceAccountAuth({
  client_email: process.env.GOOGLE_SERVICE_ACCOUNT_EMAIL,
  private_key: process.env.GOOGLE_PRIVATE_KEY.replace(/\\n/g, "\n"),
});

However, when attempting to use this function, it reports that it doesn't exist. Can you please provide guidance on the alternative approach to achieve the same outcome?

Edit:

if I remove it I am getting this error

Error: error:1E08010C:DECODER routines::unsupported
{
  library: 'DECODER routines',
  reason: 'unsupported',
  code: 'ERR_OSSL_UNSUPPORTED'
}

This is the code i currently have

import { JWT } from "google-auth-library";

import { GoogleSpreadsheet } from "google-spreadsheet";
import type { NextApiRequest, NextApiResponse } from "next";

const SCOPES = [
	"https://www.googleapis.com/auth/spreadsheets",
	"https://www.googleapis.com/auth/drive.file",
];

const jwt = new JWT({
	email: process.env.GOOGLE_SERVICE_ACCOUNT_EMAIL,
	key: process.env.GOOGLE_PRIVATE_KEY,
	scopes: SCOPES,
});

const doc = new GoogleSpreadsheet(
	process.env.GOOGLE_SHEET,
	jwt
);

export default async function handler(
	req: NextApiRequest,
	res: NextApiResponse
) {
	if (req.method !== "POST") {
		res.setHeader("Allow", "POST");
		res.status(405).end("Method Not Allowed");
	}
	try {
                 // function does not exist??
		await doc.useServiceAccountAuth({
			client_email: process.env.GOOGLE_SERVICE_ACCOUNT_EMAIL,
			// eslint-disable-next-line @typescript-eslint/no-non-null-assertion
			private_key: process.env.GOOGLE_PRIVATE_KEY!.replace(/\\n/g, "\n"),
		});

		await doc.loadInfo();

		const sheet = doc.sheetsByIndex[0]!;

		console.log(sheet.title);
		console.log(sheet.rowCount);

		res.status(200).json({ success: true });
	} catch (err) {
		console.log(err);
		res.status(500).json({ statusCode: 500, message: err });
	}
}

[theoephraim]

ah! whoops - that note is outdated. The part about replacing newlines is the relevant bit. Follow the rest of the docs and you should be ok. I'll fix it soon - cheers.

[theoephraim]

fixed in the docs! https://theoephraim.github.io/node-google-spreadsheet/#/guides/authentication?id=authentication-methods