Automatically Get Video URLs on Google Sheets Using Pabbly Connect and Pexels

Learn how to automatically retrieve video URLs from Pexels into Google Sheets using Pabbly Connect, streamlining your workflow effortlessly. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Integration

To begin with, you need to access Pabbly Connect by visiting the official website. Here, you can either sign in if you’re an existing user or create a new account to get started. The sign-up process is quick and provides you with 100 free tasks to explore the platform.

Once you log into Pabbly Connect, navigate to the dashboard and click on the ‘Create Workflow’ button. You will be prompted to name your workflow. For this integration, name it ‘Automatically Get the Video URL on Google Sheets through Pexels’ and click ‘Create’. This sets the foundation for automating the retrieval of video URLs into your Google Sheets.

2. Setting Up Google Sheets as the Trigger Application

In this step, you will configure Google Sheets as the trigger application within Pabbly Connect. Select Google Sheets from the list of applications and choose the trigger event as ‘New or Updated Spreadsheet Row’. This means any new or updated entry in your Google Sheet will initiate the workflow.

• Select Google Sheets as the trigger application.
• Choose the trigger event: New or Updated Spreadsheet Row.
• Copy the webhook URL provided by Pabbly Connect.

Next, you will need to set up the Google Sheet that contains your titles and keywords. Ensure your sheet has columns for titles, keywords, and the video URLs where the retrieved URLs will be stored. This setup is crucial for the integration to function correctly.

3. Configuring Pabbly Connect Webhooks in Google Sheets

After setting up your Google Sheet, return to Pabbly Connect and configure the webhook. Go to the ‘Extensions’ menu in Google Sheets, select ‘Add-ons’, and find Pabbly Connect Webhooks. Make sure it is installed and refresh your Google Sheet after installation.

Once refreshed, go back to ‘Extensions’, select Pabbly Connect Webhooks, and initiate the ‘Initial Setup’. Here, paste the webhook URL you copied earlier and specify the trigger column, which is where new data will be added. For example, if your titles are in column B, enter ‘B’ as the trigger column. After entering the details, send a test to ensure everything is working smoothly.

4. Using Pexels to Search for Videos

The next step in your automation process involves using Pexels to search for videos based on the keywords from your Google Sheet. In Pabbly Connect, add Pexels as the action application and select the action event as ‘Search for Videos’. This allows you to retrieve video URLs based on the keywords provided.

• Select Pexels as the action application.
• Choose ‘Search for Videos’ as the action event.
• Map the keywords from the previous step to retrieve relevant video URLs.

After mapping the keywords, test the action to ensure that video URLs are successfully retrieved from Pexels. This step is crucial for ensuring that your Google Sheet will be updated with the correct video links.

5. Updating Google Sheets with Retrieved Video URLs

Finally, you will set up another action in Pabbly Connect to update your Google Sheet with the video URLs retrieved from Pexels. Select Google Sheets again as the action application and choose ‘Update Range Values’ as the action event.

In this setup, specify the range in your Google Sheet where the video URLs will be placed. For instance, if you want to update columns C to E, you would set the range as C2:E. Map the video URLs retrieved from Pexels to the corresponding columns in your Google Sheet. Once everything is mapped, send a test request to confirm that the updates are reflected in your Google Sheet.

Conclusion

In conclusion, using Pabbly Connect to automatically retrieve video URLs from Pexels into Google Sheets streamlines your workflow significantly. By setting up triggers and actions effectively, you can automate the process of updating your sheets with relevant video content based on your keywords. This integration not only saves time but also enhances productivity, allowing you to focus on other important tasks.