Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Integration

To start your automation process, you need to access Pabbly Connect. This platform allows you to create workflows that integrate various applications seamlessly. Begin by visiting the Pabbly Connect website and logging into your account. If this is your first time, sign up to receive 100 free tasks each month.

Once logged in, navigate to the dashboard. Here, you can create new workflows. Click on the “Create Workflow” button and select the option to create using the quick builder. This feature allows you to set up your integration without any coding skills.


2. Setting Up Google Sheets as Trigger

In this step, you will set Google Sheets as the trigger for your automation using Pabbly Connect. Start by creating a new spreadsheet where you will input your LinkedIn post ideas. Ensure that your sheet has a designated column for the status of each post.

  • Open your Google Sheets and go to Extensions.
  • Select Pabbly Webhooks and then Initial Setup.
  • Copy the webhook URL provided by Pabbly Connect.

After copying the URL, go back to your Google Sheets. In the Initial Setup dialog box, paste the webhook URL and set the trigger column (e.g., Column B) where the data is added. Click on the submit button to complete the setup.


3. Connecting Gemini AI to LinkedIn via Pabbly Connect

Next, you will connect Gemini AI to LinkedIn using Pabbly Connect. This integration allows you to generate images based on the ideas you input into Google Sheets. After setting up the trigger, go back to Pabbly Connect and create a new action step.

In the action step, select Gemini AI. You will need to enter your API key from the Google AI Studio to establish the connection. After entering the key, you will need to specify the model (e.g., Nano Banana Pro) and the method (e.g., Generate Content) for generating the image. Ensure that you map the data correctly to make it dynamic.


4. Posting to LinkedIn Using Pabbly Connect

After generating the image, the next step is to post it to LinkedIn through Pabbly Connect. In the action step, select LinkedIn as the application. Connect your LinkedIn account by entering your credentials. Once connected, map the image URL generated from Gemini and the caption from Google Sheets.

Set the visibility of the post to public and click on the “Save and Send Test Request” button. If successful, you will receive a confirmation response indicating that your post has been uploaded successfully to LinkedIn.


5. Updating Google Sheets with Post Status

The final step in this automation process is to update the Google Sheets with the status of the LinkedIn post using Pabbly Connect. Create another action step in your workflow to connect back to Google Sheets. Select the spreadsheet and specify the range where you want to update the status.

Map the row index and set the value to “Created” to indicate that the post has been successfully published. Click on the “Send Test Request” button, and once confirmed, your Google Sheets will reflect the updated status. This completes your workflow!


In conclusion, using Pabbly Connect allows you to automate the process of posting on LinkedIn directly from Google Sheets. By following these steps, you can streamline your social media management effortlessly.