Topics Map > Plugins
Topics Map > Troubleshooting

WiscWeb - WordPress UW Theme - Table from Google Sheets Not Rendering

This document will address the specific issue of Google Sheet tables not rendering in wpDataTables.

Steps for Linking a Google Sheet to wpDataTables

There are specific steps that must be followed in order to be able to share a Google Sheet to wpDataTables. If these steps are not followed, your table will not render correctly. 

Step 1: Publishing the Google Sheet to the Web

  1. In your Google Sheet, choose File > Publish to the Web
  2. Choose the desired settings (Entire Document or just specific tabs)
  3. Click Publish

Step 2: Copy the Sheet URL and Paste into wpDataTables

You must copy the URL in the browser, not the URL listed in the "Publish to the Web" section. 
  1. In your browser address bar, copy the URL of the Google Sheet
  2. Make sure that you have a new wpDataTable set up and have chosen to "Create Table from Existing Data Source." The Data Source type should be "Google Spreadsheet." 
  3. Paste the URL into the "Input file path or URL" field.

Troubleshooting/Tips

  • It is important to note that Google Sheets that are located in a Team Folder cannot be shared to wpDataTables. Move your document elsewhere in order to link it. 
  • A common issue is that users are trying to copy/paste the shareable URL rather than the URL that appears in the address bar. This will not connect the table and you won't be able to pull in the content. 
  • Several users have reported issues whereby tables with a lot of customizations or functions in Google Sheets can be glitchy or not display at all. It is recommended that you simplify your tables as much as possible so that wpDataTables can render them. Or, try inline styling a table, instead. 



Keywords:wpDataTables, table, Google Sheets, render, not working, link, connection   Doc ID:88831
Owner:Jenna K.Group:WiscWeb CMS
Created:2019-01-03 16:17 CDTUpdated:2019-01-09 21:17 CDT
Sites:DoIT Help Desk, WiscWeb CMS
Feedback:  0   0