Skip to main content
Solved

Google Sheets Reader in FME Form 2025.1.2

  • September 22, 2025
  • 3 replies
  • 44 views
smithgk
Contributor
Forum|alt.badge.img+9

Hello, I just upgraded to FME Form 2025.1.2 and am having a problem with the Google Sheets Reader. The Reader previously worked in FME 2024.x, but I am now getting a very ambiguous error whenever I try to read a sheet into a workspace. I literally just upgraded this morning after initially opening the workspace in Form 2024 and successfully running it, so I know nothing has changed on my computer or anything otherwise. Any ideas what I am doing wrong?

 

Best answer by desiree_at_safe

Hi ​@smithgk! I wasn’t able to get the same error as you, but I was able to get the Google Sheet V4 Reader working in 2025.1.2.

A few things I did which I’m not sure you did as well,

  1. Go to my Web Connections> Google Sheets (safe.google-sheets) and Sign in with Google to reauthenticate
  2. Used the spreadsheet URL for the Google Sheet parameters instead of the Spreadsheet name
  3. Alternatively, I was able to get it working in an older version by creating a new web connection in the Reader’s connection parameter

I’m curious if those would work for you. I also looked into the packages dialog. I also didn’t get a notification to upgrade my package, but it looks like I was already updated to the current version.

When you go into FME Packages and Google Sheets, is the Update button also grayed out?


It’s still possible there is a bug or enhancement but with more information from your set up we would get a clearer picture!
 

    danilo_fme
    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    3 replies

    smithgk
    Contributor
    Forum|alt.badge.img+9
    • smithgkContributor
    • Author
    • Contributor
    • September 22, 2025

    It could be a bug, I downgraded to 2025.0.2 and things seem to be working okay now.

    I didn’t try it, but I maybe should have uninstalled/reinstalled the Google Sheets package to Form 2025.1.2 when I first upgraded. For whatever reason, FME did not ask me to reinstall that package when I upgraded to 2025.1.2, but it did ask me to reinstall when I downgraded to 2025.0.2

    desiree_at_safe
    Safer
    Forum|alt.badge.img+16
    • desiree_at_safeSafer
    • Safer
    • Best Answer
    • September 23, 2025

    Hi ​@smithgk! I wasn’t able to get the same error as you, but I was able to get the Google Sheet V4 Reader working in 2025.1.2.

    A few things I did which I’m not sure you did as well,

    1. Go to my Web Connections> Google Sheets (safe.google-sheets) and Sign in with Google to reauthenticate
    2. Used the spreadsheet URL for the Google Sheet parameters instead of the Spreadsheet name
    3. Alternatively, I was able to get it working in an older version by creating a new web connection in the Reader’s connection parameter

    I’m curious if those would work for you. I also looked into the packages dialog. I also didn’t get a notification to upgrade my package, but it looks like I was already updated to the current version.

    When you go into FME Packages and Google Sheets, is the Update button also grayed out?


    It’s still possible there is a bug or enhancement but with more information from your set up we would get a clearer picture!
     

    Happy FME-ing!
    smithgk
    Contributor
    Forum|alt.badge.img+9
    • smithgkContributor
    • Author
    • Contributor
    • September 23, 2025

    ​@desiree_at_safe thank you for following up! I re-upgraded to 2025.1.2 from 2025.0.2, checked all the places you indicated, and now it works great. I’m not totally sure what went wrong the first time I tried the install, but everything seems to be working great for me now. Thanks again!

    Community Stats

    32,127
    Posts
    121,961
    Replies
    39,777
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.