Automating content script workflows with Google Workspace Flows

Automated Video Script Writing Prompt

How to Set Up Email-to-Script Automation with Gemini

1. Open Google Drive and create a specific folder named 'Content Automation'.
2. Open Google Apps Script (script.google.com) and create a new project.
3. Enable 'Gmail API' and 'Google Docs API' under the 'Services' section on the left sidebar.
4. Write a trigger function using 'GmailApp.search' to detect emails with a specific subject (e.g., 'REQUEST SKRIP').
5. Use the 'message.getAttachments()' command to retrieve reference files from the email.
6. Make a fetch call to the Gemini API, passing the retrieved file information into the prompt.
7. Instruct Gemini to generate a script draft based on that data.
8. Use 'DocumentApp.create()' to automatically create a new Google Doc containing the Gemini output.
9. Set a 'Time-driven trigger' in the 'Triggers' section (clock icon) to run the script automatically every 5 or 10 minutes.