Skip to main content
Question

123FormBuilder: integration with Google Sheets failed


I am trying to do a simple integration to extract information from 123formbuilder into google sheets. Trigger activates if there is a new submission on 123formbuilder, action is to populate the fields to Google Sheets.

The error I receive is as follows:

Submission data with entry ID: 98 from your 123FormBuilder form: _, with the form ID: _, could not be sent to Google Sheets.

Returned error message: Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential.

Did this topic help you find an answer to your question?

3 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @WBRC1 

For us to have more info, post screenshots with how your Zap steps are outlined and configured in EDIT mode along with the encountered error.


  • Author
  • Beginner
  • 1 reply
  • August 6, 2024

The error is as follows:Returned error message: Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project. on Updated SpreadSheet Status: UNAUTHENTICATED
Error code: 401


Troy Tessalone
Forum|alt.badge.img+14

@WBRC1 

Check your Zap app connections here: https://zapier.com/app/connections