Okay
  Public Ticket #3842129
Google Sheets Authorizatino
Open

Comments

  • Sigurd started the conversation

    Hi,

    I keep getting this error:

    wpDataTables was unable to access data. Unauthorized access. Please make file accessible.

    Google Sheets table generation, on other parts of the website it works, but somehow i cannot replicate it. Tried two days, your support videos and chatgbt. No idea where the issue lies. 

    Please help!

    Kind regards

    Sigurd


  •  1,887
    Miloš replied

    Hello,

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

     

    Google has recently updated its security policies, affecting how Google Spreadsheets connect to third-party applications.

    As a result, existing spreadsheets created before this change will continue to work without issues. However, newly created Google Sheets will encounter connection errors due to these updated security protocols.

    For the newly created Google Sheets with wpDataTables, you’ll need to connect your Google API service account in the plugin settings/Google Spreadsheet API settings.

    You can find detailed instructions on setting up a Google API service account here.

    • If you use published sheets, follow this guide.
    • If you need to use private sheets, refer to this guide.

    Once your Google API service account is added to our plugin, you won’t need to repeat this step, and all Google Sheets functionalities will work as before.

    Let me know if you need further assistance!

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables