This plugin hasn’t been tested with the latest 3 major releases of WordPress. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

Inline Google Spreadsheet Viewer

Description

Easily turn data stored in a Google Spreadsheet, CSV file, MySQL database, or the output of a Google Apps Script into a beautiful interactive chart or graph, a sortable and searchable table, or both. Embed live previews of PDF, XLS, DOC, and other file formats supported by the Google Docs Viewer. A built-in cache provides extra speed.

  • Update your blog post or page whenever a Google Spreadsheet or CSV file changes.
  • Create beautiful interactive graphs and charts from your Google Spreadsheet or CSV files with ease.
  • Customize the table’s or chart’s look and feel using a powerful and flexible query language and a plethora of configuration options.
  • Use data from a variety of different sources: Google Spreadsheets, Google Apps Scripts, CSV files, your WordPress database, or a remote MySQL database.
  • Embed almost any online document to view without leaving your blog.

Donations for this plugin make up a chunk of my income. If you continue to enjoy this plugin, please consider making a donation. 🙂 Thank you for your support!

Quick start

Paste the URL of your public Google Spreadsheet or Google Apps Script Web App on its own line in your WordPress post or page, then save your post. That’s it. 🙂 Your data will appear in a sorted, searchable HTML table. Web App output will be displayed using the HTML defined by the Web App. See the screenshots for an example.

If using a Google Spreadsheet, the spreadsheet must be shared using either the “Public on the web” or “Anyone with the link” options (learn how to share your spreadsheet). Currently, private Google Spreadsheets or Spreadsheets shared with “Specific people” are not supported. Web Apps must be deployed with the “Anyone, even anonymous” access permissions. CSV files must be available to the public, without the need to log in to the site where they’re hosted.

Getting support

This document is the only support document for this plugin.

Due the sheer volume of repetitive posts asking questions that have already been answered in this document or by earlier postings on the support forum, I no longer volunteer any of my time to give support to users of this plugin under any circumstances beyond the documentation I have already produced.

In other words:

  • Do not email me expecting a reply. I will delete your email.
  • Do not post on the support forum expecting a reply from me. I will not read your posting and will therefore not respond.

There are more than ten years of questions and answers to those questions covering almost every conceivable use case and situation in which this plugin has been used or is likely to ever be used on the support forum that I have been present for. The meager amount of donations I receive for this plugin does not even register against the fathomingly high amount of effort I have put into monitoring support queries for this plugin. Worse, this effort was often in vain because the answers to the questions almost every single person who asked a question was seeking was already answered in this document or in a previous posting already. Enough is enough.

Your only options to get support for this plugin are:

  • actually read this document, or
  • use the Internet to search for answers previously answered elsewhere, or
  • seek help from someone other than me.

Hopefully, since no one can actually get my support any longer, more of them will do the thing they should have done in the first place and actually read this document, saving everyone involved a lot of time.

User guide

You can transform your spreadsheet into an interactive chart or graph, embed documents other than spreadsheets, and customize the HTML of your table using a [gdoc key=""] WordPress shortcode. The only required parameter is key, which specifies the document you’d like to retrieve. All additional attributes are optional.

Google Spreadsheets

After saving the appropriate Sharing setting, copy the URL you use to view the Google Spreadsheet from your browser’s address bar into the shortcode. For example, to display the spreadsheet at https://docs.google.com/spreadsheets/d/ABCDEFG/edit#gid=123456, use the following shortcode in your WordPress post or page:

[gdoc key="https://docs.google.com/spreadsheets/d/ABCDEFG/edit#gid=123456"]

CSV files

Using a CSV file works the same way as Google Spreadsheets. Set the key to the URL of the file to display it as an HTML table:

[gdoc key="http://example.com/research_data.csv"]

HTML Tables

Customizing the HTML tables that are produced is easy. For instance, to supply the table’s title, <caption>, and a customized class value, you can do the following:

[gdoc key="ABCDEFG" class="my-sheet" title="Tooltip text displayed on hover"]This is the table's caption.[/gdoc]

The above shortcode will produce HTML that looks something like the following:

<table id="igsv-ABCDEFG" class="igsv-table my-sheet" title="Tooltip text displayed on hover">
    <caption>This is the table's caption.</caption>
    <!-- ...rest of table code using spreadsheet data here... -->
</table>

By default, all tables are progressively enhanced with jQuery DataTables to provide sorting, searching, and pagination functions on the table display itself. If you’d like a specific table not to include this functionality, use the no-datatables class in your shortcode. For instance:

[gdoc key="ABCDEFG" class="no-datatables"]

Web addresses and email addresses in your data are turned into links. If this causes problems, you can disable this behavior by specifying no to the linkify attribute in your shortcode. For instance:

[gdoc key="ABCDEFG" linkify="no"]

Each table can be customized per-table, using shortcode attributes, or globally for your entire site, using the plugin’s settings screen. You can freeze the table header, columns, control pagination length, and more. Refer to the Other Notes section for a full listing of supported customization attributes.

Charts

Data from Google Spreadsheets or CSV files can be graphed in interactive charts. To visualize your data as a chart, add the chart attribute to your shortcode and supply a supported chart type. You can make:

For example, if you have data for a sports league that records the goals each team has scored (where the first column is the team name and the second column is their total goals), you can create a bar chart, with an optional title, from that data using a shortcode like this:

[gdoc key="ABCDEFG" chart="Bar" title="Total goals per team"]

You can customize your chart with a number of options, such as colors. For example, to create a 3D red and green pie chart whose slices are labelled with your data’s values:

[gdoc key="ABCDEFG" chart="Pie" chart_colors="red green" chart_dimensions="3" chart_pie_slice_text="value"]

Pre-processing data with Google Queries

You can pre-process your Google Spreadsheets or CSV files before retrieving data from them by passing a Google Charts API Query Language query to the shortcode’s query attribute. This lets you interact with the data in your Google Spreadsheet or CSV file as though it were a relational database table. For instance, if you wish to display the team that scored the most goals on your website, you might use a shortcode like this to query your Google Spreadsheet and display the highest-scoring team, where the team name is the first column (column A) and that team’s score is the second column (column B):

[gdoc key="ABCDEFG" query="select A where max(B)"]

Queries are also useful if your spreadsheet contains complex data from which many different charts can be created, allowing you to select only the parts of your spreadsheet that you’d like to use to compose the interactive chart.

Using a MySQL Database

After an administrator enables the SQL queries option in the plugin’s settings screen, privileged users can also retrieve data from the WordPress database by supplying the keyword wordpress to the key attribute of your shortcode along with a valid MySQL SELECT statement. This can be useful for displaying information that other plugins save in your website’s database or that WordPress itself maintains for you.

For example, to show a table of user registration dates from the current blog:

[gdoc key="wordpress" query="SELECT display_name AS Name, user_registered AS 'Registration Date' FROM wp_users"]

Remote MySQL databases are also accessible by supplying a MySQL connection URL with valid access credentials. For example, to show the prices from an inventory database hosted by a MySQL server at server.example.com by logging in as user with the password password and querying for items that are in stock:

[gdoc key="mysql://user:password@server.example.com/inventory" query="SELECT sku AS 'Item No.', product_name AS Product, price AS Price WHERE in_stock=TRUE"]

Using Google Apps Script Web Apps

You can also supply the URL endpoint of any Google Apps Script Web App to retrieve the output from that app and insert it directly into your WordPress post or page. This works exactly the same way as Google Spreadsheets do, so you can use this feature to display arbitrary data on your WordPress site.

For example, suppose you maintain a GMail account for fans of your podcast to write you questions, and you want to automatically display some information from these emails on your website. Using GMail filters and labels, you can access these emails through a Google Apps Script that reads your email, counts the number of mail messages in your different labels, and returns that count as an HTML list fragment. Deploy that Google Apps Script as a Web App and supply its URL to the gdoc shortcode:

[gdoc key="https://script.google.com/macros/s/ABCDEFG/exec"]

Now your website is automatically updated whenever you receive a new question in email from your listeners.

Embedding other documents

You can also supply the URL of any file online to load a preview of that file on your blog. To do so, supply the file’s URL as your key:

[gdoc key="http://example.com/my_final_paper.pdf"]

To tweak the way your preview looks, you can use the width, height, or style attributes:

[gdoc key="http://example.com/my_final_paper.pdf" style="min-height:780px;border:none;"]

If you like this plugin, please consider making a donation for your use of the plugin, purchasing one of Meitar’s web development books or, better yet, contributing directly to Meitar’s Cyberbusking fund. (Publishing royalties ain’t exactly the lucrative income it used to be, y’know?) Your support is appreciated!

Shortcode attribute documentation

This plugin provides one shortcode (gdoc) that can do many things through a combination of shortcode attributes. Every attribute must have a value. These attributes and their recognized values are documented here.

  • key – Specifies the document to retrieve.
    • required Every gdoc shortcode must have one and only one key attribute. (All other attributes are optional.)
    • key can be one of six types:
      • The fully-qualified URL of a Google Spreadsheet that has been publicly shared, like [gdoc key="https://docs.google.com/spreadsheets/d/ABCDEFG/htmlview#gid=123456"]
      • The fully-qualified URL of a Google Apps Script Web App, like [gdoc key="https://script.google.com/macros/s/ABCDEFG/exec"]
      • The fully-qualified URL of a CSV file or a web service endpoint that produces CSV data, like [gdoc key="http://viewportsizes.com/devices.csv"]
      • The fully-qualified URL of a document on the Web. PDF, DOC, XLS, and other file formats supported by the Google Docs Viewer will be rendered using the Viewer, like [gdoc key="http://example.com/my_final_paper.pdf"]
      • The keyword wordpress to make a SQL query against the current blog’s database, like [gdoc key="wordpress" query="SELECT * FROM custom_table"]
      • A MySQL connection URL to make a SQL query against an arbitrary MySQL server, like [gdoc key="mysql://user:password@server.example.com:12345/database" query="SELECT * FROM custom_table"]
  • chart – Displays Google Sheet data as a chart instead of a table. Valid values are:
    • AnnotatedTimeLine
    • Annotation
    • Area
    • Bar
    • Bubble
    • Candlestick
    • Column
    • Combo
    • Gauge
    • Geo
    • Histogram
    • Line
    • Pie
    • Scatter
    • Stepped
    • Timeline
  • class – An optional custom HTML class value or space-separated list of values. The following class names are treated specially:
    • no-datatables deactivates all DataTables features.
    • no-responsive deactivates only DataTables’ Responsive features.
    • FixedHeader or its synonym, FixedHeader-top, freezes the table header (its <thead> content) to the top of the window while scrolling vertically.
    • FixedHeader-footer freezes the table footer (its <tfoot> content) to the bottom of the window while scrolling vertically.
    • FixedHeader-left or FixedHeader-right freezes the left- or right-most column of the table while scrolling horizontally. (You will also need to set datatables_scroll_x="true" in your shortcode to enable horizontal scrolling.)
    • FixedColumns-left-N or FixedColumns-right-N freezes the left- or right-most N columns in the table, respectively. For example, class="FixedColumns-left-3" will freeze the three left-most columns.
  • csv_headers – Whether or not to include textual headers in Google Sheet CSV exports when using query or chart. (Default: 0, which is to exclude them, which is equivalent to the Google default. Use 1 to include them.)
  • expire_in – How long to cache responses for, in seconds. Set this to 0 to cache forever. (Default: 600, which is ten minutes.)
  • footer_rows – A number specifying how many trailing rows to place in the output’s <tfoot> element. (Default: 0.)
  • header_cols – A number specifying how many column cells should be written with <th> elements. (Default: 0.)
  • header_rows – A number specifying how many leading rows to place in the output’s <thead> element. (Default: 1.)
  • height – Height of the containing HTML element. Tables ignore this, use style instead. (Default: automatically calculated.)
  • http_opts – A JSON string representing options to pass to the WordPress HTTP API, like [gdoc key="ABCDEFG" http_opts='{"method": "POST", "blocking": false, "user-agent": "My Custom User Agent String"}'].
  • lang – The ISO 639 language code declaring the human language of the spreadsheet’s contents. For instance, use nl-NL to declare that content is in Dutch. (Default: your site’s global language setting.)
  • linkify – Whether or not to automatically turn URLs, email addresses, and so on, into clickable links. Set to no to disable this behavior. (Default: true.)
  • query – A Google Query Language query if the data source is a Google Spreadsheet or CSV file, or a SQL SELECT statement if the data source is a MySQL database. Note: Arrow bracktets (< and >) in queries must be URL-encoded (%3C and %3E, respectively) to avoid confusing the WordPress HTML parser. (Default: none.)
  • strip – The number of leading data source rows to omit from the resulting HTML table. (Default: 0.)
  • style – An inline CSS rule applied to the containing HTML element. For example, to set a fixed height on a table, use [gdoc key="ABCDEFG" style="height: 480px;"]. (Default: none.)
  • summary – A brief description of the information displayed for the summary attribute of the resulting HTML <table>. Web pages written in HTML5 should not use this; use a table caption instead. (Default: none.)
  • title – An optional title for your data visualization or table. This is usually displayed in Web browsers as a tooltip when a user hovers over the table or is shown as the headline of a chart. (Default: none.)
  • use_cache – Whether or not to cache spreadsheet data. Set this to no to disable caching for that shortcode invocation. (Default: true.)
  • width – Width of the containing HTML element. Tables ignore this, use style instead. (Default: 100%.)

Chart customization options

To use chart customization options, you must also choose a chart type by including the chart attribute.

The complete list of attributes for configurable chart options is below. Refer to Google’s Chart Gallery documentation for the type of chart you are using to learn more about which chart types support which chart options.

  • chart_aggregation_target
  • chart_all_values_suffix
  • chart_allow_html
  • chart_allow_redraw
  • chart_animation
  • chart_annotations
  • chart_annotations_width
  • chart_area_opacity
  • chart_avoid_overlapping_grid_lines
  • chart_axis_titles_position
  • chart_background_color
  • chart_bars
  • chart_bubble
  • chart_candlestick
  • chart_chart_area
  • chart_color_axis
  • chart_colors
  • chart_crosshair
  • chart_curve_type
  • chart_data_opacity
  • chart_dataless_region_color
  • chart_date_format
  • chart_default_color
  • chart_dimensions
  • chart_display_annotations
  • chart_display_annotations_filter
  • chart_display_date_bar_separator
  • chart_display_exact_values
  • chart_display_legend_dots
  • chart_display_legend_values
  • chart_display_mode
  • chart_display_range_selector
  • chart_display_zoom_buttons
  • chart_domain
  • chart_enable_interactivity
  • chart_enable_region_interactivity
  • chart_explorer
  • chart_fill
  • chart_focus_target
  • chart_font_name
  • chart_font_size
  • chart_force_i_frame
  • chart_green_color
  • chart_green_from
  • chart_green_to
  • chart_h_axes
  • chart_h_axis
  • chart_height
  • chart_highlight_dot
  • chart_interpolate_nulls
  • chart_is_stacked
  • chart_keep_aspect_ratio
  • chart_legend
  • chart_line_width
  • chart_magnifying_glass
  • chart_major_ticks
  • chart_marker_opacity
  • chart_max
  • chart_min
  • chart_minor_ticks
  • chart_number_formats
  • chart_orientation
  • chart_pie_hole
  • chart_pie_residue_slice_color
  • chart_pie_residue_slice_label
  • chart_pie_slice_border_color
  • chart_pie_slice_text
  • chart_pie_slice_text_style
  • chart_pie_start_angle
  • chart_point_shape
  • chart_point_size
  • chart_red_color
  • chart_red_from
  • chart_red_to
  • chart_region
  • chart_resolution
  • chart_reverse_categories
  • chart_scale_columns
  • chart_scale_format
  • chart_scale_type
  • chart_selection_mode
  • chart_series
  • chart_size_axis
  • chart_slice_visibility_threshold
  • chart_slices
  • chart_table
  • chart_theme
  • chart_thickness
  • chart_timeline
  • chart_title_position
  • chart_title_text_style
  • chart_tooltip
  • chart_trendlines
  • chart_v_axes
  • chart_v_axis
  • chart_width
  • chart_wmode
  • chart_yellow_color
  • chart_yellow_from
  • chart_yellow_to
  • chart_zoom_end_time
  • chart_zoom_start_time

DataTables customization options

To use DataTables customization options, you must not supply the no-datatables class.

The complete list of core DataTables customization attributes is below. Please refer to the DataTables Options reference for more information about each particular option.

  • datatables_auto_width
  • datatables_defer_render
  • datatables_info
  • datatables_j_query_UI
  • datatables_length_change
  • datatables_ordering
  • datatables_paging
  • datatables_processing
  • datatables_scroll_x
  • datatables_scroll_y
  • datatables_searching
  • datatables_server_side
  • datatables_state_save
  • datatables_ajax
  • datatables_data
  • datatables_defer_loading
  • datatables_destroy
  • datatables_display_start
  • datatables_dom
  • datatables_length_menu
  • datatables_order_cells_top
  • datatables_order_classes
  • datatables_order
  • datatables_order_fixed
  • datatables_order_multi
  • datatables_page_length
  • datatables_paging_type
  • datatables_renderer
  • datatables_retrieve
  • datatables_scroll_collapse
  • datatables_search_cols
  • datatables_search_delay
  • datatables_search
  • datatables_state_duration
  • datatables_stripe_classes
  • datatables_select
  • datatables_tab_index
  • datatables_column_defs
  • datatables_columns

In addition to the above, the following included DataTables extensions can be customized through these additional shortcode attributes:

Plugin hooks

This section documents hooks that the plugin implements. Developers of other plugins or themes can use these in their code to customize the way this plugin works.

Filtirlər

  • gdoc_table_html – Filters the datasource’s data after it has been converted to an HTML <table> element.
    • The most common use for this filter is to use html_entity_decode() to allow the data source to include raw HTML that will be displayed, so that spreadsheet cells that reference images such as <img src="https://example.com/my-image.png" alt="" /> will show up. However, if the datasource is editable by a malicious user, this is easily abused and is considered a security risk. The author strongly advises caution here and suggests you do not do this unless you are absolutely sure you need this functionality. A much safer technique is to include only the filename of an image in the original datasource (my-image.png) and then write your filter function to append the value of the cell’s data to a base URL so that you can control the source of embedded objects in your HTML pages. Security vulnerabilities are serious, so please make use of the WordPress support forums if you are unsure whether your code is safe.
    • Another related use case for this filter is to allow WordPress shortcodes that are present in the data source to be evaluated at runtime. See this thread for a brief discussion of that use case. However, this can also be problematic and is not recommended unless you are certain the shortcodes being used will not cause issues like broken pages, since most shortcode functions do not expect to be inside of an HTML <table>.
    • This filter runs immediately after HTML conversion is complete, but before that HTML is processed through the make_clickable() function. This means that the value of the linkify shortcode attribute will affect the ultimate output of the shortcode invocation regardless of your filter function, and also means you should not call make_clickable() yourself.
  • gdoc_viewer_html – Same as above, but applied to the <iframe> that loads the Google Docs Viewer. Use this filter to, for intance, customize the fallback content in the case that the user’s browser does not support <iframe> elements.
  • gdoc_webapp_html – Same as above, but applied to the HTTP response body of the Google Apps Script Web App. Use this filter to, for intance, customize the content returned by your GAS Web App similarly to how you might filter the_content of a WordPress post. The first argument is the HTTP response body of the request. The second argument is an array of all the attributes and their values passed to the current invocation of the shortcode.
  • gdoc_query – Filters the query language query. The first argument is the string supplied to the query attribute, or false if no query was supplied. The second argument is an array of all the attributes and their values passed to the current invocation of the shortcode.
    • A common use case for this filter is to query a datasource such as a Google Spreadsheet using dynamically generated content, like the email address or username of the current user.
  • gdoc_enqueued_front_end_styles – An array in the form $handle => array(...) representing parameters to pass to wp_enqueue_style(). This filter lets you unset() stylesheets to prevent the plugin from enqueueing them. Use this to tweak your site’s performance by removing any stylesheets you know you will not need.
  • gdoc_enqueued_front_end_scripts – An array in the form $handle => array(...) representing parameters to pass to wp_enqueue_script(). This filter lets you unset() JavaScript scripts to prevent the plugin from enqueuing them. Use this to tweak your site’s performance by removing any scripts you know you will not need.

Registered script and stylesheet handles

This plugin unconditionally loads numerous scripts in order to make it possible to enhance statically-defined tables (i.e., tables not generated automatically from a remote datasource). For performance reasons, some site administrators prefer not to load these scripts on all pages, so they can selectively dequeue any script or stylesheet this plugin adds by using the gdoc_enqueued_front_end_* filters to remove the scripts with the associated handle. The registered handles are listed here.

Scripts

  • jquery-datatables
  • datatables-buttons
  • datatables-buttons-colvis
  • datatables-buttons-print
  • pdfmake
  • pdfmake-fonts
  • jszip
  • datatables-buttons-html5
  • datatables-select
  • datatables-fixedheader
  • datatables-fixedcolumns
  • datatables-responsive
  • igsv-datatables
  • google-ajax-api
  • igsv-gvizcharts

Stylesheets

  • jquery-datatables
  • datatables-buttons
  • datatables-select
  • datatables-fixedheader
  • datatables-fixedcolumns
  • datatables-responsive

Screenshots

  • Use a Google Spreadsheet or create a new one for your WordPress post or page. Make sure the Spreadsheet is "Public on the web." Learn more about Google Docs sharing settings. If your spreadsheet was created a while ago and still uses an "old" style Google Spreadsheet, use the "Publish as a webpage" option. Make a note of the URL of your Google Spreadsheet's editing page.

  • On-screen help gives you instructions for using the plugin where you need it. Paste the address of your Google Spreadsheet into the key parameter of the plugin's shortcode ([gdoc key="YOUR_SPREADSHEET_URL_HERE"]), then save your post.

  • By default, Inline Google Spreadsheet Viewer produces a feature-rich HTML table on your site. Sort columns, filter rows, browse long tables by page number, show and hide individual columns, or export the table data in three different formats (CSV, Excel, and PDF). The plugin's ouput includes plenty of CSS and JavaScript hooks for unlimited customizability. Read the FAQ for coding details.

  • Transform your spreadsheet's data into an interactive graph or chart by adding a single shortcode attribute. More than a dozen chart types are supported, including Area, Bar, Column, Geo, Pie, Line, Scatter and more. Every chart can be customized with user-defined colors, opacity, and even 3D effects. There are over 50 configuration options to choose from. See the FAQ for a detailed list.

  • Use all the features of the Google Query Language to pinpoint the exact data you want. Over 50 additional configuration options let you customize the exact way your graphs, charts, and tables look.

  • This screenshot shows an example of what the previous screenshot might output with a given spreadsheet that contains data for the Aliens, Ninjas, Pirates, and Robots teams, and their player's respective points.

Installation

  1. Upload the unzipped inline-google-spreadsheet-viewer folder to the /wp-content/plugins/ directory.
  2. WordPress ‘Qoşmalar’ menyusundan qoşmanı aktivləşdirin.
  3. Use the [gdoc key="ABCDEFG"] shortcode wherever you’d like to insert the Google Spreadsheet.

Requirements

  • PHP 5.3 or later is required.

FAQ

Will my website be updated when my Google Spreadsheets change?

Yes. Changes you make to your Google Spreadsheets will be shown on your website within a few minutes.

To improve your website’s performance, Inline Google Spreadsheet Viewer automatically caches spreadsheets for 10 minutes. If you are making many changes quickly and/or you don’t want to wait for the cache to expire on its own, you can add the use_cache="no" attribute to your shortcode to disable the caching mechanism:

[gdoc key="ABCDEFG" use_cache="no"]

After you save and reload the page, you should see near-instant updates. Note that disabling the plugin’s cache can result in decreased performance. Disabling the cache is recommended only for relatively small spreadsheets (less than 100 rows or so) or for debugging purposes.

The default style is ugly. Can I change it?

Yes, if you’re able to change your theme’s style sheet. The plugin renders HTML with plenty of CSS hooks. Use the igsv-table class from your style sheets to target the plugin’s <table> element.

Additionally, each row (<tr>) and cell (<td>) is assigned a specific class attribute value. The first <tr> element is assigned the row-1 class, the second is assigned row-2, and the last row-N where N is the number of rows in the rendered table. Similarly, each cell is assigned a class based on its columnar position; the first cell in a row is assigned the col-1 class, the second col-2, and so on:

.igsv-table .row-2 .col-5 { /* styles for the cell in the 2nd row, 5th column */ }

Finally, both rows and cells (based on columns) are assigned an additional class of either odd or even, allowing for easy zebra-striping in CSS3 non-conformant browsers.

.igsv-table tr.odd  { /* styles for odd-numbered rows   (row 1, 3, 5...) */ }
.igsv-table tr.even { /* styles for even-numbered rows  (row 2, 4, 6...) */ }
.igsv-table td.odd  { /* styles for odd-numbered cells  (column 1, 3, 5...) */ }
.igsv-table td.even { /* styles for even-numbered cells (column 2, 4, 6...) */ }

A table appears, but it’s not my spreadsheet’s data! And it looks weird!

If you’re still using the “old” Google Spreadsheets, you should triple-check that you’ve published your spreadsheet. Google provides instructions for doing this. Be sure to follow steps 1 and 2 in Google Spreadsheets Help: Publishing to the Web. If you’re using the “new” Google Spreadsheets, be sure you’ve selected either the “Public on the web” or “Anyone with the link” Sharing options for your Google Spreadsheet.

A Google Login page appears where my Google Apps Script output should be.

If a Google Login page appears instead of the output of your GAS Web App, double check that you’ve deployed your Web App with the “Anyone, even anonymous” access permission. Learn more about GAS Web App permissions.

Nothing appears where my chart should be.

The best way to determine what’s wrong with a chart that isn’t displaying properly is to try displaying the chart’s data as a simple HTML table (by removing the chart attribute from your shortcode), and seeing what the tabular data source looks like.

Charts most likely fail to display because of a mismatch between the chart you are using and the format of your spreadsheet.

Each type of chart expects to retrieve data with a certain number of rows and/or columns. If your Google Spreadsheet is not already designed to create data for a chart, you might be able to use the query attribute to select only the rows and/or columns that the chart you’re using expects. Otherwise, consider creating a new sheet with the proper formatting and setting it as the key in your shortcode.

To learn more about the correct spreadsheet formats for each chart type, please refer to Google’s Chart Gallery documentation for the type of chart you are using.

Can I remove certain columns from appearing on my webpage?

If you’re using the “new” Google Spreadsheets, you can strip out columns by selecting only those columns you wish to retrieve by passing a Google Charts API Query Language query to the shortcode’s query attribute. For example, to retrieve and display only the first, second, and third columns in a spreadsheet, use a shortcode like this:

[gdoc key="ABCDEFG" query="select A, B, C"]

Alternatively, you can hide columns using CSS with code such as, .col-4 { display: none; }, for example.

How do I change the default settings, like can I turn paging off? Can I change the page length? Can I change the sort order?

All of these DataTables options are accessible through shortcode attributes. The shortcode attribute is an underscore-separated version of the DataTables’s CamelCase’ed option name, prefixed with datatables_. For instance, to turn off paging, you need to set the DataTables paging option to false, so you would use a shortcode like this:

[gdoc key="ABCDEFG" datatables_paging="false"]

Similarly, to change how many rows appear per page, you need to use the DataTables pageLength option, setting it to a number. Its default is 10, so if you wanted to show 15 rows per page, you would use a shortcode like this:

[gdoc key="ABCDEFG" datatables_page_length="15"]

Some DataTables options need to be given JavaScript array literals, such as in the case of the DataTables order option, which controls the initial sort order for a table. However, using square brackets ([ and ]) inside a shortcode confuses the WordPress parser, so these characters must be URL-escaped (into %5B and %5D, respectively). Suppose you want your table to be sorted by the second column in descending order (instead of the first column in ascending order, which is the default). You need to supply a 2-dimensional array such as [[ 1, "desc" ]] to DataTable’s order option (column counting begins at 0). In a shortcode, with the square brackets URL-escaped, this becomes:

[gdoc key="ABCDEFG" datatables_order='%5B%5B 2, "desc" %5D%5D']

Note that when a JSON string literal is supplied in a shortcode attribute ("desc"), it must be double-quoted, so the shortcode attribute value itself must be single-quoted.

Alternatively, if you’re able to add JavaScript to your theme, you can do all of these things, and more because any and all DataTables-enhanced tables can be modified by using the DataTables API.

For instance, to disable paging, add a JavaScript to your theme that looks like this:

jQuery(window).load(function () {
    jQuery('#igsv-MY_TABLE_KEY').dataTable().api().page.len(-1).draw();
});

Or, to have your DataTables-enhanced table automatically sort itself by the second column in descending order:

jQuery(window).load(function () {
    jQuery('#igsv-MY_TABLE_KEY').dataTable().api().order([1, 'desc']).draw();
});

(Replace MY_TABLE_KEY with the Google Spreadsheet document ID of your spreadsheet, of course.)

Please refer to the DataTables API reference manual for more information about customizing DataTables-enhanced tables.

Another option for sorting your table, for example, is to use the query attribute and pass along an appropriate Google Charts API Query Language query that includes an order by clause. In this case, however, you may want to disable DataTables’s client-side sorting, as the data will be sorted in the HTML source.

How do I customize my chart?

Using specific shortcode attributes, you can choose from a huge number of configurable options to customize the look and feel of your chart. The specific shortcode attributes available to you depend on the type of chart you chose. Refer to the Google Chart API documentation to learn which configuration options are available for which type of charts.

Each configuration option is accessible through a shortcode of a similar name. For instance, the colors configuration option is accessible to you through the chart_colors attribute. It accepts a list of colors, which you supply to the shortcode in a similar way as you might provide a class value:

[godc key="ABCDEFG" chart="Pie" chart_colors="red green"]

To create a 3D chart, specify chart_dimensions="3".

With a few exceptions, the name of a shortcode attribute is always an underscore-separated translation of the camelCase name of the option in the Google Chart API. For instance, to disable chart interactivity by setting the chart’s enableInteractivity option to false, use a shortcode like:

[gdoc key="ABCDEFG" chart="Pie" chart_enable_interactivity="false"]

Some configuration options call for an Object value. For these, the shortcode attribute value should be a JSON object. For instance, to use the different properties of the backgroundColor option:

[gdoc key="ABCDEFG" chart="Pie" chart_background_color='{"fill":"yellow","stroke":"red","strokeWidth":5}']

Note that when a JSON object is used as a value, the shortcode attribute’s value must be single-quoted.

See Other Notes for a complete list of attribute for configurable chart options.

Why am I getting errors when I try to use the `query` attribute?

If your query includes an angle bracket, such as a less than (<) or a greater than (>) sign, WordPress will assume you are trying to write HTML and strip everything except the first word of your query, resulting in a syntax error. Instead, use the URL-encoded equivalents of these characters (%3C and %3E, for < and >, respectively), which WordPress will pass to the plugin unmolested and which the plugin is specifically aware of how to handle correctly.

How do I remove unneeded stylesheets or JavaScripts that this plugin adds?

Use the gdoc_enqueued_front_end_styles or gdoc_enqueued_front_end_scripts filter hooks. For instance, to prevent the plugin from enqueueing the JavaScript file for the Google Charts, use code like the following in your theme’s functions.php file:

function igsv_dequeue_google_charts_script ($scripts) {
    unset($scripts['igsv-gvizcharts']);
    return $scripts;
}
add_filter('gdoc_enqueued_front_end_scripts', 'igsv_dequeue_google_charts_script')

See the Other Notes page for a full list of registered script and stylesheet handles this plugin uses.

Reviews

04 Aprel 2022
There have been lots of commercial imitations, but this is still be best and most dependable Google sheet viewer available .... even without support! Hopefully, Meitar, will imagine some improvements and update it someday! By far, this is one of the BEST plugins for Wordpress!
05 Mart 2021
This plugin loads FIFTEEEN external files (js/css) on EVERY PAGE OF YOUR SITE, in addition to it's own js files. This is totally unnecessary and a fundamental flaw in the design. It should only load these files on the pages that require it.
16 Fevral 2021
Even as a neophyte Google Sheets user I found this plugin straightforward and easy to use. Wonderful for sharing data to Wordpress.
20 Dekabr 2020
I have been using it for about 9 months. I do not understand those who write negative comments here. Solution suggestions for many problems are presented here. all I tried works well. Thank you very much for your efforts.
Read all 68 reviews

Contributors & Developers

“Inline Google Spreadsheet Viewer” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

0.13.2

  • Maintenance: Update DataTables libraries. No backwards incompatible changes are expected.

0.13.1

  • Enhancement: New csv_headers shortcode attribute adds support for Google Sheet Query Language HTTP endpoint headers parameter. Using csv_headers=1 in your shortcode may help if you find headers exported from a Google Sheet are missing.

0.13.0

  • Compatibility: Officially support WordPress 5.x and the Block Editor. This update removes the deprecated QuickTags integration from the Classic Editor and fixes minor author-side rendering bugs on WP 5.x.
  • Bugfix: Protect against “Undefined index” error when a user enters an incomplete key value.

0.12.9

  • Bugfix: Fix incorrect spacing causing invalid HTML table row markup.

0.12.8

  • Bugfix: Fix invalid HTML output affecting some CSS hooks.

0.12.7

  • Feature: Add HTML IDs to table rows. Thanks, @ThaiWood. 🙂
  • Bugfix: Compatibility with PHP 7.0 and later.

0.12.6

  • Update DataTables libraries to current release versions.
  • Minor code cleanup. (Fixes broken links in readme, code style, etc.)

0.12.5

  • Bugfix: Remove chart_legend_position attribute and update the documentation. This should be chart_legend with a JSON object attribute value.

0.12.4

  • Enhancement: Google Charts now accept fallback content as part of the shortcode like other options.
  • Bugfix: Support URL-encoded MySQL connection strings.
  • Security: MySQL datasources have been hardened, but their HTML IDs have changed. If you have styles or scripts looking for specific HTML IDs, you will need to update those resources to match the newly generated ID values.

0.12.3

  • Bugfix: Fix errors when using MySQL databse access shortcodes.

0.12.2

  • Feature: Support Google GeoCharts using the Geo chart type ([gdoc key="ABCDEFG" chart="Geo"]).
  • Bugfix: Exception handling no longer fails to return a human-readable error when using SQL data sources.

0.12.1

  • Bugfix: Fix regression during activation.

0.12

  • Automatically force new-style URLs for key attribute values that are still using deprecated old-style document IDs.
  • Bugfix: Fix collision with class names in some cases. This change requires the use of PHP 5.3 or later.