Import/Link from Google Sheets

[Johndinho]

Hi,

We have a large amount of work being done collaboratively in Google Sheets. I want to link the data into a spreadsheet I am working in.

When I run the "Get Data from Web" query and enter the web address of the published document all I get is

Kind	Name	Text
Element	HTML

<colgroup><col><col><col></colgroup><tbody>
</tbody>

I have managed in the past to have the spreadsheet query set so I can refresh via "Refresh All" but I can't remember how....Anyone any ideas???

Thanks