Google Calendar Integration Setup

Hi,

Thanks for all your work on this product, its quite good and I only just need to setup the google calendar for it to serve me well.

Now, I have followed your old instruction on how to setup the Google API/keys/keyfile etc... :: 
docs.joomdonation.com/osservicesbooking/...calendar-integration

Php v 8.2, Joomla V 5.3.2, OS Booking version downloaded ~only 3 months ago.
I have also enabled OS Services Booking - Google Calendar sync  plugin in Joomla.

I have generated a p12 file and placed it in /components/com_osservicesbooking

File name is: incognito-463807-a7c07ed7eef8.p12

Now in the Employee settings page where you enter the google details: (I have removed the email's for security  XXXXXXXX)

Google Calendar credentials
Google client ID
Get this from your Google App Credentials page.
App Name
This is the name of the App you create on Google. You need to create a Google `App` so that OSB is allowed to talk to your calendar(s)
Service account email
XXXXXXXX
Get this from your Google App Credentials page. You will also need to share your calendar to this email address.
Google key
Please enter your Google Application Key, JSON, or P12 file to authenticate and enable access to Google services.
- (This was listed under the 'keys' tab  IAM & Admin  / Service Accounts / Service Account XXXXXX / Keys )
Google Calendar ID
XXXXXXXXX
This is obtained on the Google Calendar 'Calendar Settings' screen, Calendar Address section.

When I create bookings, nothing gets added in calendar, I don't know what I'm missing or what's going on behind the scenes.
If I enter the p12 full file name including the .p12 (incognito-463807-a7c07ed7eef8.p12) where it says "Google key" then I get a 400 error when checking out at the booking page, booking in system but nothing in calendar.

Please help me! I've tried everything I can, searched all the forum posts, read all documentation that I could find.

Best Regards,
Ivan.
 

Hi Ivan,
Thank you very much for your detailed feedback and for using our product.
Currently, Google Application no longer supports the .p12 key file format. To integrate Google Calendar successfully, please generate a JSON key file from your Service Account in the Google Cloud Console. Once you have the JSON key file, upload it to the following folder on your server:
components/com_osservicesbooking
Then, in the Employee settings page, simply enter the JSON key file name for each employee as you did previously. Save the changes and try testing the booking and calendar sync again.
If you encounter any further issues, please let us know—we’re happy to help!
Best regards,
Dam

Thank you Dam,

Apologies if I have missed something, this is what I have tried:

I have created a JSON key and removed the P12 key in the following place in google:
console.cloud.google.com/iam-admin/servi...120327633551814/keys ?....

The key was uploaded in /components/com_osservicesbooking
'incognito-463807-a538752a8dc3.json'


I have updated the Employee settings as follows:

Google client ID
111108120327633551814
Get this from your Google App Credentials page.
App Name
osbcalendar
This is the name of the App you create on Google. You need to create a Google `App` so that OSB is allowed to talk to your calendar(s)
Service account email
XXXXXXX@gmail.com
Get this from your Google App Credentials page. You will also need to share your calendar to this email address.
Google key
incognito-463807-a538752a8dc3 <<<??????
Please enter your Google Application Key, JSON, or P12 file to authenticate and enable access to Google services.
Google Calendar ID
XXXXXXX@gmail.com
This is obtained on the Google Calendar 'Calendar Settings' screen, Calendar Address section.


I have tried using the newer Google client ID as per above: '111108120327633551814'
as well as several google Keys:

Using the json file name in full creates an error 404: 'incognito-463807-a538752a8dc3.json'
Using the name without the '.json' doesn't seem to work, (No error and nothing in calendar)

Using the key listed in:
console.cloud.google.com/iam-admin/servi...120327633551814/keys ?
'a538752a8dc3b04059709520ce3e580565fc7a09' doesnt seem to work either (No error and nothing in calendar).

Can you please let me know what Google client ID and what google key are required because its so confusing.


Best Regards and thank you for your assistance so far.
Ivan.

Hi Ivan,
Please submit ticket on category: OS Services Booking and provide your site credentials. I will check the issue for you.
Thanks
Dam