• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

error 401 Request is missing required authentication credential on google sheets

Status
Not open for further replies.
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

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

1645174105807.png



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

Attachments

  • Screenshot 2022-02-18 at 10.14.14.png
    Screenshot 2022-02-18 at 10.14.14.png
    103.5 KB · Views: 93
  • Screenshot 2022-02-18 at 10.13.43.png
    Screenshot 2022-02-18 at 10.13.43.png
    68.1 KB · Views: 87

Pabbly

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

1645176753036.png
 
P

Pabblymember11

Guest
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.


2022-02-21_12h01_39.png
 
Status
Not open for further replies.
Top