AI WhatsApp Chatbot for Coaching Classes & Quiz Campaigns

Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Chatflow for WhatsApp Chatbot Integration

To create a WhatsApp chatbot, start by accessing Pabbly Chatflow. Open your browser and type www.pabbly.com/chatflow to reach the Pabbly Chatflow website.

Once there, log in to your Pabbly account. If you are new, click on “Sign up for free” to get 100 free credits monthly. Existing users can simply sign in. After logging in, you will see the Pabbly Chatflow dashboard, where you can manage your chatbots and integrations.


2. Adding Your WhatsApp Number in Pabbly Chatflow

Next, you need to add your WhatsApp number to Pabbly Chatflow. Click on the “Add WhatsApp Number” option on your dashboard. You can connect your WhatsApp either by using the preferred method or entering a manual token.

  • Click on “WhatsApp Connect” to link your account.
  • Follow the prompts to complete the connection.
  • Ensure your WhatsApp number is verified to receive messages.

After connecting your WhatsApp, you can utilize the chatbot features effectively to automate queries and responses for your business.


3. Creating an AI Assistant in Pabbly Chatflow

The next step is to create your AI assistant. In Pabbly Chatflow, navigate to the “AI Assistant” section. Click on “Create New AI Assistant” and name it. For instance, you can name it “Coaching Classes and Quiz Campaigns”.

After naming your assistant, select the instruction type as “AI Agent”. This will automatically populate the necessary instructions. You can customize these instructions to fit your business needs.


4. Configuring AI Settings for Your WhatsApp Chatbot

In this section, configure the AI settings for your assistant in Pabbly Chatflow. Set the creativity level of the AI responses. A value of 0.7 is recommended for a balance between focus and creativity.

Next, enter your OpenAI API key to activate the AI agent. If you don’t have an API key, follow the instructions provided in the help desk section to generate one. Make sure to save the key to integrate it properly.

  • Select the knowledge source as “Upload File” for your AI assistant.
  • Upload your knowledge base in a compatible format like PDF or TXT.
  • Ensure the file does not exceed the page limit if it contains images.

After configuring the settings, your AI assistant will be ready to handle queries effectively.


5. Assigning Your AI Assistant to Contacts in Pabbly Chatflow

Finally, assign your AI assistant to specific contacts or groups in Pabbly Chatflow. Open the “Inbox Settings” from the main menu. Here, you can enable auto-replies for your AI assistant.

Select the contact list you want to assign the assistant to, or opt for all contacts. Save the settings to ensure that your AI assistant is active and ready to respond.

This automation will allow your WhatsApp chatbot to efficiently manage inquiries and conduct quizzes, enhancing your business interactions.


Conclusion

In this tutorial, we explored how to create a WhatsApp chatbot using Pabbly Chatflow. By following these steps, you can automate your business queries and enhance user engagement effectively.

I Track Zoho CRM Leads in Google Sheets Automatically

Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Integration

To start integrating Zoho CRM with Google Sheets, you need to access Pabbly Connect. Open a new tab and search for Pabbly Connect to reach the landing page.

Here, you will find options to sign in or sign up for free. If you are a new user, signing up provides you with 100 free tasks each month to test the integration. Once you log in, you will be directed to the dashboard where you can create your workflow.


2. Creating a Workflow in Pabbly Connect

Now that you are on the dashboard of Pabbly Connect, click on the “Create Workflow” option. Use the AI feature to generate your workflow automatically by providing a simple prompt.

For this integration, enter the prompt: “Track Zoho CRM leads to Google Sheets automatically.” This will set up the trigger event for whenever a new lead is created in Zoho CRM, allowing the data to be added to Google Sheets.

  • Select “Create using AI”.
  • Provide the prompt for tracking leads.
  • Open the workflow to build the connection.

After setting up the trigger, proceed to connect Zoho CRM with Pabbly Connect to capture new leads effectively.


3. Connecting Zoho CRM to Pabbly Connect

In this step, you will connect your Zoho CRM account to Pabbly Connect. Click on the “Add New Connection” option and choose to connect with Zoho CRM. You will need to provide your Zoho account domain.

Find your domain in your Zoho CRM URL. Once you enter the domain, click the “Accept” button to grant access. Now, select the module name as “Leads” to ensure that new leads are captured accurately.

  • Enter your Zoho CRM domain.
  • Select “Leads” as the module name.
  • Click “Save and Send Test Request” to capture the last lead.

Once the connection is established, Pabbly Connect will check for new leads every 10 minutes, ensuring your Google Sheets is always updated.


4. Setting Up Google Sheets with Pabbly Connect

Now it’s time to set up Google Sheets within Pabbly Connect. Click on the connect button and add a new connection by signing in with your Google account. Grant the necessary permissions for Pabbly Connect to access your Google Sheets.

After signing in, select the spreadsheet you want to use, which in this case is named “Leads Data”. Make sure to choose the correct sheet where the lead details will be recorded.

  • Choose the Google account linked to your spreadsheet.
  • Select “Leads Data” as your spreadsheet.
  • Map the fields from Zoho CRM to Google Sheets.

After mapping the fields, click on “Save and Send Test Request” to ensure that the lead details are successfully added to Google Sheets.


5. Finalizing the Integration Between Zoho CRM and Google Sheets

With all the connections established, Pabbly Connect will now automatically sync new leads from Zoho CRM to Google Sheets. Whenever a new lead is created, the details will be recorded in your spreadsheet.

This automation saves time and reduces the risk of errors, ensuring that your lead management is efficient. You can always check your Google Sheets to confirm that the lead data has been captured correctly.

In summary, using Pabbly Connect to integrate Zoho CRM with Google Sheets allows for seamless data management, making it easier to keep track of your leads.


Conclusion

This tutorial walks you through integrating Zoho CRM with Google Sheets using Pabbly Connect. Automating this process enhances lead management and ensures accuracy in your records.

Auto Send Renewal Reminder Emails Before Expiry 🤯

Watch Step By Step Video Tutorial Below






1. Introduction to Pabbly Connect for Subscription Reminders

In this tutorial, we will explore how to automate subscription renewal reminders using Pabbly Connect. This platform allows businesses to send timely reminders to customers, ensuring they do not forget to renew their subscriptions. By automating this process, you can significantly reduce the risk of losing recurring revenue.

To get started, you need a few essentials: a customer database with expiration dates, a Gmail account for sending emails, and a subscription to Pabbly Connect. This integration will streamline your workflow, making the reminder process seamless and efficient.


2. Setting Up Your Workflow in Pabbly Connect

To set up your workflow in Pabbly Connect, begin by logging into your account and navigating to the dashboard. Click on the ‘Create Workflow’ button and select ‘Create from Scratch’. Name your workflow and choose a folder to save it in.

Next, you will need to set a trigger for your workflow. Here are the steps to follow:

  • Select ‘Schedule by Pabbly’ as your trigger application.
  • Choose ‘Schedule Workflow’ as the event.
  • Set the frequency to daily and choose the time to run your workflow.

Now save your settings, and your trigger will be ready to execute daily at the specified time.


3. Fetching Customer Data from Google Sheets

Once the trigger is set, the next step is to fetch customer data from Google Sheets using Pabbly Connect. This will allow you to retrieve details like names and expiration dates of subscriptions. To do this, add a new action step in your workflow.

Follow these steps to connect Google Sheets:

  • Select ‘Google Sheets’ as your action application.
  • Choose ‘Get Rows’ as the event.
  • Connect your Google account and select the spreadsheet containing your customer data.

After fetching the data, you will be able to access all the necessary details for sending reminders.


4. Processing Customer Data with Pabbly Connect

After you have fetched the data, the next step involves processing it using an iterator in Pabbly Connect. This allows you to handle customer details one by one, making it easier to apply filters based on the expiration dates.

To set up the iterator, follow these steps:

  • Select ‘Iterator’ as the next action application.
  • Choose ‘Process Arrays’ as the event.
  • Map the response from Google Sheets to the iterator.

>Once the iterator is set, it will loop through each customer’s data, allowing you to filter out those who need reminders based on their subscription expiration dates.


5. Sending Reminder Emails with Pabbly Connect

Finally, the last step in your workflow involves sending reminder emails to customers whose subscriptions are about to expire. This is where Pabbly Connect truly shines by automating the email sending process.

To set up the email action:

  • Select ‘Gmail’ as the action application.
  • Choose ‘Send Email’ as the event.
  • Connect your Gmail account and fill in the email details using mapping for dynamic content.

Once you have configured the email action, save your workflow. The system will automatically send out reminder emails based on the conditions set in your workflow.


Conclusion

In this tutorial, we explored how to automate subscription renewal reminders using Pabbly Connect. By setting up a workflow that triggers daily, fetches customer data from Google Sheets, processes it, and sends reminder emails, you can enhance customer retention and reduce revenue loss. This simple yet effective automation can significantly benefit your business.

Gemini Can Now Generate Instagram Reels Automatically 🤯

Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Integration

To integrate Now and Gemini, you first need to access Pabbly Connect. Simply open a new tab and visit pabby.com/connect. If you are a new user, you can sign up for free and get 100 tasks every month to test the platform.

Once logged in, you’ll arrive at the Pabbly Connect dashboard. Here, you can create workflows that automate tasks between applications. The first step is to click on the “Create Workflow” button, which allows you to set up your integration seamlessly.


2. Creating a Workflow in Pabbly Connect

After accessing the dashboard, the next step is to create a new workflow using Pabbly Connect. Click on the “Create Workflow” option and choose the AI-driven workflow builder. This feature simplifies the process by generating workflows based on your prompts.

  • Select the event as “Schedule” to run the workflow daily.
  • Choose “Generate Content” from Google Gemini for captions.
  • Select “Generate Image” from Gemini for the post background.

Once your events are selected, Pabbly Connect will set up the workflow to automatically run every day based on your schedule. This ensures that your Instagram posts are created without manual intervention.


3. Setting Up Connections with Google Gemini

Now that the workflow is created, you need to establish connections with Google Gemini. Using Pabbly Connect, click on the connect button and enter your API key from Google AI Studio. This key allows Pabbly Connect to access the functionalities of Google Gemini.

After entering the API key, you will configure the prompts for generating captions and images. For captions, you can use a prompt like: ‘Generate an engaging Instagram reel caption.’ This ensures that Gemini provides unique content every time.


4. Publishing Instagram Reels Automatically

With your connections set, the next step involves publishing the reels on Instagram through Pabbly Connect. Select the “Instagram for Business” app in your workflow and create a new connection.

  • Map the video URL generated from the previous step.
  • Enter the caption generated by Gemini, including relevant hashtags.

After configuring these details, click on the save button. This will allow the workflow to publish the Instagram reel automatically at the scheduled time.


5. Finalizing the Automation Process

To complete your automation setup using Pabbly Connect, add a delay step to ensure the content is processed before publishing. Set a delay of 1 minute to give the reel time to process fully.

Finally, publish the video by selecting your Instagram account and mapping the video ID generated in the previous steps. Once you click the save button, your Instagram reel will be successfully posted automatically according to the schedule you set.


Conclusion

This tutorial demonstrated how to integrate Now and Gemini using Pabbly Connect for automated Instagram posts. With Pabbly Connect, you can streamline your content creation process efficiently.

Automatically Save Payment Details in Airtable

Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Integration

To start integrating Razer Pay with Airtable, you first need to access Pabbly Connect. Open your browser and navigate to pav.com/connect to reach the Pabbly Connect homepage.

Once there, you’ll see options to sign in or sign up. If you’re a new user, click on “Sign Up Free” to create an account and get 100 free tasks each month. Existing users can simply sign in to proceed with the integration.


2. Creating a Workflow in Pabbly Connect

After signing in, you will be directed to the Pabbly Connect dashboard. Here, click on “Access Now” to enter the workflow creation section. To set up automation, you can choose to create a workflow from scratch or use the AI workflow builder.

  • Select “Create Using AI” to initiate the automation process.
  • Input a prompt like “When a new payment comes in from Razer Pay, add it to Airtable”.
  • Choose the trigger as “Payment Captured” from Razer Pay and the action as “Create Record” in Airtable.

Once you’ve confirmed the setup, you will receive a workflow link that can be used to test the integration. This workflow will now allow you to automate payment record entries.


3. Setting Up the Trigger with Razer Pay

To establish the trigger, you will need the webhook URL provided by Pabbly Connect. Copy this URL as you will need it to connect Razer Pay with Pabbly Connect.

Log into your Razer Pay account and navigate to the developer section to set up your webhook. Click on “Add a New Webhook,” paste the copied URL, and select “Payment Captured” as the active event. Save the webhook to finalize the connection.


4. Performing a Test Submission

After setting up the webhook, you need to perform a test submission to ensure everything is working correctly. Go to your Razer Pay payment page and enter the test details.

  • Select a product and choose a payment method, like net banking.
  • Complete the payment process to trigger the webhook.
  • Check Pabbly Connect for a successful response indicating the payment details have been captured.

This test will confirm that the trigger is functioning properly and that the payment details are being sent to Pabbly Connect.


5. Adding Payment Details to Airtable

Now that the trigger is set, it’s time to add the payment details to Airtable using Pabbly Connect. You will need to create a new connection for Airtable.

In the Airtable setup, select your base and table name where the payment records will be stored. Map the fields from the Razer Pay trigger to the corresponding fields in Airtable. This includes customer name, email, phone number, and payment amount.

  • Use the mapping feature to dynamically insert data from the previous step.
  • Adjust the payment amount using the number formatter feature to ensure accuracy.
  • Save and send the request to finalize the record creation.

After saving, you can check your Airtable to confirm that a new record has been created successfully with all the payment details.


Conclusion

This tutorial detailed how to automate the storage of payment records from Razer Pay to Airtable using Pabbly Connect. By following these steps, you can ensure that payment details are captured efficiently and organized in your Airtable account.

Automate Your WooCommerce Email Marketing Using Flodesk

Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Integration

To start automating your WooCommerce orders, access Pabbly Connect by visiting pabby.com in your browser. Sign in using your credentials or create a free account to explore its features.

Once signed in, navigate to the dashboard where you can create workflows. Click on the ‘Create Workflow’ button to initiate the process of integrating WooCommerce with Flodesk.


2. Creating a Workflow in Pabbly Connect

In this section, you will create a workflow to connect WooCommerce and Flodesk using Pabbly Connect. First, name your workflow something descriptive like “Automate Your WooCommerce Email Marketing Using Flodesk”.

After naming your workflow, select a folder for organization. Here are the steps to follow:

  • Click on ‘Create Workflow’.
  • Name your workflow.
  • Select the appropriate folder.

Now, you have successfully created a new workflow in Pabbly Connect which will serve as the foundation for your automation process.


3. Setting the Trigger for New Orders

Next, set up the trigger event that will activate your workflow. In Pabbly Connect, select WooCommerce as your trigger application and choose “New Order Created” as the trigger event.

To establish this connection, you will receive a webhook URL. This URL is crucial as it acts as a bridge between WooCommerce and Pabbly Connect. Here’s how to set it up:

  • Go to your WordPress dashboard and navigate to WooCommerce settings.
  • Under the Advanced tab, find Webhooks and click on ‘Add Webhook’.
  • Enter the webhook details, including the URL from Pabbly Connect.

>After saving the webhook, you will receive a confirmation that it has been successfully set up, allowing Pabbly Connect to listen for new orders from WooCommerce.


4. Testing the Connection and Capturing Data

Once the webhook is set up, it’s time to test the connection. In Pabbly Connect, click on “Recapture Webhook Response” to ensure data is being received correctly. This step is crucial for verifying that the integration is functioning.

To test, place a test order in your WooCommerce store. Enter dummy details such as:

  • Email: [email protected]
  • First Name: Test
  • Last Name: Lead
  • Address: New Street
  • City: Bopal

>Once the order is placed, check Pabbly Connect to see if the response is captured, confirming that the connection is working as intended.


5. Adding Action to Create Subscriber in Flodesk

The final step involves adding Flodesk as the action application in your workflow. In Pabbly Connect, select Flodesk and choose “Create or Update Subscriber” as your action event.

Connect your Flodesk account by logging in and granting permissions. After successfully connecting, map the necessary fields such as:

  • Email address from WooCommerce order.
  • First Name and Last Name.

>Finally, save your workflow and send a test request to verify that the subscriber is created in Flodesk. This completes the automation process using Pabbly Connect, allowing for seamless integration between WooCommerce and Flodesk.


Conclusion

In this tutorial, you learned how to automate WooCommerce orders to Flodesk using Pabbly Connect. This integration streamlines your email marketing efforts by automatically adding subscribers from new orders. With Pabbly Connect, you can enhance your e-commerce operations efficiently.

Send Personalized Emails to Website Enquiries Automatically

Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Email Automation

To automate personalized emails, the first step is accessing Pabbly Connect. You can do this by visiting paby.com and signing into your account. If you are a new user, you can sign up for free, which gives you 100 tasks monthly to explore the platform.

Once logged in, you’ll see the Pabbly apps page. Click on Pabbly Connect to access the dashboard, where you can create workflows. These workflows will allow you to connect your website form submissions to your Gmail account efficiently.


2. Creating a Workflow in Pabbly Connect

In this section, we will create a workflow named “Send Personalized Emails to Website Inquiries Automatically” using Pabbly Connect. Click on the “Create Workflow” button to begin. Select the appropriate folder for your workflow, such as “Forms Automation,” and click on create.

  • Name your workflow clearly for easy identification.
  • Choose a folder that organizes your workflows effectively.
  • Click on the create button to finalize your workflow setup.

After creating the workflow, you will need to set a trigger. This trigger will initiate the workflow whenever there is a new form submission on your website, allowing you to send personalized emails automatically.


3. Setting Up the Trigger with Pabbly Connect

The next step involves setting up the trigger in Pabbly Connect. Select “Webhook by Pabbly” as your trigger application, and choose “Catch Webhook” as the trigger event. Click on connect to generate a unique webhook URL.

This webhook URL acts as a bridge between your website form and Pabbly Connect. Copy the webhook URL and insert it into your website form’s code to establish the connection. Save the changes to your form code.

  • Select “Webhook by Pabbly” as your trigger application.
  • Choose “Catch Webhook” as the trigger event.
  • Copy the generated webhook URL and insert it into your form code.

Once the webhook is set up, perform a test submission on your form to ensure that the connection is working correctly. You will see a response captured in Pabbly Connect confirming the setup.


4. Configuring the Email Action in Pabbly Connect

Now that the trigger is set, it’s time to configure the action step in Pabbly Connect. Select Gmail as your action application and choose “Send Email” as the action event. Click on connect and authorize your Gmail account to allow Pabbly Connect to send emails on your behalf.

Fill in the required fields, such as the sender name and email address. For the recipient email, map it to the email address captured from the form submission. This ensures each email sent is personalized based on the lead’s information.

  • Select Gmail as your action application.
  • Map the recipient email to the form submission data.
  • Enter a personalized subject and email content.

Finally, click on save and send a test request. Check your Gmail inbox to confirm that the personalized email has been sent successfully, demonstrating the effectiveness of your automation using Pabbly Connect.


5. Conclusion

This tutorial has shown you how to automate personalized emails using Pabbly Connect with Here I and Pabi. By following these steps, you can streamline your email communications and enhance your lead management process.

With Pabbly Connect, you can create various automations to improve efficiency in your business operations. Start leveraging this powerful tool today to enhance your workflows and save time.

Businesses Lose Leads in Minutes—Fix It with AI

Watch Step By Step Video Tutorial Below






1. Setting Up Pabbly Connect for Instagram Integration

To begin with, Pabbly Connect is the central platform that enables you to integrate various applications seamlessly. Start by signing up at pabblaby.com/connect if you haven’t already. Once signed up, you will receive 100 free tasks every month, which is perfect for testing your workflows.

After logging into your Pabbly Connect dashboard, click on the plus button to create a new workflow. You will need to name your workflow, which will be crucial for identifying it later. Once named, the trigger step will appear, allowing you to select the application that initiates the automation.


2. Integrating Instagram Lead Ads with Pabbly Connect

In this section, we will set up Instagram Lead Ads as the trigger for our workflow using Pabbly Connect. Select “Instagram Lead Ads” from the list of applications. Choose “New Lead Instant” as the event. Click on the connect button to establish a connection.

  • Select “Connect with Instagram Lead Ads”.
  • Ensure your Instagram account is linked to Facebook.
  • Choose the relevant Facebook page running your ads.

After selecting your page, choose the lead generation form you want to use. You can select the response format as simple, advanced, or raw depending on your needs. For this tutorial, we will choose the simple format and click on “Save and Send Test Request”.


3. Fetching Lead Data from Instagram

Once the test request is sent, Pabbly Connect will wait for a webhook response. To get this response, navigate to your Meta Developers account. Click on “Resources” and then select “Developer Tools”.

  • Select “Lead Ads Debug Tool”.
  • Choose the page and form you want to test.
  • Fill out the lead form and submit it.

After submitting the form, return to Pabbly Connect to check if the new lead data has been received. You should see the lead details populated in the workflow, confirming that the integration is working properly.


4. Generating AI Responses with OpenAI

Now that we have the lead data, the next step is to generate a personalized response using OpenAI through Pabbly Connect. Select “OpenAI” as your action application and choose “Generate Response using Text Input” as the event.

To connect OpenAI, you will need to enter your API key. Navigate to your OpenAI account, create a new secret key, and copy it. Paste this key into Pabbly Connect and save the connection.

  • Select the model you want to use, such as GPT-4.
  • Map the data received from Instagram, such as the first name and last name.
  • Set the background processing mode to immediate for real-time responses.

After mapping the data, click on “Save and Send Test Request” to test the AI response generation. You should receive a positive response with an AI-generated message.


5. Sending Messages via WhatsApp with Pabbly Chartflow

Finally, we will send the AI-generated message to the user’s WhatsApp using Pabbly Chartflow. Select “Pabbly Chartflow” as your action application and choose “Send Text Message” as the event.

To connect, you will need to enter your API token from the Pabbly dashboard. Once connected, you will map the recipient’s WhatsApp number and the AI-generated message.

  • Ensure the contact number is formatted correctly without the plus sign.
  • Test the message sending by entering a valid WhatsApp number.

Click on “Save and Send Test Request”. You should see a success status indicating that the message was sent successfully. Check your WhatsApp to see the AI-generated message received.


Conclusion

In this tutorial, we demonstrated how to automate responses for Instagram leads using Pabbly Connect, OpenAI, and WhatsApp. By following these steps, you can enhance your lead response time and improve customer engagement effectively.

How to Create Unlimited AI Images for Free

Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, go to the Pabbly Connect homepage by entering ‘pabbly.com/connect’ in your browser. Here, you have options to sign in or sign up for a free account. New users can enjoy 100 free tasks monthly to explore the features.

If you’re an existing user, simply sign in. After logging in, navigate to the Pabbly Connect dashboard where you can create a new workflow. This is the first step in integrating Google Sheets with Gemini to automate image generation.


2. Creating a Workflow in Pabbly Connect

To create a new workflow, select the option to start from scratch or use the AI workflow builder. For this tutorial, we will use the AI workflow builder. Enter a prompt detailing your workflow: “When a new row is added in Google Sheets, send data to Gemini for generating an image, and then update the image link in Google Sheets.”

  • Select the trigger event as “New or Updated Spreadsheet Row” for Google Sheets.
  • Choose the action event as “Generate and Edit Images” for Gemini.
  • Select “Update Cell Value” for Google Sheets as the final action.

After reviewing the workflow, click on “Approve and Create” to finalize your setup. This step is crucial as it establishes the connection between Google Sheets and Gemini through Pabbly Connect.


3. Setting Up the Trigger for Google Sheets

In this step, you will set up the trigger for your workflow. After selecting the Google Sheets app and the event, you will receive a webhook URL. Copy this URL, as it will be used to connect Google Sheets with Pabbly Connect.

Next, log into your Google Sheets account and open the spreadsheet you wish to automate. You need to install the Pabbly Connect Webhooks add-on. Go to Extensions, select Add-ons, and then Get Add-ons. Search for “Pabbly Connect Webhooks” and install it. After installation, refresh your Google Sheets.

  • Click on Extensions again, then select Pabbly Connect Webhooks.
  • Choose Initial Setup and paste the copied webhook URL.
  • Set the trigger column to the final data column where you will add details.

Once you’ve set this up, click Submit. This connects your Google Sheets to Pabbly Connect, allowing for automated data transfer.


4. Connecting to Gemini for Image Generation

Now that your trigger is set, it’s time to connect to Gemini to generate images. In Pabbly Connect, select the Gemini app and provide the necessary API key. You can obtain this key from your Google AI Studio account.

Once you have the API key, select the model you wish to use, such as “Nano Banana Pro,” and set the method to “Generate Content.” Here, you will also need to enter a prompt for the AI to generate the image. Instead of manual entry, you can map data from the previous steps to make the process dynamic.

  • Enter the relevant prompt for image generation.
  • Use the mapping feature to dynamically insert data from Google Sheets.
  • Click on Save and Send Request to complete this step.

This will generate an image based on the details provided, completing the connection between Pabbly Connect and Gemini.


5. Updating Google Sheets with Generated Image Links

After generating the image, the next step is to update your Google Sheets with the newly created image link. Again, you’ll use Pabbly Connect to establish this connection. Select Google Sheets as the app and choose the action event to update the cell value.

In this step, specify the spreadsheet and sheet you are working with. For the range, enter the appropriate column and row index where the image link should be updated. After setting this up, click on Save and Send Request.

  • Select the spreadsheet as “AI Image Generation” and the sheet as “Sheet 1.”
  • Specify the column name and dynamically map the row index.
  • Click Save and Send Request to finalize the update.

After successfully updating the Google Sheets, you can verify that the image link has been added correctly. This completes the automation process, allowing you to generate images and update your Google Sheets seamlessly.


Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the process of generating images from Google Sheets using Gemini. By following these steps, you can streamline your workflow and enhance productivity.

Auto Post Sale Offers on Social Media 🔥

Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Integration

To start automating your social media posts, you need to access Pabbly Connect. Open a new tab and go to the Pabbly Connect website.

Once there, create your free account if you are new. After logging in, you will be directed to the dashboard where you can create your workflow.


2. Creating a New Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the “Create Workflow” button. This is where you will set up the automation process.

  • Select “Create from Scratch”.
  • Name your workflow, for example, “Posting Offers Automatically on Social Media”.
  • Choose a folder to store the workflow.

After setting this up, click the “Create” button to proceed to the blank workflow page.


3. Setting Up Google Sheets as the Trigger Application

The next step is to select Google Sheets as the trigger application in Pabbly Connect. Click the plus button to add a trigger.

Choose “Google Sheets” and select the event as “New or Updated Spreadsheet Row”. You will then need to connect your Google Sheets account to Pabbly Connect.

  • Click the “Connect” button to generate a webhook URL.
  • Copy the webhook URL and integrate it into your Google Sheets.

This integration allows data from your Google Sheets to be sent to Pabbly Connect automatically.


4. Adding Action Steps for Facebook and LinkedIn

After setting up the trigger, you can add action steps to post on Facebook and LinkedIn. Start by clicking the plus button again.

Select “Facebook Pages” as the action application and choose “Create Page Post”. Connect your Facebook account to Pabbly Connect to enable posting.

  • Select the Facebook page where you want to post.
  • Map the details such as discount percentage, title, and description from your Google Sheets data.

Once you have mapped all required details, click on “Save and Send Test Request” to create the post.


5. Finalizing LinkedIn Post Creation

Next, repeat the action step for LinkedIn by selecting it as the action application. Choose “Create Company Update” as the event.

Connect your LinkedIn account to Pabbly Connect and fill in the content box with the mapped details from Google Sheets.

  • Add the discount percentage, title, and description.
  • Ensure to map the article preview URL as well.

After filling in the details, click on “Save and Send Test Request” to finalize the LinkedIn post.


Conclusion

Using Pabbly Connect, you can effortlessly automate social media posts by integrating Google Sheets with platforms like Facebook and LinkedIn. This saves time and enhances your promotional efforts.