TAGS Exporer url is different to worksheet ID if data is pasted

Home Forums TAGSExplorer Questions/Issues TAGS Exporer url is different to worksheet ID if data is pasted

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #1057
    danmcquillan
    Participant

    somewhere between 5k and 10k tweets, tags explorer becomes unusable on my laptop (i.e. the script hangs).

    my hack is to cut my data in to 5k chunks. i do this offline in a spreadsheet because trying to select 1000s of rows in a google doc sheet takes too long.

    i then paste the slice of data in a new tags template.

    but i notice that the worksheet id for tags explorer on the settings sheet doesn’t match the archive worksheet id in this new template. i’m a bit unclear why this is – can anyone help?

    if i copy/paste the correct id in to tags explorer it works fine.

    #1060
    mhawksey
    Keymaster

    Hi – I think Sheet IDs can change between copies of the template but the script should provide the correct link on the readme/settings sheet if you are pasting the data back into a sheet named Archive.

    If the spreadsheet is published the TAGSExplorer homepage lets you add a spreadsheet id and then select a sheet

    https://hawksey.info/tagsexplorer/

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.