Error message for Google Sheets "Add A Single Row"

Hi,

When I’m running Google Sheets “Add A Single Row” I’m receiving this error message:

Error
{“error”:{“code”:403,“message”:“The caller does not have permission”,“status”:“PERMISSION_DENIED”}}

DETAILS
at Object.addRowsToSheet (file:///tmp/pdg/dist/code/eca719e975655cd6b9c7eada882a657bab39d5900d7d10be17cf34c9530d85f3/code/google_sheets/google_sheets.app.mjs:411:15)
at process.processTicksAndRejections (internal/process/task_queues.js:95:5)
at Object.run (file:///tmp/pdg/dist/code/eca719e975655cd6b9c7eada882a657bab39d5900d7d10be17cf34c9530d85f3/code/google_sheets/actions/add-single-row/add-single-row.mjs:105:18)
at global.executeComponent (/var/task/launch_worker.js:139:22)
at MessagePort.messageHandler (/var/task/launch_worker.js:598:28)

I’ve tried re-authenticating Pipedream with Google Sheets, no issues there. Any help would be really appreciated.

Thanks

Hello @wwc-776, I couldn’t reproduce your issue.

I suspect that your issue is related to the Google Sheet permission, could you make sure that:

  1. You have grant Pipedream sufficient permission on your Google account? You can reconnect to Google Sheet as the image below
  2. You have sufficient permission to Update the Google Sheet you have selected

Hi @vunguyenhung,

Thanks for your help. The issue was that my Google Drive was over its maximum storage capacity. After fixing that issue, the workflow is working again.

Thanks again for your quick help.