Hello,

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!

Hi Zach,

That is strange. So far, we have received reports from users (as well as from our own testing) that all old spreadsheets are working fine, even without connecting the Google API service account in our plugin settings.

This new method is required for using new spreadsheets, but you are experiencing a different issue—almost the opposite scenario.

My apologies—I misunderstood at first, but after re-reading all the details, I now see what you mean.

Could you check the following:

• Did you fully publish these older Sheets by selecting "Publish the entire document" and enabling "If any change is made, automatically re-publish"?
  
  
• Did you set the Share settings to "Anyone with the link can view"?
  
  
• I realize you've probably already done this, but just to be sure to double-check if this might be the issue.

If you've verified everything and still can't isolate the problem, could you send us remote Admin access to the site?

If you can provide Admin credentials or create a new Admin user for my email (found in my signature), please mark your reply as PRIVATE for security reasons.

Thank you!