[Resolved] CRITICAL - Potential Google Sheets Usage Break [Google Verification] Starts 3/2/2024

[nhmkdev]

[Original message removed, keeping this here for anyone that hits issues]

Google verification complete for the Google Sheets usage available in CardMaker 1.3.0.0. Application accepted as of 3/5/2024! 👍

[nhmkdev]

If you are going to attempt to use a version older than 1.3.0.0 with Google Sheets you can manually add google references to the .cmp project file. They are XML and you'll need to know which layout to add the reference to. The format is as follows:

<Reference RelativePath="google;[reference name];[Child Sheet Name];[sheet id (long sequence of random characters in the url)]" Default="true" />

Notes:

• Only one reference should be marked as Default="true")
• The reference name is whatever you want
• Child Sheet Name must match exactly the name of the sheet within your Spreadsheet
• Sheet id must be exactly the same as the id from the sheets url

Example (with id replaced with 1234567890):

<Reference RelativePath="google;Game Data;Game Data Sheet;1234567890" Default="true" />

[nhmkdev]

Update:

• drive.readonly has been removed from the OAuth flow.
• CardMaker versions prior to 1.3.0.0 version will no longer be able to select Sheets when adding a Google reference
• Re-verification is underway with a new demonstration video and updated request

At this point I basically wait until they respond with additional requests or a final approval. ✔️

[Blkx-Darkreaper]

Just to confirm, this is the cause of the following then? Google Spreadsheet access exception: The service drive has thrown an exception. HttpStatusCode is Forbidden. Request had insufficient authentication scopes.

This is from v1.2.0.0

[mbancha]

@nhmkdev I (re)loaded a google Sheets reference and it seems to work fine, except it's not finding the defines worksheet. Is that just broken for now, or is there a different method to use?

[nhmkdev]

@Blkx-Darkreaper

Just to confirm, this is the cause of the following then? Google Spreadsheet access exception: The service drive has thrown an exception. HttpStatusCode is Forbidden. Request had insufficient authentication scopes.

This is from v1.2.0.0

Yea that's the exact error I would expect from an attempt to add a spreadsheet reference in 1.2.0.0.

[nhmkdev]

@nhmkdev I (re)loaded a google Sheets reference and it seems to work fine, except it's not finding the defines worksheet. Is that just broken for now, or is there a different method to use?

@Spiz

I'm assuming you are referring to project wide defines (I think reference defines are working okay) -- You may need to reconfigure the defines override in the (right-click) Layouts > Project Settings... dialog.

Example:

Which version of CardMaker are you using? Some older versions allowed references (and defines) to just be the spreadsheet name in Google. Unfortunately this will not work and you'll have to re-associate so it has the Spreadsheet ID value. I just hit this in an old project to take the screenshot above.

[mbancha]

Oh I meant using a Google "defines" worksheet for layout defines.

I did get it to work by manually adding the google sheet as a the define file in the project settings as you mentioned. It was just strange that this new version threw an authentication error and wouldn't pull the defines from the "defines" worksheet as it used to.

On Tue, Mar 5, 2024 at 4:59 PM Tim Stair @.***> wrote:

@nhmkdev https://github.com/nhmkdev I (re)loaded a google Sheets reference and it seems to work fine, except it's not finding the defines worksheet. Is that just broken for now, or is there a different method to use?

@Spiz https://github.com/Spiz

I'm assuming you are referring to project wide defines (I think reference defines are working okay) -- You may need to reconfigure the defines override in the (right-click) Layouts > Project Settings... dialog.

Example: image.png (view on web) https://github.com/nhmkdev/cardmaker/assets/6293880/8ba248fc-4766-43d4-893f-e687b3cf2c9e

Which version of CardMaker are you using? Some older versions allowed references (and defines) to just be the spreadsheet name in Google. Unfortunately this will not work and you'll have to re-associate so it has the Spreadsheet ID value. I just hit this in an old project to take the screenshot above.

— Reply to this email directly, view it on GitHub https://github.com/nhmkdev/cardmaker/issues/123#issuecomment-1979892431, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAUDVKPMKBG2X7KXKYJCC33YWZTARAVCNFSM6AAAAABEDGPOWCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNZZHA4TENBTGE . You are receiving this because you were mentioned.Message ID: @.***>