Library / Translation & Language
Translation & Language
Translate words from Google Sheets and save Pexels images to Google Drive
Reads words from a Google Sheet, translates them with Google Translate, and downloads matching illustrative images from Pexels into a Google Drive folder.
What it does
## 3. Retrieve Images from Pexels Free Database Extract from Google sheet the word you want to translate to download an illustrating image from the free database of pexels.com ### How to set up? - HTTP Request Node (Call API Pexels): add in the header field 'Authorization' the API key provided by Pexels. *(Register here for the free API key: {{ $env.WEBHOOK_URL }} [Learn more about the HTTP Request Node]({{ $env.WEBHOOK_URL }} - Upload the picture to Google Drive: 1. Add your Google Drive API credentials to access the folder for images 2. Select your parent drive using the list, an URL or ID 3. Select the folder in which you want to save the pictures using the list, an URL or ID [Learn more about the Google Drive Upload Node]({{ $env.WEBHOOK_URL }}
The steps
- Google Translate
- AI Agent
- OpenAI Chat Model
- Structured Output Parser
- Merge
- Trigger Added Row
- No Operation, do nothing
- Upload Picture
- Get Picture
- Call API Pexels
- Take initialText
- Extract Image Link
- Final Merge
- Extract Pinyin and Example
17 steps in total.
Similar automations
Content Writing & GenerationPublish Gemini-Written WordPress Posts with Pexels Images24 stepsTranslation & LanguageTranslate Subtitle Files with Google Translate14 stepsTranslation & LanguageTranslate English Text to German with Google Translate2 stepsTranslation & LanguageTranslate Subtitle Files with Google Translate18 steps