Skip to main content
Question

Error while reading Google Sheets v4 in FME Form 2023.2

  • May 6, 2026
  • 1 reply
  • 42 views
kmaheshv
Observer
Forum|alt.badge.img

I am facing issue when reading Google Sheets v4 in FME, below error occurred. Help you know how it gets rid of it.
DEBUG: urllib3.connectionpool Retrying (Retry(total=9, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1006)'))': 

      1 reply

      desiree_at_safe
      Safer
      Forum|alt.badge.img+21

      Hi ​@kmaheshv! That SSL certificate error usually points to corporate network security performing HTTPS inspection on *.googleapis.com traffic. I'd recommend checking with your IT about this, or testing from a different network (like home WiFi without VPN) to see if the issue persists!

      Also, since the Google Sheets reader is a Python-based format, it’s possible that FME's Python environment still needs to trust the certificate chain. Typically, FME checks the OS certificate store first, but may still need the certificate added to FME's bundled cacert.pem 

      Here's an article on that for reference: SSL Certificate Handling for FME Transformers


      If you’re still having trouble, feel free to open a case with us: Support Case 🙂

       

       

      Happy FME-ing!

      Community Stats

      32,724
      Posts
      124,149
      Replies
      41,216
      Members
      Terms & ConditionsAccessibility 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.