Learn to generate free stories using Gemini integrated with Google Sheets and Pabbly Connect. Follow this detailed tutorial for step-by-step guidance. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.
Watch Step By Step Video Tutorial Below
1. Accessing Pabbly Connect for Story Generation
To generate free stories using Gemini, you first need to access Pabbly Connect. Start by navigating to Pabbly.com/connect in your browser. This will take you to the Pabbly Connect homepage where you can either sign in or sign up for free.
If you are a new user, click on ‘Sign Up Free’ to create an account and receive 100 free tasks every month. Existing users can simply sign in. Once logged in, you will see the Pabbly apps window, where you can access all the applications offered by Pabbly.
2. Creating a Workflow in Pabbly Connect
After accessing Pabbly Connect, the next step is to create a workflow. Click on the ‘Create Workflow’ button. You will have options for the new beta version or classic version. For this tutorial, select the beta version for a more modern experience.
- Click on the ‘Create’ button to initiate the workflow.
- Name your workflow as ‘Generate Free Stories Using Gemini’.
- Select a folder for your workflow, such as ‘Automations’.
Once you have created the workflow, remember that every automation consists of a trigger and an action. The trigger indicates when an action should be executed. In this case, we will set up Google Sheets as our trigger app.
3. Setting Up Google Sheets as a Trigger
To set Google Sheets as the trigger, select Google Sheets from the app options and choose the event as ‘New or Updated Spreadsheet Row’. Click on ‘Connect’ to establish the connection.
Pabbly Connect will provide you with a webhook URL. Copy this URL as it will be used to connect your Google Sheets with Pabbly Connect.
- Open your Google Sheets and go to Extensions > Add-ons > Get Add-ons.
- Search for ‘Pabbly Connect Webhooks’ and install it.
- Refresh your Google Sheets and set up the webhook using the copied URL.
Once the webhook is set up successfully, you can test the connection by adding new details in your Google Sheets. This will trigger the automation process in Pabbly Connect.
4. Integrating Gemini for Story Generation
With the Google Sheets trigger set, the next step is to add Gemini as the action app to generate the story. Select Gemini and choose ‘Generate Content’ as the action event. Click on ‘Connect’ to set up the connection. using Pabbly Connect
To connect Gemini, you will need an API key from Google AI Studio. Click on the provided hyperlink to access Google AI Studio and retrieve your API key.
Add the API key to the Pabbly Connect integration. Map the necessary fields such as story idea, genre, tone, and character name from your Google Sheets. Save and send a test request to generate the story.
Once the story is generated successfully, you can proceed to create a document in Google Docs to save the story.
5. Saving the Generated Story in Google Docs
The final step is to save the generated story in Google Docs. Select Google Docs as the action app and choose ‘Create a Blank Document’ as the event. Click on ‘Connect’ and sign in to your Google account.
Map the document name to the story ID you generated earlier. After saving this document, you can append the generated story content into this document.
Select ‘Append a Paragraph to a Document’ as the next action event. Connect using the existing Google Docs connection. Map the document ID and the generated story content.
After successfully appending the story, you can also save it as a PDF in Google Drive by utilizing the Google Drive integration within Pabbly Connect.
Conclusion
Using Pabbly Connect, you can effortlessly automate the process of generating free stories with Gemini and save them in Google Docs and Google Drive. This integration enhances your storytelling capabilities while streamlining your workflow. Start automating today!
Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.
- Check out Pabbly Connect – Automate your business workflows effortlessly!
- Sign Up Free – Start your journey with ease!
- 10,000+ Video Tutorials – Learn step by step!
- Join Pabbly Facebook Group – Connect with 21,000+ like minded people!



