Support » Plugin: Google Sheets Integration for Caldera Forms » Version 2.3 – API Connected – Data not writing to sheet

  • Resolved Seth Burleigh

    (@sethburleighgmailcom)


    Hi!

    I successfully connected the API – it says “CONNECTED”.

    I’m pretty sure I put in the correct Google Sheet ID.

    But data is not writing to the sheet. I removed/added back the processor to the form, still doesn’t work.

    I am also using Divi theme – but the form submission is working (all auto-emails work, entry shows up in Caldera form entries, etc.)

    I see this error in the log:

    [ERROR_MSG] => {
    “error”: {
    “code”: 403,
    “message”: “The caller does not have permission”,
    “errors”: [
    {
    “message”: “The caller does not have permission”,
    “domain”: “global”,
    “reason”: “forbidden”
    }
    ],
    “status”: “PERMISSION_DENIED”

    Thanks!

    The page I need help with: [log in to see the link]

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Alex Agranov

    (@alexagr)

    Ok – Google API clearly thinks that you are not permitted to access the specific Sheet / Tab.

    Could it be that you are using two Google accounts. And Sheet was created in one of them. But plugin was authenticated using the other one? If so – use the browser that can access the Sheet to re-authenticate the plugin (Get Code > enter code > Save).

    If above doesn’t help – double check Sheet ID / Tab Name and try to simplify the later – e.g. name it “Form”.

    Thread Starter Seth Burleigh

    (@sethburleighgmailcom)

    That was the problem! I have multiple Google addresses, so I gave access to all of them on the form and now the data is writing. Thanks!

    trimurtis

    (@trimurtis)

    I have the same problem. When I successfully connected the API – it says “CONNECTED”. I managed to connect the API – it says “CONNECTED”.

    I am pretty sure I entered the correct Google Sheet ID.

    But the data does not write to the sheet. I deleted / added the processor back to the form, it still doesn’t work.

    [ERROR_MSG] => {
    “error”: {
    “code”: 404,
    “message”: “Requested entity was not found.”,
    “errors”: [
    {
    “message”: “Requested entity was not found.”,
    “domain”: “global”,
    “reason”: “notFound”
    }
    ],
    “status”: “NOT_FOUND”
    }
    }

    The page I need help with:
    https://misterherbal.com/solusi-alami-atasi-diabetes/

    Please Help Me. Thanks

    Plugin Author Alex Agranov

    (@alexagr)

    @trimurtis you are getting a different error code that indicates that Sheet ID / Tab Name that you are using are invalid.
    Double check that you entered them correctly and that you are using Sheet ID and not Sheet Name. And try to simplify Tab Name into a single word – e.g. “Form”.

    I don’t get any connection error, but it doesn’t write in the Sheets. This update does not work.

    Plugin Author Alex Agranov

    (@alexagr)

    Did you generate your own OAuth2 credentials?
    Did you “connect” the plugin to Sheets?
    What error do you get in Debug Log?

    I’ve got the same error:
    [ERROR_MSG] => {
    “error”: {
    “code”: 404,
    “message”: “Requested entity was not found.”,
    “errors”: [
    {
    “message”: “Requested entity was not found.”,
    “domain”: “global”,
    “reason”: “notFound”
    }
    ],
    “status”: “NOT_FOUND”
    }

    I’m sure that I inserted the correct SheetID and TabName
    T try to generate API credentials via Quickstart and manually. Plugin connect succesfully, but it doen’t write on sheet

    Plugin Author Alex Agranov

    (@alexagr)

    Are you using multiple Google accounts by any chance? Could it be that you authenticate plugin from one account and then try to access Sheet that is located in another account?

    Hi Alex, thanks for your reply.
    I tryed to use a “clean” browser with no logged in google account, but it still shows me the same error

    Plugin Author Alex Agranov

    (@alexagr)

    According to the error plugin tries to access Sheet that doesn’t exist. So either you have entered wrong sheet ID in plugin configuration screen, or you are trying to access Sheet that doesn’t belong to Google account that you used when activatng the plugin.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Version 2.3 – API Connected – Data not writing to sheet’ is closed to new replies.