Automate Story Generation with Pabbly Connect, Google Gemini, and Google Docs

Learn how to automate story generation using Pabbly Connect, Google Gemini, and Google Docs. Step-by-step guide for seamless integration. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect to Start Automation

To automate story generation, you need to access Pabbly Connect. Start by typing the URL Pabbly.com/connect in your browser. This takes you to the Pabbly Connect homepage where you can sign in or create a new account.

If you are a new user, click on the ‘Sign Up for Free’ button. After account creation, you receive 100 free tasks every month to explore the platform. Existing users can click ‘Sign In’ to access their dashboards and start creating workflows.

2. Creating a Workflow in Pabbly Connect

Once logged into Pabbly Connect, you can create a new workflow. Click on the blue button labeled ‘Create Workflow’. A dialog box prompts you to name your workflow, such as ‘Generate Creative Stories with Google Gemini’.

• Name your workflow appropriately.
• Select a folder for organization.
• Click ‘Create’ to proceed.

After creating the workflow, you’ll see two windows for trigger and action. The trigger is the event that starts the automation, while the action is what happens in response. For this process, we will use Google Sheets as the trigger and Google Gemini as the action.

3. Setting Up the Trigger with Google Sheets

In this step, you will configure the trigger in Pabbly Connect. Select Google Sheets as your trigger application and choose the event ‘New or Updated Spreadsheet Row’. This sets the workflow to activate whenever a new title is added in your Google Sheets.

Upon selecting the trigger, a webhook URL will be provided. Copy this URL and go to your Google Sheets. Under the Extensions menu, navigate to Add-ons and search for ‘Pabbly Connect Webhooks’ to install it. Once installed, refresh your spreadsheet to see the new options.

• Paste the webhook URL in the Pabbly Connect Webhooks options.
• Specify the trigger column (e.g., column B).
• Click on the ‘Send Test’ button to verify the connection.

Once the test is successful, this confirms that your Google Sheets and Pabbly Connect integration is working correctly, ready to capture new titles automatically.

4. Configuring the Action Step with Google Gemini

With the trigger set, it’s time to configure the action step using Google Gemini in Pabbly Connect. Select Google Generative AI as your action application and choose the event ‘Generate Content’. This action will create a unique story based on the title provided in Google Sheets.

To establish the connection, you’ll need to provide an API key from your Google Gemini account. Navigate to Google AI Studio to generate this key. Once you have the API key, return to Pabbly Connect and input it to connect your Google Gemini account.

Enter the text prompt for story generation. Select the model (e.g., Gemini Pro). Click ‘Save and Send Test Request’ to check if the story is generated.

Upon successful generation, Pabbly Connect will capture the creative story, ready for the next step: saving it in Google Docs.

5. Saving the Story in Google Docs

The final step involves saving the generated story in Google Docs through Pabbly Connect. Add another action step and select Google Docs as your application. Choose the ‘Create Blank Document’ action to start with a new document for the story.

Once connected, map the title of the story to the document name. This ensures that each new document reflects the title from Google Sheets. After creating the document, you will receive a document ID which you will use to append the story.

Select the ‘Append Paragraph to Document’ action. Map the document ID and insert the generated story. Test the integration to ensure the story is appended successfully.

After testing, your automation is complete. Each time you add a new title in Google Sheets, Pabbly Connect will generate a story with Google Gemini and save it in Google Docs automatically.

Conclusion

This tutorial demonstrated how to automate story generation using Pabbly Connect, Google Gemini, and Google Docs. By following these steps, you can streamline content creation efficiently and effectively.