An error with code [ 3 ] ocurred when requesting information from a Google: ScriptError
“An error with code [ 3 ] ocurred when requesting information from a Google: ScriptError”
This error is occurring in our evaluation version, during our deployment tests. What procedure should we take to solve this problem?
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…
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!
Okay, well best of luck. Hopefully they can fix that soon.
@Jorge-Santana Do you have a
render-statuscolumn in your Sheet? Do you have a
botcolumn (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?
@Kikupj do you have a
botcolumn set in your data? If so, have you set the Bot name in Templater’s preferences on both machines?
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.
@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.
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.
@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
outputcolumn, 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.
Hi Jeff, thanks!
I fond my replicated compositions.
Thanks for the help.
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?
I´ve tryed now in a different spreadsheet that only have 3 columns - 2 data and 1 render-status -, and happens the same:
Could you please help me?
@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 namein Templater’s Preferences, but there is no
botcolumn in your data.
I can´t see what I´m doing wrong.
Please check the image.
And still doesn´t work.
@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 =>
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.
Could it be something related to my google account?
I´ve just tried another account and it worked
@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?