Automate LinkedIn Posts Using Pabbly Connect and Perplexity AI

Learn how to automate your LinkedIn posts by integrating Google Sheets, Perplexity AI, and LinkedIn using Pabbly Connect with this step-by-step tutorial. 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 Automation

To start automating LinkedIn posts using Pabbly Connect, first, open your browser and navigate to the Pabbly Connect website. You will find options to sign in or sign up for free, which takes just a few minutes. Signing up grants you 100 free tasks monthly, allowing you to explore the platform’s capabilities.

After logging in, you will be directed to the Pabbly Connect dashboard. Here, you can create a new workflow by clicking on the ‘Create Workflow’ button. This is where you will set up the integration between Google Sheets, Perplexity AI, and LinkedIn, using Pabbly Connect as the central platform for automation.

2. Setting Up the Trigger with Google Sheets

The first step in your workflow is to set up a trigger using Google Sheets. In Pabbly Connect, select Google Sheets as your trigger application. Choose the event ‘New or Updated Spreadsheet Row’ as your trigger event to initiate the workflow whenever a new article is added.

• Search for Google Sheets in the trigger application list.
• Select the trigger event as ‘New or Updated Spreadsheet Row’.
• Connect Google Sheets with Pabbly Connect using the provided webhook URL.

After setting the trigger, make sure to copy the webhook URL provided by Pabbly Connect. You will need this URL to connect your Google Sheets. This integration allows the data from your spreadsheet to be sent directly to Pabbly Connect whenever a new article is added.

3. Connecting Google Sheets with Pabbly Connect

To connect your Google Sheets with Pabbly Connect, navigate to your Google Sheets and install the Pabbly Connect VBooks extension if you haven’t done so already. Go to ‘Extensions’ > ‘Add-ons’ > ‘Get add-ons’ to search and install it. After installation, refresh your spreadsheet.

Once refreshed, access the Pabbly Connect VBooks extension from the ‘Extensions’ menu. Use the ‘Initial Setup’ option to connect your spreadsheet with Pabbly Connect. Paste the webhook URL you copied earlier and define the trigger column, which should be the final data column where you will enter article details.

• Paste the webhook URL in the setup tab.
• Define the trigger column (e.g., Column B).
• Click ‘Send Test’ to confirm the connection.

After successfully sending test data to Pabbly Connect, you can enable the ‘Send on Event’ option to ensure that new entries are sent immediately.

4. Using Perplexity AI for Content Generation

With your Google Sheets connected to Pabbly Connect, the next step is to use Perplexity AI to summarize the article content. In your Pabbly Connect workflow, select Perplexity AI as your action application and choose the action event as ‘Create Chat Completion’.

To connect Perplexity AI, you will need to generate an API key from your Perplexity AI account. Log into Perplexity AI, navigate to settings, and generate a new API key. Copy this key and paste it into Pabbly Connect to establish the connection.

Select Perplexity AI in the action application list. Generate an API key from Perplexity AI settings. Map your article link from Google Sheets into the prompt for content generation.

By mapping the article link into the prompt, you instruct Perplexity AI to summarize the article and generate content specifically formatted for LinkedIn posts. This integration through Pabbly Connect automates the content creation process efficiently.

5. Creating Posts on LinkedIn Automatically

The final step in your automation workflow is to create a post on LinkedIn using the content generated by Perplexity AI. In Pabbly Connect, select LinkedIn as your action application and choose the action event ‘Share Simple Text’.

Connect your LinkedIn account to Pabbly Connect by clicking on ‘Connect with LinkedIn’. Once connected, you can map the content generated by Perplexity AI into the post content field. Set the visibility of the post to Pabbly to ensure it reaches your audience.

Select LinkedIn as the action application. Map the generated content from Perplexity AI into the post. Set the post visibility to Pabbly.

Once you save and test this action, Pabbly Connect will automatically create a new post on your LinkedIn account whenever a new article is added to your Google Sheets. This completes the automation process, allowing you to efficiently manage your LinkedIn content.

Conclusion

Using Pabbly Connect, you can seamlessly automate the process of posting on LinkedIn by integrating Google Sheets and Perplexity AI. This tutorial demonstrates how to set up triggers and actions that streamline content creation and posting, enhancing your productivity.