Get values failed. Info: TypeError: (0 , google_sheets_integration_backend.getValues) is not a function

Ask the community
, ,
1

Question:
Hello I am getting this error
Get values failed. Info: TypeError: (0 , google_sheets_integration_backend.getValues) is not a function

in the code:
import wixLocation from ‘wix-location’;
import { currentMember } from “wix-members-frontend”;

import { getValues } from “@velo/google-sheets-integration-backend”;

export async function getValuesWrapper(range) {
try {
const sheetId = spreadsheetId;
const result = await getValues(sheetId, range);
const response = result.data.values;
return response;
} catch (err) {
return Promise.reject("Get values failed. Info: " + err);
}
}

Product:
Wix Velo

What are you trying to achieve:
retrieving a google sheet cell value

What have you already tried:
tried putting the function in a backend file, getting same error on the wrapper function

Additional information:
Thank you for your help

2

Have you set up the intergration correctly -
https://dev.wix.com/docs/velo/articles/velo-package-readmes/google-sheets-integration

3

Yes I have done exactly what they say, with copy paste of the example code.

4

I havnt done any work with google sheets yet, but usually just copy paste of code will need adjusting to suit specific id’s. The code above does not look like all the code required as per the link i posted.