Automate Gumlet Video Details to Microsoft Excel with Pabbly Connect

Learn how to automate adding Gumlet video details to Microsoft Excel using Pabbly Connect. Follow our detailed step-by-step tutorial for seamless integration. 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 Integration

To automate adding Gumlet video details to Microsoft Excel, start by accessing Pabbly Connect. This platform allows you to create seamless integrations between various applications.

Once logged into your Pabbly Connect account, click on the blue ‘Create Workflow’ button. Provide a name for your workflow, such as ‘Add New Gumlet Video to Microsoft Excel Automatically,’ and select the appropriate folder for your workflow.

2. Setting Up Trigger and Action in Pabbly Connect

After creating your workflow, you will see two boxes for trigger and action. The trigger indicates when an event occurs, while the action defines what happens next. Here, select Gumlet as the trigger application and Microsoft Excel as the action application.

• Choose ‘Video Status’ as the trigger event in Gumlet.
• Select ‘Add Row to Worksheet’ as the action event in Microsoft Excel.

By connecting these applications through Pabbly Connect, you ensure that whenever a new video is uploaded to Gumlet, its details will automatically populate in your Excel sheet.

3. Connecting Gumlet Webhook to Pabbly Connect

To establish a connection between Gumlet and Pabbly Connect, copy the webhook URL provided after selecting the trigger event. This URL is essential for capturing video details.

Next, navigate to the Gumlet dashboard, find the ‘Organization’ section, and click on ‘Add Webhook.’ Paste the copied webhook URL and enter your API key from the user section to authenticate the connection.

4. Uploading Video to Gumlet for Testing

With the webhook set up, it’s time to test the integration. Upload a new video to Gumlet. As soon as the video is uploaded, Pabbly Connect will capture the video details, including its status.

For effective testing, ensure that you check the responses in Pabbly Connect. This will confirm that the video status and details have been successfully received from Gumlet.

• Delete any existing video to avoid confusion.
• Upload a new video and add relevant details such as title and description.

Once the video is processed, Pabbly Connect will automatically update your Excel sheet with the new video details.

5. Finalizing Microsoft Excel Integration with Pabbly Connect

Now that the video details are captured, proceed to connect Microsoft Excel with Pabbly Connect. Authorize access to your Excel account and select the workbook where you want to add the video details.

Map the video details from the webhook response to the corresponding columns in your Excel sheet. This includes the video title, URL, and any other relevant information. Once mapped, save the settings.

Finally, click on the ‘Save and Send Test Request’ button. Check your Excel sheet to confirm that the video details have been successfully added. With Pabbly Connect, this entire process is automated, allowing for efficient video tracking.

Conclusion

This tutorial has shown you how to automate the process of adding Gumlet video details to Microsoft Excel using Pabbly Connect. With just a few simple steps, you can streamline your video management, ensuring that your team stays updated with the latest video uploads.