grod220/CCS-B.B.Warfield

Function save email to google sheet error

Opened this issue · 2 comments

Is there anything missing here?
i copy the code to a fresh function folder and invoke the function
but i keep getting this error

SyntaxError: Unexpected token } in JSON at position 0

i did npm install googleapi and dotenv

Im not sure what im missing,

I also have my own .env file that contains GOOGLE_SERVICE_ACCOUNT

and also change the google sheet id to mine ...

Did you grant access your service account edit access in your google sheet?

For example, I used the share button in my sheet and gave access to my service account email:
ccstockholm***@*****.iam.gserviceaccount.com

can you add that in the read me file , thanks