Okay
  Public Ticket #3837200
Google Sheets
Open

Comments

  • Luke Gilde started the conversation

    Several tables on our website have started showing this error message on page load: 

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

    These tables are supposed to pull data from Google Sheets, this was working properly yesterday, and I don't believe anything was changed. Some of the other tables on the website are configured the same way, and are still working properly. 

  •  1,887
    Miloš replied

    Hello,

    Apologies for all the waiting time.

    Thank you for your patience.

     

    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