By default, Sheets2Table works from a user-created snapshot of a Google sheet. This works well if the user wants to control when to display the data in WordPress. If the user always wants to publish the data in the Google sheet to WordPress, then the user sets the get-latest-data
shortcode option.
Configure Shortcode
- Open up the Sheets2Table Shortcode tab (Dashboard -> Settings -> Sheets2Table -> Shortcodes)
- Locate the shortcode corresponding to the table you want to make responsive
- Click on the Customize link for your filename
- Select the checkboxes for the columns you want to display
- Select the
get-latest-data
checkbox - Click the Generate shortcode button
- Take notice of the updated shortcode. It should now include an option that reads:
options="get-latest-data"
- Copy / paste the updated shortcode to your page or post
- Each time the data is displayed in WordPress, it first goes to the Google sheets and retrieves the latest data.
<– Previous