Sticky Note Automate

用于Sticky Note，自动化处理用户在Google Sheets中添加的单词，实时翻译成中文，提取拼音和示例句子，并从Pexels下载相关图片。最终结果将更新到Google Sheets中，帮助用户高效学习新词汇。

7/8/2025
22 nodes
Complex
manualcomplexsticky notegoogletranslatelangchaingooglesheetstriggernoopgoogle drivegooglesheetsadvancedapiintegrationlogicconditional
Categories:
Complex WorkflowManual TriggeredData Processing & Analysis
Integrations:
Sticky NoteGoogleTranslateLangChainGoogleSheetsTriggerNoOpGoogle DriveGoogleSheets

Target Audience

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.

Problem Solved

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.

Workflow Steps

  • 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.

    • Customization Guide

    Users can customize this workflow by:
    - Modifying the Trigger: Change the Google Sheets document or the specific sheet where the vocabulary list is stored.
    - Adjusting Translation Settings: Alter the target language in the Google Translate node to translate into different languages.
    - Customizing the AI Agent: Update the system message for the AI agent to change how it generates pinyin and example sentences.
    - Changing Image Source: Modify the API key and search parameters for the Pexels node to retrieve different types of images or use another image API.
    - Updating Output Structure: Customize the output fields in the Google Sheets update node to include additional information or change the format.