[Python] Is it possible to mass replace scripts in the Google spreadsheet (extensions -> apps...

I need to create a script in python/google scripts that will replace the script in the sheet. The source script that will be used for the replacement will be saved as Google Script and will have a permanent ID. After providing the sheet ID, the script would find the .gs function with the same name and insert the source script there. I'm trying to create something like this, but every time at some stage it throws HttpError 500 when requesting https://script.googleapis.com/v1/projects.../content?alt=json returned "Internal error encountered.". Details: "Internal error encountered.">

I tried creating a google and python script, still the same effect.

import time
import google.auth
from google.auth.transport.requests import Request
from google.oauth2.credentials import Credentials
from google_auth_oauthlib.flow import InstalledAppFlow
from googleapiclient.discovery import build
from googleapiclient.errors import HttpError

# Configuration constants
SCOPES = ['https://www.googleapis.com/auth/script.projects'] # Required API scope
SOURCE_SCRIPT_ID = 'YOUR_SOURCE_SCRIPT_ID_HERE' # Replace with your source script ID
FILE_NAME = 'YOUR_SCRIPT_FILE_NAME_HERE' # Replace with your script file name

def authenticate():
"""Handle OAuth2 authentication and return credentials."""
creds = None
# Load existing credentials if available
if os.path.exists('token.json'):
creds = Credentials.from_authorized_user_file('token.json', SCOPES)

# Refresh or create new credentials if needed
if not creds or not creds.valid:
if creds and creds.expired and creds.refresh_token:
creds.refresh(Request())
else:
flow = InstalledAppFlow.from_client_secrets_file(
'credentials.json', SCOPES)
creds = flow.run_local_server(port=0)
# Save credentials for next run
with open('token.json', 'w') as token:
token.write(creds.to_json())
return creds

def get_source_file_content(creds):
"""Retrieve content of the source file from the source project."""
try:
service = build('script', 'v1', credentials=creds)
# Get content from source project
source_project = service.projects().getContent(scriptId=SOURCE_SCRIPT_ID).execute()

# Search for the specified file
for file in source_project['files']:
if file['name'] == FILE_NAME:
return file['source']

raise Exception(f"File {FILE_NAME} not found in source project.")
except HttpError as error:
print(f"API Error: {error}")
raise

def update_target_script(target_script_id, new_content, creds):
"""Update the target script with new content."""
max_retries = 3
retry_delay = 5 # Seconds between retries

for attempt in range(max_retries):
try:
service = build('script', 'v1', credentials=creds)
# Get current content of target project
target_project = service.projects().getContent(scriptId=target_script_id).execute()

# Simplify file structure for API compatibility
simplified_files = []
for file in target_project.get('files', []):
simplified_files.append({
'name': file['name'],
'type': file['type'],
'source': file['source']
})

# Update or add the target file
file_found = False
for file in simplified_files:
if file['name'] == FILE_NAME:
file['source'] = new_content
file_found = True
break

if not file_found:
simplified_files.append({
'name': FILE_NAME,
'type': 'SERVER_JS',
'source': new_content
})

# Send update request
request = {'files': simplified_files}
response = service.projects().updateContent(
scriptId=target_script_id,
body=request
).execute()
print("Script updated successfully!")
return
except HttpError as error:
if error.resp.status == 500 and attempt < max_retries - 1:
print(f"Server error. Retrying ({attempt + 1}/{max_retries})...")
time.sleep(retry_delay)
else:
raise Exception(f"Update failed: {error}")

def main():
"""Main execution flow."""
target_script_id = input("Enter target script ID: ")
creds = authenticate()
new_content = get_source_file_content(creds)
update_target_script(target_script_id, new_content, creds)

if __name__ == '__main__':
main()````

Continue reading...