Possible to sync a cell range from google sheets?

  • Resolved sashaza

    (@sashaza)


    4 years, 9 months ago

    Hi,

    We have a very complicated google sheet which is used to manage an e-sports league. We’re looking for a way to dynamically sync specific cell ranges from our spreadsheet and display them in wordpress.

    For example, we’d love a way to create tables in wordpress that can fetch data dynamically from a google sheet by specifying:

    – Spreadsheet URL: e.g. this
    – Which page/sheet in the spreadsheet, e.g. Week 1
    – Which cell range: e.g. D4:I14

    Is this possible with the WPDataTables plugin?

Viewing 1 replies (of 1 total)
  • Plugin Author wpDataTables

    (@wpdatatables)

    4 years, 9 months ago

    Hello there.

    Thank you for your interest in the plugin.

    At the moment, there’s no way to pull in a range of cells. Each tab in the spreadsheet has its own URL, so each tab needs to be created as a separate table.

    If you want to pull only a range of cells, you would need to create a new tab, where you would use the IMPORTRANGE function, which will pull only the range of cells you want to add to wpDataTables. Having column headers is mandatory.

    Kind regards.

Viewing 1 replies (of 1 total)

The topic ‘Possible to sync a cell range from google sheets?’ is closed to new replies.