The Problem
At Nimbus Nordic, I was tasked with translating the descriptions for over 80 products into 7 different languages. To do this manually would have been incredibly repetitive and time-consuming. I saw this as the perfect opportunity to build an efficient, automated solution.
How I Used It
I built a custom translation tool directly within Google Sheets, leveraging the seamless connection between Google products.
-
Code Development: I used the Gemini chat interface as a coding partner to help me write a Google Apps Script for the translation task.
-
API Integration: I configured and fetched an API key from the Google AI platform.
-
Implementation: I embedded the script into the Google Sheet. This allowed it to call the Gemini API, translating the entire product list into all 7 languages with a single command.
What This Involved
This project required me to:
-
Apply New Technology: Quickly learn and deploy a new AI model's API to solve an immediate business need.
-
Integrate an Ecosystem: Leverage the synergy between Google Sheets, Google Apps Script, and the Gemini API.
-
Manage APIs: Set up authentication and integrate an AI service into a live work environment.
-
Use AI-Assisted Development: Utilize an AI chat interface to accelerate my own coding and debugging process.
The Result
The outcome was a usefull, custom translation tool that solved the immediate task efficiently. It successfully translated all product descriptions, saving a massive amount of manual work for the company. This project not only delivered a practical solution but also validated my ability to quickly leverage new AI tools to solve real-world business problems.