Is It Possible To Create A Table From A Google Sheet?

[a-harvey 0]

Hi,

Some advise if possible.

 

I have the following script, which does exactly what I want.

Which is to import to a table a number of image urls with names, download the images and rename them. perfect.

 

clear table(&images)
create table from file("C:\\Users\\Andrew\\Desktop\\silverim.csv",&images)
set(#row,0,"Global")
create folder($special folder("Desktop"),"Silverstone Images")
set(#path,"{$special folder("Desktop")}/Silverstone Images/","Global")
loop($table total rows(&images)) {
    download file($table cell(&images,#row,1),"{#path}{$table cell(&images,#row,0)}.jpg")
    increment(#row)
}

 

However, I am creating the silverim.csv in Google Sheets, is there a command to pull the csv from sheets, ie can I create the table by pointing to a google sheet.

 

Many thanks

Andrew

[HelloInsomnia 1103]

I think the easiest way would be to export it to a CSV from sheets and then import it into Ubot as a table. You can get a shareable link from sheets so the bot may be able to export the file itself.

[a-harvey 0]

Hi Helloinsomnia,

 

Yes that's what I am currently doing, downloading the sheet as csv and then pulling into Ubot as a table.

I just wondered if Ubot could create a table from a google sheet but obviously not. I don't see it as a command, maybe something that could be added at some stage to the software, or an addon.

 

Thanks, I think the answer then is no not possible. I will stick with the way it currently works which is fine, just was trying to take out another step in the process.

 

Andrew

[HelloInsomnia 1103]

It's possible, you can see there's some JSON in a script you could scrape out and then use something like JSON Path Parser to parse it.

 

But it's way easier to just export the file instead.