Skip to main content
Question

123FormBuilder: integration with Google Sheets failed

  • August 3, 2024
  • 3 replies
  • 34 views

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.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 5, 2024

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
  • 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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 6, 2024

@WBRC1 

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