Thanks for reaching out to us.
To help identify the issue, please check the integration log for the affected entries:
- Go to the Bit Form > Entries page.
- Open any entry that didn’t send data to Google Sheets.
- Click on the entry record to view its details.
- Scroll down to the bottom of the page to find the Integrations Log.
- Copy the log response and share it with us — this will help us determine the cause of the issue and guide you on how to fix it.
Check the screenshot: https://i.imgur.com/C3hNau7.png
Looking forward to your response.
Thanks for the answer! I found the logs! I’m not sure, but apparently the problem is on google’s side. Strange. I haven’t changed or touched anything in bitform or Google. Why could this error occur?
{“error”:{“code”:401,”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.”,”status”:”UNAUTHENTICATED”}}
https://imgur.com/a/bCj7kIH
I think I found the answer to this error on your website. But there is a problem. When I try to follow the link listed in the description, it takes me to another page.
https://console.cloud.google.com/apis/credentials/consent
I’m getting here:
https://console.cloud.google.com/auth/overview
Google has recently updated their Developer Console interface, which may have caused some confusion. Please follow the steps below to resolve the issue:
- Delete your existing Google Sheets integration in Bit Form.
- Open the Google Developer Console.
- Go to OAuth Consent Screen > Audience > Publishing Status.
- Change the App Status from Testing to In Production.
- Once done, go back and recreate the integration in Bit Form.
Check the screenshot: https://i.imgur.com/2y7r1Lm.jpg
Thanks! Your instructions have solved the problem! But I have a question…can this problem happen again?
Hopefully, it will not create any problem in the future.
