Publish Pub/Sub messages from APP script: PERMISSION_DENIED

Question

I was following this tutorial to make a sheet that publishes rows as messages to Pub/Sub topic.

However, I got this error:

{ 
  error: {
    code: 403,
    message: 'User not authorized to perform this action.',
    status: 'PERMISSION_DENIED' 
  } 
}

What might be the cause?

Answer 1

The problem was caused by multiple accounts.

I created the spreadsheet and applied permissions with my usual account, and that account doesnot have access to the GCP project.

After re-create the spreadsheet with my dev account, which own the GCP project, everything worked!

Answer 2

Authentication problem seems to be the cause

Please go through this link , this might help you to resolve the issue.