Access Google Docs while using a Service Account

[olivier]

Hi guys,

I just bought the “Google Sheets & Charts (Service)” plugin, and it works like a charm after few difficulties setting up the API Key.

I replicated the following demo and am able to create spreadsheets
https://zeroqode-demo-16.bubbleapps.io/google_sheets_charts_service

The issue I face now is twofolds :

1. I would like to access the files created by my service account in my Google Account, but I do not find them in my Google docs environment associated with my Google developper account. When I try opening them directly using their URL, google sends me a message “this document is not published …”. Basically the document has been created for sure, somewhere, it has an ID and an URL, but how can I access it on Google ?

2. The “Live Results” group can not display the spreadsheet for authentication issues.
   

   
   
   Is there a tutorial for sorting out authentication issues related to displaying google documents created by a service account to bubble application users ?

1 million dollar reward to the right answers

Cheers

Olivier

[kate]

Hello, @olivier! Thanks for reaching out.
Please accept my apologies for the late reply.

1. Have you tried the “Transfer ownership feature?” or “Allow Spreadsheet Access” option? It should help.

2. Please try to use the “Allow Spreadsheet Access” before “Get Spreadsheet Data”. Take a look:

Hope it helps.