Automate Video Script Generation with Pabbly Connect: Google Gemini and Notion Integration

Learn how to automate video script generation using Pabbly Connect, Google Gemini, and Notion. This detailed tutorial guides you through the integration process step by step.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start automating video script generation, you need to access Pabbly Connect. Open your web browser and navigate to the Pabbly Connect landing page by searching for ‘Pabbly.com/connect’. Here, you will find options to sign in or sign up for a free account.

If you are new to Pabbly Connect, click on the ‘Sign Up Free’ button to create an account. Existing users can directly sign in. Once logged in, you will be directed to the dashboard where you can create automation workflows.

2. Creating a Workflow in Pabbly Connect

After signing in to Pabbly Connect, click on the ‘Create Workflow’ button. Name your workflow something like ‘Notion to Google Gemini to Google Docs’. Select the folder in your Pabbly account where you want to save this workflow.

• Click on ‘Create’ to open the workflow editor.
• You will see two windows: Trigger and Action.
• Set up the trigger to initiate the workflow whenever a new Notion item is added.

In the Trigger window, search for ‘Notion’ and select it. Choose the event ‘New Database Item’ to start the workflow when a new item is added in Notion.

3. Connecting Notion to Pabbly Connect

To connect Notion with Pabbly Connect, click on the ‘Connect’ button and select ‘Add New Connection’. A pop-up will appear asking for permission to access your Notion account. Click on ‘Connect with Notion’ to proceed.

After logging in, select the Notion database you want to connect. Once selected, click on ‘Allow Access’. Now, you will be able to receive data from the selected Notion database in your Pabbly Connect workflow.

After the connection is established, click on ‘Save and Send Test Request’. This action will fetch the most recent item details from your Notion database, confirming that the connection works correctly.

4. Integrating Google Gemini with Pabbly Connect

Now it’s time to integrate Google Gemini using Pabbly Connect. In the Action window, search for ‘Google Generative AI’ and select it. Choose the action event ‘Generate Content’ and connect it to your Google account.

• You need to provide an API key from Google AI Studio to connect.
• Follow the instructions to create an API key if you haven’t done so already.
• Once the API key is entered, click on ‘Save’ to establish the connection.

After connecting, set up the prompt for Google Gemini to generate the script. You can format your prompt by adding the topic and description received from Notion, and then click on ‘Save and Send Test Request’ to generate the script.

5. Saving the Generated Script to Google Docs

The final step involves saving the generated script into Google Docs using Pabbly Connect. In the Action step, search for ‘Google Docs’ and select it. Choose the action event ‘Create Document from Template’.

Connect your Google Docs account and select the template you created for video scripts. Map the topic, description, and generated script into the corresponding fields of the template.

Map the topic from Notion to the ‘Topic’ field. Map the description from Notion to the ‘Description’ field. Map the script generated by Google Gemini to the ‘Script’ field.

Click on ‘Save and Send Test Request’ to create the document in Google Docs. Verify that the document has been created in your specified Google Drive folder.

Conclusion

This tutorial shows how to automate video script generation using Pabbly Connect, Google Gemini, and Notion. By following these steps, you can efficiently streamline your content creation process, saving time and effort in scriptwriting.