Generate Video Scripts Using Google Gemini from Notion with Pabbly Connect

Learn how to automate video script generation using Google Gemini from Notion and save it to Google Docs with Pabbly Connect in this step-by-step tutorial.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To automate video script generation, first access Pabbly Connect. Visit the Pabbly Connect landing page by searching for ‘Pabbly.com/connect’ in your browser. Here, you can either sign up for a new account or log in to an existing one.

Once logged in, navigate to the dashboard. Click on the ‘Create Workflow’ button to start setting up your automation. Choose a suitable name for your workflow, such as ‘Notion to Google Docs Automation’. This setup will allow you to connect Notion, Google Gemini, and Google Docs through Pabbly Connect.

2. Setting Up Notion as a Trigger in Pabbly Connect

In this step, we will configure Notion as the trigger for our automation in Pabbly Connect. Select Notion from the app list and choose the trigger event as ‘New Database Item’. This means that the automation will activate whenever a new topic is added in Notion.

• Select the Notion account to connect with Pabbly Connect.
• Allow access to your Notion databases.
• Choose the specific database that contains your video topics.

Once the connection is established, click on ‘Save and Send Test Request’. This action will confirm that Pabbly Connect is successfully receiving data from your Notion database.

3. Integrating Google Gemini for Script Generation

The next step is to connect Google Gemini through Pabbly Connect to generate the video script. In the action step, search for Google Generative AI and select it. Choose the action event as ‘Generate Content’ to enable script creation based on the topic and description received from Notion.

To connect Google Gemini, you will need to input the API key from your Google AI Studio. Follow these steps to obtain the API key:

• Log into your Google AI Studio.
• Create a new project if you haven’t done so already.
• Generate a new API key for this project.

Once you have the API key, paste it into Pabbly Connect and map your prompt, which will include the topic and description from Notion. This will instruct Google Gemini to create the script based on the provided information.

4. Saving the Generated Script to Google Docs

After generating the video script with Google Gemini, the next step is to save this script in Google Docs using Pabbly Connect. In the action step, select Google Docs and choose the action event as ‘Create Document from Template’. This allows you to use a pre-existing template for your video scripts.

Connect your Google Docs account and select the template document you created earlier. Map the topic, description, and script generated by Google Gemini into the corresponding fields in the template. This ensures that all necessary information is included in the new document.

Select the folder in Google Drive where you want to save the document. Name the new document based on the video topic. Click ‘Save and Send Test Request’ to create the document.

Upon successful execution, you will find the new document in your specified Google Drive folder, containing the topic, description, and generated script.

5. Finalizing Automation Settings in Pabbly Connect

With the automation workflow set up, you can now finalize the settings in Pabbly Connect. Adjust the trigger time to determine how often Pabbly Connect checks for new items in your Notion database. The default is set to every 8 hours, but you can modify this to 90 minutes or any other interval that suits your needs.

After configuring the trigger time, ensure that everything is functioning as expected. You can test the workflow by adding a new topic in Notion and confirming that the script is generated and saved in Google Docs automatically.

This automation streamlines the video scripting process, allowing you to focus on content creation rather than manual scriptwriting. With Pabbly Connect, you can easily integrate multiple applications and improve your workflow efficiency.

Conclusion

In this tutorial, we explored how to automate video script generation using Pabbly Connect, Google Gemini, and Notion. This integration enhances productivity by streamlining the scriptwriting process, allowing you to focus on creating engaging video content.