Google Sheet Get, Insert & Update Plugin Issue

Need help Plugins
1

Hi @lindsay_knowcode,

I’m using your Google Sheet plugin with a Service Account
in a Backend Workflow. The workflow runs without errors
(I can see the access token being generated in the logs),
but nothing gets written to the sheet.

Setup:

  • Step 1: Create new database thing
  • Step 2: GS - get access token
  • Step 3: GS - Append Thing into a Row
    • Access token = Result of Step 2
    • Sheet shared with service account as Editor

Any idea what could be wrong?

P.S.: Account email & private key are set up correctly in your plugin.

Thanks,

Niklas

2

I’ll need to see the debug that the plugin produces. I’ll DM you - don’t paste it here it will have your token in it.

3

Hey Niklas,

Most likely cause here is a mismatch between the Sheet ID or the tab/range reference in Step 3. The access token generating successfully rules out auth as the problem, so the write itself is failing silently.

A few things to check:

  1. Is the Sheet ID the long string from the URL (between /d/ and /edit), not the full URL?
  2. What range/tab name are you passing in Step 3 — does it exactly match the tab name in the sheet (including capitalization)?
  3. Is the service account email added as an Editor on the actual Google Sheet (not just the folder it’s in)?

If all three look right, try running a test with a hardcoded value in the append step to rule out a dynamic data issue.