How to Automatically Shorten Video Links Using Pabbly Connect

Learn how to integrate Google Sheets, Short.io, and Google Chat using Pabbly Connect to automatically shorten video links and notify your team. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for Integration

To start the integration process, you need to access Pabbly Connect. Simply visit the Pabbly website and log in or sign up for a free account. This platform will enable you to connect various applications seamlessly.

Once logged in, navigate to the Pabbly Connect dashboard. From here, click on the ‘Create Workflow’ button. This is where you will name your workflow and choose a folder to save it. Naming your workflow appropriately helps in organizing your tasks efficiently.

Setting Up Google Sheets as the Trigger Application

In this step, you will configure Google Sheets as the trigger application in Pabbly Connect. Select Google Sheets from the list of applications and choose the trigger event as ‘New or Updated Spreadsheet Row’. This means that whenever a new video is published in your sheet, the workflow will activate.

After selecting your trigger event, Pabbly Connect will provide a webhook URL. Copy this URL and head over to your Google Sheets. You need to install the Pabbly Connect Webhook add-on to facilitate this integration. Here’s how you can do it:

• Go to Extensions > Add-ons > Get Add-ons in Google Sheets.
• Search for Pabbly Connect Webhook and install it.
• Refresh your Google Sheets to see the new add-on.

After installation, go to the Pabbly Connect Webhook option and perform the initial setup by pasting the copied webhook URL. Select the trigger column where the status of the video will be updated to ‘Published’. This setup ensures that the workflow is triggered correctly.

Shortening Video Links with Short.io

Now that you have set up Google Sheets, it’s time to shorten the video links using Short.io through Pabbly Connect. Add a new action step and select Short.io as your action application. Choose the action event as ‘Create Short Link’. This allows you to convert long URLs into short, manageable links.

To connect your Short.io account, you will need to provide a secret key. You can find this key in your Short.io account under the Integrations and API section. Once you have entered the key, map the long video URL from the previous step to ensure that the correct URL is shortened.

• Select the long URL field and map it from the Google Sheets response.
• Click on ‘Save and Send Test Request’ to validate the connection.
• Ensure you receive a positive response confirming the short URL has been created.

After successfully shortening the URL, you can use this link in the next step of your workflow.

Sending Notifications to Google Chat

The final step involves sending a notification to your Google Chat space using the short URL generated in the previous step via Pabbly Connect. Start by adding another action step and select Google Chat as your application. Choose ‘Create Message’ as the action event.

To set this up, you will need to provide the Google Chat webhook URL. Create a new webhook in your Google Chat space and copy the URL. Paste this URL into the Pabbly Connect workflow. Then, map the message content, including the video title, creator name, and the short URL.

Enter a message format such as ‘New Video Alert: [Title], Creator: [Name], Watch Now: [Short URL]’. Click on ‘Save and Send Test Request’ to check if the message is sent correctly. Verify the message appears in your Google Chat space.

This integration ensures that your team is promptly notified whenever a new video is published, streamlining your communication process effectively.

Conclusion

In this tutorial, we have demonstrated how to use Pabbly Connect to integrate Google Sheets, Short.io, and Google Chat. This process allows for automatic shortening of video links and sending notifications to your team, enhancing your workflow efficiency.