Slides-To-Translate: When IT Says No, Build a $0.04 Solution on Your Lunch Break

# Authenticate with your Google Cloud Project
from google.colab import auth
auth.authenticate_user(project_id="your-gcp-project-id")

# Build the service clients for Drive and Slides
from googleapiclient.discovery import build
drive_service = build('drive', 'v3')
slides_service = build('slides', 'v1')

# And initialize the Vertex AI client
from google import genai
client = genai.Client(vertexai=True)

def translate_text(text):
    """Translates a single text string."""
    try:
        response = client.models.generate_content(
            model=MODEL_NAME,
            contents=text,
            config=types.GenerateContentConfig(
                system_instruction=instructions, # e.g., "Translate to German..."
                temperature=0.0,
            )
        )
        return text, response.text.strip()
    except Exception as error:
        print(f"Error translating '{text}': {error}")
        return text, None

from concurrent.futures import ThreadPoolExecutor, as_completed

# Use ThreadPoolExecutor for concurrent translation
with ThreadPoolExecutor(max_workers=MAX_WORKERS) as executor:
    # Create a future for each text translation
    futures = [executor.submit(translate_text, text) for text in unique_texts]
    for future in as_completed(futures):
        # Collect the results as they complete
        text, translation = future.result()
        translations[text] = translation

requests = []
sorted_translations = sorted(translations.items(), key=lambda item: len(item[0]), reverse=True)
for text, translation in sorted_translations:
    if translation.strip():
        requests.append({
            'replaceAllText': {
                'replaceText': translation,
                'pageObjectIds': list(page_ids), # The slides where the text appears
                'containsText': {
                    'text': text,
                    'matchCase': True,
                }
            }
        })

# Execute the batch update
body = {'requests': requests}
response = slides_service.presentations().batchUpdate(
    presentationId=copied_presentation_id, body=body
).execute()