Sticky Note Automate

This workflow is ideal for:

• Language Learners: Individuals looking to enhance their vocabulary in Mandarin Chinese through visual aids and phonetic transcription.
• Educators: Teachers seeking to provide engaging learning materials for students studying Chinese.
• Developers: Those interested in automating language translation and image retrieval processes using APIs.
• Content Creators: People who need to create educational content that combines text and images for better understanding.

This workflow addresses the challenge of learning new vocabulary in Mandarin Chinese by automating the translation process, generating phonetic transcriptions, and providing illustrative images. It streamlines the creation of flashcards, allowing users to:

• Quickly translate words from English to Chinese.
• Obtain accurate pinyin for pronunciation.
• Retrieve relevant images to enhance memory retention and understanding.

1. Trigger on New Row in Google Sheets: The workflow starts when a new word is added to a specified Google Sheets document.
2. Check for Empty Input: It verifies whether the input word is empty and proceeds only if a valid word is provided.
3. Translate the Word: The workflow uses the Google Translate API to translate the word into Chinese (zh-CN).
4. Extract Initial Text and Translation: The initial word and its translation are extracted for further processing.
5. Generate Phonetic Transcription and Example Sentence: An AI agent processes the translated text to generate pinyin and an example sentence in Chinese.
6. Call Pexels API for Images: The workflow searches for relevant images on Pexels based on the initial word.
7. Retrieve Image: It fetches the image from the Pexels API response.
8. Upload Image to Google Drive: The retrieved image is uploaded to Google Drive for storage.
9. Combine Results: All results (initial text, translation, pinyin, example sentence, and image link) are combined.
10. Update Google Sheets: Finally, the workflow updates the Google Sheets document with the new vocabulary details, including the image link.