Google sheets Error 403

Questions
#1

Hi there,

I want to create a workflow to copy data from mongoDB to Google sheets. However, when I configure google credentials, I got error message like this:

ERROR: 403 - {“error”:{“code”:403,“message”:"Google Sheets API has not been used in project…

I’m sure that I gave the service email edit authentication in google sheets, but when I execute the node, the error message is still there. Please help.

Thanks

#2

Welcome to the community @Amanda_Xiao!

As the error message did not get copied completely I can just speculate but is that not the message that appears when the API has not been activated? If so then the message also contains a link to the exact page on which it can be done.