Automatically Share Posts on Facebook and Instagram from MS Excel Using Pabbly Connect

Learn how to automatically share posts on Facebook and Instagram from MS Excel using Pabbly Connect in this detailed tutorial. Follow the step-by-step process for seamless integration.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Integration

To automatically share posts on Facebook and Instagram from MS Excel, you first need to access Pabbly Connect. Start by visiting the Pabbly website at www.Pabbly.com. If you are a new user, click on the ‘Sign up for free’ button to create an account. This process takes just two minutes and grants you free tasks every month.

If you already have an account, click on ‘Sign in’ and navigate to the all apps section. Select Pabbly Connect and click on ‘Access Now’ to enter your dashboard. Here, you can create workflows that automate your posting process.

2. Create a Workflow in Pabbly Connect

After accessing Pabbly Connect, click on the plus sign to create a new workflow. Name your workflow something descriptive, like ‘Share Post on Facebook and Instagram from MS Excel’. This name helps identify your automation later.

In the workflow setup, you’ll see a trigger and an action window. The trigger signifies when a specific event occurs, while the action defines what happens as a result. In this case, the trigger will be a new row added to your Excel worksheet, which will initiate the posting process.

• Click on ‘Create Workflow’.
• Select ‘Microsoft Excel’ as the application.
• Choose ‘New Row in Worksheet’ as the trigger event.

Ensure that you save your workflow to capture the changes. This setup is crucial as it links your Excel data to Pabbly Connect, allowing for seamless automation.

3. Connect Microsoft Excel with Pabbly Connect

Once your workflow is created, you need to connect your Microsoft Excel account to Pabbly Connect. Click on the connect button in the trigger window. You will be prompted to add a new connection. Ensure that you are logged into your Microsoft Excel account before proceeding.

After clicking on ‘Connect with Microsoft Excel’, authorize Pabbly Connect to access your Excel data. Once authorized, you can select the workbook containing your post details. For instance, if your workbook is named ‘Social Media Post’, select it from the list.

• Choose the specific sheet, like ‘Sheet1’.
• Save and send a test request to ensure connection.

This step captures the data from your Excel sheet, including the photo URL and caption for your posts. The connection is essential for Pabbly Connect to automate the posting process.

4. Share Posts on Facebook and Instagram

Now that your Excel data is connected to Pabbly Connect, it’s time to share your posts on Facebook and Instagram. Start by adding an action step in your workflow. Choose ‘Facebook Pages’ as the application and select the action event as ‘Create Page Photo’.

Click on connect and authorize Pabbly Connect to access your Facebook account. Select the page where you want to post the photo. You will need to map the photo URL and caption from the Excel trigger response to the Facebook post fields.

Map the photo URL and description from the Excel response. Click on ‘Save and send test request’ to create the post.

After saving, refresh your Facebook page to see the newly created post. This confirms that Pabbly Connect successfully shared your post on Facebook.

5. Final Check and Automation Confirmation

With the Facebook post confirmed, the final step is to share the same post on Instagram. Again, add an action step and choose ‘Instagram for Business’ as the application. Select the action event as ‘Publish Photo’ and connect your Instagram account.

Just like before, map the photo URL and caption from your Excel data to the Instagram post fields. Click on ‘Save and send test request’ to publish the photo on Instagram. Refresh your Instagram account to see the post appear.

Now your workflow is complete. Whenever you add a new row in your Excel sheet, Pabbly Connect will automatically share the post on both Facebook and Instagram. This automation saves time and ensures consistency across your social media platforms.

Conclusion

In this tutorial, we demonstrated how to automatically share posts on Facebook and Instagram from MS Excel using Pabbly Connect. By following these steps, you can streamline your social media posting process and enhance your online presence effectively.