How to Generate Creative Stories With Google Gemini Using Pabbly Connect

Learn how to automate story generation with Google Gemini and Pabbly Connect. Follow this step-by-step tutorial to integrate Google Sheets and Google Docs seamlessly. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Story Generation

To start generating creative stories with Google Gemini, you need to access Pabbly Connect. Visit the Pabbly Connect website by typing ‘Pabbly.com/connect’ in your browser. Here, you can either sign in if you are an existing user or click on ‘Sign up for free’ to create a new account.

After signing up, you will have access to 100 free tasks every month. Once logged in, navigate to the dashboard where you can create new workflows. Click on the blue button labeled ‘Create Workflow’ to begin setting up your automation.

2. Creating a Workflow in Pabbly Connect

In this section, you will create a workflow to automate story generation. After clicking ‘Create Workflow’, name it ‘Generate Creative Stories With Google Gemini’. Select a folder to save your workflow, then click ‘Create’. This will open two windows: one for the trigger and another for the action. using Pabbly Connect

• Select Google Sheets as the trigger application.
• Choose the trigger event ‘New or Updated Spreadsheet Row’.
• Copy the provided webhook URL for later use.

Now, go to your Google Sheets where you will add titles for stories. This setup allows the automation to trigger whenever a new title is added, ensuring that a story is generated based on that title using Google Gemini.

3. Linking Google Sheets with Pabbly Connect

To link Google Sheets with Pabbly Connect, navigate to the Extensions menu in Google Sheets and select ‘Add-ons’. Search for the Pabbly Connect Webhooks add-on and install it. After installation, refresh your spreadsheet to see the Pabbly Connect Webhooks option.

Go to the initial setup of the Pabbly Connect Webhooks add-on. Here, paste the webhook URL you copied earlier into the ‘Webhook URL’ field. Set the trigger column to the column that will contain your new titles, typically column B. Click ‘Send Test’ to ensure the connection works.

4. Generating Stories with Google Gemini

After successfully linking Google Sheets with Pabbly Connect, it’s time to set up Google Gemini for story generation. In the action step of your workflow, select Google Generative AI (Gemini) as the application and choose the action event ‘Generate Content’. You will need to create a connection using an API key from Google AI Studio.

• Log into your Google Gemini account and navigate to Google AI Studio.
• Generate a new API key and copy it.
• Paste the API key into Pabbly Connect to establish the connection.

Once connected, enter the prompt for the story generation. You can map the title received from Google Sheets into the prompt. Select the model as Gemini Pro and set the method to ‘Generate Content’. Click ‘Save and Send Test Request’ to check if the story is generated successfully.

5. Saving Generated Stories in Google Docs

After generating the story with Google Gemini, the final step is to save it in Google Docs using Pabbly Connect. Add another action step to your workflow and select Google Docs as the application. Choose the action event ‘Create a Blank Document’. Map the title of the story as the document name.

Once the blank document is created, add another action step to append the story to the document. Select the previously created document by mapping its ID. Insert the generated story content into the document and click ‘Save and Send Test Request’. This will ensure that your story is saved in Google Docs automatically.

Conclusion

Using Pabbly Connect, you can automate the process of generating creative stories with Google Gemini. This integration allows you to seamlessly connect Google Sheets and Google Docs, saving time and enhancing productivity.