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

    An error with code [ 3 ] ocurred when requesting information from a Google: ScriptError

    Scheduled Pinned Locked Moved
    Google Sheets
    5
    18
    1.8k
    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.
    • Kikupjundefined
      Kikupj
      last edited by

      Is this in relation to my last post?? I’m having the issue on one machine but my other machine connects the google sheets without a problem…

      Jonundefined 1 Reply Last reply Reply Quote 0
      • Jorge Santanaundefined
        Jorge Santana
        last edited by

        Hi Kikupj,

        I think there is a correction between your post and mine, but I’m not sure.

        In my case I can authenticate the spreadsheet, but the error happens at the time of rendering.

        I am waiting for help!

        1 Reply Last reply Reply Quote 0
        • Kikupjundefined
          Kikupj
          last edited by

          Okay, well best of luck. Hopefully they can fix that soon.

          1 Reply Last reply Reply Quote 0
          • Jonundefined
            Jon @Jorge Santana
            last edited by

            @Jorge-Santana Do you have a render-status column in your Sheet? Do you have a bot column (optional)? If you have a bot column, do you also have an identical name set in Templater’s preferences? Is there an empty column at last column in your Sheet?

            1 Reply Last reply Reply Quote 0
            • Jonundefined
              Jon @Kikupj
              last edited by

              @Kikupj do you have a bot column set in your data? If so, have you set the Bot name in Templater’s preferences on both machines?

              1 Reply Last reply Reply Quote 0
              • Jorge Santanaundefined
                Jorge Santana
                last edited by

                Hi Jon,

                thanks for the help!

                I don’t have a render-status column, nor do I have a bot column. I have a few empty columns at the end of my last column.

                Jonundefined 1 Reply Last reply Reply Quote 0
                • Jonundefined
                  Jon @Jorge Santana
                  last edited by

                  @Jorge-Santana If you are using “the Bot” by clicking “Enable Bot” you will need to have a “render-status” column in your Sheet with values set as “ready” for the rows that you want to render. That ScriptError appears when you enable the Bot without a “render-status” column-- the Bot doesn’t know which rows to render. The error can also occur when you do have a “render-status” column without a corresponding “bot” column and value when you have set a Bot Name in Templater’s Preferences. If you’re not using multiple Bots to render, then leave that option blank in the Preferences, and don’t worry about adding a “bot” column into your data.

                  1 Reply Last reply Reply Quote 0
                  • Jorge Santanaundefined
                    Jorge Santana
                    last edited by

                    Hi Jon, the error is gone after I added the columns you said. Thank you!

                    I have another question:

                    I get the message that all the compositions have been replicated, but I can’t find them in the destination folder. I am generating compositions for a watch folder in Adobe Media Encoder.

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

                      @Jorge-Santana Can you check and make sure that the 'Send replicates to Adobe Media Encoder (CC Only) option is checked in the Templater Preferences panel? That’s the most likely culprit. If that doesn’t make a difference, it’s possible, if you’re using an output column, that a subfolder might be being created where the replicates are being stored. I’d recommend checking that option first and if that doesn’t solve things, let us know. Thanks.

                      1 Reply Last reply Reply Quote 0
                      • Jorge Santanaundefined
                        Jorge Santana
                        last edited by

                        Hi Jeff, thanks!

                        I fond my replicated compositions.

                        Thanks for the help.

                        1 Reply Last reply Reply Quote 0
                        • RobAranterundefined
                          RobAranter
                          last edited by

                          I´m having the same problem here.
                          But I´ve already created a column named render-status.
                          For some reason I cannot get the bot to work.
                          I even thought the problem was I had the OUTPUT column in the end, so I brought it to the beggining.
                          And I deleted all the columns I was not using for Templater.
                          But still, I can´t find the solution.
                          What else can I do about it?

                          1 Reply Last reply Reply Quote 0
                          • RobAranterundefined
                            RobAranter
                            last edited by

                            I´ve tryed now in a different spreadsheet that only have 3 columns - 2 data and 1 render-status -, and happens the same:
                            error 3
                            Could you please help me?

                            Jonundefined 1 Reply Last reply Reply Quote 0
                            • Jonundefined
                              Jon @RobAranter
                              last edited by

                              @RobAranter You need to make sure that you have an empty column at the end of your sheet. If you only have three columns, and all of them have data in them, that will cause an error with the Bot. If you have data in three columns, you need at least four columns, total, with the last one being empty.

                              We are going to be pushing out an update soon that will resolve this issue, if that is what you are experiencing, but the workaround is pretty straightforward in the meantime.

                              It could also happen if your column isn’t called exactly render-status, but something such as render_status, or if you’ve set a Bot name in Templater’s Preferences, but there is no bot column in your data.

                              RobAranterundefined 1 Reply Last reply Reply Quote 0
                              • RobAranterundefined
                                RobAranter
                                last edited by

                                Hello!
                                I can´t see what I´m doing wrong.
                                Please check the image.
                                And still doesn´t work.
                                alt text

                                1 Reply Last reply Reply Quote 0
                                • RobAranterundefined
                                  RobAranter @Jon
                                  last edited by

                                  @Jon This is the message from log

                                  2020-11-19 @ 23:45:42 [BOT] : The Bot for Templater is now enabled.
                                  2020-11-19 @ 23:46:42 [BOT ACTION] : Render…
                                  2020-11-19 @ 23:46:42 [RENDER VIDEO] : Executing batch render of video output.
                                  2020-11-19 @ 23:46:43 [GOOGLE API ERROR] : An error with code [ 3 ] occurred when requesting information from a Goo gle: ScriptError
                                  2020-11-19 @ 23:46:43 [RETRIEVING JOBS] : No jobs found in datasource.
                                  2020-11-19 @ 23:47:14 [BOT TOGGLE] : Templater Bot checking [ Google Sheet Document ] interval in minutes =>
                                  1

                                  2020-11-19 @ 23:47:14 [BOT] : The Bot for Templater is now disabled
                                  2020-11-19 @ 23:48:11 [LOG] : Attempting to display contents of Templater’s log in new window.

                                  1 Reply Last reply Reply Quote 0
                                  • RobAranterundefined
                                    RobAranter
                                    last edited by

                                    Could it be something related to my google account?
                                    I´ve just tried another account and it worked

                                    Jonundefined 1 Reply Last reply Reply Quote 0
                                    • Jonundefined
                                      Jon @RobAranter
                                      last edited by

                                      @RobAranter Do you have any special characters in the title of your Google Sheet?

                                      It could also be something to do with your Google Account, or with the authorization that Templater had previously retrieved. Can you try signing back into the problematic account in the Google Sheets Setup?

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