Mon. - Fri. 9 am - 5 pm Ask a Question
Remember me

Can't add Google Sheet API keys into forms

1 month 4 weeks ago #1

  • COULON's Avatar
  • COULON
  • Posts: 14
Hello,

I'm trying to export form fields content to Google sheet.

At this last step of this tuto i am NOT prompted to enter Google Sheet API keys
www.balbooa.com/joomla-forms-documentati...e-sheets-integration

When i open the Form Integration modal window: Integration ➝ Data Storage ➝ Google Sheets.

Screen stays in "Installing please wait" step, here is the screen capture

i.postimg.cc/Lsd3knQt/Screen-Hunter-28-Jun-09-23-17.jpg

How could i get this solved ?
Thanks,

1 month 4 weeks ago #2

  • Vyacheslav's Avatar
  • Vyacheslav
  • Posts: 23440
Hello,
Thank you for contacting us

Send us a link to page with problem.
Send us FTP access and Joomla admin access via our contact form.
support.balbooa.com/contact-us

Regards,
Vyacheslav, Balbooa.com

1 month 3 weeks ago #3

  • COULON's Avatar
  • COULON
  • Posts: 14
I spent lot of time trying to get Google Sheet API set up for forms.
I finally got the authorisation code from Google but i had to proceed a bit differently compared to your documentation :
www.balbooa.com/joomla-forms-documentati...e-sheets-integration
At step n°7 : i did not publish as suggested but stayed in TEST mode, then i added my google account email.

--

I also found that at your post here : support.balbooa.com/forum/joomla-forms/1...sheets-problem#73374

Step 1 does NOT get working result but if we go only with Step 2 while keeping OAuth in TEST mode : it works.

Proceeding this way get Google to accept Forms app and when Forms tries to authenticate Client ID and Client Secret, it works.

Then, this leads to get the Authentication code afterwards.

Hope this post would help others.

1 week 5 days ago #4

  • COULON's Avatar
  • COULON
  • Posts: 14
Hello,

Since today Forms has lost the Google Sheet page and it is no longer able to add datas into it.

The Google authentication passes and i get the Authentication Code (only in TEST mode with my emails defined in registered user into Google console) however Forms is not able anymore to list the shared Google Sheets files.

Select a spreadsheet list stays empty !

1 week 5 days ago #5

  • Vyacheslav's Avatar
  • Vyacheslav
  • Posts: 23440
Hello,
Thank you for contacting us

Send us a link to page with problem.
Send us FTP access and Joomla admin access via our contact form.
support.balbooa.com/contact-us

Regards,
Vyacheslav, Balbooa.com

1 week 5 days ago #6

  • Vyacheslav's Avatar
  • Vyacheslav
  • Posts: 23440
Google has changed api for test applications now set a limit of 7 days and the token becomes expired
support.google.com/cloud/answer/10311615...ting%2Cin-production

You need to recreate the token again, etc.
or send the application to production
and in 3-5 days the first email will come with instructions on what else needs to be filled out

Best Regards,
Vyacheslav, Balbooa Support Team
Powered by Kunena Forum