Skip to content

google_apps_script.md

Latest commit

 

History

History
53 lines (27 loc) · 2.28 KB

google_apps_script.md

File metadata and controls

53 lines (27 loc) · 2.28 KB
Raw

Upload the codes to Google App script

  1. Go Google Apps Script and new a project.

    image

  2. Copy and paste the codes from src to Google Apps Script.

    image

  3. Set the OpenAI API key, Tenor API key and Tenor client key.

    image

  4. Set the Sheet ID and Discord webhook. Check the function pushEnglishVocabulary is selected and then click Run.

    image

  5. Click Review permissions.

    image

  6. Choose your account.

    image

  7. Click Go to Project_name (unsafe)

    image

  8. This script will access Google Sheets. Click Allow

    image

  9. Check the result. (The message should be pushed to Discord.)

    image

  10. Check your Discord.

    image

  11. Check your Google sheets, the Notified should be set to yes.

    image

  12. Go back to Apps Script and click clock icon and add the triggers.

    image

  13. Set the triggers to whatever you want.

    image