How to Get JSON Response from Google Gemini in Pabbly Connect

Learn how to get a JSON response from Google Gemini using Pabbly Connect in this detailed step-by-step tutorial. Perfect for automating your workflow! Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Google Gemini Integration

To get a JSON response from Google Gemini, you first need to access Pabbly Connect. Simply enter ‘Pabbly.com/connect’ in your browser. This will direct you to the Pabbly Connect landing page where you can either 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 your account. Existing users can click on ‘Sign in’ and proceed to the all apps page. From there, click on ‘Access Now’ below Pabbly Connect to reach the dashboard.

2. Creating a Workflow in Pabbly Connect

Once you are in the Pabbly Connect dashboard, create a new workflow by clicking on the ‘Create Workflow’ button. Name your workflow something like ‘JSON Response from Gemini’. This will help you identify the purpose of your automation.

After naming your workflow, select the appropriate folder in your Pabbly account and click ‘Create’. Your new workflow will open, displaying two windows: the trigger window and the action window. The trigger window is where you will set up the initial event that starts the automation.

• Click on the trigger window to choose your app.
• Search for Google Sheets and select it.
• Choose ‘New or Updated Spreadsheet Row’ as your trigger event.

Now you are set up to receive data from Google Sheets into Pabbly Connect.

3. Setting Up Google Sheets with Pabbly Connect

Next, you will need to set up your Google Sheets to work with Pabbly Connect. After selecting your trigger event, Pabbly Connect will provide you with a webhook URL. Copy this URL and go to your Google Sheets.

In Google Sheets, navigate to ‘Extensions’, then ‘Add-ons’, and select ‘Get Add-ons’. Search for ‘Pabbly Connect Webhooks’ and install it. Once installed, refresh your Google Sheets to ensure the add-on is active.

• Go back to ‘Extensions’ and select ‘Pabbly Connect Webhooks’.
• Click on ‘Initial Setup’ and paste the webhook URL.
• Set the trigger column as the last column where you will enter data.

After setting this up, you can test by clicking the ‘Send Test’ button, ensuring that data is sent from Google Sheets to Pabbly Connect.

4. Filtering Data for Google Gemini

Once your Google Sheets is set up, the next step is to filter the data before sending it to Google Gemini through Pabbly Connect. This is crucial to ensure that only relevant data is processed. In your Pabbly Connect workflow, add a filter step after the trigger.

Select ‘Filter’ from the app options and set the filter condition based on the status you defined in your spreadsheet. For instance, if the status is ‘Generate’, the automation will proceed to send data to Google Gemini.

Choose the label for the filter as ‘Status’. Set the filter type to ‘Equals’. Specify the value to be ‘Generate’.

By implementing this filter in Pabbly Connect, you ensure that only relevant entries are processed, allowing for a more streamlined workflow.

5. Generating Content with Google Gemini

Now that your data is filtered, the next step is to generate content using Google Gemini through Pabbly Connect. Add an action step and select Google AI Studio as your app. Choose ‘Generate Content’ as the action event and connect your Google AI Studio account.

To connect your account, you will need to enter your API key from Google AI Studio. Once connected, you can set the text prompt that Google Gemini will use to generate the blog content.

Specify the prompt for generating content, including the topic and audience from your previous steps. Ensure to request a JSON response format in your prompt. Select the model you wish to use, such as Gemini 1.5 Pro.

After entering all necessary details, click ‘Save and Send Test Request’. You will receive a JSON response containing the generated blog title, content, slug, and keywords, which you can then map back to your Google Sheets.

Conclusion

In this tutorial, we explored how to get a JSON response from Google Gemini using Pabbly Connect. By following the steps outlined, you can automate your content generation process efficiently. With Pabbly Connect, integrating various applications becomes seamless, enhancing your workflow significantly.