Google Sheets integration appears to have stopped functioning correctly in Form Builder?
I had previously connected a form to Google Sheets and it was originally working as expected.
That Google Sheets integration suddenly stopped working (when exactly is not known but it was first noticed by us around 5 days ago).
The Google account WAS connected for over 12 months and the Google Sheet WOULD open from the link in the Elfsight Form Builder app - but no NEW entries were being added. Old entries remained in the open Sheet - but no new entries were being added.
I tried to fix the issue by disconnecting the Google account and starting again with a fresh Google Sheets integration.
Now when I try to connect to the Google account via the “Connect to Google Sheets” link in the Elfsight app, the popup Google Auth opens but with this error message:
{“error”:{“code”:400,“message”:“Service is unavailable now”}}
It would appear the Elfsight server is unable to connect to Google?
This error first appeared to us about 5 days ago. I have tried continuously until now, thinking it may have been a short term outage, however it is still down (same error) as of writing this thread.
I have tried multiple browsers, clearing cookies, different browsers, etc. It would appear to be an error at your end? I have submitted a support ticket (#567035) but am still waiting on a reply.
Any assistance greatly appreciated please. Thanks.
OK, did a bit more testing Max and I see that on other NEW and existing forms I CAN open the Google Auth popup and it does appear to be working correctly.
The only one it appears to NOT be working on is “Quoll HQ Visitor Registration” form - which WAS previously connected to Google, was then disconnected and now cannot reconnect.
It would appear that the problem exists when (1) Google has been connected (2) is disconnected from the form and (3) then an attempt is made to reconnect.
Hello, I am having the same issue. The Google sheet integration stopped working, so I removed the integration and now cannot connect to a new sheet. The same error message {“error”:{“code”:400,“message”:“Service is unavailable now”}}
The form I am trying to connect is Edgy Veg Awards
Just for information - if anybody else experiences this error mentioned above:
Once Elfsight have reset the connection to Google Auth and you can reconnect to Google Sheets, you just may find that any dropdown field data from your forms will not transfer to either your Google Sheet or the generated email response. You may receive blank cells on the Sheet and “-” on the email response.
The fix (that worked for me at least) is to replicate any dropdowns in your original form and then delete those old dropdowns that weren’t working. Hope that may help.
