Integrate Gumlet with Google Sheets Using Pabbly Connect

Learn how to seamlessly integrate Gumlet and Google Sheets using Pabbly Connect to automate video detail updates. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Gumlet with Google Sheets, first access Pabbly Connect by visiting the Pabbly website. If you are a new user, click on ‘Sign up for free’ to create your account, which includes 100 free tasks to explore the platform.

Once you have your account set up, sign in to access the dashboard. Here, you will find all the Pabbly products. Click on ‘Access Now’ under Pabbly Connect to create your workflow for adding video details to Google Sheets.

2. Creating Your Workflow in Pabbly Connect

To create a new workflow in Pabbly Connect, click on the ‘Create Workflow’ button. Assign a name to your workflow, such as ‘Add Gumlet Video Details to Google Sheets.’ You can also choose a folder to save your workflow.

• Click on the ‘Create’ button to proceed.
• You will see two windows: one for the trigger and one for the action.

For this integration, select Gumlet as your trigger application and Google Sheets as your action application. This setup allows Pabbly Connect to automatically add video details to Google Sheets whenever a new video is uploaded on Gumlet.

3. Setting Up the Gumlet Trigger

In the trigger application, select Gumlet and choose the trigger event as ‘Video Status.’ This event triggers whenever the status of a video changes. To connect your Gumlet account with Pabbly Connect, you will receive a webhook URL.

Copy the webhook URL and navigate to your Gumlet dashboard. Under the Organizations section, find the ‘Webhooks’ option and click on it. Click on the ‘Add Webhook’ button to create a new webhook for your integration.

• Paste the copied webhook URL in the URL field.
• Set up your secret token by creating an API key in the Users section.

After setting up the webhook, return to Pabbly Connect and test the connection by uploading a new video in Gumlet. This will allow Pabbly Connect to capture the response and proceed with the workflow.

4. Filtering Video Status Before Adding to Google Sheets

Once the video is uploaded, you will see the response in Pabbly Connect. However, to ensure only completed uploads are recorded, you need to apply a filter. This filter checks if the video status is set to ‘Ready’ before proceeding to the next step.

In your Pabbly Connect workflow, add a filter step. Set the condition to check if the status equals ‘Ready.’ This ensures that only videos that are fully processed are added to Google Sheets.

Click on ‘Save and Send Test Request’ to validate the filter. If the condition is false, the workflow will not proceed to add the video details.

This filtering step is crucial for maintaining a clean and organized Google Sheets record, ensuring that only relevant video details are logged.

5. Adding Video Details to Google Sheets

After successfully filtering out the video statuses, the next step is to add the video details to Google Sheets using Pabbly Connect. Select Google Sheets as your action application and choose the action event as ‘Add New Row.’ This action will add a new row for each video that meets the filter criteria.

Connect your Google Sheets account by clicking on ‘Sign In with Google.’ Make sure you are logged into your Google account for a seamless connection. After the connection is established, select the spreadsheet where you want to store the video details.

Map the video details from Gumlet to the appropriate columns in Google Sheets. Ensure to include the video title, description, tags, and asset ID in the respective fields.

Once you have mapped all the necessary details, click on ‘Save and Send Test Request’ to finalize the integration. Check your Google Sheets to confirm that the new video details have been added correctly. This confirms that your Pabbly Connect workflow is functioning as intended.

Conclusion

In this tutorial, we explored how to integrate Gumlet with Google Sheets using Pabbly Connect. By following these steps, you can automate the process of adding new video details to your Google Sheets, ensuring that your records are always up-to-date and organized. This integration enhances your workflow and saves you time by automating repetitive tasks.