Learning Timeline
Key Insights
How to Save API Credits
Use a 'Filter' node in n8n to limit the process to only the first 2-3 rows during the testing phase. This prevents wasting your Gemini or Google API credits before you are satisfied with the results.
Gemini Voice Variations
Gemini TTS offers nearly 30 different voice options. You can set parameters to choose male or female voices, and control the speed and tone to suit your project's needs.
Step by Step
Bulk Audio Generation Automation Process
- Prepare a Google Sheets file containing columns for 'Text' (sentences) and 'Language' (target language).
- Open n8n and add a 'Google Sheets' node to Read all data rows from the sheet.
- Connect to the 'Gemini' node and select the 'Pro Preview' model that supports TTS (Text-to-Speech) functionality.
- Enter your prompt into the Gemini node by mapping the data references from the Google Sheets columns.
- Use a 'Code' node or data transformation function to convert the Gemini API output (Base64) into Binary format.
- Add a simple script or processing node to convert the audio into a .wav format compatible with Google Drive.
- Add a 'Google Drive' node and select a destination folder to Upload the generated audio files.
- Click the 'Execute Workflow' button to start the automated audio generation for every row of data.
