Can't setup Oauth2 to import Google Sheet to Excel

[sc...@xlautomation.com.au]

I am trying to use your examples to import a google sheet into Excel for reporting analysis

I have installed CAPICOM and downloaded the "oauth2credentials.xlsm" and "cDataSet.xlsm" files.

But I cannot work out what I need to do to run the "firstTimeOauth2" routine to set the credentials in my registry before using those to access the Google Sheets...

I am sure that I need to include something in place of the "xxxxxxx" below....but what is that supposed to be.

I have an Google Apps account for my business...

'or you can do first ever like this

    With getGoogled("viz", , "xxxxxx.apps.googleusercontent.com", "xxxxxxx")

        Debug.Print .authHeader

        .tearDown

    End With

Any help appreciated...

[Bruce Mcpherson]

You need to go to the google cloud console and create an application. This will give you some credentials that you can use here. Are you familiar with the cloud console?

Sent from my iPad

--
You received this message because you are subscribed to the Google Groups "Excel Liberation" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excel-ramblin...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[james...@sealedair.com]

Bruce, I am getting an ' the parameter is not correct error' with  "firstTimeOauth2", I see on the web someone else has had this problem, was there ever a solution ? thanks

I would post this on G+ but it says I need Company credentials, have the three basic REST parameters changed ?

[Bruce Mcpherson]

Can you send me the exact code youre getting the error with to br...@mcpher.com. Disguise the credentials if you like.

Bruce

Sent from my iPad

[James Engel]

the error is attached, I checked the scope definition for "sheets" which is correct, so the three required objects seem correct

// this is about setting up for OAUTH2

'// all you have to do is to create a google console developer project

'// create some credentials of app type other

'// activeate the sheets api

'// copy the credentials to the below function (the ones here wont work- they are deactivated)

'// and run this function once.

'// you can delete it once you;ve run it - its not needed any more if you successfully go through the google auth process

Private Function sheetsOnceOff()

    

    getGoogled "sheets", , _

    "40779713482-6qhscp72hf8535o77ohd5s7oekdadlh2.apps.googleusercontent.com", _

    "CFZwF2GbnMHL1vBtGqA9oK2h"

    

End Function

On Fri, Dec 30, 2016 at 12:48 PM, Bruce Mcpherson <br...@mcpher.com> wrote:

Can you send me the exact code youre getting the error with to br...@mcpher.com. Disguise the credentials if you like.

Bruce

Sent from my iPad

On Dec 30, 2016, at 3:27 PM, james.engel via Excel Liberation <excel-ramblings@googlegroups.com> wrote:

Bruce, I am getting an ' the parameter is not correct error' with  "firstTimeOauth2", I see on the web someone else has had this problem, was there ever a solution ? thanks

I would post this on G+ but it says I need Company credentials, have the three basic REST parameters changed ?

On Friday, February 27, 2015 at 5:22:33 PM UTC-6, bruce wrote:

You need to go to the google cloud console and create an application. This will give you some credentials that you can use here. Are you familiar with the cloud console?

Sent from my iPad

On 27 Feb 2015, at 20:08, sc...@xlautomation.com.au wrote:

I am trying to use your examples to import a google sheet into Excel for reporting analysis

I have installed CAPICOM and downloaded the "oauth2credentials.xlsm" and "cDataSet.xlsm" files.

But I cannot work out what I need to do to run the "firstTimeOauth2" routine to set the credentials in my registry before using those to access the Google Sheets...

I am sure that I need to include something in place of the "xxxxxxx" below....but what is that supposed to be.

I have an Google Apps account for my business...

'or you can do first ever like this

    With getGoogled("viz", , "xxxxxx.apps.googleusercontent.com", "xxxxxxx")

        Debug.Print .authHeader

        .tearDown

    End With

Any help appreciated...

--
You received this message because you are subscribed to the Google Groups "Excel Liberation" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excel-ramblin...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Excel Liberation" group.

To unsubscribe from this group and stop receiving emails from it, send an email to excel-ramblings+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to a topic in the Google Groups "Excel Liberation" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-ramblings/yrqFp_48F-s/unsubscribe.
To unsubscribe from this group and all its topics, send an email to excel-ramblings+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

James J. Engel

Allegis Group Database Developer

Wauwatosa, Wisconsin USA

james.engel@sealedair 414-841-8131

[James Engel]

if you have the registry changes I could do them manually

thanks

[burak...@gmail.com]

Hi James,

Did you find any solution.

thanks

5 Ocak 2017 Perşembe 21:55:19 UTC+3 tarihinde James Engel yazdı:

if you have the registry changes I could do them manually

thanks

On Fri, Dec 30, 2016 at 1:19 PM, James Engel <james...@sealedair.com> wrote:

the error is attached, I checked the scope definition for "sheets" which is correct, so the three required objects seem correct

// this is about setting up for OAUTH2

'// all you have to do is to create a google console developer project

'// create some credentials of app type other

'// activeate the sheets api

'// copy the credentials to the below function (the ones here wont work- they are deactivated)

'// and run this function once.

'// you can delete it once you;ve run it - its not needed any more if you successfully go through the google auth process

Private Function sheetsOnceOff()

    

    getGoogled "sheets", , _

    "40779713482-6qhscp72hf8535o77ohd5s7oekdadlh2.apps.googleusercontent.com", _

    "CFZwF2GbnMHL1vBtGqA9oK2h"

    

End Function

On Fri, Dec 30, 2016 at 12:48 PM, Bruce Mcpherson <br...@mcpher.com> wrote:

Can you send me the exact code youre getting the error with to br...@mcpher.com. Disguise the credentials if you like.

Bruce

Sent from my iPad

--

You received this message because you are subscribed to a topic in the Google Groups "Excel Liberation" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-ramblings/yrqFp_48F-s/unsubscribe.

To unsubscribe from this group and all its topics, send an email to excel-ramblin...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

James J. Engel

Allegis Group Database Developer

Wauwatosa, Wisconsin USA

james...@sealedair 414-841-8131

--

James J. Engel

Allegis Group Database Developer

Wauwatosa, Wisconsin USA

james...@sealedair 414-841-8131