As in archived copy of this thread :

Re: Automations error (but not on Block): Response status was 302 'Moved Temporarily' but redirect mode was set to 'error'

Can someone in Airtable update me about the issue of allowing redirects in API/fetch requests in code in automations ? This is needed urgently , so that we can connect airtable to google sheets. (as i create an API in google apps script) so the behaviour of google apps script is, it redirects the requests to another url when you pass a parameter into itself.

example :  if you send a get request to in automation: 

https://script.google.com/macros/s/*******-g/exec

google redirects the paramteres into :

https://script.googleusercontent.com/macros/echo?user_content_key=*******

thus, when i set an automation in when a data updates in airtables scripting section, i get this error:

 I dont want to use any 3rd party services to solve this problem. Thanks