error 401 Request is missing required authentication credential on google sheets

[Christo Tee]

Hey everyone
New to Pabbly here. Ive been trying to complete a simple workflow of parsing some text from an email and creating a new line on google sheets but its consistently partially failing.
I get an error code 401 with this error message: "Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project."
Error details: type.googleapis.com/google.rpc.ErrorInfo
the reason is Credentials missing
Error Details 0 Domain: googleapis-com
Error Details 0 Metadata Method: google.apps.sheets.v4.SpreadsheetsService.AppendValues

I have no idea what I should do- anyone else has run into this issue?

 

[Pabbly]

You need to reauthorize Google Sheets to fix this as shown below -

 

[Christo Tee]

that helped
but even though the task is tagged as successful there is still no entry in google sheets

 

[Pabbly]

Can you confirm if your Google Sheet has header column defined something like this?

 

[Christo Tee]

yes

 

[Christo Tee]

any idea anyone?

 

[Pabblymember11]

Hey @Christo Tee

Kindly map the respective data in the fields of the " Google Sheets: Add New Row" action step to pass the data in your sheet in real-time.

 

[Christo Tee]

that worked! thanks!