Learn how to automate video creation and sharing on social media with Pabbly Connect, Google Sheets, and more in this step-by-step tutorial. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below


1. Accessing Pabbly Connect for Video Automation

To begin using Pabbly Connect for your video automation needs, you first need to access the platform. Start by navigating to the Pabbly website at pabby.com. If you are an existing user, click on the ‘Sign In’ button located at the top right corner. For new users, you can sign up for free and receive 100 tasks monthly to explore the platform’s capabilities.

Once signed in, you will be directed to the Pabbly Apps page. From there, click on the ‘Pabbly Connect’ option to access the dashboard. Here, you can create workflows that will automate your video creation and sharing process. If you want to organize your workflows better, you can create folders by clicking on the plus icon.


2. Creating a Workflow in Pabbly Connect

In this section, we will create a new workflow in Pabbly Connect. Click on the ‘Create Workflow’ button and select the new beta workflow builder. Name your workflow, for example, ‘AI Video Automation for Social Media Growth’, and choose the folder where you want to save it.

  • Click on ‘Create’ to finalize your workflow setup.
  • You will see a box to enter your trigger application.
  • Select Google Sheets as your trigger application.

After setting up the trigger, you will configure it to activate whenever a new topic is added to your Google Sheets. This will initiate the automation process, allowing you to create and share videos seamlessly.


3. Integrating Google Sheets with Pabbly Connect

To connect Google Sheets with Pabbly Connect, select the event ‘New or Updated Spreadsheet Row’. Click on the ‘Connect’ button to establish the connection. A webhook URL will be provided, which acts as a bridge between Google Sheets and Pabbly Connect.

Open your Google Sheets and navigate to the Extensions menu. Click on ‘Add-ons’ and then ‘Get add-ons’. Search for ‘Pabbly Connect Webhooks’ and install it. After installation, refresh your Google Sheet, go back to Extensions, and select ‘Pabbly Connect Webhooks’ followed by ‘Initial Setup’. Here, paste the webhook URL and specify the trigger column, which should be the final data column where you will enter your topics.


4. Automating Video Generation with Pabbly Connect

Once your Google Sheets is integrated with Pabbly Connect, the next step is to set up video generation. Add a new action step and select ‘Filter by Pabbly’. In the action event, choose ‘Filter Values’ and connect it. Set the label to ‘Generate’ to ensure videos are created only when this condition is met.

  • Click on ‘Add New Action Step’ and select the AI video generation tool.
  • Enter your API token to connect to the video generation service.
  • Map the data from the Google Sheets response to the required fields in the video generation tool.

After setting up the video generation, you will need to add a delay action to allow the video to process. This ensures that the workflow waits for the video to be created before proceeding to the next steps.


5. Posting the Generated Video on Facebook

After successfully generating the video, the final step is to share it on Facebook using Pabbly Connect. Add a new action step and search for Facebook Pages. Select the action event ‘Create Page Video Post’ and connect your Facebook account.

Choose the Facebook page where you want to post the video and map the video URL from the previous action step. Additionally, you can add a descriptive caption for the video. Once everything is set up, click on ‘Save and Send Test Request’ to post the video on your Facebook page.


Conclusion

This tutorial demonstrated how to automate video creation and sharing on social media using Pabbly Connect, Google Sheets, and Facebook. By following these steps, you can streamline your content promotion process and focus more on creating engaging content for your audience.

Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.