Dataclay — Automating Digital Production
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Register
    • Login

    Using a script to pull all Google Sheets into one sheet - issues.

    Scheduled Pinned Locked Moved
    Google Sheets
    2
    2
    457
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • UncleMontyundefined
      UncleMonty
      last edited by

      I’ve got a Google Sheet set up working with a separate sheet for multiple languages - for clarity.

      When I go to render I like to pull all the sheets into one long sheet using…

      =QUERY({ })

      Which works fine on my Windows PC.

      I have a colleague trying to do the same thing but on Mac OSX, I only mention this because it seems to be the only difference otherwise we are set up identically with AE and Templater.

      It only works on my end and when they try to do it Templater just returns errors.

      Does anyone have any idea why?

      1 Reply Last reply Reply Quote 0
      • Jeffundefined
        Jeff
        last edited by

        @UncleMonty

        That’s quite odd. The OS of the machine running Templater typically shouldn’t make a difference when it comes to getting data from a Google Sheet. Can you give us some more information on the errors that you’re seeing?

        If you’d like, you can also email our support channel at support@dataclay.com. Let us know what you can, and we’ll take it from there.

        Thanks!

        1 Reply Last reply Reply Quote 0
        • First post
          Last post