GoogleCloudPlatform / cloud-for-marketing

Apache License 2.0
186 stars 78 forks source link

permission error #70

Open ejiro-mmw opened 1 month ago

ejiro-mmw commented 1 month ago

hi, been on this for ages, what permisions do i need enabled to have it to work?

tentacles

lushu commented 1 month ago

Hi Ejiro,

Sorry for the inconvenience.

Can you please try to create this Firestore (tentaclessheetdb) in your Google Cloud Console (UI)? After that, try to use the sheet Check resources again? Thank you.

ejiro-mmw commented 1 month ago

will do and get back to you. Thanks you for your swift response

ejiro-mmw commented 1 month ago

image

i have done that and its still the same error, also in the highlighted column, it doesn't have the list of locations as part of the drop down

lushu commented 1 month ago

It looks like the root cause is that a project number has been entered as the project Id. Although project number could work as project Id for many Cloud APIs, it would fail the Firestore location list API invocation. Could you please input the project Id and try again?

Ref: Determine the ID & number of a standard Cloud project

ejiro-mmw commented 1 month ago

Hi Lushu It's all working now after replacing the project number with the ID, Since the project number returned 'OK(green)' on the sheets, it would have been difficult to figure out what the problem was,

thanks again

ejiro-mmw commented 2 weeks ago

Hi Lushu, need help with this please Screenshot 2024-11-11 121308 i have the following secrets Screenshot 2024-11-11 121407

lushu commented 2 weeks ago

Do other secrets work?

ejiro-mmw commented 2 weeks ago

none please

lushu commented 2 weeks ago

Your service account need permissions (e.g. secretmanager.versions.access) from this role: Secret Manager Secret Accessor.

ejiro-mmw commented 2 weeks ago

thanks lushu that worked but came up with this error

image

also file is being uploaded on the tentacle dashboard but it seems one more permission issue image